…InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive… problems caused by buffer pool mutexes, using “estimate” checkpoint method to reduce chances of log flush storms …
Comment: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… “innodb_adaptive_checkpoint=estimate” It performs much more work than “innodb_adaptive_checkpoint=keep_average” and in the result XtraDB may be slower than MySQL/InnoDB-plugin, because it does more operations in flushing. Probably it will be good idea to change “innodb_adaptive_checkpoint=keep_average…
Post: Adaptive checkpointing
November 13, 2008 By 9 Comments
… 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…
Post: Which adaptive should we use?
September 15, 2009 By 14 Comments
… 0 innodb_ibuf_active_contract = 1
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… pages 457902 Log flushed up to 10026890404067 Last checkpoint at 10024612103454 …. We enabled innodb_adaptive_flushing just before 10am, which resulted in a… 2 * 1.5G log files, and innodb_io_capacity=1000. While adaptive flushing was off, the checkpoint age was comparable to the log…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…, innodb_log_file_size=2000M (innodb_log_files_in_group=2), and innodb_flush_log_at_trx_commit=2. Also, innodb_adaptive_flushing (ON) / innodb_adaptive_checkpoint (estimate… the existing adaptive_checkpoint or adaptive_flushing algorithms. So, Yasufumi invested a lot of research time and came up with the new innodb_adaptive_checkpoint=”keep…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… do checkpoint activity. What is important about this? If your workload is mostly bound by the LRU list, then innodb_adaptive_flushing, innodb_max… is less than innodb_max_dirty_pages_pct and checkpoint age is less than 3/4 of innodb_log_file_size * innodb_log_files… already use Percona Server, then increasing innodb_log_file_size may help, but check checkpoint age history to see if that is…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… waves for InnoDB-plugin. Here we observe innodb_adaptive_flushing in action (which is ON by default), and I think innodb_adaptive_flushing in InnoDB-plugin… different adaptive_checkpoint algorithm. The results are: So I guess buffer_pool improvements play here for XtraDB, and looking on summary result: InnoDB…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
… innodb_log_file_size=4G innodb_adaptive_checkpoint=keep_average innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write_io_threads=16 innodb…
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
… can set some InnoDB options! I’m going to try the obvious first: innodb-flush-method, sync-frm and innodb-flush-log-at-trx-commit. There is an undocumented option for innodb-flush-method… just escapes the timeout. I then added the options of innodb-adaptive-checkpoint=0 and flush-neighbor-pages=0 in the hope of…
