… by AFTAB, crash recovery is far cheaper in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster…/en/innodb-performance-recovery.html “If you kept the size of your redo log files artificially low because recovery took a long…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… captured. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace and…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… more zealous. Pretty interesting to speed up point in time recovery when you dataset is 700GB. If you google a bit… cosmic ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
We implemented early lock release for InnoDB but didn’t write a paper about it. Unfortunately it broke assumptions for crash recovery so the change was removed.
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… to have an accurate table definition to ensure a successful recovery. Even an unnoticeable difference like NULL or NOT NULL can… Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL There is yet another source of information about the…. 0. Download the latest revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. Compile the dictionary…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
….send_window and evs.user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL… threads were started before running wsrep recovery, this would lead to memory corruption and server crash. Bug fixed #1132974 (Seppo Jaakola). Conflicting…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… better solution. Innodb Recovery – Unless you have some hardware problems (99%) or found new Innodb bug (1%) Innodb recovery should be automatic… which you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write about…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… everyone may know this, but there are precious few innodb crash recovery tests available. Some folks have noticed this and asked for… crash test bug: DBUG_EXECUTE_IF(“crash_commit_before”, DBUG_SUICIDE();); DBUG_EXECUTE_IF(“crash_commit_after_prepare”, DBUG_SUICIDE();); DBUG_EXECUTE_IF(“crash…_CRASHED (101) I also took pains to ensure that the randgen workload was having an effect on the test tables between crash/recovery…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… you’re using only Innodb tables – Innodb when Innodb does crash recovery it would print position in master log files up to… implementation though the code which prints the data back on recovery was not, so it prints you some log file name… broken other somewhat similar functionality works as expected. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
… http://dammit.lt/2008/10/26/innodb-crash-recovery/ This is problem when your InnoDB crashes, it may takes long time to start… lives in http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/ tree. The patch by itself is quite small… review it: http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/revision/86 So your comments about patch is…
