… table could wait on a metadata lock instead of failing or returning immediately …MySQL would re-create the test database when using rpm on server upgrade, even if the database…MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… table could wait on a metadata lock instead of failing or returning immediately …MySQL would re-create the test database when using rpm on server upgrade, even if the database…MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
… | A | | B | | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A; +———-+ | count(*) | +———-+ | 2359296 | +———-+ 1 row …you can use mysqldump –lock-all-tables instead which does not have this problem at the cost of having database read …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…ALTER DATABASE DEFAULT CHARACTER SET
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… technique is used for the backup? Is it mysqldump or a custom product that does something similar…LOCK TABLES, or FLUSH TABLES WITH READ LOCK? These all interrupt processing. What other effects are there on MySQL… just has a bullet point “Support for MySQL Databases“. Or “I have to transfer you to …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… | 0.000008 | | Opening tables | 0.000118 | | System lock | 0.000007 | | setup | 0.000027 | | creating table …database contained only the table I used in my previous examples): $ mysqldump -uroot test > dump_unoptimized.sql $ mysqldump… References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast …
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
… mysqldump) Write a customized backup script 1) Extract the names of all databases (except mysql and information_schema) 2) FLUSH TABLES WITH READ LOCK… company with 650+ databases (450+ GB) in one mysql instance. mysqldump databases one by one : 7 hours mysqldump in parallel, 7 databases at a time : 3…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…crash or partially executed statements. Table locks is no more problem, hot backups …aspects a lot – for example using mysqldump as a backup may well work…not so common paths in the MySQL server – in particular Optimizer may have… I’ve seen hundreds of GB databases ran with MyISAM with default settings…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…set from OS cache. Operation Systems and MySQL Itself employs various strategies to attempt to…locks reporting queries can affect web site performance dramatically. Sometimes instead of using slave you may use database… when move them to the master using mysqldump, or even careful file transfer if you…
Comment: Is DRBD the right choice for me?
March 14, 2012 By 18 Comments
… MySQL replication is resyncing a master and slave on a database with high write activity. Locking the master and dumping the master database via mysqldump can take 20+ minutes on a database of…
