… innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… high io subsystems, it effectively just doubles the dirty buffer flushing per second when the % dirty pages exceeds this amount. innodb_io_capacity: This setting, in spite of all our grand hopes that it would allow Innodb to make better use of our IO in… to the transaction log if you set this too high. innodb_write_io_threads: Controls how many threads will have writes in…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… 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…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
… innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write_io_threads=16 innodb_read_io_threads=16 innodb_io_capacity=2000 I made two runs, one with default innodb-log…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… innodb_flush_method=O_DIRECT innodb_file_per_table = 1 And for XtraDB I additionally used: innodb_io_capacity = 10000 innodb_adaptive_checkpoint = 1 innodb_write_io_threads = 16 innodb_read_io_threads…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… innodb_log_files_in_group=2 innodb_log_file_size=1900M 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…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read_io…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… innodb_buffer_pool_instances=1 innodb_log_file_size = 8000M innodb_log_files_in_group = 2 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…
Post: Which adaptive should we use?
September 15, 2009 By 14 Comments
… innodb_log_files_in_group = 2 innodb_io_capacity = 4000 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_flush_method = O_DIRECT innodb_thread_concurrency = 0 innodb_ibuf_active_contract = 1
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…
