… and two slaves, all had same setting Developer accidentally ran DROP DATABASE X on the wrong machine (production master) All slaves…, here’s what I learned while working on this case: Recovering from XFS is possible. Just a month ago we had… deleted files on xfs – we all agreed on few things: recovering files from xfs is hard, if at all possible we…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
As I wrote we had been recovering corrupted Innodb Tablespace and it is finally done now. As … would be just the table it should have been easy – dropping the table with corrupted page would remove all appropriate insert… added in 5.0.33, meaning you could not really recover corrupted Innodb tables this way for about 6 months. What…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…’ error. The table and triggers created during the process are dropped, and the original table is left unmodified. The same attendee… is known, this space won’t be recovered when the auxiliary table is dropped unless you’re using innodb_file_per_table… to run the alter table command directly (specially so when dropping an index, based on my experience). Q: I see lot…
Post: Upcoming webinar on Data Recovery for MySQL
April 6, 2011 By 5 Comments
… the task of recovering data from a database, whether it be via user error such as a erroneously dropped table or from… the structure and state of tables * Retrieving data * Restoring from recovered data During this Webinar the Percona-InnoDB-Recovery-Tool will…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… one of the worst onces, because you can’t really recover data on per table basics. Also if MySQL crashes during… corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb_force_recovery and load them… with lower recovery setting as it may allow you to recover more data or avoid full dump and restore. Another trick…
Post: Small things are better
October 8, 2006 By 15 Comments
… the table fixes it. Sometimes table needs to be dropped and recovered from backup but in certain cases you may need to… to like medium end commodity hardware) makes it faster to recover, smaller tables allow per table backup and recovery to happen…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… be removed or overwritten A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down… that server A disk failed, and RAID array does not recover You run into a InnoDB corruption bug that propagates via….g. there is one primary schema and that schema was dropped. Basically when restoring may take less time that trying to…
Comment: How long is recovery from 8G innodb_log_file
December 23, 2010 By 11 Comments
…. It did recover faster than innodb hot backup 
Unfortunately, it fails if partitions are dropped or any tables are dropped for legitimate purpose…
Comment: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… further: drop durability inside InnoDB (–innodb-flush-log-at-trx-commit=0), and instead get durability and consistency by recovering any missing… best solution in terms of efficiency, as it allows to drop durability (no fsync() at all) and still preserve consistency. But…
Comment: Funniest bug ever
January 31, 2009 By 19 Comments
… are to recover data that has been dropped, deleted, corrupted, etc and there is no backup. If it’s been dropped from the…
