…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: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
…’re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it too large will… on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find log records which only have been…
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 innodb_open_files affects performance
November 18, 2009 By 4 Comments
… provides the best performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep… on hardware log file size workload and even when crash happen (how many unflushed changes we had) Repeating test with innodb_open_files=16384 I…
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…
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: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… frequently in Innodb talks and during consulting engagements. It is well known to get better performance you should normally set innodb_log_file_size large. We however usually recommend caution as it may significantly increase recovery time if Innodb needs…
