… 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 from the manual: http://dev.mysql…/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
…. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace and…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… are no longer complete or useful for point-in-time recovery. Generally if you’re considering the binary log filtering approach…
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…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
To recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media with records… to have an accurate table definition to ensure a successful recovery. Even an unnoticeable difference like NULL or NOT NULL can…. 0. Download the latest revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. Compile the dictionary…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
… it http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:start . The biggest challenge here is to find… each table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:advanced_techniques#recovering_the_data_dictionary
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: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
After nearly every recovery case the same question arises: How many MySQL records were …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… Jaakola). If MySQL replication threads were started before running wsrep recovery, this would lead to memory corruption and server crash. Bug…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… per table basics. Also if MySQL crashes during recovery lower values of innodb_force_recovery normally would not work. Reading Documentation one… magically healing itself after he was able to complete recovery with innodb_force_recovery=4. So I decided to check if I… innodb_force_recovery settings and see which one allows you to start. – After recovery succeeds you can try restarting with lower recovery setting…
