…innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per-table –target-dir=/mnt/mysql/export ALTER TABLE…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
…we always could repair table by running ALTER TABLE with limited impact to production system (as only one table of about …potentially corrupted tables (in this particular corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb_force_recovery and …
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… couple of tables rather than full dump and restore. The bug which we found during attempt to dump tables with innodb_force_recovery=4 was confirmed to be added in 5.0.33, meaning you could not really recover corrupted Innodb tables this…, so simple ALTER TABLE fixes it This also seems to be the case. In my experience probably 80-90% of Innodb corruptions are…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_flush_methodblogpercona.commanual innodb_force_recoveryblogpercona.commanual Innodb_have_atomic_builtinsblogpercona.commanual innodb_io_capacityblogpercona.commanual innodb_lock_wait_timeoutblogpercona.commanual innodb…recovery…
