… performance – serving simple standard web traffic is drastically impacted when some heavy queries are ran in background or backup is done with mysqldump… makes workload extremely IO bound hence such drop in performance. The performance of mysqldump is impacted too because we now have 2 threads competing…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large … suffer from table locks reporting queries can affect web site performance dramatically. Sometimes instead of using slave you may use database… the slave and when move them to the master using mysqldump, or even careful file transfer if you’re using MyISAM…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…pool, fast index creation provides even better performance as compared to the default method, …, a small buffer pool had a huge impact on ALTER TABLE with the optimization disabled…used in my previous examples): $ mysqldump -uroot test > dump_unoptimized.sql $ mysqldump -uroot test –innodb-optimize-…
Comment: Using LVM for MySQL Backup and Replication Setup
August 18, 2011 By 53 Comments
… particular volume group they are residing in , now taking a mysqldump is a long process and can’t afford the slave… issues queries on tar backup on another volume it wont impact our performance since it has nothing to do with slave ?? can… this mess that i haven’t thought about apart from mysqldump ??? Tariq
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… databases below 100GB in size compression performance is usually not the problem (though backup impact on server performance may well be). We also… using dedicated server for backups. I should also note for mysqldump backup typically tools with better and slower compression make sense…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… work for your business and your application, and won’t impact your critical processes while it runs? Here are ten questions… impact on the running server? Blocking, I/O load, cache pollution, etc? What technique is used for the backup? Is it mysqldump… FLUSH LOGS? How does the system guarantee that you can perform point-in-time recovery? How does the system guarantee consistency…
