Percona provides a really interesting tool for MySQL backups! It works on a live running MySQL server by copying the MySQL binary files from the data directory and because the tool knows how the engines work (InnoDB, MyISAM, and so on) it can make point-in-time consistent MySQL data files. Of course, using this tool on a database with InnoDB tables only is the best case, because no write lock will be used.
There are two main tasks when making a backup and one, which is not mandatory:
- Execute xtrabackup with –backup option to copy the MySQL data files and additional information for the tool
- Execute xtrabackup with –prepare option to prepare the MySQL (InnoDB) files ready for use of a MySQL server. The files are consistented, i.e. the whole backup is consistent despite the copy of the different files that happened at different times.
- Execute xtrabackup with –prepare option again to further prepare the MySQL (InnoDB) files ready for use of a MySQL server. Additional preparation such as InnoDB log files and more. This step is not mandatory and it may be skipped because the MySQL server, which uses the data files, will create the InnoDB log files.
The directory with MySQL copied files contains not only the MySQL files but additional information plus my.cnf (MySQL current configuration) backup. The backup files may be prepared (and restore) in a different server than the original, on which the backup was made.
xtrabackup may enable compressing on-the-fly when copying the binary files with the option –compress but the steps to use (restore) the backup in a new server are different – additional step to decompress before prepare. So the above steps become:
- xtrabackup –backup –compress – copy and compress on-the-fly.
- xtrabackup –decompress – decompress the backup files
- xtrabackup –prepare – make point-in-time consistent MySQL data files, which are ready for a MySQL server.
- xtrabackup –prepare – additional preparation to make the start up of the MySQL server with those files faster.
And here is a real-world example:
STEP 1) Install the xtrabackup utility
yum install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm yum install -y percona-xtrabackup-24 qpress
The percona-xtrabackup-24 provides the percona xtrabackup tool for backup of MySQL 5.1, 5.5, 5.6 and 5.7 servers, as well as Percona Server for MySQL with XtraDB. Install percona-xtrabackup-80 for use with MySQL 8 and later.
The whole output is included in the Bonus 3 section below.
STEP 2) Make backup
Make the backup. The datadir of the MySQL server is needed and a new direcotry for the backup files. The MySQL server is running and serving requests.
[root@srv ~]# xtrabackup --backup --slave-info --datadir=/var/lib/mysql/ --target-dir=/mnt/backups/sql-xtrabackup/ xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin --server-id=1 --open_files_limit=5000 --innodb_buffer_pool_size=256M --innodb_log_buffer_size=32M --innodb_log_files_in_group=2 --innodb_flush_log_at_trx_commit=0 --innodb_file_per_table=1 --innodb_flush_method=O_DIRECT --datadir=/var/lib/mysql/ xtrabackup: recognized client arguments: --password=* --backup=1 --slave-info=1 --target-dir=/mnt/backups/sql-xtrabackup/ 200919 14:35:11 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: YES). 200919 14:35:11 version_check Connected to MySQL server 200919 14:35:11 version_check Executing a version check against the server... 200919 14:35:11 version_check Done. 200919 14:35:11 Connecting to MySQL server host: localhost, user: not set, password: set, port: not set, socket: not set Using server version 5.7.31-log xtrabackup version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql/ xtrabackup: open files limit requested 5000, set to 5000 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 xtrabackup: using O_DIRECT InnoDB: Number of pools: 1 200919 14:35:11 >> log scanned up to (1135932912) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 34 for mywordpress/wp_users, old maximum was 0 200919 14:35:12 [01] Copying ./ibdata1 to /mnt/backups/sql-xtrabackup/ibdata1 200919 14:35:12 >> log scanned up to (1135932912) 200919 14:35:13 >> log scanned up to (1135932912) 200919 14:35:14 [01] ...done 200919 14:35:14 >> log scanned up to (1135932912) 200919 14:35:15 >> log scanned up to (1135932912) 200919 14:35:16 [01] Copying ./mywordpress/wp_users.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_users.ibd 200919 14:35:16 [01] ...done 200919 14:35:16 [01] Copying ./mywordpress/wp_gglcptch_whitelist.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_gglcptch_whitelist.ibd 200919 14:35:16 [01] ...done 200919 14:35:16 [01] Copying ./mywordpress/wp_usermeta.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_usermeta.ibd 200919 14:35:16 [01] ...done 200919 14:35:16 >> log scanned up to (1135932912) 200919 14:35:17 [01] Copying ./mywordpress/wp_postmeta.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_postmeta.ibd 200919 14:35:17 [01] ...done 200919 14:35:17 [01] Copying ./mywordpress/wp_posts.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_posts.ibd 200919 14:35:17 >> log scanned up to (1135932912) 200919 14:35:18 >> log scanned up to (1135932912) 200919 14:35:19 [01] ...done 200919 14:35:19 >> log scanned up to (1135932912) ..... ..... 200919 14:36:30 [01] Copying ./mysql/columns_priv.MYD to /mnt/backups/sql-xtrabackup/mysql/columns_priv.MYD 200919 14:36:30 [01] ...done 200919 14:36:30 >> log scanned up to (1135933567) 200919 14:36:31 [01] Copying ./mysql/proxies_priv.frm to /mnt/backups/sql-xtrabackup/mysql/proxies_priv.frm 200919 14:36:31 [01] ...done 200919 14:36:31 [01] Copying ./mysql/help_category.frm to /mnt/backups/sql-xtrabackup/mysql/help_category.frm 200919 14:36:31 [01] ...done 200919 14:36:31 [01] Copying ./mysql/proc.frm to /mnt/backups/sql-xtrabackup/mysql/proc.frm 200919 14:36:31 [01] ...done 200919 14:36:31 Finished backing up non-InnoDB tables and files 200919 14:36:31 [00] Writing /mnt/backups/sql-xtrabackup/xtrabackup_slave_info 200919 14:36:31 [00] ...done 200919 14:36:31 [00] Writing /mnt/backups/sql-xtrabackup/xtrabackup_binlog_info 200919 14:36:31 [00] ...done 200919 14:36:31 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '1135933558' xtrabackup: Stopping log copying thread. .200919 14:36:31 >> log scanned up to (1135933567) 200919 14:36:32 Executing UNLOCK TABLES 200919 14:36:32 All tables unlocked 200919 14:36:32 [00] Copying ib_buffer_pool to /mnt/backups/sql-xtrabackup/ib_buffer_pool 200919 14:36:32 [00] ...done 200919 14:36:32 Backup created in directory '/mnt/backups/sql-xtrabackup/' MySQL binlog position: filename 'srv-bin.000001', position '1004' 200919 14:36:32 [00] Writing /mnt/backups/sql-xtrabackup/backup-my.cnf 200919 14:36:32 [00] ...done 200919 14:36:32 [00] Writing /mnt/backups/sql-xtrabackup/xtrabackup_info 200919 14:36:32 [00] ...done xtrabackup: Transaction log of lsn (1135932903) to (1135933567) was copied. 200919 14:36:33 completed OK!
In the end, there must be written: “completed OK!”.
The whole output of the command is included in the Bonus 1 section below. An example with compress option enabled is in Bonus 2 section below.
Here is what contains the backup diectory:
[root@srv ~]# ls -altr /mnt/backups/sql-xtrabackup/ total 77865 drwxr-xr-x. 7 root root 4096 19 Sep 14,34 .. -rw-r-----. 1 root root 79691776 19 Sep 14,35 ibdata1 drwxr-x---. 2 root root 4096 19 Sep 14,35 mywordpress drwxr-x---. 2 root root 12288 19 Sep 14,35 sys drwxr-x---. 2 root root 4096 19 Sep 14,36 performance_schema drwxr-x---. 2 root root 4096 19 Sep 14,36 mysql -rw-r-----. 1 root root 0 19 Sep 14,36 xtrabackup_slave_info -rw-r-----. 1 root root 22 19 Sep 14,36 xtrabackup_binlog_info -rw-r-----. 1 root root 3584 19 Sep 14,36 xtrabackup_logfile -rw-r-----. 1 root root 144 19 Sep 14,36 xtrabackup_checkpoints -rw-r-----. 1 root root 2208 19 Sep 14,36 ib_buffer_pool -rw-r-----. 1 root root 487 19 Sep 14,36 backup-my.cnf drwxr-xr-x. 6 root root 4096 19 Sep 14,36 . -rw-r-----. 1 root root 543 19 Sep 14,36 xtrabackup_info
To use this backup to become a slave server, the change master command should use the information from file xtrabackup_binlog_info – the MASTER_LOG_FILE and MASTER_LOG_POS. It should be noted that if binloging is not enabled in the server configuration this file would not present in the backups!
STEP 3) Use (restore) backup
Before to be able to use the above backup files a prepare command should be executed over the directory. At least one prepare command is required or the data will not be point-in-time consistent. The second
[root@srv ~]# xtrabackup --prepare --target-dir=/mnt/backups/sql-xtrabackup/ xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=1 --redo-log-version=1 xtrabackup: recognized client arguments: --prepare=1 --target-dir=/mnt/backups/sql-xtrabackup/ xtrabackup version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056) xtrabackup: cd to /mnt/backups/sql-xtrabackup/ xtrabackup: This target seems to be not prepared yet. InnoDB: Number of pools: 1 xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1135932903) xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Not using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 1135932903 InnoDB: Doing recovery: scanned up to log sequence number 1135933567 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: xtrabackup: Last MySQL binlog file position 1004, file name srv-bin.000001 InnoDB: Creating shared tablespace for temporary tables InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... InnoDB: File './ibtmp1' size is now 12 MB. InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active. InnoDB: 32 non-redo rollback segment(s) are active. InnoDB: 5.7.26 started; log sequence number 1135933567 InnoDB: xtrabackup: Last MySQL binlog file position 1004, file name srv-bin.000001 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 1135933663 InnoDB: Number of pools: 1 xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Not using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Setting log file ./ib_logfile101 size to 48 MB InnoDB: Setting log file ./ib_logfile1 size to 48 MB InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 InnoDB: New log files created, LSN=1135933663 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 1135933964 InnoDB: Doing recovery: scanned up to log sequence number 1135933973 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: xtrabackup: Last MySQL binlog file position 1004, file name srv-bin.000001 InnoDB: Removed temporary tablespace data file: "ibtmp1" InnoDB: Creating shared tablespace for temporary tables InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... InnoDB: File './ibtmp1' size is now 12 MB. InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active. InnoDB: 32 non-redo rollback segment(s) are active. InnoDB: page_cleaner: 1000ms intended loop took 5203ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) InnoDB: 5.7.26 started; log sequence number 1135933973 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 1135933992 200919 14:48:50 completed OK! [root@srv ~]# ls -altr /mnt/backups/sql-xtrabackup/ total 196646 drwxr-xr-x. 7 root root 4096 19 Sep 14,34 .. drwxr-x---. 2 root root 4096 19 Sep 14,35 mywordpress drwxr-x---. 2 root root 12288 19 Sep 14,35 sys drwxr-x---. 2 root root 4096 19 Sep 14,36 performance_schema drwxr-x---. 2 root root 4096 19 Sep 14,36 mysql -rw-r-----. 1 root root 0 19 Sep 14,36 xtrabackup_slave_info -rw-r-----. 1 root root 22 19 Sep 14,36 xtrabackup_binlog_info -rw-r-----. 1 root root 2208 19 Sep 14,36 ib_buffer_pool -rw-r-----. 1 root root 487 19 Sep 14,36 backup-my.cnf -rw-r-----. 1 root root 543 19 Sep 14,36 xtrabackup_info -rw-r--r--. 1 root root 22 19 Sep 14,48 xtrabackup_binlog_pos_innodb -rw-r--r--. 1 root root 1 19 Sep 14,48 xtrabackup_master_key_id -rw-r-----. 1 root root 8388608 19 Sep 14,48 xtrabackup_logfile -rw-r-----. 1 root root 144 19 Sep 14,48 xtrabackup_checkpoints -rw-r-----. 1 root root 50331648 19 Sep 14,48 ib_logfile1 drwxr-xr-x. 6 root root 4096 19 Sep 14,48 . -rw-r-----. 1 root root 12582912 19 Sep 14,48 ibtmp1 -rw-r-----. 1 root root 50331648 19 Sep 14,48 ib_logfile0 -rw-r-----. 1 root root 79691776 19 Sep 14,48 ibdata1
Now it is ready to use the files in a new MySQL server replacing the datadir with the above files (aka the whole directory).
And here it is included the second prepare execution:
[root@srv ~]# xtrabackup --prepare --target-dir=/mnt/backups/sql-xtrabackup/ xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=1 --redo-log-version=1 xtrabackup: recognized client arguments: --prepare=1 --target-dir=/mnt/backups/sql-xtrabackup/ xtrabackup version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056) xtrabackup: cd to /mnt/backups/sql-xtrabackup/ xtrabackup: This target seems to be already prepared. InnoDB: Number of pools: 1 xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'. xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Not using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Highest supported file format is Barracuda. InnoDB: Removed temporary tablespace data file: "ibtmp1" InnoDB: Creating shared tablespace for temporary tables InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... InnoDB: File './ibtmp1' size is now 12 MB. InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active. InnoDB: 32 non-redo rollback segment(s) are active. InnoDB: 5.7.26 started; log sequence number 1135933992 InnoDB: xtrabackup: Last MySQL binlog file position 1004, file name srv-bin.000001 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 1135934011 InnoDB: Number of pools: 1 xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Not using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Highest supported file format is Barracuda. InnoDB: Removed temporary tablespace data file: "ibtmp1" InnoDB: Creating shared tablespace for temporary tables InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... InnoDB: File './ibtmp1' size is now 12 MB. InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active. InnoDB: 32 non-redo rollback segment(s) are active. InnoDB: 5.7.26 started; log sequence number 1135934011 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 1135934030 200919 14:56:03 completed OK! [root@srv ~]# ls -altr /mnt/backups/sql-xtrabackup/ total 196646 drwxr-xr-x. 7 root root 4096 19 Sep 14,34 .. drwxr-x---. 2 root root 4096 19 Sep 14,35 mywordpress drwxr-x---. 2 root root 12288 19 Sep 14,35 sys drwxr-x---. 2 root root 4096 19 Sep 14,36 performance_schema drwxr-x---. 2 root root 4096 19 Sep 14,36 mysql -rw-r-----. 1 root root 0 19 Sep 14,36 xtrabackup_slave_info -rw-r-----. 1 root root 22 19 Sep 14,36 xtrabackup_binlog_info -rw-r-----. 1 root root 2208 19 Sep 14,36 ib_buffer_pool -rw-r-----. 1 root root 487 19 Sep 14,36 backup-my.cnf -rw-r-----. 1 root root 543 19 Sep 14,36 xtrabackup_info -rw-r-----. 1 root root 8388608 19 Sep 14,48 xtrabackup_logfile -rw-r-----. 1 root root 50331648 19 Sep 14,48 ib_logfile1 -rw-r--r--. 1 root root 22 19 Sep 14,55 xtrabackup_binlog_pos_innodb -rw-r--r--. 1 root root 1 19 Sep 14,55 xtrabackup_master_key_id -rw-r-----. 1 root root 144 19 Sep 14,56 xtrabackup_checkpoints drwxr-xr-x. 6 root root 4096 19 Sep 14,56 . -rw-r-----. 1 root root 12582912 19 Sep 14,56 ibtmp1 -rw-r-----. 1 root root 50331648 19 Sep 14,56 ib_logfile0 -rw-r-----. 1 root root 79691776 19 Sep 14,56 ibdata1
Bonus 1 – Backup of a sample wordpress database server
[root@srv ~]# xtrabackup --backup --slave-info --datadir=/var/lib/mysql/ --target-dir=/mnt/backups/sql-xtrabackup/ xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin --server-id=1 --open_files_limit=5000 --innodb_buffer_pool_size=256M --innodb_log_buffer_size=32M --innodb_log_files_in_group=2 --innodb_flush_log_at_trx_commit=0 --innodb_file_per_table=1 --innodb_flush_method=O_DIRECT --datadir=/var/lib/mysql/ xtrabackup: recognized client arguments: --password=* --backup=1 --slave-info=1 --target-dir=/mnt/backups/sql-xtrabackup/ 200919 14:35:11 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: YES). 200919 14:35:11 version_check Connected to MySQL server 200919 14:35:11 version_check Executing a version check against the server... 200919 14:35:11 version_check Done. 200919 14:35:11 Connecting to MySQL server host: localhost, user: not set, password: set, port: not set, socket: not set Using server version 5.7.31-log xtrabackup version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql/ xtrabackup: open files limit requested 5000, set to 5000 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 xtrabackup: using O_DIRECT InnoDB: Number of pools: 1 200919 14:35:11 >> log scanned up to (1135932912) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 34 for mywordpress/wp_users, old maximum was 0 200919 14:35:12 [01] Copying ./ibdata1 to /mnt/backups/sql-xtrabackup/ibdata1 200919 14:35:12 >> log scanned up to (1135932912) 200919 14:35:13 >> log scanned up to (1135932912) 200919 14:35:14 [01] ...done 200919 14:35:14 >> log scanned up to (1135932912) 200919 14:35:15 >> log scanned up to (1135932912) 200919 14:35:16 [01] Copying ./mywordpress/wp_users.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_users.ibd 200919 14:35:16 [01] ...done 200919 14:35:16 [01] Copying ./mywordpress/wp_gglcptch_whitelist.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_gglcptch_whitelist.ibd 200919 14:35:16 [01] ...done 200919 14:35:16 [01] Copying ./mywordpress/wp_usermeta.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_usermeta.ibd 200919 14:35:16 [01] ...done 200919 14:35:16 >> log scanned up to (1135932912) 200919 14:35:17 [01] Copying ./mywordpress/wp_postmeta.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_postmeta.ibd 200919 14:35:17 [01] ...done 200919 14:35:17 [01] Copying ./mywordpress/wp_posts.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_posts.ibd 200919 14:35:17 >> log scanned up to (1135932912) 200919 14:35:18 >> log scanned up to (1135932912) 200919 14:35:19 [01] ...done 200919 14:35:19 >> log scanned up to (1135932912) 200919 14:35:20 >> log scanned up to (1135932912) 200919 14:35:21 [01] Copying ./mywordpress/wp_terms.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_terms.ibd 200919 14:35:21 [01] ...done 200919 14:35:21 >> log scanned up to (1135932912) 200919 14:35:21 [01] Copying ./mywordpress/wp_term_relationships.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_term_relationships.ibd 200919 14:35:22 [01] ...done 200919 14:35:22 [01] Copying ./mywordpress/wp_links.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_links.ibd 200919 14:35:22 [01] ...done 200919 14:35:22 [01] Copying ./mywordpress/wp_termmeta.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_termmeta.ibd 200919 14:35:22 [01] ...done 200919 14:35:22 [01] Copying ./mywordpress/wp_comments.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_comments.ibd 200919 14:35:22 >> log scanned up to (1135933412) 200919 14:35:23 [01] ...done 200919 14:35:23 [01] Copying ./mywordpress/wp_commentmeta.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_commentmeta.ibd 200919 14:35:23 >> log scanned up to (1135933412) 200919 14:35:24 [01] ...done 200919 14:35:24 [01] Copying ./mywordpress/wp_options.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_options.ibd 200919 14:35:24 >> log scanned up to (1135933471) 200919 14:35:25 [01] ...done 200919 14:35:25 >> log scanned up to (1135933480) 200919 14:35:25 [01] Copying ./mywordpress/wp_term_taxonomy.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_term_taxonomy.ibd 200919 14:35:26 [01] ...done 200919 14:35:26 [01] Copying ./sys/sys_config.ibd to /mnt/backups/sql-xtrabackup/sys/sys_config.ibd 200919 14:35:26 [01] ...done 200919 14:35:26 >> log scanned up to (1135933480) 200919 14:35:26 [01] Copying ./mysql/innodb_table_stats.ibd to /mnt/backups/sql-xtrabackup/mysql/innodb_table_stats.ibd 200919 14:35:26 [01] ...done 200919 14:35:27 [01] Copying ./mysql/engine_cost.ibd to /mnt/backups/sql-xtrabackup/mysql/engine_cost.ibd 200919 14:35:27 [01] ...done 200919 14:35:27 [01] Copying ./mysql/server_cost.ibd to /mnt/backups/sql-xtrabackup/mysql/server_cost.ibd 200919 14:35:27 [01] ...done 200919 14:35:27 [01] Copying ./mysql/innodb_index_stats.ibd to /mnt/backups/sql-xtrabackup/mysql/innodb_index_stats.ibd 200919 14:35:27 [01] ...done 200919 14:35:27 [01] Copying ./mysql/time_zone_transition.ibd to /mnt/backups/sql-xtrabackup/mysql/time_zone_transition.ibd 200919 14:35:27 [01] ...done 200919 14:35:27 >> log scanned up to (1135933480) 200919 14:35:27 [01] Copying ./mysql/help_relation.ibd to /mnt/backups/sql-xtrabackup/mysql/help_relation.ibd 200919 14:35:27 [01] ...done 200919 14:35:28 [01] Copying ./mysql/time_zone.ibd to /mnt/backups/sql-xtrabackup/mysql/time_zone.ibd 200919 14:35:28 [01] ...done 200919 14:35:28 [01] Copying ./mysql/slave_relay_log_info.ibd to /mnt/backups/sql-xtrabackup/mysql/slave_relay_log_info.ibd 200919 14:35:28 [01] ...done 200919 14:35:28 [01] Copying ./mysql/slave_worker_info.ibd to /mnt/backups/sql-xtrabackup/mysql/slave_worker_info.ibd 200919 14:35:28 [01] ...done 200919 14:35:28 >> log scanned up to (1135933480) 200919 14:35:28 [01] Copying ./mysql/time_zone_name.ibd to /mnt/backups/sql-xtrabackup/mysql/time_zone_name.ibd 200919 14:35:28 [01] ...done 200919 14:35:29 [01] Copying ./mysql/gtid_executed.ibd to /mnt/backups/sql-xtrabackup/mysql/gtid_executed.ibd 200919 14:35:29 [01] ...done 200919 14:35:29 [01] Copying ./mysql/time_zone_leap_second.ibd to /mnt/backups/sql-xtrabackup/mysql/time_zone_leap_second.ibd 200919 14:35:29 [01] ...done 200919 14:35:29 [01] Copying ./mysql/plugin.ibd to /mnt/backups/sql-xtrabackup/mysql/plugin.ibd 200919 14:35:29 [01] ...done 200919 14:35:29 [01] Copying ./mysql/help_topic.ibd to /mnt/backups/sql-xtrabackup/mysql/help_topic.ibd 200919 14:35:29 >> log scanned up to (1135933480) 200919 14:35:30 [01] ...done 200919 14:35:30 [01] Copying ./mysql/servers.ibd to /mnt/backups/sql-xtrabackup/mysql/servers.ibd 200919 14:35:30 [01] ...done 200919 14:35:30 [01] Copying ./mysql/help_keyword.ibd to /mnt/backups/sql-xtrabackup/mysql/help_keyword.ibd 200919 14:35:30 [01] ...done 200919 14:35:30 >> log scanned up to (1135933480) 200919 14:35:30 [01] Copying ./mysql/time_zone_transition_type.ibd to /mnt/backups/sql-xtrabackup/mysql/time_zone_transition_type.ibd 200919 14:35:30 [01] ...done 200919 14:35:31 [01] Copying ./mysql/slave_master_info.ibd to /mnt/backups/sql-xtrabackup/mysql/slave_master_info.ibd 200919 14:35:31 [01] ...done 200919 14:35:31 [01] Copying ./mysql/help_category.ibd to /mnt/backups/sql-xtrabackup/mysql/help_category.ibd 200919 14:35:31 [01] ...done 200919 14:35:31 >> log scanned up to (1135933480) 200919 14:35:32 Executing FLUSH NO_WRITE_TO_BINLOG TABLES... 200919 14:35:32 Executing FLUSH TABLES WITH READ LOCK... 200919 14:35:32 Starting to backup non-InnoDB tables and files 200919 14:35:32 [01] Copying ./mywordpress/wp_gglcptch_whitelist.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_gglcptch_whitelist.frm 200919 14:35:32 [01] ...done 200919 14:35:32 [01] Copying ./mywordpress/wp_users.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_users.frm 200919 14:35:32 [01] ...done 200919 14:35:32 >> log scanned up to (1135933480) 200919 14:35:32 [01] Copying ./mywordpress/db.opt to /mnt/backups/sql-xtrabackup/mywordpress/db.opt 200919 14:35:32 [01] ...done 200919 14:35:33 [01] Copying ./mywordpress/wp_terms.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_terms.frm 200919 14:35:33 [01] ...done 200919 14:35:33 [01] Copying ./mywordpress/wp_termmeta.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_termmeta.frm 200919 14:35:33 [01] ...done 200919 14:35:33 [01] Copying ./mywordpress/wp_comments.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_comments.frm 200919 14:35:33 [01] ...done 200919 14:35:33 [01] Copying ./mywordpress/wp_options.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_options.frm 200919 14:35:33 [01] ...done 200919 14:35:33 [01] Copying ./mywordpress/wp_postmeta.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_postmeta.frm 200919 14:35:33 [01] ...done 200919 14:35:33 >> log scanned up to (1135933480) 200919 14:35:34 [01] Copying ./mywordpress/wp_term_relationships.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_term_relationships.frm 200919 14:35:34 [01] ...done 200919 14:35:34 [01] Copying ./mywordpress/wp_posts.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_posts.frm 200919 14:35:34 [01] ...done 200919 14:35:34 [01] Copying ./mywordpress/wp_usermeta.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_usermeta.frm 200919 14:35:34 [01] ...done 200919 14:35:34 [01] Copying ./mywordpress/wp_links.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_links.frm 200919 14:35:34 [01] ...done 200919 14:35:34 [01] Copying ./mywordpress/wp_commentmeta.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_commentmeta.frm 200919 14:35:34 [01] ...done 200919 14:35:34 [01] Copying ./mywordpress/wp_term_taxonomy.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_term_taxonomy.frm 200919 14:35:34 [01] ...done 200919 14:35:34 >> log scanned up to (1135933480) 200919 14:35:35 [01] Copying ./sys/x@0024user_summary.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary.frm 200919 14:35:35 [01] ...done 200919 14:35:35 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statements_with_temp_tables.frm 200919 14:35:35 [01] ...done 200919 14:35:35 [01] Copying ./sys/schema_redundant_indexes.frm to /mnt/backups/sql-xtrabackup/sys/schema_redundant_indexes.frm 200919 14:35:35 [01] ...done 200919 14:35:35 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /mnt/backups/sql-xtrabackup/sys/x@0024innodb_buffer_stats_by_schema.frm 200919 14:35:35 [01] ...done 200919 14:35:35 >> log scanned up to (1135933480) 200919 14:35:35 [01] Copying ./sys/metrics.frm to /mnt/backups/sql-xtrabackup/sys/metrics.frm 200919 14:35:35 [01] ...done 200919 14:35:36 [01] Copying ./sys/x@0024statements_with_sorting.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statements_with_sorting.frm 200919 14:35:36 [01] ...done 200919 14:35:36 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary_by_file_io.frm 200919 14:35:36 [01] ...done 200919 14:35:36 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/io_global_by_wait_by_latency.frm 200919 14:35:36 [01] ...done 200919 14:35:36 [01] Copying ./sys/statements_with_full_table_scans.frm to /mnt/backups/sql-xtrabackup/sys/statements_with_full_table_scans.frm 200919 14:35:36 [01] ...done 200919 14:35:36 >> log scanned up to (1135933480) 200919 14:35:37 [01] Copying ./sys/schema_index_statistics.frm to /mnt/backups/sql-xtrabackup/sys/schema_index_statistics.frm 200919 14:35:37 [01] ...done 200919 14:35:37 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary_by_file_io.frm 200919 14:35:37 [01] ...done 200919 14:35:37 [01] Copying ./sys/io_global_by_file_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/io_global_by_file_by_latency.frm 200919 14:35:37 [01] ...done 200919 14:35:37 [01] Copying ./sys/host_summary_by_statement_latency.frm to /mnt/backups/sql-xtrabackup/sys/host_summary_by_statement_latency.frm 200919 14:35:37 [01] ...done 200919 14:35:37 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /mnt/backups/sql-xtrabackup/sys/schema_tables_with_full_table_scans.frm 200919 14:35:37 [01] ...done 200919 14:35:37 [01] Copying ./sys/io_by_thread_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/io_by_thread_by_latency.frm 200919 14:35:37 [01] ...done 200919 14:35:37 >> log scanned up to (1135933480) 200919 14:35:38 [01] Copying ./sys/db.opt to /mnt/backups/sql-xtrabackup/sys/db.opt 200919 14:35:38 [01] ...done 200919 14:35:38 [01] Copying ./sys/user_summary_by_statement_type.frm to /mnt/backups/sql-xtrabackup/sys/user_summary_by_statement_type.frm 200919 14:35:38 [01] ...done 200919 14:35:38 [01] Copying ./sys/innodb_lock_waits.frm to /mnt/backups/sql-xtrabackup/sys/innodb_lock_waits.frm 200919 14:35:38 [01] ...done 200919 14:35:38 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024wait_classes_global_by_latency.frm 200919 14:35:38 [01] ...done 200919 14:35:38 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /mnt/backups/sql-xtrabackup/sys/io_global_by_wait_by_bytes.frm 200919 14:35:38 [01] ...done 200919 14:35:38 >> log scanned up to (1135933480) 200919 14:35:38 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_flattened_keys.frm 200919 14:35:38 [01] ...done 200919 14:35:39 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statements_with_errors_or_warnings.frm 200919 14:35:39 [01] ...done 200919 14:35:39 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_table_statistics_with_buffer.frm 200919 14:35:39 [01] ...done 200919 14:35:39 [01] Copying ./sys/schema_object_overview.frm to /mnt/backups/sql-xtrabackup/sys/schema_object_overview.frm 200919 14:35:39 [01] ...done 200919 14:35:39 [01] Copying ./sys/x@0024schema_index_statistics.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_index_statistics.frm 200919 14:35:39 [01] ...done 200919 14:35:39 [01] Copying ./sys/host_summary_by_statement_type.frm to /mnt/backups/sql-xtrabackup/sys/host_summary_by_statement_type.frm 200919 14:35:39 [01] ...done 200919 14:35:39 >> log scanned up to (1135933480) 200919 14:35:39 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /mnt/backups/sql-xtrabackup/sys/x@0024innodb_lock_waits.frm 200919 14:35:39 [01] ...done 200919 14:35:40 [01] Copying ./sys/host_summary_by_file_io.frm to /mnt/backups/sql-xtrabackup/sys/host_summary_by_file_io.frm 200919 14:35:40 [01] ...done 200919 14:35:40 [01] Copying ./sys/x@0024memory_global_total.frm to /mnt/backups/sql-xtrabackup/sys/x@0024memory_global_total.frm 200919 14:35:40 [01] ...done 200919 14:35:40 [01] Copying ./sys/statement_analysis.frm to /mnt/backups/sql-xtrabackup/sys/statement_analysis.frm 200919 14:35:40 [01] ...done 200919 14:35:40 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024io_global_by_file_by_latency.frm 200919 14:35:40 [01] ...done 200919 14:35:40 >> log scanned up to (1135933480) 200919 14:35:40 [01] Copying ./sys/session_ssl_status.frm to /mnt/backups/sql-xtrabackup/sys/session_ssl_status.frm 200919 14:35:40 [01] ...done 200919 14:35:41 [01] Copying ./sys/schema_auto_increment_columns.frm to /mnt/backups/sql-xtrabackup/sys/schema_auto_increment_columns.frm 200919 14:35:41 [01] ...done 200919 14:35:41 [01] Copying ./sys/x@0024latest_file_io.frm to /mnt/backups/sql-xtrabackup/sys/x@0024latest_file_io.frm 200919 14:35:41 [01] ...done 200919 14:35:41 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_table_lock_waits.frm 200919 14:35:41 [01] ...done 200919 14:35:41 [01] Copying ./sys/x@0024host_summary.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary.frm 200919 14:35:41 [01] ...done 200919 14:35:41 >> log scanned up to (1135933480) 200919 14:35:42 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /mnt/backups/sql-xtrabackup/sys/statements_with_errors_or_warnings.frm 200919 14:35:42 [01] ...done 200919 14:35:42 [01] Copying ./sys/sys_config_update_set_user.TRN to /mnt/backups/sql-xtrabackup/sys/sys_config_update_set_user.TRN 200919 14:35:42 [01] ...done 200919 14:35:42 [01] Copying ./sys/x@0024processlist.frm to /mnt/backups/sql-xtrabackup/sys/x@0024processlist.frm 200919 14:35:42 [01] ...done 200919 14:35:42 [01] Copying ./sys/user_summary.frm to /mnt/backups/sql-xtrabackup/sys/user_summary.frm 200919 14:35:42 [01] ...done 200919 14:35:42 [01] Copying ./sys/user_summary_by_file_io_type.frm to /mnt/backups/sql-xtrabackup/sys/user_summary_by_file_io_type.frm 200919 14:35:42 [01] ...done 200919 14:35:42 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024wait_classes_global_by_avg_latency.frm 200919 14:35:42 [01] ...done 200919 14:35:42 >> log scanned up to (1135933480) 200919 14:35:42 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /mnt/backups/sql-xtrabackup/sys/io_global_by_file_by_bytes.frm 200919 14:35:42 [01] ...done 200919 14:35:43 [01] Copying ./sys/waits_by_user_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/waits_by_user_by_latency.frm 200919 14:35:43 [01] ...done 200919 14:35:43 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary_by_stages.frm 200919 14:35:43 [01] ...done 200919 14:35:43 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_tables_with_full_table_scans.frm 200919 14:35:43 [01] ...done 200919 14:35:43 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /mnt/backups/sql-xtrabackup/sys/x@0024ps_digest_avg_latency_distribution.frm 200919 14:35:43 [01] ...done 200919 14:35:43 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024io_by_thread_by_latency.frm 200919 14:35:43 [01] ...done 200919 14:35:43 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statements_with_full_table_scans.frm 200919 14:35:43 [01] ...done 200919 14:35:43 >> log scanned up to (1135933480) 200919 14:35:43 [01] Copying ./sys/user_summary_by_file_io.frm to /mnt/backups/sql-xtrabackup/sys/user_summary_by_file_io.frm 200919 14:35:43 [01] ...done 200919 14:35:44 [01] Copying ./sys/x@0024statement_analysis.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statement_analysis.frm 200919 14:35:44 [01] ...done 200919 14:35:44 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /mnt/backups/sql-xtrabackup/sys/innodb_buffer_stats_by_schema.frm 200919 14:35:44 [01] ...done 200919 14:35:44 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024waits_by_user_by_latency.frm 200919 14:35:44 [01] ...done 200919 14:35:44 [01] Copying ./sys/schema_table_statistics.frm to /mnt/backups/sql-xtrabackup/sys/schema_table_statistics.frm 200919 14:35:44 [01] ...done 200919 14:35:44 [01] Copying ./sys/schema_unused_indexes.frm to /mnt/backups/sql-xtrabackup/sys/schema_unused_indexes.frm 200919 14:35:44 [01] ...done 200919 14:35:44 >> log scanned up to (1135933480) 200919 14:35:44 [01] Copying ./sys/statements_with_sorting.frm to /mnt/backups/sql-xtrabackup/sys/statements_with_sorting.frm 200919 14:35:44 [01] ...done 200919 14:35:45 [01] Copying ./sys/sys_config_insert_set_user.TRN to /mnt/backups/sql-xtrabackup/sys/sys_config_insert_set_user.TRN 200919 14:35:45 [01] ...done 200919 14:35:45 [01] Copying ./sys/waits_by_host_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/waits_by_host_by_latency.frm 200919 14:35:45 [01] ...done 200919 14:35:45 [01] Copying ./sys/waits_global_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/waits_global_by_latency.frm 200919 14:35:45 [01] ...done 200919 14:35:45 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024memory_global_by_current_bytes.frm 200919 14:35:45 [01] ...done 200919 14:35:45 >> log scanned up to (1135933480) 200919 14:35:45 [01] Copying ./sys/session.frm to /mnt/backups/sql-xtrabackup/sys/session.frm 200919 14:35:45 [01] ...done 200919 14:35:46 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary_by_statement_type.frm 200919 14:35:46 [01] ...done 200919 14:35:46 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/memory_by_thread_by_current_bytes.frm 200919 14:35:46 [01] ...done 200919 14:35:46 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /mnt/backups/sql-xtrabackup/sys/innodb_buffer_stats_by_table.frm 200919 14:35:46 [01] ...done 200919 14:35:46 [01] Copying ./sys/version.frm to /mnt/backups/sql-xtrabackup/sys/version.frm 200919 14:35:46 [01] ...done 200919 14:35:46 [01] Copying ./sys/processlist.frm to /mnt/backups/sql-xtrabackup/sys/processlist.frm 200919 14:35:46 [01] ...done 200919 14:35:46 >> log scanned up to (1135933480) 200919 14:35:46 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /mnt/backups/sql-xtrabackup/sys/statements_with_runtimes_in_95th_percentile.frm 200919 14:35:46 [01] ...done 200919 14:35:47 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary_by_file_io_type.frm 200919 14:35:47 [01] ...done 200919 14:35:47 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary_by_file_io_type.frm 200919 14:35:47 [01] ...done 200919 14:35:47 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary_by_statement_type.frm 200919 14:35:47 [01] ...done 200919 14:35:47 [01] Copying ./sys/memory_global_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/memory_global_by_current_bytes.frm 200919 14:35:47 [01] ...done 200919 14:35:47 [01] Copying ./sys/sys_config.TRG to /mnt/backups/sql-xtrabackup/sys/sys_config.TRG 200919 14:35:47 [01] ...done 200919 14:35:47 >> log scanned up to (1135933480) 200919 14:35:47 [01] Copying ./sys/memory_global_total.frm to /mnt/backups/sql-xtrabackup/sys/memory_global_total.frm 200919 14:35:47 [01] ...done 200919 14:35:48 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024io_global_by_file_by_bytes.frm 200919 14:35:48 [01] ...done 200919 14:35:48 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary_by_stages.frm 200919 14:35:48 [01] ...done 200919 14:35:48 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024io_global_by_wait_by_bytes.frm 200919 14:35:48 [01] ...done 200919 14:35:48 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024io_global_by_wait_by_latency.frm 200919 14:35:48 [01] ...done 200919 14:35:48 >> log scanned up to (1135933480) 200919 14:35:49 >> log scanned up to (1135933480) 200919 14:35:50 >> log scanned up to (1135933480) 200919 14:35:51 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary_by_statement_latency.frm 200919 14:35:51 [01] ...done 200919 14:35:51 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024waits_global_by_latency.frm 200919 14:35:51 [01] ...done 200919 14:35:51 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024waits_by_host_by_latency.frm 200919 14:35:51 [01] ...done 200919 14:35:51 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /mnt/backups/sql-xtrabackup/sys/ps_check_lost_instrumentation.frm 200919 14:35:51 [01] ...done 200919 14:35:51 >> log scanned up to (1135933480) 200919 14:35:51 [01] Copying ./sys/user_summary_by_stages.frm to /mnt/backups/sql-xtrabackup/sys/user_summary_by_stages.frm 200919 14:35:51 [01] ...done 200919 14:35:52 >> log scanned up to (1135933480) 200919 14:35:53 [01] Copying ./sys/wait_classes_global_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/wait_classes_global_by_latency.frm 200919 14:35:53 [01] ...done 200919 14:35:53 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024memory_by_user_by_current_bytes.frm 200919 14:35:53 [01] ...done 200919 14:35:53 >> log scanned up to (1135933480) 200919 14:35:53 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024memory_by_host_by_current_bytes.frm 200919 14:35:53 [01] ...done 200919 14:35:54 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /mnt/backups/sql-xtrabackup/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm 200919 14:35:54 [01] ...done 200919 14:35:54 [01] Copying ./sys/schema_table_lock_waits.frm to /mnt/backups/sql-xtrabackup/sys/schema_table_lock_waits.frm 200919 14:35:54 [01] ...done 200919 14:35:54 [01] Copying ./sys/latest_file_io.frm to /mnt/backups/sql-xtrabackup/sys/latest_file_io.frm 200919 14:35:54 [01] ...done 200919 14:35:54 [01] Copying ./sys/x@0024session.frm to /mnt/backups/sql-xtrabackup/sys/x@0024session.frm 200919 14:35:54 [01] ...done 200919 14:35:54 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /mnt/backups/sql-xtrabackup/sys/x@0024ps_schema_table_statistics_io.frm 200919 14:35:54 [01] ...done 200919 14:35:54 >> log scanned up to (1135933480) 200919 14:35:54 [01] Copying ./sys/host_summary.frm to /mnt/backups/sql-xtrabackup/sys/host_summary.frm 200919 14:35:54 [01] ...done 200919 14:35:55 [01] Copying ./sys/host_summary_by_file_io_type.frm to /mnt/backups/sql-xtrabackup/sys/host_summary_by_file_io_type.frm 200919 14:35:55 [01] ...done 200919 14:35:55 [01] Copying ./sys/host_summary_by_stages.frm to /mnt/backups/sql-xtrabackup/sys/host_summary_by_stages.frm 200919 14:35:55 [01] ...done 200919 14:35:55 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /mnt/backups/sql-xtrabackup/sys/wait_classes_global_by_avg_latency.frm 200919 14:35:55 [01] ...done 200919 14:35:55 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary_by_statement_latency.frm 200919 14:35:55 [01] ...done 200919 14:35:55 >> log scanned up to (1135933480) 200919 14:35:55 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statements_with_runtimes_in_95th_percentile.frm 200919 14:35:55 [01] ...done 200919 14:35:56 [01] Copying ./sys/x@0024schema_table_statistics.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_table_statistics.frm 200919 14:35:56 [01] ...done 200919 14:35:56 [01] Copying ./sys/user_summary_by_statement_latency.frm to /mnt/backups/sql-xtrabackup/sys/user_summary_by_statement_latency.frm 200919 14:35:56 [01] ...done 200919 14:35:56 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024memory_by_thread_by_current_bytes.frm 200919 14:35:56 [01] ...done 200919 14:35:56 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /mnt/backups/sql-xtrabackup/sys/x@0024innodb_buffer_stats_by_table.frm 200919 14:35:56 [01] ...done 200919 14:35:56 [01] Copying ./sys/sys_config.frm to /mnt/backups/sql-xtrabackup/sys/sys_config.frm 200919 14:35:56 [01] ...done 200919 14:35:56 >> log scanned up to (1135933480) 200919 14:35:56 [01] Copying ./sys/statements_with_temp_tables.frm to /mnt/backups/sql-xtrabackup/sys/statements_with_temp_tables.frm 200919 14:35:56 [01] ...done 200919 14:35:57 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /mnt/backups/sql-xtrabackup/sys/schema_table_statistics_with_buffer.frm 200919 14:35:57 [01] ...done 200919 14:35:57 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/memory_by_host_by_current_bytes.frm 200919 14:35:57 [01] ...done 200919 14:35:57 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/memory_by_user_by_current_bytes.frm 200919 14:35:57 [01] ...done 200919 14:35:57 [01] Copying ./performance_schema/status_by_account.frm to /mnt/backups/sql-xtrabackup/performance_schema/status_by_account.frm 200919 14:35:57 [01] ...done 200919 14:35:57 >> log scanned up to (1135933480) 200919 14:35:58 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/memory_summary_by_account_by_event_name.frm 200919 14:35:58 [01] ...done 200919 14:35:58 >> log scanned up to (1135933480) 200919 14:35:59 [01] Copying ./performance_schema/events_transactions_history.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_history.frm 200919 14:35:59 [01] ...done 200919 14:35:59 >> log scanned up to (1135933480) 200919 14:35:59 [01] Copying ./performance_schema/replication_group_members.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_group_members.frm 200919 14:35:59 [01] ...done 200919 14:36:00 [01] Copying ./performance_schema/events_stages_history.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_history.frm 200919 14:36:00 [01] ...done 200919 14:36:00 [01] Copying ./performance_schema/events_statements_current.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_current.frm 200919 14:36:00 [01] ...done 200919 14:36:00 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/memory_summary_by_user_by_event_name.frm 200919 14:36:00 [01] ...done 200919 14:36:00 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_by_thread_by_event_name.frm 200919 14:36:00 [01] ...done 200919 14:36:00 >> log scanned up to (1135933480) 200919 14:36:00 [01] Copying ./performance_schema/replication_applier_configuration.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_applier_configuration.frm 200919 14:36:00 [01] ...done 200919 14:36:01 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /mnt/backups/sql-xtrabackup/performance_schema/objects_summary_global_by_type.frm 200919 14:36:01 [01] ...done 200919 14:36:01 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_by_user_by_event_name.frm 200919 14:36:01 [01] ...done 200919 14:36:01 [01] Copying ./performance_schema/threads.frm to /mnt/backups/sql-xtrabackup/performance_schema/threads.frm 200919 14:36:01 [01] ...done 200919 14:36:01 [01] Copying ./performance_schema/socket_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/socket_instances.frm 200919 14:36:01 [01] ...done 200919 14:36:01 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/memory_summary_by_host_by_event_name.frm 200919 14:36:01 [01] ...done 200919 14:36:01 >> log scanned up to (1135933480) 200919 14:36:02 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_summary_by_account_by_event_name.frm 200919 14:36:02 [01] ...done 200919 14:36:02 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_summary_by_account_by_event_name.frm 200919 14:36:02 [01] ...done 200919 14:36:02 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_summary_by_thread_by_event_name.frm 200919 14:36:02 [01] ...done 200919 14:36:02 [01] Copying ./performance_schema/db.opt to /mnt/backups/sql-xtrabackup/performance_schema/db.opt 200919 14:36:02 >> log scanned up to (1135933480) 200919 14:36:02 [01] ...done 200919 14:36:03 [01] Copying ./performance_schema/accounts.frm to /mnt/backups/sql-xtrabackup/performance_schema/accounts.frm 200919 14:36:03 [01] ...done 200919 14:36:03 [01] Copying ./performance_schema/cond_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/cond_instances.frm 200919 14:36:03 [01] ...done 200919 14:36:03 [01] Copying ./performance_schema/users.frm to /mnt/backups/sql-xtrabackup/performance_schema/users.frm 200919 14:36:03 [01] ...done 200919 14:36:03 >> log scanned up to (1135933480) 200919 14:36:04 [01] Copying ./performance_schema/events_statements_history.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_history.frm 200919 14:36:04 [01] ...done 200919 14:36:04 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_user_by_event_name.frm 200919 14:36:04 [01] ...done 200919 14:36:04 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_summary_by_host_by_event_name.frm 200919 14:36:04 [01] ...done 200919 14:36:04 [01] Copying ./performance_schema/rwlock_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/rwlock_instances.frm 200919 14:36:04 [01] ...done 200919 14:36:04 [01] Copying ./performance_schema/global_variables.frm to /mnt/backups/sql-xtrabackup/performance_schema/global_variables.frm 200919 14:36:04 [01] ...done 200919 14:36:04 >> log scanned up to (1135933480) 200919 14:36:04 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/memory_summary_global_by_event_name.frm 200919 14:36:04 [01] ...done 200919 14:36:05 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/file_summary_by_event_name.frm 200919 14:36:05 [01] ...done 200919 14:36:05 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/socket_summary_by_event_name.frm 200919 14:36:05 [01] ...done 200919 14:36:05 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_applier_status_by_worker.frm 200919 14:36:05 [01] ...done 200919 14:36:05 [01] Copying ./performance_schema/setup_timers.frm to /mnt/backups/sql-xtrabackup/performance_schema/setup_timers.frm 200919 14:36:05 [01] ...done 200919 14:36:05 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_digest.frm 200919 14:36:05 [01] ...done 200919 14:36:05 >> log scanned up to (1135933480) 200919 14:36:06 [01] Copying ./performance_schema/replication_group_member_stats.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_group_member_stats.frm 200919 14:36:06 [01] ...done 200919 14:36:06 [01] Copying ./performance_schema/mutex_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/mutex_instances.frm 200919 14:36:06 [01] ...done 200919 14:36:06 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_summary_by_host_by_event_name.frm 200919 14:36:06 [01] ...done 200919 14:36:06 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /mnt/backups/sql-xtrabackup/performance_schema/table_io_waits_summary_by_index_usage.frm 200919 14:36:06 [01] ...done 200919 14:36:06 [01] Copying ./performance_schema/replication_applier_status.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_applier_status.frm 200919 14:36:06 [01] ...done 200919 14:36:06 >> log scanned up to (1135933480) 200919 14:36:06 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /mnt/backups/sql-xtrabackup/performance_schema/session_account_connect_attrs.frm 200919 14:36:06 [01] ...done 200919 14:36:07 [01] Copying ./performance_schema/setup_objects.frm to /mnt/backups/sql-xtrabackup/performance_schema/setup_objects.frm 200919 14:36:07 [01] ...done 200919 14:36:07 [01] Copying ./performance_schema/prepared_statements_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/prepared_statements_instances.frm 200919 14:36:07 [01] ...done 200919 14:36:07 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_host_by_event_name.frm 200919 14:36:07 [01] ...done 200919 14:36:07 >> log scanned up to (1135933480) 200919 14:36:07 [01] Copying ./performance_schema/session_status.frm to /mnt/backups/sql-xtrabackup/performance_schema/session_status.frm 200919 14:36:07 [01] ...done 200919 14:36:07 [01] Copying ./performance_schema/status_by_thread.frm to /mnt/backups/sql-xtrabackup/performance_schema/status_by_thread.frm 200919 14:36:07 [01] ...done 200919 14:36:08 [01] Copying ./performance_schema/events_transactions_history_long.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_history_long.frm 200919 14:36:08 [01] ...done 200919 14:36:08 [01] Copying ./performance_schema/host_cache.frm to /mnt/backups/sql-xtrabackup/performance_schema/host_cache.frm 200919 14:36:08 [01] ...done 200919 14:36:08 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /mnt/backups/sql-xtrabackup/performance_schema/table_io_waits_summary_by_table.frm 200919 14:36:08 [01] ...done 200919 14:36:08 [01] Copying ./performance_schema/replication_connection_status.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_connection_status.frm 200919 14:36:08 [01] ...done 200919 14:36:08 [01] Copying ./performance_schema/setup_actors.frm to /mnt/backups/sql-xtrabackup/performance_schema/setup_actors.frm 200919 14:36:08 [01] ...done 200919 14:36:08 >> log scanned up to (1135933480) 200919 14:36:09 [01] Copying ./performance_schema/metadata_locks.frm to /mnt/backups/sql-xtrabackup/performance_schema/metadata_locks.frm 200919 14:36:09 [01] ...done 200919 14:36:09 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_global_by_event_name.frm 200919 14:36:09 [01] ...done 200919 14:36:09 [01] Copying ./performance_schema/file_summary_by_instance.frm to /mnt/backups/sql-xtrabackup/performance_schema/file_summary_by_instance.frm 200919 14:36:09 [01] ...done 200919 14:36:09 [01] Copying ./performance_schema/status_by_user.frm to /mnt/backups/sql-xtrabackup/performance_schema/status_by_user.frm 200919 14:36:09 [01] ...done 200919 14:36:09 >> log scanned up to (1135933480) 200919 14:36:09 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_thread_by_event_name.frm 200919 14:36:09 [01] ...done 200919 14:36:10 [01] Copying ./performance_schema/events_statements_history_long.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_history_long.frm 200919 14:36:10 [01] ...done 200919 14:36:10 [01] Copying ./performance_schema/session_variables.frm to /mnt/backups/sql-xtrabackup/performance_schema/session_variables.frm 200919 14:36:10 [01] ...done 200919 14:36:10 [01] Copying ./performance_schema/setup_instruments.frm to /mnt/backups/sql-xtrabackup/performance_schema/setup_instruments.frm 200919 14:36:10 [01] ...done 200919 14:36:10 [01] Copying ./performance_schema/hosts.frm to /mnt/backups/sql-xtrabackup/performance_schema/hosts.frm 200919 14:36:10 [01] ...done 200919 14:36:10 [01] Copying ./performance_schema/setup_consumers.frm to /mnt/backups/sql-xtrabackup/performance_schema/setup_consumers.frm 200919 14:36:10 [01] ...done 200919 14:36:10 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_by_host_by_event_name.frm 200919 14:36:10 [01] ...done 200919 14:36:10 >> log scanned up to (1135933480) 200919 14:36:10 [01] Copying ./performance_schema/file_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/file_instances.frm 200919 14:36:10 [01] ...done 200919 14:36:11 [01] Copying ./performance_schema/events_waits_history_long.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_history_long.frm 200919 14:36:11 [01] ...done 200919 14:36:11 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_summary_by_thread_by_event_name.frm 200919 14:36:11 [01] ...done 200919 14:36:11 [01] Copying ./performance_schema/user_variables_by_thread.frm to /mnt/backups/sql-xtrabackup/performance_schema/user_variables_by_thread.frm 200919 14:36:11 [01] ...done 200919 14:36:11 [01] Copying ./performance_schema/events_stages_history_long.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_history_long.frm 200919 14:36:11 [01] ...done 200919 14:36:11 >> log scanned up to (1135933480) 200919 14:36:12 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_program.frm 200919 14:36:12 [01] ...done 200919 14:36:12 [01] Copying ./performance_schema/global_status.frm to /mnt/backups/sql-xtrabackup/performance_schema/global_status.frm 200919 14:36:12 [01] ...done 200919 14:36:12 [01] Copying ./performance_schema/events_transactions_current.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_current.frm 200919 14:36:12 [01] ...done 200919 14:36:12 [01] Copying ./performance_schema/performance_timers.frm to /mnt/backups/sql-xtrabackup/performance_schema/performance_timers.frm 200919 14:36:12 [01] ...done 200919 14:36:12 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_summary_by_user_by_event_name.frm 200919 14:36:12 [01] ...done 200919 14:36:12 >> log scanned up to (1135933480) 200919 14:36:12 [01] Copying ./performance_schema/variables_by_thread.frm to /mnt/backups/sql-xtrabackup/performance_schema/variables_by_thread.frm 200919 14:36:12 [01] ...done 200919 14:36:13 [01] Copying ./performance_schema/replication_connection_configuration.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_connection_configuration.frm 200919 14:36:13 [01] ...done 200919 14:36:13 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_applier_status_by_coordinator.frm 200919 14:36:13 [01] ...done 200919 14:36:13 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /mnt/backups/sql-xtrabackup/performance_schema/socket_summary_by_instance.frm 200919 14:36:13 [01] ...done 200919 14:36:13 [01] Copying ./performance_schema/status_by_host.frm to /mnt/backups/sql-xtrabackup/performance_schema/status_by_host.frm 200919 14:36:13 [01] ...done 200919 14:36:13 [01] Copying ./performance_schema/events_waits_history.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_history.frm 200919 14:36:13 [01] ...done 200919 14:36:13 >> log scanned up to (1135933480) 200919 14:36:14 [01] Copying ./performance_schema/table_handles.frm to /mnt/backups/sql-xtrabackup/performance_schema/table_handles.frm 200919 14:36:14 [01] ...done 200919 14:36:14 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_by_account_by_event_name.frm 200919 14:36:14 [01] ...done 200919 14:36:14 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_account_by_event_name.frm 200919 14:36:14 [01] ...done 200919 14:36:14 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_summary_global_by_event_name.frm 200919 14:36:14 [01] ...done 200919 14:36:14 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/memory_summary_by_thread_by_event_name.frm 200919 14:36:14 [01] ...done 200919 14:36:14 >> log scanned up to (1135933480) 200919 14:36:15 >> log scanned up to (1135933480) 200919 14:36:16 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_summary_by_user_by_event_name.frm 200919 14:36:16 [01] ...done 200919 14:36:16 >> log scanned up to (1135933480) 200919 14:36:17 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_summary_global_by_event_name.frm 200919 14:36:17 [01] ...done 200919 14:36:17 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_global_by_event_name.frm 200919 14:36:17 [01] ...done 200919 14:36:17 [01] Copying ./performance_schema/events_waits_current.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_current.frm 200919 14:36:17 [01] ...done 200919 14:36:17 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_by_instance.frm 200919 14:36:17 [01] ...done 200919 14:36:17 >> log scanned up to (1135933480) 200919 14:36:17 [01] Copying ./performance_schema/events_stages_current.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_current.frm 200919 14:36:17 [01] ...done 200919 14:36:18 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /mnt/backups/sql-xtrabackup/performance_schema/table_lock_waits_summary_by_table.frm 200919 14:36:18 [01] ...done 200919 14:36:18 [01] Copying ./performance_schema/session_connect_attrs.frm to /mnt/backups/sql-xtrabackup/performance_schema/session_connect_attrs.frm 200919 14:36:18 [01] ...done 200919 14:36:18 [01] Copying ./mysql/slow_log.CSM to /mnt/backups/sql-xtrabackup/mysql/slow_log.CSM 200919 14:36:18 [01] ...done 200919 14:36:18 [01] Copying ./mysql/db.MYI to /mnt/backups/sql-xtrabackup/mysql/db.MYI 200919 14:36:18 [01] ...done 200919 14:36:18 [01] Copying ./mysql/server_cost.frm to /mnt/backups/sql-xtrabackup/mysql/server_cost.frm 200919 14:36:18 [01] ...done 200919 14:36:18 [01] Copying ./mysql/proxies_priv.MYD to /mnt/backups/sql-xtrabackup/mysql/proxies_priv.MYD 200919 14:36:18 [01] ...done 200919 14:36:18 >> log scanned up to (1135933480) 200919 14:36:18 [01] Copying ./mysql/proxies_priv.MYI to /mnt/backups/sql-xtrabackup/mysql/proxies_priv.MYI 200919 14:36:18 [01] ...done 200919 14:36:19 [01] Copying ./mysql/func.MYI to /mnt/backups/sql-xtrabackup/mysql/func.MYI 200919 14:36:19 [01] ...done 200919 14:36:19 [01] Copying ./mysql/time_zone.frm to /mnt/backups/sql-xtrabackup/mysql/time_zone.frm 200919 14:36:19 [01] ...done 200919 14:36:19 [01] Copying ./mysql/plugin.frm to /mnt/backups/sql-xtrabackup/mysql/plugin.frm 200919 14:36:19 [01] ...done 200919 14:36:19 [01] Copying ./mysql/engine_cost.frm to /mnt/backups/sql-xtrabackup/mysql/engine_cost.frm 200919 14:36:19 [01] ...done 200919 14:36:19 [01] Copying ./mysql/general_log.CSV to /mnt/backups/sql-xtrabackup/mysql/general_log.CSV 200919 14:36:19 [01] ...done 200919 14:36:19 >> log scanned up to (1135933480) 200919 14:36:19 [01] Copying ./mysql/ndb_binlog_index.MYD to /mnt/backups/sql-xtrabackup/mysql/ndb_binlog_index.MYD 200919 14:36:19 [01] ...done 200919 14:36:20 [01] Copying ./mysql/procs_priv.frm to /mnt/backups/sql-xtrabackup/mysql/procs_priv.frm 200919 14:36:20 [01] ...done 200919 14:36:20 [01] Copying ./mysql/db.opt to /mnt/backups/sql-xtrabackup/mysql/db.opt 200919 14:36:20 [01] ...done 200919 14:36:20 [01] Copying ./mysql/func.MYD to /mnt/backups/sql-xtrabackup/mysql/func.MYD 200919 14:36:20 [01] ...done 200919 14:36:20 [01] Copying ./mysql/event.frm to /mnt/backups/sql-xtrabackup/mysql/event.frm 200919 14:36:20 [01] ...done 200919 14:36:20 [01] Copying ./mysql/help_keyword.frm to /mnt/backups/sql-xtrabackup/mysql/help_keyword.frm 200919 14:36:20 [01] ...done 200919 14:36:20 >> log scanned up to (1135933480) 200919 14:36:20 [01] Copying ./mysql/slave_relay_log_info.frm to /mnt/backups/sql-xtrabackup/mysql/slave_relay_log_info.frm 200919 14:36:20 [01] ...done 200919 14:36:21 [01] Copying ./mysql/ndb_binlog_index.frm to /mnt/backups/sql-xtrabackup/mysql/ndb_binlog_index.frm 200919 14:36:21 [01] ...done 200919 14:36:21 [01] Copying ./mysql/proc.MYI to /mnt/backups/sql-xtrabackup/mysql/proc.MYI 200919 14:36:21 [01] ...done 200919 14:36:21 [01] Copying ./mysql/innodb_table_stats.frm to /mnt/backups/sql-xtrabackup/mysql/innodb_table_stats.frm 200919 14:36:21 [01] ...done 200919 14:36:21 [01] Copying ./mysql/slave_worker_info.frm to /mnt/backups/sql-xtrabackup/mysql/slave_worker_info.frm 200919 14:36:21 [01] ...done 200919 14:36:21 [01] Copying ./mysql/innodb_index_stats.frm to /mnt/backups/sql-xtrabackup/mysql/innodb_index_stats.frm 200919 14:36:21 [01] ...done 200919 14:36:21 >> log scanned up to (1135933480) 200919 14:36:21 [01] Copying ./mysql/slave_master_info.frm to /mnt/backups/sql-xtrabackup/mysql/slave_master_info.frm 200919 14:36:21 [01] ...done 200919 14:36:22 [01] Copying ./mysql/slow_log.CSV to /mnt/backups/sql-xtrabackup/mysql/slow_log.CSV 200919 14:36:22 [01] ...done 200919 14:36:22 [01] Copying ./mysql/event.MYD to /mnt/backups/sql-xtrabackup/mysql/event.MYD 200919 14:36:22 [01] ...done 200919 14:36:22 [01] Copying ./mysql/event.MYI to /mnt/backups/sql-xtrabackup/mysql/event.MYI 200919 14:36:22 [01] ...done 200919 14:36:22 [01] Copying ./mysql/ndb_binlog_index.MYI to /mnt/backups/sql-xtrabackup/mysql/ndb_binlog_index.MYI 200919 14:36:22 [01] ...done 200919 14:36:22 >> log scanned up to (1135933480) 200919 14:36:22 [01] Copying ./mysql/user.MYI to /mnt/backups/sql-xtrabackup/mysql/user.MYI 200919 14:36:22 [01] ...done 200919 14:36:23 [01] Copying ./mysql/func.frm to /mnt/backups/sql-xtrabackup/mysql/func.frm 200919 14:36:23 [01] ...done 200919 14:36:23 [01] Copying ./mysql/general_log.frm to /mnt/backups/sql-xtrabackup/mysql/general_log.frm 200919 14:36:23 [01] ...done 200919 14:36:23 [01] Copying ./mysql/help_relation.frm to /mnt/backups/sql-xtrabackup/mysql/help_relation.frm 200919 14:36:23 [01] ...done 200919 14:36:23 [01] Copying ./mysql/tables_priv.MYI to /mnt/backups/sql-xtrabackup/mysql/tables_priv.MYI 200919 14:36:23 [01] ...done 200919 14:36:23 [01] Copying ./mysql/columns_priv.frm to /mnt/backups/sql-xtrabackup/mysql/columns_priv.frm 200919 14:36:23 [01] ...done 200919 14:36:23 >> log scanned up to (1135933480) 200919 14:36:24 [01] Copying ./mysql/time_zone_leap_second.frm to /mnt/backups/sql-xtrabackup/mysql/time_zone_leap_second.frm 200919 14:36:24 [01] ...done 200919 14:36:24 [01] Copying ./mysql/time_zone_transition.frm to /mnt/backups/sql-xtrabackup/mysql/time_zone_transition.frm 200919 14:36:24 [01] ...done 200919 14:36:24 [01] Copying ./mysql/user.frm to /mnt/backups/sql-xtrabackup/mysql/user.frm 200919 14:36:24 [01] ...done 200919 14:36:24 [01] Copying ./mysql/gtid_executed.frm to /mnt/backups/sql-xtrabackup/mysql/gtid_executed.frm 200919 14:36:24 [01] ...done 200919 14:36:24 >> log scanned up to (1135933480) 200919 14:36:24 [01] Copying ./mysql/columns_priv.MYI to /mnt/backups/sql-xtrabackup/mysql/columns_priv.MYI 200919 14:36:24 [01] ...done 200919 14:36:25 [01] Copying ./mysql/tables_priv.frm to /mnt/backups/sql-xtrabackup/mysql/tables_priv.frm 200919 14:36:25 [01] ...done 200919 14:36:25 >> log scanned up to (1135933480) 200919 14:36:26 >> log scanned up to (1135933558) 200919 14:36:27 [01] Copying ./mysql/procs_priv.MYI to /mnt/backups/sql-xtrabackup/mysql/procs_priv.MYI 200919 14:36:27 [01] ...done 200919 14:36:27 >> log scanned up to (1135933558) 200919 14:36:28 [01] Copying ./mysql/general_log.CSM to /mnt/backups/sql-xtrabackup/mysql/general_log.CSM 200919 14:36:28 [01] ...done 200919 14:36:28 [01] Copying ./mysql/user.MYD to /mnt/backups/sql-xtrabackup/mysql/user.MYD 200919 14:36:28 [01] ...done 200919 14:36:28 [01] Copying ./mysql/time_zone_name.frm to /mnt/backups/sql-xtrabackup/mysql/time_zone_name.frm 200919 14:36:28 [01] ...done 200919 14:36:28 >> log scanned up to (1135933558) 200919 14:36:29 [01] Copying ./mysql/procs_priv.MYD to /mnt/backups/sql-xtrabackup/mysql/procs_priv.MYD 200919 14:36:29 [01] ...done 200919 14:36:29 [01] Copying ./mysql/time_zone_transition_type.frm to /mnt/backups/sql-xtrabackup/mysql/time_zone_transition_type.frm 200919 14:36:29 [01] ...done 200919 14:36:29 [01] Copying ./mysql/servers.frm to /mnt/backups/sql-xtrabackup/mysql/servers.frm 200919 14:36:29 [01] ...done 200919 14:36:29 [01] Copying ./mysql/proc.MYD to /mnt/backups/sql-xtrabackup/mysql/proc.MYD 200919 14:36:29 [01] ...done 200919 14:36:29 >> log scanned up to (1135933567) 200919 14:36:30 [01] Copying ./mysql/slow_log.frm to /mnt/backups/sql-xtrabackup/mysql/slow_log.frm 200919 14:36:30 [01] ...done 200919 14:36:30 [01] Copying ./mysql/db.frm to /mnt/backups/sql-xtrabackup/mysql/db.frm 200919 14:36:30 [01] ...done 200919 14:36:30 [01] Copying ./mysql/tables_priv.MYD to /mnt/backups/sql-xtrabackup/mysql/tables_priv.MYD 200919 14:36:30 [01] ...done 200919 14:36:30 [01] Copying ./mysql/help_topic.frm to /mnt/backups/sql-xtrabackup/mysql/help_topic.frm 200919 14:36:30 [01] ...done 200919 14:36:30 [01] Copying ./mysql/db.MYD to /mnt/backups/sql-xtrabackup/mysql/db.MYD 200919 14:36:30 [01] ...done 200919 14:36:30 [01] Copying ./mysql/columns_priv.MYD to /mnt/backups/sql-xtrabackup/mysql/columns_priv.MYD 200919 14:36:30 [01] ...done 200919 14:36:30 >> log scanned up to (1135933567) 200919 14:36:31 [01] Copying ./mysql/proxies_priv.frm to /mnt/backups/sql-xtrabackup/mysql/proxies_priv.frm 200919 14:36:31 [01] ...done 200919 14:36:31 [01] Copying ./mysql/help_category.frm to /mnt/backups/sql-xtrabackup/mysql/help_category.frm 200919 14:36:31 [01] ...done 200919 14:36:31 [01] Copying ./mysql/proc.frm to /mnt/backups/sql-xtrabackup/mysql/proc.frm 200919 14:36:31 [01] ...done 200919 14:36:31 Finished backing up non-InnoDB tables and files 200919 14:36:31 [00] Writing /mnt/backups/sql-xtrabackup/xtrabackup_slave_info 200919 14:36:31 [00] ...done 200919 14:36:31 [00] Writing /mnt/backups/sql-xtrabackup/xtrabackup_binlog_info 200919 14:36:31 [00] ...done 200919 14:36:31 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '1135933558' xtrabackup: Stopping log copying thread. .200919 14:36:31 >> log scanned up to (1135933567) 200919 14:36:32 Executing UNLOCK TABLES 200919 14:36:32 All tables unlocked 200919 14:36:32 [00] Copying ib_buffer_pool to /mnt/backups/sql-xtrabackup/ib_buffer_pool 200919 14:36:32 [00] ...done 200919 14:36:32 Backup created in directory '/mnt/backups/sql-xtrabackup/' MySQL binlog position: filename 'srv-bin.000001', position '1004' 200919 14:36:32 [00] Writing /mnt/backups/sql-xtrabackup/backup-my.cnf 200919 14:36:32 [00] ...done 200919 14:36:32 [00] Writing /mnt/backups/sql-xtrabackup/xtrabackup_info 200919 14:36:32 [00] ...done xtrabackup: Transaction log of lsn (1135932903) to (1135933567) was copied. 200919 14:36:33 completed OK!
Bonus 2 – Making backup with compress option enabled
[root@srv ~]# xtrabackup --backup --compress --slave-info --datadir=/var/lib/mysql/ --target-dir=/mnt/backups/sql-xtrabackup/ xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin --server-id=1 --open_files_limit=5000 --innodb_buffer_pool_size=256M --innodb_log_buffer_size=32M --innodb_log_files_in_group=2 --innodb_flush_log_at_trx_commit=0 --innodb_file_per_table=1 --innodb_flush_method=O_DIRECT --datadir=/var/lib/mysql/ xtrabackup: recognized client arguments: --password=* --backup=1 --compress --slave-info=1 --target-dir=/mnt/backups/sql-xtrabackup/ 200919 15:05:12 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: YES). 200919 15:05:12 version_check Connected to MySQL server 200919 15:05:12 version_check Executing a version check against the server... 200919 15:05:12 version_check Done. 200919 15:05:12 Connecting to MySQL server host: localhost, user: not set, password: set, port: not set, socket: not set Using server version 5.7.31-log xtrabackup version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql/ xtrabackup: open files limit requested 5000, set to 5000 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 xtrabackup: using O_DIRECT InnoDB: Number of pools: 1 200919 15:05:12 >> log scanned up to (1136502297) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 34 for mywordpress/wp_users, old maximum was 0 200919 15:05:13 [01] Compressing ./ibdata1 to /mnt/backups/sql-xtrabackup/ibdata1.qp 200919 15:05:13 >> log scanned up to (1136502297) 200919 15:05:14 [01] ...done 200919 15:05:14 [01] Compressing ./mywordpress/wp_users.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_users.ibd.qp 200919 15:05:14 [01] ...done 200919 15:05:14 [01] Compressing ./mywordpress/wp_gglcptch_whitelist.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_gglcptch_whitelist.ibd.qp 200919 15:05:14 >> log scanned up to (1136502297) 200919 15:05:14 [01] ...done 200919 15:05:15 [01] Compressing ./mywordpress/wp_usermeta.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_usermeta.ibd.qp 200919 15:05:15 [01] ...done 200919 15:05:15 [01] Compressing ./mywordpress/wp_postmeta.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_postmeta.ibd.qp 200919 15:05:15 [01] ...done 200919 15:05:15 [01] Compressing ./mywordpress/wp_posts.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_posts.ibd.qp 200919 15:05:15 >> log scanned up to (1136502798) 200919 15:05:16 >> log scanned up to (1136502798) 200919 15:05:17 >> log scanned up to (1136502841) 200919 15:05:18 [01] ...done 200919 15:05:18 >> log scanned up to (1136502850) 200919 15:05:19 >> log scanned up to (1136502850) 200919 15:05:20 >> log scanned up to (1136502850) 200919 15:05:21 [01] Compressing ./mywordpress/wp_terms.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_terms.ibd.qp 200919 15:05:21 [01] ...done 200919 15:05:21 [01] Compressing ./mywordpress/wp_term_relationships.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_term_relationships.ibd.qp 200919 15:05:21 >> log scanned up to (1136502850) 200919 15:05:21 [01] ...done 200919 15:05:22 [01] Compressing ./mywordpress/wp_links.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_links.ibd.qp 200919 15:05:22 [01] ...done 200919 15:05:22 [01] Compressing ./mywordpress/wp_termmeta.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_termmeta.ibd.qp 200919 15:05:22 [01] ...done 200919 15:05:22 [01] Compressing ./mywordpress/wp_comments.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_comments.ibd.qp 200919 15:05:22 >> log scanned up to (1136502850) 200919 15:05:23 [01] ...done 200919 15:05:23 [01] Compressing ./mywordpress/wp_commentmeta.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_commentmeta.ibd.qp 200919 15:05:23 >> log scanned up to (1136502850) 200919 15:05:23 [01] ...done 200919 15:05:24 [01] Compressing ./mywordpress/wp_options.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_options.ibd.qp 200919 15:05:24 [01] ...done 200919 15:05:24 [01] Compressing ./mywordpress/wp_term_taxonomy.ibd to /mnt/backups/sql-xtrabackup/mywordpress/wp_term_taxonomy.ibd.qp 200919 15:05:24 >> log scanned up to (1136502850) 200919 15:05:24 [01] ...done 200919 15:05:25 [01] Compressing ./sys/sys_config.ibd to /mnt/backups/sql-xtrabackup/sys/sys_config.ibd.qp 200919 15:05:25 [01] ...done 200919 15:05:25 [01] Compressing ./mysql/innodb_table_stats.ibd to /mnt/backups/sql-xtrabackup/mysql/innodb_table_stats.ibd.qp 200919 15:05:25 [01] ...done 200919 15:05:25 >> log scanned up to (1136502850) 200919 15:05:26 [01] Compressing ./mysql/engine_cost.ibd to /mnt/backups/sql-xtrabackup/mysql/engine_cost.ibd.qp 200919 15:05:26 [01] ...done 200919 15:05:26 [01] Compressing ./mysql/server_cost.ibd to /mnt/backups/sql-xtrabackup/mysql/server_cost.ibd.qp 200919 15:05:26 [01] ...done 200919 15:05:26 [01] Compressing ./mysql/innodb_index_stats.ibd to /mnt/backups/sql-xtrabackup/mysql/innodb_index_stats.ibd.qp 200919 15:05:26 [01] ...done 200919 15:05:26 >> log scanned up to (1136502850) 200919 15:05:26 [01] Compressing ./mysql/time_zone_transition.ibd to /mnt/backups/sql-xtrabackup/mysql/time_zone_transition.ibd.qp 200919 15:05:26 [01] ...done 200919 15:05:27 [01] Compressing ./mysql/help_relation.ibd to /mnt/backups/sql-xtrabackup/mysql/help_relation.ibd.qp 200919 15:05:27 [01] ...done 200919 15:05:27 [01] Compressing ./mysql/time_zone.ibd to /mnt/backups/sql-xtrabackup/mysql/time_zone.ibd.qp 200919 15:05:27 [01] ...done 200919 15:05:27 [01] Compressing ./mysql/slave_relay_log_info.ibd to /mnt/backups/sql-xtrabackup/mysql/slave_relay_log_info.ibd.qp 200919 15:05:27 [01] ...done 200919 15:05:27 [01] Compressing ./mysql/slave_worker_info.ibd to /mnt/backups/sql-xtrabackup/mysql/slave_worker_info.ibd.qp 200919 15:05:27 [01] ...done 200919 15:05:27 [01] Compressing ./mysql/time_zone_name.ibd to /mnt/backups/sql-xtrabackup/mysql/time_zone_name.ibd.qp 200919 15:05:27 [01] ...done 200919 15:05:27 >> log scanned up to (1136502850) 200919 15:05:27 [01] Compressing ./mysql/gtid_executed.ibd to /mnt/backups/sql-xtrabackup/mysql/gtid_executed.ibd.qp 200919 15:05:27 [01] ...done 200919 15:05:28 [01] Compressing ./mysql/time_zone_leap_second.ibd to /mnt/backups/sql-xtrabackup/mysql/time_zone_leap_second.ibd.qp 200919 15:05:28 [01] ...done 200919 15:05:28 [01] Compressing ./mysql/plugin.ibd to /mnt/backups/sql-xtrabackup/mysql/plugin.ibd.qp 200919 15:05:28 [01] ...done 200919 15:05:28 [01] Compressing ./mysql/help_topic.ibd to /mnt/backups/sql-xtrabackup/mysql/help_topic.ibd.qp 200919 15:05:28 [01] ...done 200919 15:05:28 >> log scanned up to (1136502850) 200919 15:05:29 [01] Compressing ./mysql/servers.ibd to /mnt/backups/sql-xtrabackup/mysql/servers.ibd.qp 200919 15:05:29 [01] ...done 200919 15:05:29 [01] Compressing ./mysql/help_keyword.ibd to /mnt/backups/sql-xtrabackup/mysql/help_keyword.ibd.qp 200919 15:05:29 [01] ...done 200919 15:05:29 [01] Compressing ./mysql/time_zone_transition_type.ibd to /mnt/backups/sql-xtrabackup/mysql/time_zone_transition_type.ibd.qp 200919 15:05:29 [01] ...done 200919 15:05:29 [01] Compressing ./mysql/slave_master_info.ibd to /mnt/backups/sql-xtrabackup/mysql/slave_master_info.ibd.qp 200919 15:05:29 [01] ...done 200919 15:05:29 >> log scanned up to (1136502850) 200919 15:05:29 [01] Compressing ./mysql/help_category.ibd to /mnt/backups/sql-xtrabackup/mysql/help_category.ibd.qp 200919 15:05:29 [01] ...done 200919 15:05:30 Executing FLUSH NO_WRITE_TO_BINLOG TABLES... 200919 15:05:30 Executing FLUSH TABLES WITH READ LOCK... 200919 15:05:30 Starting to backup non-InnoDB tables and files 200919 15:05:30 [01] Compressing ./mywordpress/wp_gglcptch_whitelist.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_gglcptch_whitelist.frm.qp 200919 15:05:30 [01] ...done 200919 15:05:30 [01] Compressing ./mywordpress/wp_users.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_users.frm.qp 200919 15:05:30 [01] ...done 200919 15:05:30 >> log scanned up to (1136502850) 200919 15:05:30 [01] Compressing ./mywordpress/db.opt to /mnt/backups/sql-xtrabackup/mywordpress/db.opt.qp 200919 15:05:30 [01] ...done 200919 15:05:31 [01] Compressing ./mywordpress/wp_terms.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_terms.frm.qp 200919 15:05:31 [01] ...done 200919 15:05:31 [01] Compressing ./mywordpress/wp_termmeta.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_termmeta.frm.qp 200919 15:05:31 [01] ...done 200919 15:05:31 [01] Compressing ./mywordpress/wp_comments.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_comments.frm.qp 200919 15:05:31 [01] ...done 200919 15:05:31 [01] Compressing ./mywordpress/wp_options.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_options.frm.qp 200919 15:05:31 [01] ...done 200919 15:05:31 [01] Compressing ./mywordpress/wp_postmeta.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_postmeta.frm.qp 200919 15:05:31 [01] ...done 200919 15:05:31 >> log scanned up to (1136502850) 200919 15:05:31 [01] Compressing ./mywordpress/wp_term_relationships.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_term_relationships.frm.qp 200919 15:05:31 [01] ...done 200919 15:05:32 [01] Compressing ./mywordpress/wp_posts.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_posts.frm.qp 200919 15:05:32 [01] ...done 200919 15:05:32 [01] Compressing ./mywordpress/wp_usermeta.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_usermeta.frm.qp 200919 15:05:32 [01] ...done 200919 15:05:32 [01] Compressing ./mywordpress/wp_links.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_links.frm.qp 200919 15:05:32 [01] ...done 200919 15:05:32 [01] Compressing ./mywordpress/wp_commentmeta.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_commentmeta.frm.qp 200919 15:05:32 [01] ...done 200919 15:05:32 >> log scanned up to (1136502850) 200919 15:05:33 [01] Compressing ./mywordpress/wp_term_taxonomy.frm to /mnt/backups/sql-xtrabackup/mywordpress/wp_term_taxonomy.frm.qp 200919 15:05:33 [01] ...done 200919 15:05:33 [01] Compressing ./sys/x@0024user_summary.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary.frm.qp 200919 15:05:33 [01] ...done 200919 15:05:33 [01] Compressing ./sys/x@0024statements_with_temp_tables.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statements_with_temp_tables.frm.qp 200919 15:05:33 [01] ...done 200919 15:05:33 [01] Compressing ./sys/schema_redundant_indexes.frm to /mnt/backups/sql-xtrabackup/sys/schema_redundant_indexes.frm.qp 200919 15:05:33 [01] ...done 200919 15:05:33 [01] Compressing ./sys/x@0024innodb_buffer_stats_by_schema.frm to /mnt/backups/sql-xtrabackup/sys/x@0024innodb_buffer_stats_by_schema.frm.qp 200919 15:05:33 [01] ...done 200919 15:05:33 [01] Compressing ./sys/metrics.frm to /mnt/backups/sql-xtrabackup/sys/metrics.frm.qp 200919 15:05:33 [01] ...done 200919 15:05:33 >> log scanned up to (1136502850) 200919 15:05:33 [01] Compressing ./sys/x@0024statements_with_sorting.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statements_with_sorting.frm.qp 200919 15:05:33 [01] ...done 200919 15:05:34 [01] Compressing ./sys/x@0024user_summary_by_file_io.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary_by_file_io.frm.qp 200919 15:05:34 [01] ...done 200919 15:05:34 [01] Compressing ./sys/io_global_by_wait_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/io_global_by_wait_by_latency.frm.qp 200919 15:05:34 [01] ...done 200919 15:05:34 [01] Compressing ./sys/statements_with_full_table_scans.frm to /mnt/backups/sql-xtrabackup/sys/statements_with_full_table_scans.frm.qp 200919 15:05:34 [01] ...done 200919 15:05:34 [01] Compressing ./sys/schema_index_statistics.frm to /mnt/backups/sql-xtrabackup/sys/schema_index_statistics.frm.qp 200919 15:05:34 [01] ...done 200919 15:05:34 [01] Compressing ./sys/x@0024host_summary_by_file_io.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary_by_file_io.frm.qp 200919 15:05:34 [01] ...done 200919 15:05:34 >> log scanned up to (1136502850) 200919 15:05:34 [01] Compressing ./sys/io_global_by_file_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/io_global_by_file_by_latency.frm.qp 200919 15:05:34 [01] ...done 200919 15:05:35 [01] Compressing ./sys/host_summary_by_statement_latency.frm to /mnt/backups/sql-xtrabackup/sys/host_summary_by_statement_latency.frm.qp 200919 15:05:35 [01] ...done 200919 15:05:35 [01] Compressing ./sys/schema_tables_with_full_table_scans.frm to /mnt/backups/sql-xtrabackup/sys/schema_tables_with_full_table_scans.frm.qp 200919 15:05:35 [01] ...done 200919 15:05:35 [01] Compressing ./sys/io_by_thread_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/io_by_thread_by_latency.frm.qp 200919 15:05:35 [01] ...done 200919 15:05:35 [01] Compressing ./sys/db.opt to /mnt/backups/sql-xtrabackup/sys/db.opt.qp 200919 15:05:35 [01] ...done 200919 15:05:35 >> log scanned up to (1136502850) 200919 15:05:35 [01] Compressing ./sys/user_summary_by_statement_type.frm to /mnt/backups/sql-xtrabackup/sys/user_summary_by_statement_type.frm.qp 200919 15:05:35 [01] ...done 200919 15:05:36 [01] Compressing ./sys/innodb_lock_waits.frm to /mnt/backups/sql-xtrabackup/sys/innodb_lock_waits.frm.qp 200919 15:05:36 [01] ...done 200919 15:05:36 [01] Compressing ./sys/x@0024wait_classes_global_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024wait_classes_global_by_latency.frm.qp 200919 15:05:36 [01] ...done 200919 15:05:36 [01] Compressing ./sys/io_global_by_wait_by_bytes.frm to /mnt/backups/sql-xtrabackup/sys/io_global_by_wait_by_bytes.frm.qp 200919 15:05:36 [01] ...done 200919 15:05:36 [01] Compressing ./sys/x@0024schema_flattened_keys.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_flattened_keys.frm.qp 200919 15:05:36 [01] ...done 200919 15:05:36 [01] Compressing ./sys/x@0024statements_with_errors_or_warnings.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statements_with_errors_or_warnings.frm.qp 200919 15:05:36 [01] ...done 200919 15:05:36 [01] Compressing ./sys/x@0024schema_table_statistics_with_buffer.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_table_statistics_with_buffer.frm.qp 200919 15:05:36 [01] ...done 200919 15:05:36 >> log scanned up to (1136502850) 200919 15:05:36 [01] Compressing ./sys/schema_object_overview.frm to /mnt/backups/sql-xtrabackup/sys/schema_object_overview.frm.qp 200919 15:05:36 [01] ...done 200919 15:05:37 [01] Compressing ./sys/x@0024schema_index_statistics.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_index_statistics.frm.qp 200919 15:05:37 [01] ...done 200919 15:05:37 [01] Compressing ./sys/host_summary_by_statement_type.frm to /mnt/backups/sql-xtrabackup/sys/host_summary_by_statement_type.frm.qp 200919 15:05:37 [01] ...done 200919 15:05:37 [01] Compressing ./sys/x@0024innodb_lock_waits.frm to /mnt/backups/sql-xtrabackup/sys/x@0024innodb_lock_waits.frm.qp 200919 15:05:37 [01] ...done 200919 15:05:37 [01] Compressing ./sys/host_summary_by_file_io.frm to /mnt/backups/sql-xtrabackup/sys/host_summary_by_file_io.frm.qp 200919 15:05:37 [01] ...done 200919 15:05:37 [01] Compressing ./sys/x@0024memory_global_total.frm to /mnt/backups/sql-xtrabackup/sys/x@0024memory_global_total.frm.qp 200919 15:05:37 [01] ...done 200919 15:05:37 >> log scanned up to (1136502850) 200919 15:05:37 [01] Compressing ./sys/statement_analysis.frm to /mnt/backups/sql-xtrabackup/sys/statement_analysis.frm.qp 200919 15:05:37 [01] ...done 200919 15:05:38 [01] Compressing ./sys/x@0024io_global_by_file_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024io_global_by_file_by_latency.frm.qp 200919 15:05:38 [01] ...done 200919 15:05:38 [01] Compressing ./sys/session_ssl_status.frm to /mnt/backups/sql-xtrabackup/sys/session_ssl_status.frm.qp 200919 15:05:38 [01] ...done 200919 15:05:38 [01] Compressing ./sys/schema_auto_increment_columns.frm to /mnt/backups/sql-xtrabackup/sys/schema_auto_increment_columns.frm.qp 200919 15:05:38 [01] ...done 200919 15:05:38 [01] Compressing ./sys/x@0024latest_file_io.frm to /mnt/backups/sql-xtrabackup/sys/x@0024latest_file_io.frm.qp 200919 15:05:38 [01] ...done 200919 15:05:38 [01] Compressing ./sys/x@0024schema_table_lock_waits.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_table_lock_waits.frm.qp 200919 15:05:38 [01] ...done 200919 15:05:38 >> log scanned up to (1136502850) 200919 15:05:39 [01] Compressing ./sys/x@0024host_summary.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary.frm.qp 200919 15:05:39 [01] ...done 200919 15:05:39 [01] Compressing ./sys/statements_with_errors_or_warnings.frm to /mnt/backups/sql-xtrabackup/sys/statements_with_errors_or_warnings.frm.qp 200919 15:05:39 [01] ...done 200919 15:05:39 [01] Compressing ./sys/sys_config_update_set_user.TRN to /mnt/backups/sql-xtrabackup/sys/sys_config_update_set_user.TRN.qp 200919 15:05:39 [01] ...done 200919 15:05:39 [01] Compressing ./sys/x@0024processlist.frm to /mnt/backups/sql-xtrabackup/sys/x@0024processlist.frm.qp 200919 15:05:39 [01] ...done 200919 15:05:39 [01] Compressing ./sys/user_summary.frm to /mnt/backups/sql-xtrabackup/sys/user_summary.frm.qp 200919 15:05:39 [01] ...done 200919 15:05:39 >> log scanned up to (1136502850) 200919 15:05:39 [01] Compressing ./sys/user_summary_by_file_io_type.frm to /mnt/backups/sql-xtrabackup/sys/user_summary_by_file_io_type.frm.qp 200919 15:05:39 [01] ...done 200919 15:05:40 [01] Compressing ./sys/x@0024wait_classes_global_by_avg_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024wait_classes_global_by_avg_latency.frm.qp 200919 15:05:40 [01] ...done 200919 15:05:40 [01] Compressing ./sys/io_global_by_file_by_bytes.frm to /mnt/backups/sql-xtrabackup/sys/io_global_by_file_by_bytes.frm.qp 200919 15:05:40 [01] ...done 200919 15:05:40 [01] Compressing ./sys/waits_by_user_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/waits_by_user_by_latency.frm.qp 200919 15:05:40 [01] ...done 200919 15:05:40 [01] Compressing ./sys/x@0024host_summary_by_stages.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary_by_stages.frm.qp 200919 15:05:40 [01] ...done 200919 15:05:40 >> log scanned up to (1136502850) 200919 15:05:40 [01] Compressing ./sys/x@0024schema_tables_with_full_table_scans.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_tables_with_full_table_scans.frm.qp 200919 15:05:40 [01] ...done 200919 15:05:41 [01] Compressing ./sys/x@0024ps_digest_avg_latency_distribution.frm to /mnt/backups/sql-xtrabackup/sys/x@0024ps_digest_avg_latency_distribution.frm.qp 200919 15:05:41 [01] ...done 200919 15:05:41 [01] Compressing ./sys/x@0024io_by_thread_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024io_by_thread_by_latency.frm.qp 200919 15:05:41 [01] ...done 200919 15:05:41 [01] Compressing ./sys/x@0024statements_with_full_table_scans.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statements_with_full_table_scans.frm.qp 200919 15:05:41 [01] ...done 200919 15:05:41 [01] Compressing ./sys/user_summary_by_file_io.frm to /mnt/backups/sql-xtrabackup/sys/user_summary_by_file_io.frm.qp 200919 15:05:41 [01] ...done 200919 15:05:41 >> log scanned up to (1136502850) 200919 15:05:41 [01] Compressing ./sys/x@0024statement_analysis.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statement_analysis.frm.qp 200919 15:05:41 [01] ...done 200919 15:05:42 [01] Compressing ./sys/innodb_buffer_stats_by_schema.frm to /mnt/backups/sql-xtrabackup/sys/innodb_buffer_stats_by_schema.frm.qp 200919 15:05:42 [01] ...done 200919 15:05:42 [01] Compressing ./sys/x@0024waits_by_user_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024waits_by_user_by_latency.frm.qp 200919 15:05:42 [01] ...done 200919 15:05:42 >> log scanned up to (1136502850) 200919 15:05:42 [01] Compressing ./sys/schema_table_statistics.frm to /mnt/backups/sql-xtrabackup/sys/schema_table_statistics.frm.qp 200919 15:05:42 [01] ...done 200919 15:05:43 [01] Compressing ./sys/schema_unused_indexes.frm to /mnt/backups/sql-xtrabackup/sys/schema_unused_indexes.frm.qp 200919 15:05:43 [01] ...done 200919 15:05:43 [01] Compressing ./sys/statements_with_sorting.frm to /mnt/backups/sql-xtrabackup/sys/statements_with_sorting.frm.qp 200919 15:05:43 [01] ...done 200919 15:05:43 [01] Compressing ./sys/sys_config_insert_set_user.TRN to /mnt/backups/sql-xtrabackup/sys/sys_config_insert_set_user.TRN.qp 200919 15:05:43 [01] ...done 200919 15:05:43 >> log scanned up to (1136502850) 200919 15:05:44 [01] Compressing ./sys/waits_by_host_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/waits_by_host_by_latency.frm.qp 200919 15:05:44 [01] ...done 200919 15:05:44 [01] Compressing ./sys/waits_global_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/waits_global_by_latency.frm.qp 200919 15:05:44 [01] ...done 200919 15:05:44 [01] Compressing ./sys/x@0024memory_global_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024memory_global_by_current_bytes.frm.qp 200919 15:05:44 [01] ...done 200919 15:05:44 [01] Compressing ./sys/session.frm to /mnt/backups/sql-xtrabackup/sys/session.frm.qp 200919 15:05:44 [01] ...done 200919 15:05:44 >> log scanned up to (1136502850) 200919 15:05:44 [01] Compressing ./sys/x@0024host_summary_by_statement_type.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary_by_statement_type.frm.qp 200919 15:05:44 [01] ...done 200919 15:05:45 [01] Compressing ./sys/memory_by_thread_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/memory_by_thread_by_current_bytes.frm.qp 200919 15:05:45 [01] ...done 200919 15:05:45 [01] Compressing ./sys/innodb_buffer_stats_by_table.frm to /mnt/backups/sql-xtrabackup/sys/innodb_buffer_stats_by_table.frm.qp 200919 15:05:45 [01] ...done 200919 15:05:45 [01] Compressing ./sys/version.frm to /mnt/backups/sql-xtrabackup/sys/version.frm.qp 200919 15:05:45 [01] ...done 200919 15:05:45 [01] Compressing ./sys/processlist.frm to /mnt/backups/sql-xtrabackup/sys/processlist.frm.qp 200919 15:05:45 [01] ...done 200919 15:05:45 [01] Compressing ./sys/statements_with_runtimes_in_95th_percentile.frm to /mnt/backups/sql-xtrabackup/sys/statements_with_runtimes_in_95th_percentile.frm.qp 200919 15:05:45 [01] ...done 200919 15:05:45 >> log scanned up to (1136502850) 200919 15:05:45 [01] Compressing ./sys/x@0024host_summary_by_file_io_type.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary_by_file_io_type.frm.qp 200919 15:05:45 [01] ...done 200919 15:05:46 [01] Compressing ./sys/x@0024user_summary_by_file_io_type.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary_by_file_io_type.frm.qp 200919 15:05:46 [01] ...done 200919 15:05:46 [01] Compressing ./sys/x@0024user_summary_by_statement_type.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary_by_statement_type.frm.qp 200919 15:05:46 [01] ...done 200919 15:05:46 [01] Compressing ./sys/memory_global_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/memory_global_by_current_bytes.frm.qp 200919 15:05:46 [01] ...done 200919 15:05:46 >> log scanned up to (1136502850) 200919 15:05:46 [01] Compressing ./sys/sys_config.TRG to /mnt/backups/sql-xtrabackup/sys/sys_config.TRG.qp 200919 15:05:46 [01] ...done 200919 15:05:47 [01] Compressing ./sys/memory_global_total.frm to /mnt/backups/sql-xtrabackup/sys/memory_global_total.frm.qp 200919 15:05:47 [01] ...done 200919 15:05:47 [01] Compressing ./sys/x@0024io_global_by_file_by_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024io_global_by_file_by_bytes.frm.qp 200919 15:05:47 [01] ...done 200919 15:05:47 [01] Compressing ./sys/x@0024user_summary_by_stages.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary_by_stages.frm.qp 200919 15:05:47 [01] ...done 200919 15:05:47 [01] Compressing ./sys/x@0024io_global_by_wait_by_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024io_global_by_wait_by_bytes.frm.qp 200919 15:05:47 [01] ...done 200919 15:05:47 [01] Compressing ./sys/x@0024io_global_by_wait_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024io_global_by_wait_by_latency.frm.qp 200919 15:05:47 [01] ...done 200919 15:05:47 >> log scanned up to (1136502850) 200919 15:05:48 [01] Compressing ./sys/x@0024user_summary_by_statement_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024user_summary_by_statement_latency.frm.qp 200919 15:05:48 [01] ...done 200919 15:05:48 [01] Compressing ./sys/x@0024waits_global_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024waits_global_by_latency.frm.qp 200919 15:05:48 [01] ...done 200919 15:05:48 [01] Compressing ./sys/x@0024waits_by_host_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024waits_by_host_by_latency.frm.qp 200919 15:05:48 [01] ...done 200919 15:05:48 [01] Compressing ./sys/ps_check_lost_instrumentation.frm to /mnt/backups/sql-xtrabackup/sys/ps_check_lost_instrumentation.frm.qp 200919 15:05:48 [01] ...done 200919 15:05:48 [01] Compressing ./sys/user_summary_by_stages.frm to /mnt/backups/sql-xtrabackup/sys/user_summary_by_stages.frm.qp 200919 15:05:48 [01] ...done 200919 15:05:48 [01] Compressing ./sys/wait_classes_global_by_latency.frm to /mnt/backups/sql-xtrabackup/sys/wait_classes_global_by_latency.frm.qp 200919 15:05:48 [01] ...done 200919 15:05:48 >> log scanned up to (1136502850) 200919 15:05:48 [01] Compressing ./sys/x@0024memory_by_user_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024memory_by_user_by_current_bytes.frm.qp 200919 15:05:48 [01] ...done 200919 15:05:49 [01] Compressing ./sys/x@0024memory_by_host_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024memory_by_host_by_current_bytes.frm.qp 200919 15:05:49 [01] ...done 200919 15:05:49 [01] Compressing ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /mnt/backups/sql-xtrabackup/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm.qp 200919 15:05:49 [01] ...done 200919 15:05:49 [01] Compressing ./sys/schema_table_lock_waits.frm to /mnt/backups/sql-xtrabackup/sys/schema_table_lock_waits.frm.qp 200919 15:05:49 [01] ...done 200919 15:05:49 [01] Compressing ./sys/latest_file_io.frm to /mnt/backups/sql-xtrabackup/sys/latest_file_io.frm.qp 200919 15:05:49 [01] ...done 200919 15:05:49 >> log scanned up to (1136502850) 200919 15:05:49 [01] Compressing ./sys/x@0024session.frm to /mnt/backups/sql-xtrabackup/sys/x@0024session.frm.qp 200919 15:05:49 [01] ...done 200919 15:05:50 [01] Compressing ./sys/x@0024ps_schema_table_statistics_io.frm to /mnt/backups/sql-xtrabackup/sys/x@0024ps_schema_table_statistics_io.frm.qp 200919 15:05:50 [01] ...done 200919 15:05:50 [01] Compressing ./sys/host_summary.frm to /mnt/backups/sql-xtrabackup/sys/host_summary.frm.qp 200919 15:05:50 [01] ...done 200919 15:05:50 [01] Compressing ./sys/host_summary_by_file_io_type.frm to /mnt/backups/sql-xtrabackup/sys/host_summary_by_file_io_type.frm.qp 200919 15:05:50 [01] ...done 200919 15:05:50 [01] Compressing ./sys/host_summary_by_stages.frm to /mnt/backups/sql-xtrabackup/sys/host_summary_by_stages.frm.qp 200919 15:05:50 [01] ...done 200919 15:05:50 [01] Compressing ./sys/wait_classes_global_by_avg_latency.frm to /mnt/backups/sql-xtrabackup/sys/wait_classes_global_by_avg_latency.frm.qp 200919 15:05:50 [01] ...done 200919 15:05:50 >> log scanned up to (1136502850) 200919 15:05:50 [01] Compressing ./sys/x@0024host_summary_by_statement_latency.frm to /mnt/backups/sql-xtrabackup/sys/x@0024host_summary_by_statement_latency.frm.qp 200919 15:05:50 [01] ...done 200919 15:05:51 [01] Compressing ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /mnt/backups/sql-xtrabackup/sys/x@0024statements_with_runtimes_in_95th_percentile.frm.qp 200919 15:05:51 [01] ...done 200919 15:05:51 [01] Compressing ./sys/x@0024schema_table_statistics.frm to /mnt/backups/sql-xtrabackup/sys/x@0024schema_table_statistics.frm.qp 200919 15:05:51 [01] ...done 200919 15:05:51 [01] Compressing ./sys/user_summary_by_statement_latency.frm to /mnt/backups/sql-xtrabackup/sys/user_summary_by_statement_latency.frm.qp 200919 15:05:51 [01] ...done 200919 15:05:51 [01] Compressing ./sys/x@0024memory_by_thread_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/x@0024memory_by_thread_by_current_bytes.frm.qp 200919 15:05:51 [01] ...done 200919 15:05:51 [01] Compressing ./sys/x@0024innodb_buffer_stats_by_table.frm to /mnt/backups/sql-xtrabackup/sys/x@0024innodb_buffer_stats_by_table.frm.qp 200919 15:05:51 [01] ...done 200919 15:05:51 >> log scanned up to (1136502850) 200919 15:05:52 [01] Compressing ./sys/sys_config.frm to /mnt/backups/sql-xtrabackup/sys/sys_config.frm.qp 200919 15:05:52 [01] ...done 200919 15:05:52 >> log scanned up to (1136502850) 200919 15:05:53 [01] Compressing ./sys/statements_with_temp_tables.frm to /mnt/backups/sql-xtrabackup/sys/statements_with_temp_tables.frm.qp 200919 15:05:53 [01] ...done 200919 15:05:53 >> log scanned up to (1136502850) 200919 15:05:53 [01] Compressing ./sys/schema_table_statistics_with_buffer.frm to /mnt/backups/sql-xtrabackup/sys/schema_table_statistics_with_buffer.frm.qp 200919 15:05:53 [01] ...done 200919 15:05:54 [01] Compressing ./sys/memory_by_host_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/memory_by_host_by_current_bytes.frm.qp 200919 15:05:54 [01] ...done 200919 15:05:54 [01] Compressing ./sys/memory_by_user_by_current_bytes.frm to /mnt/backups/sql-xtrabackup/sys/memory_by_user_by_current_bytes.frm.qp 200919 15:05:54 [01] ...done 200919 15:05:54 [01] Compressing ./performance_schema/status_by_account.frm to /mnt/backups/sql-xtrabackup/performance_schema/status_by_account.frm.qp 200919 15:05:54 [01] ...done 200919 15:05:54 >> log scanned up to (1136502850) 200919 15:05:55 >> log scanned up to (1136502850) 200919 15:05:56 >> log scanned up to (1136502850) 200919 15:05:57 [01] Compressing ./performance_schema/memory_summary_by_account_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/memory_summary_by_account_by_event_name.frm.qp 200919 15:05:57 [01] ...done 200919 15:05:57 [01] Compressing ./performance_schema/events_transactions_history.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_history.frm.qp 200919 15:05:57 [01] ...done 200919 15:05:57 >> log scanned up to (1136502850) 200919 15:05:57 [01] Compressing ./performance_schema/replication_group_members.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_group_members.frm.qp 200919 15:05:57 [01] ...done 200919 15:05:58 [01] Compressing ./performance_schema/events_stages_history.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_history.frm.qp 200919 15:05:58 [01] ...done 200919 15:05:58 [01] Compressing ./performance_schema/events_statements_current.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_current.frm.qp 200919 15:05:58 [01] ...done 200919 15:05:58 [01] Compressing ./performance_schema/memory_summary_by_user_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/memory_summary_by_user_by_event_name.frm.qp 200919 15:05:58 [01] ...done 200919 15:05:58 >> log scanned up to (1136502850) 200919 15:05:58 [01] Compressing ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_by_thread_by_event_name.frm.qp 200919 15:05:58 [01] ...done 200919 15:05:59 [01] Compressing ./performance_schema/replication_applier_configuration.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_applier_configuration.frm.qp 200919 15:05:59 [01] ...done 200919 15:05:59 [01] Compressing ./performance_schema/objects_summary_global_by_type.frm to /mnt/backups/sql-xtrabackup/performance_schema/objects_summary_global_by_type.frm.qp 200919 15:05:59 [01] ...done 200919 15:05:59 [01] Compressing ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_by_user_by_event_name.frm.qp 200919 15:05:59 [01] ...done 200919 15:05:59 [01] Compressing ./performance_schema/threads.frm to /mnt/backups/sql-xtrabackup/performance_schema/threads.frm.qp 200919 15:05:59 [01] ...done 200919 15:05:59 >> log scanned up to (1136502850) 200919 15:05:59 [01] Compressing ./performance_schema/socket_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/socket_instances.frm.qp 200919 15:05:59 [01] ...done 200919 15:06:00 [01] Compressing ./performance_schema/memory_summary_by_host_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/memory_summary_by_host_by_event_name.frm.qp 200919 15:06:00 [01] ...done 200919 15:06:00 [01] Compressing ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_summary_by_account_by_event_name.frm.qp 200919 15:06:00 [01] ...done 200919 15:06:00 [01] Compressing ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_summary_by_account_by_event_name.frm.qp 200919 15:06:00 [01] ...done 200919 15:06:00 [01] Compressing ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_summary_by_thread_by_event_name.frm.qp 200919 15:06:00 [01] ...done 200919 15:06:00 >> log scanned up to (1136502850) 200919 15:06:00 [01] Compressing ./performance_schema/db.opt to /mnt/backups/sql-xtrabackup/performance_schema/db.opt.qp 200919 15:06:00 [01] ...done 200919 15:06:01 [01] Compressing ./performance_schema/accounts.frm to /mnt/backups/sql-xtrabackup/performance_schema/accounts.frm.qp 200919 15:06:01 [01] ...done 200919 15:06:01 [01] Compressing ./performance_schema/cond_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/cond_instances.frm.qp 200919 15:06:01 [01] ...done 200919 15:06:01 [01] Compressing ./performance_schema/users.frm to /mnt/backups/sql-xtrabackup/performance_schema/users.frm.qp 200919 15:06:01 [01] ...done 200919 15:06:01 [01] Compressing ./performance_schema/events_statements_history.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_history.frm.qp 200919 15:06:01 >> log scanned up to (1136502850) 200919 15:06:01 [01] ...done 200919 15:06:02 [01] Compressing ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_user_by_event_name.frm.qp 200919 15:06:02 [01] ...done 200919 15:06:02 [01] Compressing ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_summary_by_host_by_event_name.frm.qp 200919 15:06:02 [01] ...done 200919 15:06:02 [01] Compressing ./performance_schema/rwlock_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/rwlock_instances.frm.qp 200919 15:06:02 [01] ...done 200919 15:06:02 [01] Compressing ./performance_schema/global_variables.frm to /mnt/backups/sql-xtrabackup/performance_schema/global_variables.frm.qp 200919 15:06:02 [01] ...done 200919 15:06:02 >> log scanned up to (1136502850) 200919 15:06:02 [01] Compressing ./performance_schema/memory_summary_global_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/memory_summary_global_by_event_name.frm.qp 200919 15:06:02 [01] ...done 200919 15:06:03 [01] Compressing ./performance_schema/file_summary_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/file_summary_by_event_name.frm.qp 200919 15:06:03 [01] ...done 200919 15:06:03 [01] Compressing ./performance_schema/socket_summary_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/socket_summary_by_event_name.frm.qp 200919 15:06:03 [01] ...done 200919 15:06:03 [01] Compressing ./performance_schema/replication_applier_status_by_worker.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_applier_status_by_worker.frm.qp 200919 15:06:03 [01] ...done 200919 15:06:03 [01] Compressing ./performance_schema/setup_timers.frm to /mnt/backups/sql-xtrabackup/performance_schema/setup_timers.frm.qp 200919 15:06:03 [01] ...done 200919 15:06:03 >> log scanned up to (1136502850) 200919 15:06:03 [01] Compressing ./performance_schema/events_statements_summary_by_digest.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_digest.frm.qp 200919 15:06:03 [01] ...done 200919 15:06:04 [01] Compressing ./performance_schema/replication_group_member_stats.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_group_member_stats.frm.qp 200919 15:06:04 [01] ...done 200919 15:06:04 [01] Compressing ./performance_schema/mutex_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/mutex_instances.frm.qp 200919 15:06:04 [01] ...done 200919 15:06:04 [01] Compressing ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_summary_by_host_by_event_name.frm.qp 200919 15:06:04 [01] ...done 200919 15:06:04 [01] Compressing ./performance_schema/table_io_waits_summary_by_index_usage.frm to /mnt/backups/sql-xtrabackup/performance_schema/table_io_waits_summary_by_index_usage.frm.qp 200919 15:06:04 [01] ...done 200919 15:06:04 >> log scanned up to (1136502850) 200919 15:06:04 [01] Compressing ./performance_schema/replication_applier_status.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_applier_status.frm.qp 200919 15:06:04 [01] ...done 200919 15:06:05 [01] Compressing ./performance_schema/session_account_connect_attrs.frm to /mnt/backups/sql-xtrabackup/performance_schema/session_account_connect_attrs.frm.qp 200919 15:06:05 [01] ...done 200919 15:06:05 [01] Compressing ./performance_schema/setup_objects.frm to /mnt/backups/sql-xtrabackup/performance_schema/setup_objects.frm.qp 200919 15:06:05 [01] ...done 200919 15:06:05 [01] Compressing ./performance_schema/prepared_statements_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/prepared_statements_instances.frm.qp 200919 15:06:05 [01] ...done 200919 15:06:05 [01] Compressing ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_host_by_event_name.frm.qp 200919 15:06:05 [01] ...done 200919 15:06:05 [01] Compressing ./performance_schema/session_status.frm to /mnt/backups/sql-xtrabackup/performance_schema/session_status.frm.qp 200919 15:06:05 [01] ...done 200919 15:06:05 >> log scanned up to (1136502850) 200919 15:06:05 [01] Compressing ./performance_schema/status_by_thread.frm to /mnt/backups/sql-xtrabackup/performance_schema/status_by_thread.frm.qp 200919 15:06:05 [01] ...done 200919 15:06:06 [01] Compressing ./performance_schema/events_transactions_history_long.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_history_long.frm.qp 200919 15:06:06 [01] ...done 200919 15:06:06 [01] Compressing ./performance_schema/host_cache.frm to /mnt/backups/sql-xtrabackup/performance_schema/host_cache.frm.qp 200919 15:06:06 [01] ...done 200919 15:06:06 [01] Compressing ./performance_schema/table_io_waits_summary_by_table.frm to /mnt/backups/sql-xtrabackup/performance_schema/table_io_waits_summary_by_table.frm.qp 200919 15:06:06 [01] ...done 200919 15:06:06 [01] Compressing ./performance_schema/replication_connection_status.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_connection_status.frm.qp 200919 15:06:06 [01] ...done 200919 15:06:06 >> log scanned up to (1136502850) 200919 15:06:06 [01] Compressing ./performance_schema/setup_actors.frm to /mnt/backups/sql-xtrabackup/performance_schema/setup_actors.frm.qp 200919 15:06:06 [01] ...done 200919 15:06:07 [01] Compressing ./performance_schema/metadata_locks.frm to /mnt/backups/sql-xtrabackup/performance_schema/metadata_locks.frm.qp 200919 15:06:07 [01] ...done 200919 15:06:07 [01] Compressing ./performance_schema/events_waits_summary_global_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_global_by_event_name.frm.qp 200919 15:06:07 [01] ...done 200919 15:06:07 [01] Compressing ./performance_schema/file_summary_by_instance.frm to /mnt/backups/sql-xtrabackup/performance_schema/file_summary_by_instance.frm.qp 200919 15:06:07 [01] ...done 200919 15:06:07 [01] Compressing ./performance_schema/status_by_user.frm to /mnt/backups/sql-xtrabackup/performance_schema/status_by_user.frm.qp 200919 15:06:07 [01] ...done 200919 15:06:07 >> log scanned up to (1136502850) 200919 15:06:07 [01] Compressing ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_thread_by_event_name.frm.qp 200919 15:06:07 [01] ...done 200919 15:06:08 [01] Compressing ./performance_schema/events_statements_history_long.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_history_long.frm.qp 200919 15:06:08 [01] ...done 200919 15:06:08 [01] Compressing ./performance_schema/session_variables.frm to /mnt/backups/sql-xtrabackup/performance_schema/session_variables.frm.qp 200919 15:06:08 [01] ...done 200919 15:06:08 [01] Compressing ./performance_schema/setup_instruments.frm to /mnt/backups/sql-xtrabackup/performance_schema/setup_instruments.frm.qp 200919 15:06:08 [01] ...done 200919 15:06:08 >> log scanned up to (1136502850) 200919 15:06:08 [01] Compressing ./performance_schema/hosts.frm to /mnt/backups/sql-xtrabackup/performance_schema/hosts.frm.qp 200919 15:06:08 [01] ...done 200919 15:06:09 [01] Compressing ./performance_schema/setup_consumers.frm to /mnt/backups/sql-xtrabackup/performance_schema/setup_consumers.frm.qp 200919 15:06:09 [01] ...done 200919 15:06:09 [01] Compressing ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_by_host_by_event_name.frm.qp 200919 15:06:09 [01] ...done 200919 15:06:09 [01] Compressing ./performance_schema/file_instances.frm to /mnt/backups/sql-xtrabackup/performance_schema/file_instances.frm.qp 200919 15:06:09 [01] ...done 200919 15:06:09 [01] Compressing ./performance_schema/events_waits_history_long.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_history_long.frm.qp 200919 15:06:09 [01] ...done 200919 15:06:09 [01] Compressing ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_summary_by_thread_by_event_name.frm.qp 200919 15:06:09 [01] ...done 200919 15:06:09 >> log scanned up to (1136502850) 200919 15:06:09 [01] Compressing ./performance_schema/user_variables_by_thread.frm to /mnt/backups/sql-xtrabackup/performance_schema/user_variables_by_thread.frm.qp 200919 15:06:09 [01] ...done 200919 15:06:10 [01] Compressing ./performance_schema/events_stages_history_long.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_history_long.frm.qp 200919 15:06:10 [01] ...done 200919 15:06:10 [01] Compressing ./performance_schema/events_statements_summary_by_program.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_program.frm.qp 200919 15:06:10 [01] ...done 200919 15:06:10 [01] Compressing ./performance_schema/global_status.frm to /mnt/backups/sql-xtrabackup/performance_schema/global_status.frm.qp 200919 15:06:10 [01] ...done 200919 15:06:10 >> log scanned up to (1136502850) 200919 15:06:10 [01] Compressing ./performance_schema/events_transactions_current.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_current.frm.qp 200919 15:06:10 [01] ...done 200919 15:06:11 [01] Compressing ./performance_schema/performance_timers.frm to /mnt/backups/sql-xtrabackup/performance_schema/performance_timers.frm.qp 200919 15:06:11 [01] ...done 200919 15:06:11 [01] Compressing ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_summary_by_user_by_event_name.frm.qp 200919 15:06:11 [01] ...done 200919 15:06:11 [01] Compressing ./performance_schema/variables_by_thread.frm to /mnt/backups/sql-xtrabackup/performance_schema/variables_by_thread.frm.qp 200919 15:06:11 [01] ...done 200919 15:06:11 [01] Compressing ./performance_schema/replication_connection_configuration.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_connection_configuration.frm.qp 200919 15:06:11 [01] ...done 200919 15:06:11 >> log scanned up to (1136502850) 200919 15:06:12 [01] Compressing ./performance_schema/replication_applier_status_by_coordinator.frm to /mnt/backups/sql-xtrabackup/performance_schema/replication_applier_status_by_coordinator.frm.qp 200919 15:06:12 [01] ...done 200919 15:06:12 [01] Compressing ./performance_schema/socket_summary_by_instance.frm to /mnt/backups/sql-xtrabackup/performance_schema/socket_summary_by_instance.frm.qp 200919 15:06:12 [01] ...done 200919 15:06:12 [01] Compressing ./performance_schema/status_by_host.frm to /mnt/backups/sql-xtrabackup/performance_schema/status_by_host.frm.qp 200919 15:06:12 [01] ...done 200919 15:06:12 [01] Compressing ./performance_schema/events_waits_history.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_history.frm.qp 200919 15:06:12 [01] ...done 200919 15:06:12 [01] Compressing ./performance_schema/table_handles.frm to /mnt/backups/sql-xtrabackup/performance_schema/table_handles.frm.qp 200919 15:06:12 [01] ...done 200919 15:06:12 >> log scanned up to (1136502850) 200919 15:06:13 [01] Compressing ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_by_account_by_event_name.frm.qp 200919 15:06:13 [01] ...done 200919 15:06:13 [01] Compressing ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_by_account_by_event_name.frm.qp 200919 15:06:13 [01] ...done 200919 15:06:13 >> log scanned up to (1136502850) 200919 15:06:13 [01] Compressing ./performance_schema/events_transactions_summary_global_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_summary_global_by_event_name.frm.qp 200919 15:06:13 [01] ...done 200919 15:06:13 [01] Compressing ./performance_schema/memory_summary_by_thread_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/memory_summary_by_thread_by_event_name.frm.qp 200919 15:06:13 [01] ...done 200919 15:06:14 [01] Compressing ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_transactions_summary_by_user_by_event_name.frm.qp 200919 15:06:14 [01] ...done 200919 15:06:14 [01] Compressing ./performance_schema/events_stages_summary_global_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_summary_global_by_event_name.frm.qp 200919 15:06:14 [01] ...done 200919 15:06:14 [01] Compressing ./performance_schema/events_statements_summary_global_by_event_name.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_statements_summary_global_by_event_name.frm.qp 200919 15:06:14 [01] ...done 200919 15:06:14 [01] Compressing ./performance_schema/events_waits_current.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_current.frm.qp 200919 15:06:14 [01] ...done 200919 15:06:14 >> log scanned up to (1136502850) 200919 15:06:14 [01] Compressing ./performance_schema/events_waits_summary_by_instance.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_waits_summary_by_instance.frm.qp 200919 15:06:14 [01] ...done 200919 15:06:14 [01] Compressing ./performance_schema/events_stages_current.frm to /mnt/backups/sql-xtrabackup/performance_schema/events_stages_current.frm.qp 200919 15:06:14 [01] ...done 200919 15:06:15 [01] Compressing ./performance_schema/table_lock_waits_summary_by_table.frm to /mnt/backups/sql-xtrabackup/performance_schema/table_lock_waits_summary_by_table.frm.qp 200919 15:06:15 [01] ...done 200919 15:06:15 [01] Compressing ./performance_schema/session_connect_attrs.frm to /mnt/backups/sql-xtrabackup/performance_schema/session_connect_attrs.frm.qp 200919 15:06:15 [01] ...done 200919 15:06:15 [01] Compressing ./mysql/slow_log.CSM to /mnt/backups/sql-xtrabackup/mysql/slow_log.CSM.qp 200919 15:06:15 [01] ...done 200919 15:06:15 >> log scanned up to (1136502850) 200919 15:06:15 [01] Compressing ./mysql/db.MYI to /mnt/backups/sql-xtrabackup/mysql/db.MYI.qp 200919 15:06:15 [01] ...done 200919 15:06:16 [01] Compressing ./mysql/server_cost.frm to /mnt/backups/sql-xtrabackup/mysql/server_cost.frm.qp 200919 15:06:16 [01] ...done 200919 15:06:16 [01] Compressing ./mysql/proxies_priv.MYD to /mnt/backups/sql-xtrabackup/mysql/proxies_priv.MYD.qp 200919 15:06:16 [01] ...done 200919 15:06:16 [01] Compressing ./mysql/proxies_priv.MYI to /mnt/backups/sql-xtrabackup/mysql/proxies_priv.MYI.qp 200919 15:06:16 [01] ...done 200919 15:06:16 [01] Compressing ./mysql/func.MYI to /mnt/backups/sql-xtrabackup/mysql/func.MYI.qp 200919 15:06:16 [01] ...done 200919 15:06:16 >> log scanned up to (1136502850) 200919 15:06:16 [01] Compressing ./mysql/time_zone.frm to /mnt/backups/sql-xtrabackup/mysql/time_zone.frm.qp 200919 15:06:16 [01] ...done 200919 15:06:17 [01] Compressing ./mysql/plugin.frm to /mnt/backups/sql-xtrabackup/mysql/plugin.frm.qp 200919 15:06:17 [01] ...done 200919 15:06:17 [01] Compressing ./mysql/engine_cost.frm to /mnt/backups/sql-xtrabackup/mysql/engine_cost.frm.qp 200919 15:06:17 [01] ...done 200919 15:06:17 [01] Compressing ./mysql/general_log.CSV to /mnt/backups/sql-xtrabackup/mysql/general_log.CSV.qp 200919 15:06:17 [01] ...done 200919 15:06:17 [01] Compressing ./mysql/ndb_binlog_index.MYD to /mnt/backups/sql-xtrabackup/mysql/ndb_binlog_index.MYD.qp 200919 15:06:17 [01] ...done 200919 15:06:17 [01] Compressing ./mysql/procs_priv.frm to /mnt/backups/sql-xtrabackup/mysql/procs_priv.frm.qp 200919 15:06:17 [01] ...done 200919 15:06:17 >> log scanned up to (1136502850) 200919 15:06:17 [01] Compressing ./mysql/db.opt to /mnt/backups/sql-xtrabackup/mysql/db.opt.qp 200919 15:06:17 [01] ...done 200919 15:06:18 [01] Compressing ./mysql/func.MYD to /mnt/backups/sql-xtrabackup/mysql/func.MYD.qp 200919 15:06:18 [01] ...done 200919 15:06:18 [01] Compressing ./mysql/event.frm to /mnt/backups/sql-xtrabackup/mysql/event.frm.qp 200919 15:06:18 [01] ...done 200919 15:06:18 [01] Compressing ./mysql/help_keyword.frm to /mnt/backups/sql-xtrabackup/mysql/help_keyword.frm.qp 200919 15:06:18 [01] ...done 200919 15:06:18 [01] Compressing ./mysql/slave_relay_log_info.frm to /mnt/backups/sql-xtrabackup/mysql/slave_relay_log_info.frm.qp 200919 15:06:18 [01] ...done 200919 15:06:18 [01] Compressing ./mysql/ndb_binlog_index.frm to /mnt/backups/sql-xtrabackup/mysql/ndb_binlog_index.frm.qp 200919 15:06:18 [01] ...done 200919 15:06:18 >> log scanned up to (1136502850) 200919 15:06:18 [01] Compressing ./mysql/proc.MYI to /mnt/backups/sql-xtrabackup/mysql/proc.MYI.qp 200919 15:06:18 [01] ...done 200919 15:06:19 [01] Compressing ./mysql/innodb_table_stats.frm to /mnt/backups/sql-xtrabackup/mysql/innodb_table_stats.frm.qp 200919 15:06:19 [01] ...done 200919 15:06:19 [01] Compressing ./mysql/slave_worker_info.frm to /mnt/backups/sql-xtrabackup/mysql/slave_worker_info.frm.qp 200919 15:06:19 [01] ...done 200919 15:06:19 [01] Compressing ./mysql/innodb_index_stats.frm to /mnt/backups/sql-xtrabackup/mysql/innodb_index_stats.frm.qp 200919 15:06:19 [01] ...done 200919 15:06:19 [01] Compressing ./mysql/slave_master_info.frm to /mnt/backups/sql-xtrabackup/mysql/slave_master_info.frm.qp 200919 15:06:19 [01] ...done 200919 15:06:19 >> log scanned up to (1136502850) 200919 15:06:19 [01] Compressing ./mysql/slow_log.CSV to /mnt/backups/sql-xtrabackup/mysql/slow_log.CSV.qp 200919 15:06:19 [01] ...done 200919 15:06:19 [01] Compressing ./mysql/event.MYD to /mnt/backups/sql-xtrabackup/mysql/event.MYD.qp 200919 15:06:19 [01] ...done 200919 15:06:20 [01] Compressing ./mysql/event.MYI to /mnt/backups/sql-xtrabackup/mysql/event.MYI.qp 200919 15:06:20 [01] ...done 200919 15:06:20 [01] Compressing ./mysql/ndb_binlog_index.MYI to /mnt/backups/sql-xtrabackup/mysql/ndb_binlog_index.MYI.qp 200919 15:06:20 [01] ...done 200919 15:06:20 [01] Compressing ./mysql/user.MYI to /mnt/backups/sql-xtrabackup/mysql/user.MYI.qp 200919 15:06:20 [01] ...done 200919 15:06:20 [01] Compressing ./mysql/func.frm to /mnt/backups/sql-xtrabackup/mysql/func.frm.qp 200919 15:06:20 [01] ...done 200919 15:06:20 [01] Compressing ./mysql/general_log.frm to /mnt/backups/sql-xtrabackup/mysql/general_log.frm.qp 200919 15:06:20 [01] ...done 200919 15:06:20 >> log scanned up to (1136502850) 200919 15:06:20 [01] Compressing ./mysql/help_relation.frm to /mnt/backups/sql-xtrabackup/mysql/help_relation.frm.qp 200919 15:06:20 [01] ...done 200919 15:06:21 [01] Compressing ./mysql/tables_priv.MYI to /mnt/backups/sql-xtrabackup/mysql/tables_priv.MYI.qp 200919 15:06:21 [01] ...done 200919 15:06:21 [01] Compressing ./mysql/columns_priv.frm to /mnt/backups/sql-xtrabackup/mysql/columns_priv.frm.qp 200919 15:06:21 [01] ...done 200919 15:06:21 [01] Compressing ./mysql/time_zone_leap_second.frm to /mnt/backups/sql-xtrabackup/mysql/time_zone_leap_second.frm.qp 200919 15:06:21 [01] ...done 200919 15:06:21 [01] Compressing ./mysql/time_zone_transition.frm to /mnt/backups/sql-xtrabackup/mysql/time_zone_transition.frm.qp 200919 15:06:21 [01] ...done 200919 15:06:21 [01] Compressing ./mysql/user.frm to /mnt/backups/sql-xtrabackup/mysql/user.frm.qp 200919 15:06:21 [01] ...done 200919 15:06:21 [01] Compressing ./mysql/gtid_executed.frm to /mnt/backups/sql-xtrabackup/mysql/gtid_executed.frm.qp 200919 15:06:21 [01] ...done 200919 15:06:21 >> log scanned up to (1136502850) 200919 15:06:21 [01] Compressing ./mysql/columns_priv.MYI to /mnt/backups/sql-xtrabackup/mysql/columns_priv.MYI.qp 200919 15:06:21 [01] ...done 200919 15:06:22 [01] Compressing ./mysql/tables_priv.frm to /mnt/backups/sql-xtrabackup/mysql/tables_priv.frm.qp 200919 15:06:22 [01] ...done 200919 15:06:22 [01] Compressing ./mysql/procs_priv.MYI to /mnt/backups/sql-xtrabackup/mysql/procs_priv.MYI.qp 200919 15:06:22 [01] ...done 200919 15:06:22 [01] Compressing ./mysql/general_log.CSM to /mnt/backups/sql-xtrabackup/mysql/general_log.CSM.qp 200919 15:06:22 [01] ...done 200919 15:06:22 [01] Compressing ./mysql/user.MYD to /mnt/backups/sql-xtrabackup/mysql/user.MYD.qp 200919 15:06:22 [01] ...done 200919 15:06:22 >> log scanned up to (1136502850) 200919 15:06:22 [01] Compressing ./mysql/time_zone_name.frm to /mnt/backups/sql-xtrabackup/mysql/time_zone_name.frm.qp 200919 15:06:22 [01] ...done 200919 15:06:23 [01] Compressing ./mysql/procs_priv.MYD to /mnt/backups/sql-xtrabackup/mysql/procs_priv.MYD.qp 200919 15:06:23 [01] ...done 200919 15:06:23 [01] Compressing ./mysql/time_zone_transition_type.frm to /mnt/backups/sql-xtrabackup/mysql/time_zone_transition_type.frm.qp 200919 15:06:23 [01] ...done 200919 15:06:23 [01] Compressing ./mysql/servers.frm to /mnt/backups/sql-xtrabackup/mysql/servers.frm.qp 200919 15:06:23 [01] ...done 200919 15:06:23 [01] Compressing ./mysql/proc.MYD to /mnt/backups/sql-xtrabackup/mysql/proc.MYD.qp 200919 15:06:23 [01] ...done 200919 15:06:23 >> log scanned up to (1136502942) 200919 15:06:24 [01] Compressing ./mysql/slow_log.frm to /mnt/backups/sql-xtrabackup/mysql/slow_log.frm.qp 200919 15:06:24 [01] ...done 200919 15:06:24 >> log scanned up to (1136502942) 200919 15:06:25 >> log scanned up to (1136502942) 200919 15:06:25 [01] Compressing ./mysql/db.frm to /mnt/backups/sql-xtrabackup/mysql/db.frm.qp 200919 15:06:25 [01] ...done 200919 15:06:26 [01] Compressing ./mysql/tables_priv.MYD to /mnt/backups/sql-xtrabackup/mysql/tables_priv.MYD.qp 200919 15:06:26 [01] ...done 200919 15:06:26 [01] Compressing ./mysql/help_topic.frm to /mnt/backups/sql-xtrabackup/mysql/help_topic.frm.qp 200919 15:06:26 [01] ...done 200919 15:06:26 [01] Compressing ./mysql/db.MYD to /mnt/backups/sql-xtrabackup/mysql/db.MYD.qp 200919 15:06:26 [01] ...done 200919 15:06:26 [01] Compressing ./mysql/columns_priv.MYD to /mnt/backups/sql-xtrabackup/mysql/columns_priv.MYD.qp 200919 15:06:26 [01] ...done 200919 15:06:26 >> log scanned up to (1136502942) 200919 15:06:26 [01] Compressing ./mysql/proxies_priv.frm to /mnt/backups/sql-xtrabackup/mysql/proxies_priv.frm.qp 200919 15:06:26 [01] ...done 200919 15:06:27 [01] Compressing ./mysql/help_category.frm to /mnt/backups/sql-xtrabackup/mysql/help_category.frm.qp 200919 15:06:27 [01] ...done 200919 15:06:27 [01] Compressing ./mysql/proc.frm to /mnt/backups/sql-xtrabackup/mysql/proc.frm.qp 200919 15:06:27 [01] ...done 200919 15:06:27 Finished backing up non-InnoDB tables and files 200919 15:06:27 [00] Compressing /mnt/backups/sql-xtrabackup/xtrabackup_slave_info.qp 200919 15:06:27 [00] ...done 200919 15:06:27 [00] Compressing /mnt/backups/sql-xtrabackup/xtrabackup_binlog_info.qp 200919 15:06:27 [00] ...done 200919 15:06:27 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '1136502933' xtrabackup: Stopping log copying thread. .200919 15:06:27 >> log scanned up to (1136502942) 200919 15:06:28 Executing UNLOCK TABLES 200919 15:06:28 All tables unlocked 200919 15:06:28 [00] Compressing ib_buffer_pool to /mnt/backups/sql-xtrabackup/ib_buffer_pool.qp 200919 15:06:28 [00] ...done 200919 15:06:28 Backup created in directory '/mnt/backups/sql-xtrabackup/' MySQL binlog position: filename 'srv-bin.000001', position '997678' 200919 15:06:28 [00] Compressing /mnt/backups/sql-xtrabackup/backup-my.cnf.qp 200919 15:06:28 [00] ...done 200919 15:06:28 [00] Compressing /mnt/backups/sql-xtrabackup/xtrabackup_info.qp 200919 15:06:28 [00] ...done xtrabackup: Transaction log of lsn (1136502288) to (1136502942) was copied. 200919 15:06:29 completed OK! [root@srv ~]# ls -altr /mnt/backups/sql-xtrabackup/ общо 2008 drwxr-xr-x. 7 root root 4096 19 Sep 15,04 .. -rw-r-----. 1 root root 2016947 19 Sep 15,05 ibdata1.qp drwxr-x---. 2 root root 4096 19 Sep 15,05 mywordpress drwxr-x---. 2 root root 12288 19 Sep 15,05 sys drwxr-x---. 2 root root 4096 19 Sep 15,06 performance_schema drwxr-x---. 2 root root 4096 19 Sep 15,06 mysql -rw-r-----. 1 root root 59 19 Sep 15,06 xtrabackup_slave_info.qp -rw-r-----. 1 root root 111 19 Sep 15,06 xtrabackup_binlog_info.qp -rw-r-----. 1 root root 986 19 Sep 15,06 xtrabackup_logfile.qp -rw-r-----. 1 root root 144 19 Sep 15,06 xtrabackup_checkpoints -rw-r-----. 1 root root 1477 19 Sep 15,06 ib_buffer_pool.qp -rw-r-----. 1 root root 471 19 Sep 15,06 backup-my.cnf.qp drwxr-xr-x. 6 root root 4096 19 Sep 15,06 . -rw-r-----. 1 root root 534 19 Sep 15,06 xtrabackup_info.qp
Before –prepare command the –decompress should be used!
yum install -y qpress xtrabackup --decompress --slave-info --datadir=/var/lib/mysql/ --target-dir=/mnt/backups/sql-xtrabackup/
Bonus 3 – Installation under CentOS 7
The whole output in CentOS 7 and what packages you may have including percona-xtrabackup in the name.
[root@srv ~]# yum install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm Loaded plugins: fastestmirror percona-release-latest.noarch.rpm | 19 kB 00:00:00 Examining /var/tmp/yum-root-GmzK6H/percona-release-latest.noarch.rpm: percona-release-1.0-25.noarch Marking /var/tmp/yum-root-GmzK6H/percona-release-latest.noarch.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package percona-release.noarch 0:1.0-25 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================== Package Arch Version Repository Size ============================================================================================================================================================================================== Installing: percona-release noarch 1.0-25 /percona-release-latest.noarch 31 k Transaction Summary ============================================================================================================================================================================================== Install 1 Package Total size: 31 k Installed size: 31 k Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : percona-release-1.0-25.noarch 1/1 * Enabling the Percona Original repository <*> All done! * Enabling the Percona Release repository <*> All done! The percona-release package now contains a percona-release script that can enable additional repositories for our newer products. For example, to enable the Percona Server 8.0 repository use: percona-release setup ps80 Note: To avoid conflicts with older product versions, the percona-release setup command may disable our original repository for some products. For more information, please visit: https://www.percona.com/doc/percona-repo-config/percona-release.html Verifying : percona-release-1.0-25.noarch 1/1 Installed: percona-release.noarch 0:1.0-25 Complete! [root@srv ~]# yum search percona-xtrabackup Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile epel/x86_64/metalink | 15 kB 00:00:00 * epel: mirrors.n-ix.net * extras: linux.darkpenguin.net * updates: mirror.fra10.de.leaseweb.net base | 3.6 kB 00:00:00 centos-gluster6 | 3.0 kB 00:00:00 centos-gluster7 | 3.0 kB 00:00:00 epel | 4.7 kB 00:00:00 extras | 2.9 kB 00:00:00 ius | 1.3 kB 00:00:00 nginx | 2.9 kB 00:00:00 percona-release-noarch | 2.9 kB 00:00:00 percona-release-x86_64 | 2.9 kB 00:00:00 prel-release-noarch | 2.9 kB 00:00:00 rsyslog_v8 | 2.6 kB 00:00:00 updates | 2.9 kB 00:00:00 (1/6): epel/x86_64/updateinfo | 1.0 MB 00:00:00 (2/6): prel-release-noarch/7/primary_db | 2.5 kB 00:00:00 (3/6): percona-release-noarch/7/primary_db | 24 kB 00:00:00 (4/6): epel/x86_64/primary_db | 6.9 MB 00:00:00 (5/6): percona-release-x86_64/7/primary_db | 1.1 MB 00:00:00 (6/6): rsyslog_v8/7/x86_64/primary_db | 540 kB 00:00:00 ============================================================================== N/S matched: percona-xtrabackup =============================================================================== percona-xtrabackup-22-debuginfo.x86_64 : Debug information for package percona-xtrabackup-22 percona-xtrabackup-24-debuginfo.x86_64 : Debug information for package percona-xtrabackup-24 percona-xtrabackup-80-debuginfo.x86_64 : Debug information for package percona-xtrabackup-80 percona-xtrabackup-debuginfo.x86_64 : Debug information for package percona-xtrabackup percona-xtrabackup.x86_64 : XtraBackup online backup for MySQL / InnoDB percona-xtrabackup-22.x86_64 : XtraBackup online backup for MySQL / InnoDB percona-xtrabackup-24.x86_64 : XtraBackup online backup for MySQL / InnoDB percona-xtrabackup-80.x86_64 : XtraBackup online backup for MySQL / InnoDB percona-xtrabackup-test.x86_64 : Test suite for Percona XtraBackup percona-xtrabackup-test-22.x86_64 : Test suite for Percona XtraBackup percona-xtrabackup-test-24.x86_64 : Test suite for Percona XtraBackup percona-xtrabackup-test-80.x86_64 : Test suite for Percona XtraBackup Name and summary matches only, use "search all" for everything. [root@srv ~]# yum install -y percona-xtrabackup-24 Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: mirror.alpix.eu * centos-gluster6: mirror.alpix.eu * centos-gluster7: mirror.fra10.de.leaseweb.net * epel: mirrors.n-ix.net * extras: linux.darkpenguin.net * updates: mirror.fra10.de.leaseweb.net Resolving Dependencies --> Running transaction check ---> Package percona-xtrabackup-24.x86_64 0:2.4.20-1.el7 will be installed --> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-24-2.4.20-1.el7.x86_64 --> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.20-1.el7.x86_64 --> Running transaction check ---> Package libev.x86_64 0:4.15-7.el7 will be installed ---> Package perl-DBD-MySQL.x86_64 0:4.023-6.el7 will be installed --> Processing Dependency: perl(DBI::Const::GetInfoType) for package: perl-DBD-MySQL-4.023-6.el7.x86_64 --> Processing Dependency: perl(DBI) for package: perl-DBD-MySQL-4.023-6.el7.x86_64 --> Running transaction check ---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed --> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64 --> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64 --> Running transaction check ---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed --> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch --> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch --> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch --> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch --> Running transaction check ---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed --> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch --> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch ---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed --> Running transaction check ---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed ---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================== Package Arch Version Repository Size ============================================================================================================================================================================================== Installing: percona-xtrabackup-24 x86_64 2.4.20-1.el7 percona-release-x86_64 7.6 M Installing for dependencies: libev x86_64 4.15-7.el7 extras 44 k perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k perl-DBD-MySQL x86_64 4.023-6.el7 base 140 k perl-DBI x86_64 1.627-4.el7 base 802 k perl-IO-Compress noarch 2.061-2.el7 base 260 k perl-Net-Daemon noarch 0.48-5.el7 base 51 k perl-PlRPC noarch 0.2020-14.el7 base 36 k Transaction Summary ============================================================================================================================================================================================== Install 1 Package (+8 Dependent packages) Total download size: 9.0 M Installed size: 11 M Downloading packages: (1/9): libev-4.15-7.el7.x86_64.rpm | 44 kB 00:00:00 (2/9): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:00 (3/9): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:00 (4/9): perl-DBD-MySQL-4.023-6.el7.x86_64.rpm | 140 kB 00:00:00 (5/9): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:00 (6/9): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00 (7/9): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:00 (8/9): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00 warning: /var/cache/yum/x86_64/7/percona-release-x86_64/packages/percona-xtrabackup-24-2.4.20-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY | 8.8 MB 00:00:00 ETA Public key for percona-xtrabackup-24-2.4.20-1.el7.x86_64.rpm is not installed (9/9): percona-xtrabackup-24-2.4.20-1.el7.x86_64.rpm | 7.6 MB 00:00:01 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 5.8 MB/s | 9.0 MB 00:00:01 Retrieving key from file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY Importing GPG key 0x8507EFA5: Userid : "Percona MySQL Development Team (Packaging key) <mysql-dev@percona.com>" Fingerprint: 4d1b b29d 63d9 8e42 2b21 13b1 9334 a25f 8507 efa5 Package : percona-release-1.0-25.noarch (installed) From : /etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 1/9 Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 2/9 Installing : perl-IO-Compress-2.061-2.el7.noarch 3/9 Installing : libev-4.15-7.el7.x86_64 4/9 Installing : perl-Net-Daemon-0.48-5.el7.noarch 5/9 Installing : perl-PlRPC-0.2020-14.el7.noarch 6/9 Installing : perl-DBI-1.627-4.el7.x86_64 7/9 Installing : perl-DBD-MySQL-4.023-6.el7.x86_64 8/9 Installing : percona-xtrabackup-24-2.4.20-1.el7.x86_64 9/9 Verifying : perl-Net-Daemon-0.48-5.el7.noarch 1/9 Verifying : percona-xtrabackup-24-2.4.20-1.el7.x86_64 2/9 Verifying : perl-DBD-MySQL-4.023-6.el7.x86_64 3/9 Verifying : perl-IO-Compress-2.061-2.el7.noarch 4/9 Verifying : libev-4.15-7.el7.x86_64 5/9 Verifying : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 6/9 Verifying : perl-DBI-1.627-4.el7.x86_64 7/9 Verifying : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 8/9 Verifying : perl-PlRPC-0.2020-14.el7.noarch 9/9 Installed: percona-xtrabackup-24.x86_64 0:2.4.20-1.el7 Dependency Installed: libev.x86_64 0:4.15-7.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBD-MySQL.x86_64 0:4.023-6.el7 perl-DBI.x86_64 0:1.627-4.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7 Complete!