Using xtrabackup to make fast MySQL backups – backup and restore

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:

  1. Execute xtrabackup with –backup option to copy the MySQL data files and additional information for the tool
  2. 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.
  3. 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:

  1. xtrabackup –backup –compress – copy and compress on-the-fly.
  2. xtrabackup –decompress – decompress the backup files
  3. xtrabackup –prepare – make point-in-time consistent MySQL data files, which are ready for a MySQL server.
  4. 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!

Leave a Reply

Your email address will not be published.