… you have the faster load will normally be, if you measure…mysqldump output). Generally LOAD DATA can be optimized better and a bit faster because of easier parsing. Mysqldump however takes…the database data directory to see how much data is loaded per… our rows were relatively long. In most cases I …
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
… Lets talk a bit how it is happening and how to prevent it. Cache… in random locations other threads are willing to take. Especially some older disk schedulers … move them to the master using mysqldump, or even careful file transfer if…none of them can take too much resources for too long time. If you…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… there is a dedicated slave available for all long reporting queries. In case MyISAM was chosen not… – for example using mysqldump as a backup may well work for MyISAM but will start taking way too much…table but it is important to consider them. How about Mixing Storage Engines ? Sure you can mix…
Post: Living with backups
November 6, 2008 By 28 Comments
…heavy queries against each table in the database when mysqldump is used or reading a lot of data …. That happens for as long as it does not get flushed. MySQL obviously takes advantage of this functionality … called ionice. It allows to affect how I/O scheduler will be dealing with I/O request coming …
Comment: Using LVM for MySQL Backup and Replication Setup
August 18, 2011 By 53 Comments
…volume group they are residing in , now taking a mysqldump is a long process and can’t afford the slave …. what are the options of using that snapshot and how ? the purpose is to use this snapshot or …only and configure mysql to use it , will that work ? and will that impact on the original volume in …
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
…the product was killed by IBM. So long time after PPC 2009 there was …setup a new node you had to take down whole cluster. And all this time … whole mysqldump, like it is new empty node. I hope Codership guys will address this…-questions/. I am not sure how many nines it will provide 
, but efforts on…
