… InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for… is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup… fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs. Fixed by…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for… is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup… fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs. Fixed by…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… tables. Global read lock only held until myisam tables are dumped. We are researching into how we could further improve lock times here when… 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, especially the option …read_ahead_thresholdblogpercona.commanual innodb_read_io_threadsblogpercona.commanual innodb_replication_delayblogpercona.commanual innodb_rollback_on_timeoutblogpercona.commanual Innodb_row_lock….commanual sporadic_binlog_dump_failblogpercona.commanual sql_…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
…_length = 0}, mark_used_columns = MARK_COLUMNS_READ, name = {str = 0×0, length = 0}, lex = 0x33ae900…observer = 0×0, open_tables = 0x7f3eac0085d0, temporary_tables = 0x7f3e84034a50, LOCK_temporary_tables = {m_mutex = { mutex = [...] … dump by checking the contents of the thd array in the mysql_execute…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… use FLUSH TABLES, LOCK TABLES, or FLUSH TABLES WITH READ LOCK? These all interrupt processing. What other effects are there on MySQL? I’ve… of the things I’d require specifically for MySQL, or more so for MySQL than for other types of backups. Where is… can’t even get the most basic information such as “dump or file copy.” Sometimes they tell me to register and…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… the file-based logs on the server. I read the logging code in MySQL 5.6.10 source, in file sql/log….0); 1947 sprintf(lock_time_buff, “%.6f”, ulonglong2double(lock_utime)/1000000.0); However, just like in prior releases of MySQL, when writing slow… table—they only read the query log file. To account for this, you can use a client script to dump the contents…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
…) mysql> select * from C; +——+ | t | +——+ | test | +——+ 1 row in set (0.00 sec) SESSION2: root@ubuntu:~/dump# mysqldump –single-transaction dumptest > dump.sql SESSION1: (before dump has completed) mysql> alter table C add i int… use mysqldump –lock-all-tables instead which does not have this problem at the cost of having database read only for the…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…is generally a single person, with another person reading all the notes and generally keeping in …, at the tail it has information on core dumps and so on. It’s possible that …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock…
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
…) Extract the names of all databases (except mysql and information_schema) 2) FLUSH TABLES WITH READ LOCK; 3) Record Log File and Position…/Web hosting company with 650+ databases (450+ GB) in one mysql instance. mysqldump databases one by one : 7 hours mysqldump in… (not using mysqldump) MAATKIT’s very own toolset has Parallel Dump and Parallel Restore sugin SELECT INTO and LOAD DATA INFILE…
