… 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…/en/innodb-performance-recovery.html “If you kept the size of your redo log files artificially low because recovery took a long time, you…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… pool. Note that this can be somewhat mitigated using innodb_old_blocks_time, but that is outside the scope of this post… captured. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace and… target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… be more zealous. Pretty interesting to speed up point in time recovery when you dataset is 700GB. If you google a bit… many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… cosmic ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
Not everyone may know this, but there are precious few innodb crash recovery tests available. Some folks have noticed this and asked for…_CRASHED (101) I also took pains to ensure that the randgen workload was having an effect on the test tables between crash/recovery… –randgen-seed=time. For those test cases that are written to take advantage of this (like our shiny new Innodb crash tests!), it…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
… 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 time to start. Also it affects…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… the problems. As I already wrote innodb_log_file_size and innodb_buffer_pool_size affect recovery time significantly as well as your workload… may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write about them some other time.
Post: Innodb Recovery - Is large buffer pool always better ?
July 17, 2007 By 3 Comments
… with 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… pages in the flush list which takes a lot of time… Innodb is smart about a way it flushes pages, it tries…
Post: Innodb crash recovery update
May 22, 2007 By 3 Comments
I have not had a serious Innodb corruptions for a while, typically even if it happened it … worry. If it is global bug it should have been Innodb recovery show stopper while it goes back so many releases (5… isolated from all scripts which may bother it for the time of recovery. For complex systems it may be very hard to…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… set innodb_log_file_size large. We however usually recommend caution as it may significantly increase recovery time if Innodb needs to do crash recovery. I’m often something like what recovery time would expect for 512MB total…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… InnoDB: Doing recovery…
