… know the potential cause for it. What are potential solutions for this problem ? you can use mysqldump –lock-all-tables instead which does not have this problem at the cost of having database read only for the duration of operation…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…lock…the test database contained only the table I used in my previous examples): $ mysqldump -uroot test > dump_unoptimized.sql $ mysqldump…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… of all the frm files and all the MYD/MYI files. It then does a second rsync while under a global lock. This means… schema’s. It does not handle views/triggers/procedures etc. Run with –no-schemas, instead use mysqldump for the schemas and rely on… out ALTER DATABASE DEFAULT CHARACTER SET
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…the end for most users – you do not get to deal with recovering tables on the crash or partially executed statements. Table locks…the databases from the Slave to the dev envinronment works great for MyISAM but does not work with Innodb. Backup tools like “mysqlhotcopy” does… mysqldump does…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…the backup? Is it mysqldump or a custom product that does something similar? Is it a filesystem copy? Does the backup system understand that you cannot back up InnoDB by simply copying its files? Does the backup use FLUSH TABLES, LOCK…for MySQL Databases“. Or “I have to transfer you to the …
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…The ways to do a backup is mysqldump/mysqlhotcopy. It is not fully transparent backup, as it applied TABLE LOCK… partially the problem of storage engine. The biggest problem is that MySQL does…the more space they take, and we have had setups where logs are 80% of total database size. Also there is the…
