…, particularly when using a blocking SST method like rsync or mysqldump. So, flow control kicks in when the recv queue gets… queue applying on any node by simply by running “FLUSH TABLES WITH READ LOCK“, or perhaps by “LOCK TABLE“, in which case flow control will kick in…, I can easily see flow control if I execute a FLUSH TABLES WITH READ LOCK on node3: [root@node3 ~]# myq_status wsrep Wsrep Cluster Node…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…. This significantly improves InnoDB scalability on read-only workloads, especially when the default… log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…. This significantly improves InnoDB scalability on read-only workloads, especially when the default… log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We …post. Tips/Tricks: run with –kill-long-queries to avoid nasty problems with “FLUSH TABLES WITH READ LOCK” –compress, compresses tables per file and should …
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
If you’re just running innodb, you can run mysqldump with the –singletransaction flag which will get you a consistent logical … issue flush tables with read lock, but to do this right you have to hold the lock until your dump completes. A read lock is just that, a lock…
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
… (using mysqldump) Write a customized backup script 1) Extract the names of all databases (except mysql and information_schema) 2) FLUSH TABLES WITH READ LOCK; 3) Record Log File and Position from SHOW MASTER STATUS; 4) Run all mysqldumps of each database in…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
…SST available in Percona XtraDB Cluster: mysqldump, rsync and xtrabackup ( Percona XtraBackup with support of XtraDB Cluster will be …FLUSH TABLES WITH READ LOCK command). Xtrabackup SST does not require READ LOCK for full time, only for syncing .frm files (the same as with regular backup). Even with…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…, etc? What technique is used for the backup? Is it mysqldump or a custom product that does something similar? Is it… InnoDB by simply copying its files? Does the backup use FLUSH TABLES, LOCK TABLES, or FLUSH TABLES WITH READ LOCK? These all interrupt processing. What other effects are there…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 25, 2010 By 30 Comments
… 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 a FLUSH TABLES WITH READ LOCK, only so that it can do a BEGIN TRANSACTION; SHOW MASTER STATUS then immediately UNLOCK TABLES. This means…
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
… perfect. You need to make sure that you hold a lock after FLUSH TABLES WITH READ LOCK, so in command line scripting you need to add…. There are other issues with mysqldump – but I didn’t want to cover them in this article. mysqldump needs to churn all the… this synchronizes the backup to the start of running mysqldump. Xtrabackup synchronizes with the end of the backup, which is probably the…
