…what is now a …buffer pool should be faster than getting them from the OS cache, which is another advantage of InnoDB…innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…InnoDB is faster, but you should look into the steady decline of InnoDB… for InnoDB, but this is what …and it might be a problem …innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 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 118 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…
