…innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… memory for the MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option… at the Linux settings for the dirty pages. You can either set “vm.dirty_ratio” or “vm.dirty_bytes”, but keep in mind that…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… use case where the MySQL working set is significantly larger than the InnoDB buffer pool (thus leading to a lot of buffer pool disk reads) but… them have support for not caching sequential IO, adjusting the dirty page threshold, flushing the cache on demand, or having a time…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Innodb_buffer_pool_pages_datablogpercona.commanual Innodb_buffer_pool_pages_dirtyblogpercona.commanual Innodb_buffer_pool_pages_flushedblogpercona.commanual Innodb_buffer_pool_pages_freeblogpercona.commanual Innodb_buffer_pool_pages_latchedblogpercona.commanual Innodb_buffer_pool_pages…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
… in cache, for example being washed away by other queries. MySQL Server does not provide any information of this type, Percona…(dirty = 1) dirty, SUM(hashed = 1) hashed FROM innodb_buffer_pool_pages_index GROUP BY index_id) bp JOIN innodb_sys_indexes ON id = index_id JOIN innodb…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…dirty pages in the InnoDB buffer pool. This value is calculated from the output of mysqladmin ext -i10 using this formula: (100*Innodb_buffer_pool_pages_dirty)/(1+Innodb_buffer_pool_pages_data+Innodb_buffer_pool_pages…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… scenes those updated (dirty) buffer pool pages are flushed down the to the tablespace. If Innodb stops (read: crashes) with dirty buffer pool pages, Innodb recovery must be … any kind of production MySQL server, you should be monitoring your Checkpoint age and your Innodb dirty pages and try to see …
Post: How long Innodb Shutdown may take
September 2, 2010 By 9 Comments
… MySQL with Innodb tables to shut down ? It can be quite a while. In default configuration innodb_fast_shutdown=ON the main job Innodb… as workload and innodb_log_buffer_size and can be anywhere from 10 to 90% in the real life workloads. Innodb_buffer_pool_pages_dirty status will…
Post: How to decrease InnoDB shutdown times
April 15, 2009 By 20 Comments
… the dirty pages, like this: mysql> set global innodb_max_dirty_pages_pct = 0; Now run the following command: $ mysqladmin ext -i10 | grep dirty | Innodb_buffer_pool_pages_dirty | 1823484 | | Innodb_buffer_pool_pages_dirty | 1821293 | | Innodb_buffer_pool_pages_dirty | 1818938…
