…MySQL manual, especially the ….commanual Com_rename_tableblogpercona.commanual Com_rename_userblogpercona…relay_logblogpercona.commanual relay_log_indexblogpercona.commanual relay_log_info_fileblogpercona.commanual relay_log_purgeblogpercona.commanual relay_log_recoveryblogpercona.commanual relay_log…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… know MySQL is not really ACID even with Innodb tables, at least not for DDL statements. There is a chance of failing… unsync with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1 sync_frm option was added… statements as RENAME TABLE – these are most vulnerable. master.info corruption – If slave happens to crash you can also have relay logs corruption…
