… theory. The two most important parameters for InnoDB performance are innodb_buffer_pool_size and innodb_log_file_size. InnoDB works with data in memory, and… the transaction log affects recovery time after a crash. The bigger the log, the longer the recovery time. Okay, so we have innodb_log_file_size. Let…
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
… first log file name in binary log index file” error message Looking at the Master for this slave I could see its binary log files going… the binary log file mentioned did not ever exist on this master. What is going on ? The thing is Innodb does not update… which restores this information and uses it on slave crash recovery.
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
…=29847 http://dammit.lt/2008/10/26/innodb-crash-recovery/ This is problem when your InnoDB crashes, it may takes long time to… 16 running threads. MySQL params are: innodb_buffer_pool_size=16G innodb_log_files_in_group=3 innodb_log_file_size=512M So let’s take standard MySQL 5.4.1, it starts: 090706 15:39:47 InnoDB…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… tuning innodb buffer pool 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: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…Recovery uses the transaction log by redoing (hence the name ‘redo log‘) the page operations in the log…Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number 9682004056 Log…allow parallel writing to the same file by more than one thread (…
Post: Innodb Recovery - Is large buffer pool always better ?
July 17, 2007 By 3 Comments
… Innodb crash recovery on box with large amount of memory (64GB) with Innodb Buffer pool configured to be just a bit over 20GB. Innodb recovery was taking long hours with reasonably sized Innodb log files (256M…
Post: What is the longest part of Innodb Recovery Process ?
December 20, 2007 By 1 Comment
… MySQL 4.1 and above the longest part of recovery after crash for Innodb tables could be UNDO stage – it was happening… other hand always could be regulated by size of your Innodb log files so you could have it as large as you like… with restarts more than crash recovery as it presents in normal restarts as well – “Opening Tables”. As Innodb has to recompute the…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… (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… would be to increase innodb_log_file_size, but that: 1) only delays the problem until later; 2) increases recovery time (and that is an important factor with slow disks); and 3) MySQL does not support innodb_log_file_size > 4GB…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…log_file_size to 25 % of buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb…
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…rpl_recovery_…
