I have a 5G mysqldump which takes 30 minutes to restore from backup. That … take 30×10=5 hours to restore. Right? Wrong. Mysqldump recovery time is not linear. Bigger tables, or tables…) * 1024)/70/60 = ~17 minutes I can tell progress with mysqldump by monitoring the rate at which show global status like…
Comment: An argument for not using mysqldump
November 11, 2010 By 26 Comments
… blog (and my reply): http://code.openark.org/blog/mysql/an-argument-for-using-mysqldump
Comment: Lost innodb tables, xfs and binary grep
November 10, 2010 By 12 Comments
… previous post: http://www.mysqlperformanceblog.com/2010/11/08/an-argument-for-not-using-mysqldump-in-production/ My least favorite experience with reiserfs…
