…/mysql/ib_logfile1 Of course it is worth reiterating the point made by AFTAB, crash recovery is far cheaper in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And….5/en/innodb-performance-recovery.html “If you kept the size of your redo log files artificially low because recovery took a long time…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see: http://bugs.mysql.com/bug.php?id=29847 http://dammit.lt/2008/10/26/innodb-crash-recovery/ This is problem when your InnoDB crashes, it may takes long…
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…shot at restarting MySQL with much…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… significantly increase recovery time if Innodb needs to do crash recovery. I’m often something like what recovery time …MySQL 5.0 these seems to be done in the background. In the future to increase recovery… and crash Innodb few times to see how long it takes Innodb to recover. I’d recommend to crash…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… in MySQL 5.1.60. I’ll repeat here the full documentation from the release notes: “InnoDB Storage … it all the time, InnoDB has managed to have recovery bugs for a very long time before and people… of us who are into InnoDB internals: The fix of Bug#12612184 broke crash recovery. When a record that …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… need to copy files. Fast Recovery Recovery time is as fast as putting data back and standard MySQL crash recovery, and it can be reduced even further. More on this later. Free No extra commercial tools as Innodb Hot… may take quite a while to complete on systems with long queries. Problems with data on multiple volumes If you have…
Comment: MySQL Replication vs DRBD Battles
May 1, 2008 By 12 Comments
I think DRBD is amazing. The concern about long crash recovery times after failover with InnoDB and DRBD can be resolved. One method to do this is a config option that enforces the maximum number of crash-recovery… IOs pending) in InnoDB crash recovery code? The Google patch had more than semi-sync for an HA solution with MySQL. It also includes…
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 -… long hours. REDO stage on other hand always could be regulated by size of your Innodb …restarts more than crash recovery as it presents in normal restarts as well – “Opening Tables”. As Innodb has …
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… Repositories). Based on MySQL 5.1.66, … code via a long argument to the …Crash-resistant replication would break with binlog XA transaction recovery. If a crash would happened between XA PREPARE and COMMIT stages, the prepared InnoDB… replayed during binlog crash recovery. Bug fixed #1012715 (Laurynas…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…innodb_log_file_size = 1600M – another Benchmark optimization. Such large logs typically will cause too long recovery time in case of crash…
