…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_flushing_method = estimate innodb_flush_log… InnoDB log flushing, which can cause downward spikes in performance…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
Hi Chris, try this: innodb_log_file_size = 64M (without the “B” in “MB” string) This works on …/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system I set… sure what the MySQLDB performance cracks like Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_… (15 min 54.29 sec) Please help to improve performance and suggest if any config changes are to be …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_log_buffer_sizeblogpercona.commanual innodb_log_file_sizeblogpercona.commanual innodb_log_files_in_groupblogpercona.commanual innodb_log_group_home_dirblogpercona.commanual Innodb_log_waitsblogpercona.commanual Innodb_log_write_requestsblogpercona.commanual Innodb_log…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… of write size. InnoDB writes to the log files in multiples of 512 bytes. Mark Callaghan explained this and some of its performance implications here. How many big writes does InnoDB… So, in sum, we see that about 3/4ths of InnoDB log file writes on this workload are 512 or 1024 bytes. (It…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
…size=26G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=4G innodb…
Post: How long is recovery from 8G innodb_log_file
December 22, 2010 By 11 Comments
… support of innodb_log_file_size > 4G. This test was done using Percona Server 5.5.7, but the same performance expected for InnoDB-plugin and… InnoDB: Rollback of non-prepared transactions completed that is 14min 57sec I think this time is acceptable as trade-off for performance…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… your concerns are at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? We also want… is the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file. But again, you… the error log is interesting and needs to be investigated. You might find that there are InnoDB tables whose .frm files exist but…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… benchmark (100W ~ 10GB of data, 12G innodb_buffer_pool_size, 1G innodb_log_file_size), MySQL 5.5.10 with innodb_adaptive_flushing=ON (default)). The problem… a result of how it works, instead of performing 1 random write, InnoDB will perform 8 random writes. I do not have a…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… is unflushed in log buffer as well as when last checkpoint was performed. Innodb uses fuzzy checkpointing so this line hold log sequence, all… in log files. By monitoring log sequence number and value up to which logs have been flushed you can check if your innodb_log_buffer_size is…
