…files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6…the backup stage. During the copy back stage (restore) it is copied back to data directory. … tables. Bug fixed #1169169. Tables that were dropped between taking a full backup and an …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6…the backup stage. During the copy back stage (restore) it is copied back to data directory. … tables. Bug fixed #1169169. Tables that were dropped between taking a full backup and an …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… a separate ALTER TABLE after restoring the data from a dump would actually make the restore slower; mysqldump –innodb-optimize-keys ignores indexes… be indexed, so it is impossible to temporarily drop the corresponding index; mysqldump –innodb-optimize-keys ignores the first UNIQUE index on…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
… running innodb_file_per_table There was a production master and two slaves, all had same setting Developer accidentally ran DROP DATABASE… and dropped their copy of the data The important tables were all InnoDB Having a backup, customer has first attempted to restore from… and see what you get. If InnoDB Data Dictionary was not overwritten by an attempt to restore from the backup, actually second…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… be no way to make Innodb avoid touching it. Even when we dropped all Innodb tables (for test purposes) Innodb still was crashing if… rather than full dump and restore. The bug which we found during attempt to dump tables with innodb_force_recovery=4 was… integer keys in Innodb while secondary keys may have very complex structure. Compex corruptions are resolved by dump and restore from backup…
Post: Recovery after DROP [ TABLE | DATABASE ]
July 19, 2009 By 4 Comments
… problem when data lost by execution DROP TABLE or DROP DATABASE statement. In this case even our InnoDB Data Recovery tool can’t… are deleted in this case. So first step after DROP is to restore files, and for ext3 file system there are two… them is to restore deleted files. I don’t know such tools for xfs, so in this case DROP will be fatal…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
…. First, you must meet certain prerequisites to be able to restore a ibd tablespace: The ibd file must be from a…, shutting down with innodb_fast_shutdown=0. We’ll use XtraBackup to avoid the server shutdown. You must not drop, truncate or alter the schema of the table after the backup has been taken. The variable innodb_file_per…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… (in this particular corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb_force_recovery and load them back. But just yesterday one of the customers told me he had Innodb… you to recover more data or avoid full dump and restore. Another trick which helped me in previous instances, but not…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… repositories i.e. updates on CentOS. If you are using InnoDB, it is also important that your transaction logs (ib_logfile… TIMESTAMP=1329980395/*!*/; DROP TABLE `salaries` /* generated by server */ … Now, let’s restore our data from the snapshot, under the hood restore is really… after restoring the snapshot, I know I have to apply mysql-bin.00022 only starting from position 336796712 and skipping the DROP…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… removed or overwritten A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server… and that schema was dropped. Basically when restoring may take less time that trying to load a logical backup. Restoring your data from… a limiting factor on restore time when done inline. When do we typically use mydumper restores: Restoring a single file Restoring a single schema…
