… optimal performance, but effect does not end here. If …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…and our rows were relatively long. In most cases I …
Post: Living with backups
November 6, 2008 By 28 Comments
… queries against each table in the database when mysqldump is used or reading a lot of data …again. That happens for as long as it does not get flushed. MySQL obviously takes advantage of this functionality just … a utility called ionice. It allows to affect how I/O scheduler will be dealing with I/…
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…will start taking way too much time to do restore for Innodb. On large scale installations mysqldump does not…table but it is important to consider them. How about Mixing Storage Engines ? Sure you can …
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 25, 2010 By 28 Comments
How exactly do I get the master binlog position consistent with a transaction snapshot, in a way which does NOT involve FLUSH TABLES WITH READ LOCK? My understanding is that mysqldump –single-transaction –master-data does… world may take quite a long time to stop, as noted. Does MySQL have any…
