… want tables to be checked and repaired on startup myisam_recover is the decent option. If this causes problems because MySQL starts to… tables at the same time blocking all connections may be MyISAM is simply not the right choice for you. Running check… middle ground – you still have some queries ran against corrupted MyISAM tables which can cause wrong query results or further corruption…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… cases such as modifying meta data stored in MyISAM tables which can get master out of sync…choices do you have in this case ? Your main options are using Backup or Slave with delayed replication …positions in mind. Such if you recover master you need to recover slaves to matching snapshot – either it…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… need to do roll forward recovery while recovering from backup. There are however some cases … on the master. Even though replicate-*-table options also have some issues they are much …MyISAM tables, because MyISAM can’t be disabled and so if you create tables as MYISAM or ALTER them to MyISAM…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… that server A disk failed, and RAID array does not recover You run into a InnoDB corruption bug that propagates via… have a lot of non-transactional tables (i.e. myisam), use –rsync option. This will rsync a copy of all the frm… – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We are…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…on this matter at this point. [-] Few configuration options This one is probably a bit contradicting …storage engines, it certainly can be applied for MyISAM and Innodb. I remember there were plans … Buffer was implemented and seeing some pages recovered from it after it was implemented. Speaking …
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
…nice for Innodb to have some additional recovery options for example for skipping over insert buffer …5.0.33, meaning you could not really recover corrupted Innodb tables this way for about 6…experience Innodb tables become corrupted more seldom than MyISAM. Thanks to checksums and crashing in case of…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the current performance, future performance, scalability, ability to recover from disasters? We also want to know what…won’t give you a full rundown over every option in the file. But again, you learn quickly… an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might…
