…should also adjust/increase the size of the buffer that MRR uses appropriately. In my tests I noticed that with just the join_buffer_size…Innodb_buffer_pool_reads and Innodb_data_read. We can see that with appropriately sized buffers less no. of Innodb_buffer_pool_reads are done, and less amount of…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of… memory allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1…should be and I’m very hopeful future releases of…what purpose memory is allocated and so detect all kinds of…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… size will be enough. You also should account for growth of course. You need buffer pool a bit (say 10%) larger than your data (total size of Innodb…Double Buffering – This is again very important for buffer pool size choice. You do not want OS to cache what Innodb is caching already. Innodb cache …
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… size of innodb_buffer_pool_size: Let me point out three interesting characteristics about this benchmark: The A arrow is when data fits completely in the buffer pool… need to be a small percentage – but in other cases it can be considerably higher. If you don’t know what your…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…what amount of the space in innodb_log_file corresponds to changed pages in the buffer pool…innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 64M innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=16 innodb_log_file_size = 2000M innodb…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… detect what kind of flushing is used. There is a variable in SHOW STATUS, innodb_buffer_pool_pages_flushed, but it shows the sum of flushing… LRU list. So, let’s see what flushing we have using 13GB and 52GB for innodb_buffer_pool_size settings in Percona Server 5.5… if that is really needed. Of course, more memory and/or a better I/O subsystem should also be helpful. (Post edited by…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server… work kind of OK with default key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer pool caches both…
Post: Innodb Fuzzy checkpointing woes
May 10, 2006 By Leave a Comment
… the same LSN range scheduled for flush and Innodb might end up flushing most of buffer pool pages.     Now… unusual case of increasing your buffer pool size actually may decrease performance. What I would do to fix it ?  I think fuzzy checkpointing should be dynamic…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…size of read requests. For random IO these should be 16K – page size, for full table scan or index scan read-ahead may be…be equal to total size of buffer pool, because buffer pool…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…size of your Innodb log files to be able to use a lot of memory for write buffering efficiently… this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL…should work through the adaptive hash index! What is your database like? Do you have a big enough buffer pool…
