… 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as SELECT ld.label_id, cai… on (cai.client_id = d.client_id) inner join label_to_device ld on (ld.device_id = d.id) where ld…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… quick refresher, Xtrabackup works by copying the dirty tablespace files while streaming the redo-logs to ensure that all transactions are also…-log –export /tmp/snapshot/2013-06-03_11-30 For each table, run: ALTER TABLE tblname DISCARD TABLESPACE Copy the .exp and .ibd files from the snapshot to the new instance: cp /tmp/snapshot/2013-06-03…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it is copied back to data directory… corresponding to tables that are missing in the incremental backup directory. Bug fixed #856400. Percona XtraBackup would leave stale xtrabackup_tmp* files…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it is copied back to data directory… corresponding to tables that are missing in the incremental backup directory. Bug fixed #856400. Percona XtraBackup would leave stale xtrabackup_tmp* files…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
… | Pct_R | Calls | R/Call | +———————-+———-+——-+——-+————–+ | removing tmp table | 0.095135 | 55.10 | 3 | 0.0317116667 | | Copying to tmp table | 0.046175 | 26.74 | 1… | | checking permissions | 0.000802 | 0.46 | 6 | 0.0001336667 | | Creating tmp table | 0.000548 | 0.32 | 1 | 0.0005480000 | | Opening tables…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… | 0.000040 | | creating table | 0.002176 | | After create | 0.000058 | | copy to tmp table | 18.083490 | | restoring secondary keys | 17.824109 | | rename result…: 4194304 Duplicates: 0 Warnings: 0 mysql> SHOW PROFILE; +——————————+————+ | Status | Duration | +——————————+————+ . . . | copy to tmp table | 184.694432 | . . . +——————————+————+ 18 rows in set (0.00 sec…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… $REMOTEHOST — “rm -f $TMP/$TMPfile $TMP/$RESfile”; rm -f $LOCKFILE $RESfile; exit’ INT TERM EXIT # digest the result, copy to localhost, then email it ssh $REMOTEHOST — “mk-query-digest –type tcpdump –limit $LIMIT < $TMP/$TMPfile 2>&1 > $TMP/$RESfile” scp -q $REMOTEHOST:$TMP…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… | 0.000016 | | creating table | 0.168283 | | After create | 0.000061 | | copy to tmp table | 0.165808 | | rename result table | 46.446738 | | end | 0… done and then RENAME old_table to tmp_table, new_table to old_table and finally DROP tmp_table. Let’s see another example… can keep executing without any hindrance, copying rows from the table with the old structure to the table with the new structure…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
…. Then, our first step is to get a consistent backup. First we need to copy all the data to an output directory: The –export option is the magic trick that will help us to get… TABLE salaries DISCARD TABLESPACE; Copy the salaries.ibd files from the backup to the database data directory: # cp /tmp/2012-01-22_14…
Post: xtrabackup-0.5, bugfixes, incremental backup introduction
April 7, 2009 By 6 Comments
… 06:03:29 innobackupex: Connection to database server closed innobackupex: Backup created in directory ‘/mnt/data/tmp‘ innobackupex: MySQL binlog position: filename… be copied to specified dir. You may have several incremental dir, and apply them one-by-one. Current version does not allow to copy…
