… Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced…abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql dependency… would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying …
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
…no 5.6-specific features are used (such as GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool dump… #1085099 (Alexey Kopytov). XtraBackup for MySQL 5.6 has improved the… (Alexey Bychko). innobackupex would fail when –no-lock and –rsync were used in conjunction….
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… are dumped. We are researching into how we could further improve lock times here when non-transactional tables are used Almost no locking, if… retention dailies weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available Downloading from s3…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, …lock_current_waitsblogpercona.commanual Innodb_row_lock_timeblogpercona.commanual Innodb_row_lock_time_avgblogpercona.commanual Innodb_row_lock_time_maxblogpercona.commanual Innodb_row_lock…newblogpercona.commanual no_defaultsblogpercona….sporadic_binlog_dump_failblogpercona.commanual…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
…lock_time_buff, “%.6f”, ulonglong2double(lock_utime)/1000000.0); However, just like in prior releases of MySQL…mine: cat <<'GO' | mysql –raw –skip-column-names –quick –silent –no-auto-rehash –compress $* SELECT CONCAT…,Delayed insert,Change user,Binlog Dump,Table Dump,Connect Out,Register Slave,…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
… get new structure in the dump but no data. Here is example: SESSION1: mysql> show tables; +——————–+ | Tables_in_dumptest | +——————–+ | A | … SET character_set_client = @saved_cs_client */; — – Dumping data for table `C` — LOCK TABLES `C` WRITE; /*!40000 ALTER TABLE `C…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, at the tail it has information on core dumps and so on. It’s possible that it…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock…s true workload. At the moment there is no other technique that approaches the amount of …
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… from the transactions are buffered together and when dumped to binary log as one big chunk which …will perform full table scan in MySQL 5.0 (even if there are no spam posts) which will load … going through replication in 5.0 for many reasons (locking, long query time, waste of execution on slave). …
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 … disabled, and absolutely no effect on the optimized…dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql real 2m52.785s user 0m3.179s sys 0m0.069s $ time mysql -uroot test < dump…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…buffer pool by large full table scan HT: No PZ: Another possible area of optimization. I …it is global MySQL Server option, though it may have problems on Linux if you lock very large portion…when an InnoDB instance is created. PZ: Sequential “dump” of buffer pool would need more optimizations to work…
