… = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
… smarter about flushing more aggressively based on the number of dirty pages and the rate of transaction log growth. innodb_adaptive_flushing_method: (Percona Server… method is my go-to setting for managing Checkpoint age. To be clear, the best we have today (IMO) is using innodb_adaptive_flushing_method…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… InnoDB configured for this hardware innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log… and HDD, while for SSD in Percona Server we have “innodb_adaptive_flushing_method = keep_average”. Unfortunately on spinning disks (as in this case…
Post: Which adaptive should we use?
September 15, 2009 By 14 Comments
… innodb_write_io_threads = 8 innodb_flush_method = O_DIRECT innodb_thread_concurrency = 0 innodb_ibuf_active_contract = 1
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…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
… SHOW INNODB STATUS was made available in new status variables in InnoDB Show Status. Bug fixed:#698797. Variable Changes New variable innodb_adaptive_flushing_method was added. New variable innodb_use_global_flush_log_at…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… flushing algorithm Disable flushing of neighbor pages and the configuration to provide better experience on SSD is : innodb_flush_neighbor_pages = 0 innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb_log_file_size = 4G Versions…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…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_adaptive…
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_…, the flushing becomes more strong. This is the effect of innodb_adaptive_checkpoint. And its strength can be controlled by innodb_io_…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_adaptive_flushingblogpercona.commanual innodb_adaptive_hash_indexblogpercona.commanual innodb_additional_mem_pool_sizeblogpercona.commanual innodb_autoextend_incrementblogpercona.commanual innodb_autoinc_lock_modeblogpercona.commanual innodb…
