… replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT… are no longer complete or useful for point-in-time recovery. Generally if you’re considering the binary log filtering approach… get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace and….sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… more zealous. Pretty interesting to speed up point in time recovery when you dataset is 700GB. If you google a bit… work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media with records(ibdata1, *.ibd, disk image, etc.) and a table… exist for any InnoDB table. If explicitely defined its `NAME` is PRIMARY. If the primary key is not defined InnoDB will use a… generate CREATE TABLE statement. 0. Download the latest revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. Compile…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
…/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:start . The biggest challenge here is to find index_id for each table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:advanced_techniques#recovering_the_data…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo… replication threads were started before running wsrep recovery, this would lead to memory corruption and…Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work …
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… delete any data (though you can create or drop Innodb tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize… data back from simple Innodb Table Corruption. In more complex cases you may need to use higher innodb_force_recovery modes to block purging…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
….com/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our …InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Doing recovery: scanned up to log sequence number 3 768598528 (6 %) …. InnoDB: Doing recovery…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… alter the schema of the table after the backup has been taken. The variable innodb_file_per_table must be enabled. Then, our… the use of –export option runs a recovery process on the backup with innodb_fast_shutdown=0 and therefore merging all the… again! Conclusion: As we learned , you can also recover single InnoDB table as with MyISAM but knowing in advance that there are…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
Everyone using Innodb tables probably got use to the fact Innodb tables perform non locking reads, meaning unless you use some modifiers … table. It also applies to similar tables with where clause and joins. It is important for tables which is being read to be Innodb… makes locks unsafe fore replication and point in time recovery, so use innodb_locks_unsafe_for_binlog option with caution. Note disabling…
