… InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring…
Comment: Connecting orphaned .ibd files
April 6, 2012 By 12 Comments
… file a bug here https://bugs.launchpad.net/percona-data-recovery-tool-for-innodb
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… some failures are not recoverable (which can cause problems for recovery after a snapshot). Alas, I don’t use LVM2 any…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… as the donor machine. Every once in a while the recovery of the innodb in the target location fails, though, even…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 24, 2012 By 20 Comments
… be recoverable 100% of the time. You might have found recovery bug but there have been very few of them. Typically…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
…://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
Comment: Percona Server vs MySQL on Intel 320 SSD
March 21, 2012 By 21 Comments
Patrick, There are two factors: 1. Speed of recovery is much better in MySQL/Percona Server 5.5 2. Having on SSD makes it also much faster. So having big log files is practical under these conditions. It still may be long, but that that painful as in old InnoDB.
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads 425080 (406936 + 18144) Dictionary memory…
Comment: Percona Server vs MySQL on Intel 320 SSD
March 19, 2012 By 21 Comments
Vadim, Thank you, as always. I would have not thought of having such a large log file size. I thought that would make recovery painfully long? Is the log size you show something that many of your clients are now using and that you would advise? Thanks!
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…
