… to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it too large will increase recovery time, so in case of MySQL crash… explain what happens 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…
Post: How long is recovery from 8G innodb_log_file
December 22, 2010 By 11 Comments
… 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 MySQL 5… mins of work. The recovery time after start is: for 52GB innodb_buffer_pool_size: 101220 21:54:31 InnoDB: Database was not shut…
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: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…log file size workload and even when crash happen (how many unflushed changes we had) Repeating test with innodb_open_files…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… 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… transactions. As MySQL 5.0 these seems to be done in the background. In the future to increase recovery time even more…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-log-file-size=128M innodb-open-files=1000 innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb-read-io-threads=16 innodb-recovery-stats innodb-recovery…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… It is Performance of this process which may cause the problems. As I already wrote innodb_log_file_size and innodb_buffer_pool_size affect recovery time … log, but at performance penalty. If using Innodb you also might with to use innodb-safe-binlog option in MySQL 4.1 so your Innodb log…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log_buffer_size = 16M innodb…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
…would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% …innodb_log_file_size – This depends on your recovery speed needs but 256M seems to be a good balance between reasonable recovery time and good performance innodb_log_buffer_size…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL …Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive workloads especially for large data sets. Larger sizes offer better performance but increase recovery…
