…when using a blocking SST method like rsync or mysqldump. So, flow control kicks in when the recv… by the above calculation if fc_master_slave=NO). This yields the number of transactions the recv… simply by running “FLUSH TABLES WITH READ LOCK“, or perhaps by “LOCK TABLE”, in which case flow control…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… 5 and CentOS 5. Bug fixed #1144777 (Ignacio Nin). When mysqldump was used with –innodb-optimize-keys option it produced invalid… statements on an existing table could wait on a metadata lock instead of failing or returning immediately if there is a…. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… 5 and CentOS 5. Bug fixed #1144777 (Ignacio Nin). When mysqldump was used with –innodb-optimize-keys option it produced invalid… statements on an existing table could wait on a metadata lock instead of failing or returning immediately if there is a…. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… for logical backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are… into how we could further improve lock times here when non-transactional tables are used Almost no locking, if not using myisam tables… not handle views/triggers/procedures etc. Run with –no-schemas, instead use mysqldump for the schemas and rely on mydumper for data…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
… end we will get new structure in the dump but no data. Here is example: SESSION1: mysql> show tables; +——————–+ | Tables_in… at the same time as mysqldump was running we got table empty table with new structure in mysqldump instead of table with…. What are potential solutions for this problem ? you can use mysqldump –lock-all-tables instead which does not have this problem at…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… | 0.000004 | | init | 0.000008 | | Opening tables | 0.000118 | | System lock | 0.000007 | | setup | 0.000027 | | creating table | 0.002255 | | After… corresponding index; mysqldump –innodb-optimize-keys ignores the first UNIQUE index on non-nullable columns when the table has no PRIMARY KEY…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… exclusive (X) row locks to shared (S) locks, these S locks prevent X locks from being taken and …. Bug fixed #1070856 (Alexey Kopytov). There is no need to scan buffer pool for AHI … with AUTO_INCREMENT columns where correctly detected, mysqldump prevented all such keys from optimization, even …
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
… TABLES WITH READ LOCK; 3) Record Log File and Position from SHOW MASTER STATUS; 4) Run all mysqldumps of each database in…+ databases (450+ GB) in one mysql instance. mysqldump databases one by one : 7 hours mysqldump in parallel, 7 databases at a time….5 hours, loading 32 mysqldumps in parallel at a time I am sure 5GB should present no challenge if you parallel dump…
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 … have to hold the lock until your dump completes. A read lock is just that, a lock, and that means no delta transactions as…. That means its impossible to guarantee a “no downtime backup” via this method. You’re locked up for flush time + snap time…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
… All data is available locally, no need for remote access. No central management. You can loose… of SST available in Percona XtraDB Cluster: mysqldump, rsync and xtrabackup ( Percona XtraBackup with support… FLUSH TABLES WITH READ LOCK command). Xtrabackup SST does not require READ LOCK for full time,…
