… of the data The important tables were all InnoDB Having a backup, customer has first attempted to restore from backup on the production master Luckily (or rather, unfortunately) backup only had table definitions but not… table, a small one with 4 smallint columns where all we could match on was a sequence of numbers from a single…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… backing your databases up properly either. For per-table restores, we use mysqldump + –single-transaction and > splice out what we need with… out what you need when maybe a critical table of data needs to be restored quickly and your ops is down at… in the realm of possibility that we would have to restore a table from tape to deal with some kind of unknown…
Comment: MySQL Backup tools used by Percona Remote DBA for MySQL
March 17, 2013 By 8 Comments
… long time to load. Some factors that affect speed of restore include innodb_log_file_size, innodb_buffer_pool_size, innodb… things up nearly as much. I recommend testing restores using different number of restore threads and measure time taken. Compare this to… primary purpose of logical restores are when retrieving a subset of data such as a single table or a single schema which is only…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… a backup with mysqldump from the master: # mysqldump –all-databases –single-transaction –triggers –routines –host=127.0.0.1 –port=18675… duplication then you can run the pt-table-checksum and pt-table-sync. How to restore a slave in a good and slow… error messages can dissapear on the shell buffer because the restore of the dump will continue. Be cautious. Same problem again…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… could be possible to recover, on some specific cases, a single table from a full backup in order to save time and… because we don’t have a backup or the backup restore process doesn’t work. How can I recover deleted rows… pages are stored in a single directory with some subdirectories inside, one for every single index in the table: ~/recovery-tool# ls pages…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…tables I got “Dictionary memory allocated 392029720″ which means very simple single tables takes about 4KB of space in data dictionary. More complicated tables… InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB…
Comment: My "hot" list for next InnoDB features
October 11, 2009 By 18 Comments
It’s a table cold backup and restory without shut down of InnoDB Restoring a single .ibd file http://www.innodb.com/doc/hot_backup/manual.html#partial.restoring.single
Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !
December 18, 2012 By 3 Comments
…: But in this case there was one major issue, the tables where MyISAM and this is not really recommended with Galera… each production server restoring the dump on the node that will be the dedicated slave convert the table in InnoDB configure and… times… that could take some time ! And then, if the single production servers where more than 3 ? So I decided to…
Post: Small things are better
October 8, 2006 By 15 Comments
…. Sometimes corruption kind be mild, so ALTER TABLE to rebuild the table fixes it. Sometimes table needs to be dropped and recovered from… better to have backups for. Backups however take time to restore, especially if you do point in time recovery using binary… data split at 256 groups of tables. Current data size is small enough so even single table would not be big problem but…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… versions, compression was only possible with streaming backups + external (usually single-threaded) compression utilities, which also had a number of other… copying, it was required to uncompress the entire backup to restore a single table). Percona XtraBackup now supports streaming incremental backups. In previous…
