… 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: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… 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…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… innodb ./global-variables.txt have_innodb YES ignore_builtin_innodb ON innodb_adaptive_flushing ON innodb_adaptive_hash_index ON innodb_additional_mem_pool_size 2097152 innodb_autoextend_increment 8 innodb_autoinc_lock_mode 1 innodb…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…=2 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: Adaptive flushing in MySQL 5.6
September 4, 2012 By 8 Comments
… options: innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 2 innodb_buffer_pool_size = 150G innodb_log_file_size = 4G innodb…
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
… the obvious first: innodb-flush-method, sync-frm and innodb-flush-log-at-trx-commit. There is an undocumented option for innodb-flush-method called “nosync… the options of innodb-adaptive-checkpoint=0 and flush-neighbor-pages=0 in the hope of avoiding a bunch of background flushing (which called…
Post: Looking for InnoDB/XtraDB hacker
October 25, 2011 By 3 Comments
… InnoDB flushing problems, e.g: http://www.mysqlperformanceblog.com/2011/09/18/disaster-mysql-5-5-flushing/ Fix InnoDB index locking Figure out InnoDB adaptive locking issue, e.g: http://www.mysqlperformanceblog.com/2010/02/25/index-lock-and-adaptive…
Comment: Effect of adaptive_flushing
December 10, 2009 By 5 Comments
How about the result of XtraDB for the workload with settings ” innodb_adaptive_flushing=OFF innodb_adaptive_checkpoint=estimate innodb_use_purge_thread=1 ” ? “estimate” is based on the different strategy, and it is not so much eagerly to flush…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… Tuned 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…
Comment: Effect of adaptive_flushing
December 29, 2009 By 5 Comments
How about the result of XtraDB for the workload with settings †innodb_adaptive_flushing=OFF innodb_adaptive_checkpoint=estimate innodb_use_purge_thread=1 †? “estimate†is based on the different strategy, and it is not so much eagerly to flush…
