…it progresses it may slow down dramatically, typically if Index BTREE has to be built by insertion and data does…mysqldump output). Generally LOAD DATA can be optimized better and a bit faster because of easier parsing. Mysqldump however takes… directory to see how much data…were relatively long. In …
Post: Living with backups
November 6, 2008 By 28 Comments
…again. That happens for as long as it does not get flushed. MySQL obviously takes advantage of this functionality … What can be done about it? Nothing really when you are using mysqldump. You can play some tricks…is also a utility called ionice. It allows to affect how I/O scheduler will be dealing …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… all long reporting queries. In case MyISAM was chosen not just happened to be it is …It is important the team understands Innodb and knows how to handle it, or be able to learn it. It…taking way too much time to do restore for Innodb. On large scale installations mysqldump does not work anyway but it…
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…that mysqldump –single-transaction –master-data does a FLUSH TABLES WITH READ LOCK, only so that it can … but the world may take quite a long time to stop, as noted. Does MySQL have any plans …
