… this Virident card (configuration C): innodb_io_capacity = 30000 innodb_adaptive_flushing_method = keep_average innodb_flush_neighbor_pages=none innodb_max_dirty_pages_pct = 60 And then… hypothesis. vCache vs. FlashCache – dirty page threshold Finally, we examine the impact of a couple of different dirty-page ratios on device performance, since…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… to most effective: innodb_max_dirty_pages_pct: This attempts to keep the percentage of dirty pages under control, and before the Innodb plugin this was really… subsystems, it effectively just doubles the dirty buffer flushing per second when the % dirty pages exceeds this amount. innodb_io_capacity: This setting, in…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… mostly bound by the LRU list, then innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size do not matter, and… MySQL 5.1/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… this case is to increase innodb_io_capacity and decrease innodb_max_dirty_pages_pct so as to have fewer dirty pages. But I call that tuning… keep the number of dirty pages within the given innodb_max_dirty_pages_pct limit. Another possible solution would be to increase innodb_log_file_size, but…
Post: How long Innodb Shutdown may take
September 2, 2010 By 9 Comments
… Innodb has to do to complete shutdown is flushing dirty buffers. The number of dirty buffers in the buffer pool varies depending on innodb_max_dirty_pages_pct as well as workload and innodb_log…
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…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…=uniform –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool… innodb_thread_concurrency=16 innodb_flush_method = O_DIRECT innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 innodb_max_dirty_pages_pct=90 max…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_io_capacity=500 innodb_max_dirty_pages_pct = 60 innodb_purge_threads=1 innodb_adaptive_flushing=0 innodb_doublewrite=1 innodb_flush_neighbor_pages=0 innodb…
Post: Adaptive checkpointing
November 13, 2008 By 9 Comments
… method, because innodb_max_dirty_pages_pct and innodb_io_capacity are independent to the checkpoint age. <innodb_adaptive_checkpoint(new patched parameter) & innodb_io_capacity> The last is the case of using innodb_adaptive_checkpoint instead of innodb_max_dirty_pages_pct…
