… take 30×10=5 hours to restore. Right? Wrong. Mysqldump recovery time is not linear. Bigger tables, or tables… I restore from a raw backup (LVM snapshot, xtrabackup, innodb hot backup), it is very easy to model how much longer…) * 1024)/70/60 = ~17 minutes I can tell progress with mysqldump by monitoring the rate at which show global status like…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… small table drops more than 150 times when heavy mysqldump is running concurrently. mysqldump itself also slows down about 2x. What is… they should not push any hot data which is in “young” sublist. However when you’re doing mysqldump (or running some complex…. Running Sysbench and MySQLDump convurrently gives about 325 req/sec for sysbench and some 100 seconds for mysqldump which is a dramatic…
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
… are other issues with mysqldump – but I didn’t want to cover them in this article. mysqldump needs to churn all the… is not “hot” (non blocking). You can make it hot – but this synchronizes the backup to the start of running mysqldump. Xtrabackup synchronizes…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… or partially executed statements. Table locks is no more problem, hot backups are easy, though there are some important things which… Performance also affects Operations aspects a lot – for example using mysqldump as a backup may well work for MyISAM but will… time to do restore for Innodb. On large scale installations mysqldump does not work anyway but it may still work for…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… different indexing Q: Is there a Percona recommendation for finding Hot Spots in a high load application? Or some material to… response time of the server: that’s typical of a hot spot and this query is a good candidate for optimization…. Q: Is any logical backup facility provided by Percona like mysqldump? No, on the backup side, we’re focusing on XtraBackup…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…, and describe the advantages of common backup methods (mysqldump, file system snapshot, InnoDB hot backup). Setup and administer MySQL replication. Monitor MySQL…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… global variables. This is a problem in mysqldump based configurations, and we will prepare a hot-fix for that. Vadim, thanks for…
Comment: An argument for not using mysqldump
November 11, 2010 By 26 Comments
… still restore a table at a time with xtrabackup/innodb hot backup. You may want to check out this discussion on…): http://code.openark.org/blog/mysql/an-argument-for-using-mysqldump
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
If you’re just running innodb, you can run mysqldump with the –singletransaction flag which will get you a consistent … you), then there really is no way to get a “hot” consistent dump. You can issue flush tables with read lock…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only way practical… using dedicated server for backups. I should also note for mysqldump backup typically tools with better and slower compression make sense…
