MariaDB10.2.26 +xtrabackup 备份恢复测试过程

1、测试过程

[root@rec lib]# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 11Server version: 10.2.26-MariaDB-log MariaDB ServerCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> drop database full;Query OK, 1 row affected (0.31 sec)MariaDB [(none)]> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || performance_schema || test               |+--------------------+4 rows in set (0.00 sec)MariaDB [(none)]> create database full charset=utf8;Query OK, 1 row affected (0.00 sec)MariaDB [(none)]> create table full.incr(id int not null auto_increment primary key,tag varchar(256)) charset=utf8;Query OK, 0 rows affected (0.02 sec)MariaDB [(none)]> show table from full;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from full' at line 1MariaDB [(none)]> show tables from full;+----------------+| Tables_in_full |+----------------+| incr           |+----------------+1 row in set (0.00 sec)MariaDB [(none)]> select * from full.incr;Empty set (0.00 sec)MariaDB [(none)]> exitBye[root@rec lib]# cd /tmp/[root@rec tmp]# ll总用量 4drwxr-x---. 3 root root 33 8月  26 14:17 fullbakdrwxr-x---. 5 root root 45 8月  26 14:21 incr-rw-r--r--. 1 root root 57 8月  26 14:17 percona-version-check[root@rec tmp]# rm /tmp/* -fr[root@rec tmp]# ll总用量 0[root@rec tmp]# innobackupex --user=root  --no-timestamp  /tmp/fullbakxtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin xtrabackup: recognized client arguments: 190826 14:31:20 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully.           At the end of a successful backup run innobackupex           prints "completed OK!".190826 14:31:20  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root'  (using password: NO).190826 14:31:20  version_check Connected to MySQL server190826 14:31:20  version_check Executing a version check against the server...190826 14:31:20  version_check Done.190826 14:31:20 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not setUsing server version 10.2.26-MariaDB-loginnobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)xtrabackup: uses posix_fadvise().xtrabackup: cd to /var/lib/mysqlxtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = ./xtrabackup:   innodb_log_files_in_group = 2xtrabackup:   innodb_log_file_size = 50331648InnoDB: Number of pools: 1190826 14:31:20 >> log scanned up to (1648472)xtrabackup: Generating a list of tablespacesInnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0190826 14:31:20 [01] Copying ./ibdata1 to /tmp/fullbak/ibdata1190826 14:31:20 [01]        ...done190826 14:31:21 >> log scanned up to (1648472)190826 14:31:21 [01] Copying ./mysql/innodb_table_stats.ibd to /tmp/fullbak/mysql/innodb_table_stats.ibd190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/innodb_index_stats.ibd to /tmp/fullbak/mysql/innodb_index_stats.ibd190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/gtid_slave_pos.ibd to /tmp/fullbak/mysql/gtid_slave_pos.ibd190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./full/incr.ibd to /tmp/fullbak/full/incr.ibd190826 14:31:21 [01]        ...done190826 14:31:21 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...190826 14:31:21 Executing FLUSH TABLES WITH READ LOCK...190826 14:31:21 Starting to backup non-InnoDB tables and files190826 14:31:21 [01] Copying ./mysql/db.opt to /tmp/fullbak/mysql/db.opt190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/db.frm to /tmp/fullbak/mysql/db.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/db.MYI to /tmp/fullbak/mysql/db.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/db.MYD to /tmp/fullbak/mysql/db.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/host.frm to /tmp/fullbak/mysql/host.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/host.MYI to /tmp/fullbak/mysql/host.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/host.MYD to /tmp/fullbak/mysql/host.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/user.frm to /tmp/fullbak/mysql/user.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/user.MYI to /tmp/fullbak/mysql/user.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/user.MYD to /tmp/fullbak/mysql/user.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/roles_mapping.frm to /tmp/fullbak/mysql/roles_mapping.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/roles_mapping.MYI to /tmp/fullbak/mysql/roles_mapping.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/roles_mapping.MYD to /tmp/fullbak/mysql/roles_mapping.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/func.frm to /tmp/fullbak/mysql/func.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/func.MYI to /tmp/fullbak/mysql/func.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/func.MYD to /tmp/fullbak/mysql/func.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/plugin.frm to /tmp/fullbak/mysql/plugin.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/plugin.MYI to /tmp/fullbak/mysql/plugin.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/plugin.MYD to /tmp/fullbak/mysql/plugin.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/servers.frm to /tmp/fullbak/mysql/servers.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/servers.MYI to /tmp/fullbak/mysql/servers.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/servers.MYD to /tmp/fullbak/mysql/servers.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/tables_priv.frm to /tmp/fullbak/mysql/tables_priv.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/tables_priv.MYI to /tmp/fullbak/mysql/tables_priv.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/tables_priv.MYD to /tmp/fullbak/mysql/tables_priv.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/columns_priv.frm to /tmp/fullbak/mysql/columns_priv.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/columns_priv.MYI to /tmp/fullbak/mysql/columns_priv.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/columns_priv.MYD to /tmp/fullbak/mysql/columns_priv.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_topic.frm to /tmp/fullbak/mysql/help_topic.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_topic.MYI to /tmp/fullbak/mysql/help_topic.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_topic.MYD to /tmp/fullbak/mysql/help_topic.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_category.frm to /tmp/fullbak/mysql/help_category.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_category.MYI to /tmp/fullbak/mysql/help_category.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_category.MYD to /tmp/fullbak/mysql/help_category.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_relation.frm to /tmp/fullbak/mysql/help_relation.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_relation.MYI to /tmp/fullbak/mysql/help_relation.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_relation.MYD to /tmp/fullbak/mysql/help_relation.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_keyword.frm to /tmp/fullbak/mysql/help_keyword.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_keyword.MYI to /tmp/fullbak/mysql/help_keyword.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/help_keyword.MYD to /tmp/fullbak/mysql/help_keyword.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_name.frm to /tmp/fullbak/mysql/time_zone_name.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_name.MYI to /tmp/fullbak/mysql/time_zone_name.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_name.MYD to /tmp/fullbak/mysql/time_zone_name.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone.frm to /tmp/fullbak/mysql/time_zone.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone.MYI to /tmp/fullbak/mysql/time_zone.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone.MYD to /tmp/fullbak/mysql/time_zone.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_transition.frm to /tmp/fullbak/mysql/time_zone_transition.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_transition.MYI to /tmp/fullbak/mysql/time_zone_transition.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_transition.MYD to /tmp/fullbak/mysql/time_zone_transition.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/fullbak/mysql/time_zone_transition_type.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_transition_type.MYI to /tmp/fullbak/mysql/time_zone_transition_type.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_transition_type.MYD to /tmp/fullbak/mysql/time_zone_transition_type.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/fullbak/mysql/time_zone_leap_second.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_leap_second.MYI to /tmp/fullbak/mysql/time_zone_leap_second.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/time_zone_leap_second.MYD to /tmp/fullbak/mysql/time_zone_leap_second.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/proc.frm to /tmp/fullbak/mysql/proc.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/proc.MYI to /tmp/fullbak/mysql/proc.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/proc.MYD to /tmp/fullbak/mysql/proc.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/procs_priv.frm to /tmp/fullbak/mysql/procs_priv.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/procs_priv.MYI to /tmp/fullbak/mysql/procs_priv.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/procs_priv.MYD to /tmp/fullbak/mysql/procs_priv.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/general_log.frm to /tmp/fullbak/mysql/general_log.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/general_log.CSM to /tmp/fullbak/mysql/general_log.CSM190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/general_log.CSV to /tmp/fullbak/mysql/general_log.CSV190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/slow_log.frm to /tmp/fullbak/mysql/slow_log.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/slow_log.CSM to /tmp/fullbak/mysql/slow_log.CSM190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/slow_log.CSV to /tmp/fullbak/mysql/slow_log.CSV190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/event.frm to /tmp/fullbak/mysql/event.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/event.MYI to /tmp/fullbak/mysql/event.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/event.MYD to /tmp/fullbak/mysql/event.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/fullbak/mysql/innodb_table_stats.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/fullbak/mysql/innodb_index_stats.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/proxies_priv.frm to /tmp/fullbak/mysql/proxies_priv.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/proxies_priv.MYI to /tmp/fullbak/mysql/proxies_priv.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/proxies_priv.MYD to /tmp/fullbak/mysql/proxies_priv.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/table_stats.frm to /tmp/fullbak/mysql/table_stats.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/table_stats.MYI to /tmp/fullbak/mysql/table_stats.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/table_stats.MYD to /tmp/fullbak/mysql/table_stats.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/column_stats.frm to /tmp/fullbak/mysql/column_stats.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/column_stats.MYI to /tmp/fullbak/mysql/column_stats.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/column_stats.MYD to /tmp/fullbak/mysql/column_stats.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/index_stats.frm to /tmp/fullbak/mysql/index_stats.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/index_stats.MYI to /tmp/fullbak/mysql/index_stats.MYI190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/index_stats.MYD to /tmp/fullbak/mysql/index_stats.MYD190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./mysql/gtid_slave_pos.frm to /tmp/fullbak/mysql/gtid_slave_pos.frm190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./test/db.opt to /tmp/fullbak/test/db.opt190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./performance_schema/db.opt to /tmp/fullbak/performance_schema/db.opt190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./full/db.opt to /tmp/fullbak/full/db.opt190826 14:31:21 [01]        ...done190826 14:31:21 [01] Copying ./full/incr.frm to /tmp/fullbak/full/incr.frm190826 14:31:21 [01]        ...done190826 14:31:21 Finished backing up non-InnoDB tables and files190826 14:31:21 [00] Writing /tmp/fullbak/xtrabackup_binlog_info190826 14:31:21 [00]        ...done190826 14:31:21 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...xtrabackup: The latest check point (for incremental): '1648463'xtrabackup: Stopping log copying thread..190826 14:31:21 >> log scanned up to (1648472)190826 14:31:22 Executing UNLOCK TABLES190826 14:31:22 All tables unlocked190826 14:31:22 [00] Copying ib_buffer_pool to /tmp/fullbak/ib_buffer_pool190826 14:31:22 [00]        ...done190826 14:31:22 Backup created in directory '/tmp/fullbak/'MySQL binlog position: filename 'mysqlbin.000001', position '797', GTID of the last change '0-1-3'190826 14:31:22 [00] Writing /tmp/fullbak/backup-my.cnf190826 14:31:22 [00]        ...done190826 14:31:22 [00] Writing /tmp/fullbak/xtrabackup_info190826 14:31:22 [00]        ...donextrabackup: Transaction log of lsn (1648463) to (1648472) was copied.190826 14:31:22 completed OK![root@rec tmp]# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 14Server version: 10.2.26-MariaDB-log MariaDB ServerCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> insert into full.incr(tag) values("第1次增备后");Query OK, 1 row affected (0.30 sec)MariaDB [(none)]> exitBye[root@rec tmp]# innobackupex --user=root  --no-timestamp  --parallel=4  --incremental-basedir=/tmp/fullbak/ --incremental /tmp/incr/incr1xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin --parallel=4 xtrabackup: recognized client arguments: 190826 14:32:45 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully.           At the end of a successful backup run innobackupex           prints "completed OK!".190826 14:32:46  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root'  (using password: NO).190826 14:32:46  version_check Connected to MySQL server190826 14:32:46  version_check Executing a version check against the server...190826 14:32:46  version_check Done.190826 14:32:46 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not setUsing server version 10.2.26-MariaDB-loginnobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)incremental backup from 1648463 is enabled.xtrabackup: uses posix_fadvise().xtrabackup: cd to /var/lib/mysqlxtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = ./xtrabackup:   innodb_log_files_in_group = 2xtrabackup:   innodb_log_file_size = 50331648InnoDB: Number of pools: 1190826 14:32:46 >> log scanned up to (1648883)xtrabackup: Generating a list of tablespacesInnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0xtrabackup: using the full scan for incremental backupxtrabackup: Starting 4 threads for parallel data files transfer190826 14:32:46 [03] Copying ./mysql/innodb_index_stats.ibd to /tmp/incr/incr1/mysql/innodb_index_stats.ibd.delta190826 14:32:46 [03]        ...done190826 14:32:46 [04] Copying ./mysql/gtid_slave_pos.ibd to /tmp/incr/incr1/mysql/gtid_slave_pos.ibd.delta190826 14:32:46 [02] Copying ./mysql/innodb_table_stats.ibd to /tmp/incr/incr1/mysql/innodb_table_stats.ibd.delta190826 14:32:46 [02]        ...done190826 14:32:46 [04]        ...done190826 14:32:46 [01] Copying ./ibdata1 to /tmp/incr/incr1/ibdata1.delta190826 14:32:46 [03] Copying ./full/incr.ibd to /tmp/incr/incr1/full/incr.ibd.delta190826 14:32:46 [03]        ...done190826 14:32:46 [01]        ...done190826 14:32:47 >> log scanned up to (1648883)190826 14:32:47 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...190826 14:32:47 Executing FLUSH TABLES WITH READ LOCK...190826 14:32:47 Starting to backup non-InnoDB tables and files190826 14:32:47 [01] Copying ./mysql/db.opt to /tmp/incr/incr1/mysql/db.opt190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/db.frm to /tmp/incr/incr1/mysql/db.frm190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/db.MYI to /tmp/incr/incr1/mysql/db.MYI190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/db.MYD to /tmp/incr/incr1/mysql/db.MYD190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/host.frm to /tmp/incr/incr1/mysql/host.frm190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/host.MYI to /tmp/incr/incr1/mysql/host.MYI190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/host.MYD to /tmp/incr/incr1/mysql/host.MYD190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/user.frm to /tmp/incr/incr1/mysql/user.frm190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/user.MYI to /tmp/incr/incr1/mysql/user.MYI190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/user.MYD to /tmp/incr/incr1/mysql/user.MYD190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/roles_mapping.frm to /tmp/incr/incr1/mysql/roles_mapping.frm190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/roles_mapping.MYI to /tmp/incr/incr1/mysql/roles_mapping.MYI190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/roles_mapping.MYD to /tmp/incr/incr1/mysql/roles_mapping.MYD190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/func.frm to /tmp/incr/incr1/mysql/func.frm190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/func.MYI to /tmp/incr/incr1/mysql/func.MYI190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/func.MYD to /tmp/incr/incr1/mysql/func.MYD190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/plugin.frm to /tmp/incr/incr1/mysql/plugin.frm190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/plugin.MYI to /tmp/incr/incr1/mysql/plugin.MYI190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/plugin.MYD to /tmp/incr/incr1/mysql/plugin.MYD190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/servers.frm to /tmp/incr/incr1/mysql/servers.frm190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/servers.MYI to /tmp/incr/incr1/mysql/servers.MYI190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/servers.MYD to /tmp/incr/incr1/mysql/servers.MYD190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/tables_priv.frm to /tmp/incr/incr1/mysql/tables_priv.frm190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/tables_priv.MYI to /tmp/incr/incr1/mysql/tables_priv.MYI190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/tables_priv.MYD to /tmp/incr/incr1/mysql/tables_priv.MYD190826 14:32:47 [01]        ...done190826 14:32:47 [01] Copying ./mysql/columns_priv.frm to /tmp/incr/incr1/mysql/columns_priv.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/columns_priv.MYI to /tmp/incr/incr1/mysql/columns_priv.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/columns_priv.MYD to /tmp/incr/incr1/mysql/columns_priv.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_topic.frm to /tmp/incr/incr1/mysql/help_topic.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_topic.MYI to /tmp/incr/incr1/mysql/help_topic.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_topic.MYD to /tmp/incr/incr1/mysql/help_topic.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_category.frm to /tmp/incr/incr1/mysql/help_category.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_category.MYI to /tmp/incr/incr1/mysql/help_category.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_category.MYD to /tmp/incr/incr1/mysql/help_category.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_relation.frm to /tmp/incr/incr1/mysql/help_relation.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_relation.MYI to /tmp/incr/incr1/mysql/help_relation.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_relation.MYD to /tmp/incr/incr1/mysql/help_relation.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_keyword.frm to /tmp/incr/incr1/mysql/help_keyword.frm190826 14:32:48 >> log scanned up to (1648883)190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_keyword.MYI to /tmp/incr/incr1/mysql/help_keyword.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/help_keyword.MYD to /tmp/incr/incr1/mysql/help_keyword.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_name.frm to /tmp/incr/incr1/mysql/time_zone_name.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_name.MYI to /tmp/incr/incr1/mysql/time_zone_name.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_name.MYD to /tmp/incr/incr1/mysql/time_zone_name.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone.frm to /tmp/incr/incr1/mysql/time_zone.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone.MYI to /tmp/incr/incr1/mysql/time_zone.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone.MYD to /tmp/incr/incr1/mysql/time_zone.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_transition.frm to /tmp/incr/incr1/mysql/time_zone_transition.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_transition.MYI to /tmp/incr/incr1/mysql/time_zone_transition.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_transition.MYD to /tmp/incr/incr1/mysql/time_zone_transition.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/incr/incr1/mysql/time_zone_transition_type.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_transition_type.MYI to /tmp/incr/incr1/mysql/time_zone_transition_type.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_transition_type.MYD to /tmp/incr/incr1/mysql/time_zone_transition_type.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/incr/incr1/mysql/time_zone_leap_second.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_leap_second.MYI to /tmp/incr/incr1/mysql/time_zone_leap_second.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/time_zone_leap_second.MYD to /tmp/incr/incr1/mysql/time_zone_leap_second.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/proc.frm to /tmp/incr/incr1/mysql/proc.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/proc.MYI to /tmp/incr/incr1/mysql/proc.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/proc.MYD to /tmp/incr/incr1/mysql/proc.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/procs_priv.frm to /tmp/incr/incr1/mysql/procs_priv.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/procs_priv.MYI to /tmp/incr/incr1/mysql/procs_priv.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/procs_priv.MYD to /tmp/incr/incr1/mysql/procs_priv.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/general_log.frm to /tmp/incr/incr1/mysql/general_log.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/general_log.CSM to /tmp/incr/incr1/mysql/general_log.CSM190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/general_log.CSV to /tmp/incr/incr1/mysql/general_log.CSV190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/slow_log.frm to /tmp/incr/incr1/mysql/slow_log.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/slow_log.CSM to /tmp/incr/incr1/mysql/slow_log.CSM190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/slow_log.CSV to /tmp/incr/incr1/mysql/slow_log.CSV190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/event.frm to /tmp/incr/incr1/mysql/event.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/event.MYI to /tmp/incr/incr1/mysql/event.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/event.MYD to /tmp/incr/incr1/mysql/event.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/incr/incr1/mysql/innodb_table_stats.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/incr/incr1/mysql/innodb_index_stats.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/proxies_priv.frm to /tmp/incr/incr1/mysql/proxies_priv.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/proxies_priv.MYI to /tmp/incr/incr1/mysql/proxies_priv.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/proxies_priv.MYD to /tmp/incr/incr1/mysql/proxies_priv.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/table_stats.frm to /tmp/incr/incr1/mysql/table_stats.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/table_stats.MYI to /tmp/incr/incr1/mysql/table_stats.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/table_stats.MYD to /tmp/incr/incr1/mysql/table_stats.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/column_stats.frm to /tmp/incr/incr1/mysql/column_stats.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/column_stats.MYI to /tmp/incr/incr1/mysql/column_stats.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/column_stats.MYD to /tmp/incr/incr1/mysql/column_stats.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/index_stats.frm to /tmp/incr/incr1/mysql/index_stats.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/index_stats.MYI to /tmp/incr/incr1/mysql/index_stats.MYI190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/index_stats.MYD to /tmp/incr/incr1/mysql/index_stats.MYD190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./mysql/gtid_slave_pos.frm to /tmp/incr/incr1/mysql/gtid_slave_pos.frm190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./test/db.opt to /tmp/incr/incr1/test/db.opt190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./performance_schema/db.opt to /tmp/incr/incr1/performance_schema/db.opt190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./full/db.opt to /tmp/incr/incr1/full/db.opt190826 14:32:48 [01]        ...done190826 14:32:48 [01] Copying ./full/incr.frm to /tmp/incr/incr1/full/incr.frm190826 14:32:48 [01]        ...done190826 14:32:48 Finished backing up non-InnoDB tables and files190826 14:32:48 [00] Writing /tmp/incr/incr1/xtrabackup_binlog_info190826 14:32:48 [00]        ...done190826 14:32:48 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...xtrabackup: The latest check point (for incremental): '1648874'xtrabackup: Stopping log copying thread..190826 14:32:48 >> log scanned up to (1648883)190826 14:32:48 Executing UNLOCK TABLES190826 14:32:48 All tables unlocked190826 14:32:48 [00] Copying ib_buffer_pool to /tmp/incr/incr1/ib_buffer_pool190826 14:32:48 [00]        ...done190826 14:32:48 Backup created in directory '/tmp/incr/incr1/'MySQL binlog position: filename 'mysqlbin.000001', position '1018', GTID of the last change '0-1-4'190826 14:32:48 [00] Writing /tmp/incr/incr1/backup-my.cnf190826 14:32:48 [00]        ...done190826 14:32:48 [00] Writing /tmp/incr/incr1/xtrabackup_info190826 14:32:48 [00]        ...donextrabackup: Transaction log of lsn (1648874) to (1648883) was copied.190826 14:32:48 completed OK![root@rec tmp]# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 17Server version: 10.2.26-MariaDB-log MariaDB ServerCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> insert into full.incr(tag) values("第2次增备后");Query OK, 1 row affected (0.01 sec)MariaDB [(none)]> exitBye[root@rec tmp]# innobackupex --user=root  --no-timestamp  --parallel=4  --incremental-basedir=/tmp/incr/incr1/ --incremental /tmp/incr/incr2 xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin --parallel=4 xtrabackup: recognized client arguments: 190826 14:33:33 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully.           At the end of a successful backup run innobackupex           prints "completed OK!".190826 14:33:33  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root'  (using password: NO).190826 14:33:33  version_check Connected to MySQL server190826 14:33:33  version_check Executing a version check against the server...190826 14:33:33  version_check Done.190826 14:33:33 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not setUsing server version 10.2.26-MariaDB-loginnobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)incremental backup from 1648874 is enabled.xtrabackup: uses posix_fadvise().xtrabackup: cd to /var/lib/mysqlxtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = ./xtrabackup:   innodb_log_files_in_group = 2xtrabackup:   innodb_log_file_size = 50331648InnoDB: Number of pools: 1190826 14:33:33 >> log scanned up to (1649256)xtrabackup: Generating a list of tablespacesInnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0xtrabackup: using the full scan for incremental backupxtrabackup: Starting 4 threads for parallel data files transfer190826 14:33:34 [04] Copying ./mysql/gtid_slave_pos.ibd to /tmp/incr/incr2/mysql/gtid_slave_pos.ibd.delta190826 14:33:34 [04]        ...done190826 14:33:34 [03] Copying ./mysql/innodb_index_stats.ibd to /tmp/incr/incr2/mysql/innodb_index_stats.ibd.delta190826 14:33:34 [03]        ...done190826 14:33:34 [01] Copying ./ibdata1 to /tmp/incr/incr2/ibdata1.delta190826 14:33:34 [04] Copying ./full/incr.ibd to /tmp/incr/incr2/full/incr.ibd.delta190826 14:33:34 [02] Copying ./mysql/innodb_table_stats.ibd to /tmp/incr/incr2/mysql/innodb_table_stats.ibd.delta190826 14:33:34 [02]        ...done190826 14:33:34 [04]        ...done190826 14:33:34 [01]        ...done190826 14:33:34 >> log scanned up to (1649256)190826 14:33:35 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...190826 14:33:35 Executing FLUSH TABLES WITH READ LOCK...190826 14:33:35 Starting to backup non-InnoDB tables and files190826 14:33:35 [01] Copying ./mysql/db.opt to /tmp/incr/incr2/mysql/db.opt190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/db.frm to /tmp/incr/incr2/mysql/db.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/db.MYI to /tmp/incr/incr2/mysql/db.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/db.MYD to /tmp/incr/incr2/mysql/db.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/host.frm to /tmp/incr/incr2/mysql/host.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/host.MYI to /tmp/incr/incr2/mysql/host.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/host.MYD to /tmp/incr/incr2/mysql/host.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/user.frm to /tmp/incr/incr2/mysql/user.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/user.MYI to /tmp/incr/incr2/mysql/user.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/user.MYD to /tmp/incr/incr2/mysql/user.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/roles_mapping.frm to /tmp/incr/incr2/mysql/roles_mapping.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/roles_mapping.MYI to /tmp/incr/incr2/mysql/roles_mapping.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/roles_mapping.MYD to /tmp/incr/incr2/mysql/roles_mapping.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/func.frm to /tmp/incr/incr2/mysql/func.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/func.MYI to /tmp/incr/incr2/mysql/func.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/func.MYD to /tmp/incr/incr2/mysql/func.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/plugin.frm to /tmp/incr/incr2/mysql/plugin.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/plugin.MYI to /tmp/incr/incr2/mysql/plugin.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/plugin.MYD to /tmp/incr/incr2/mysql/plugin.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/servers.frm to /tmp/incr/incr2/mysql/servers.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/servers.MYI to /tmp/incr/incr2/mysql/servers.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/servers.MYD to /tmp/incr/incr2/mysql/servers.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/tables_priv.frm to /tmp/incr/incr2/mysql/tables_priv.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/tables_priv.MYI to /tmp/incr/incr2/mysql/tables_priv.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/tables_priv.MYD to /tmp/incr/incr2/mysql/tables_priv.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/columns_priv.frm to /tmp/incr/incr2/mysql/columns_priv.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/columns_priv.MYI to /tmp/incr/incr2/mysql/columns_priv.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/columns_priv.MYD to /tmp/incr/incr2/mysql/columns_priv.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_topic.frm to /tmp/incr/incr2/mysql/help_topic.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_topic.MYI to /tmp/incr/incr2/mysql/help_topic.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_topic.MYD to /tmp/incr/incr2/mysql/help_topic.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_category.frm to /tmp/incr/incr2/mysql/help_category.frm190826 14:33:35 >> log scanned up to (1649256)190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_category.MYI to /tmp/incr/incr2/mysql/help_category.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_category.MYD to /tmp/incr/incr2/mysql/help_category.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_relation.frm to /tmp/incr/incr2/mysql/help_relation.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_relation.MYI to /tmp/incr/incr2/mysql/help_relation.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_relation.MYD to /tmp/incr/incr2/mysql/help_relation.MYD190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_keyword.frm to /tmp/incr/incr2/mysql/help_keyword.frm190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_keyword.MYI to /tmp/incr/incr2/mysql/help_keyword.MYI190826 14:33:35 [01]        ...done190826 14:33:35 [01] Copying ./mysql/help_keyword.MYD to /tmp/incr/incr2/mysql/help_keyword.MYD190826 14:33:35 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_name.frm to /tmp/incr/incr2/mysql/time_zone_name.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_name.MYI to /tmp/incr/incr2/mysql/time_zone_name.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_name.MYD to /tmp/incr/incr2/mysql/time_zone_name.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone.frm to /tmp/incr/incr2/mysql/time_zone.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone.MYI to /tmp/incr/incr2/mysql/time_zone.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone.MYD to /tmp/incr/incr2/mysql/time_zone.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_transition.frm to /tmp/incr/incr2/mysql/time_zone_transition.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_transition.MYI to /tmp/incr/incr2/mysql/time_zone_transition.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_transition.MYD to /tmp/incr/incr2/mysql/time_zone_transition.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/incr/incr2/mysql/time_zone_transition_type.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_transition_type.MYI to /tmp/incr/incr2/mysql/time_zone_transition_type.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_transition_type.MYD to /tmp/incr/incr2/mysql/time_zone_transition_type.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/incr/incr2/mysql/time_zone_leap_second.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_leap_second.MYI to /tmp/incr/incr2/mysql/time_zone_leap_second.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/time_zone_leap_second.MYD to /tmp/incr/incr2/mysql/time_zone_leap_second.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/proc.frm to /tmp/incr/incr2/mysql/proc.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/proc.MYI to /tmp/incr/incr2/mysql/proc.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/proc.MYD to /tmp/incr/incr2/mysql/proc.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/procs_priv.frm to /tmp/incr/incr2/mysql/procs_priv.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/procs_priv.MYI to /tmp/incr/incr2/mysql/procs_priv.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/procs_priv.MYD to /tmp/incr/incr2/mysql/procs_priv.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/general_log.frm to /tmp/incr/incr2/mysql/general_log.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/general_log.CSM to /tmp/incr/incr2/mysql/general_log.CSM190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/general_log.CSV to /tmp/incr/incr2/mysql/general_log.CSV190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/slow_log.frm to /tmp/incr/incr2/mysql/slow_log.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/slow_log.CSM to /tmp/incr/incr2/mysql/slow_log.CSM190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/slow_log.CSV to /tmp/incr/incr2/mysql/slow_log.CSV190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/event.frm to /tmp/incr/incr2/mysql/event.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/event.MYI to /tmp/incr/incr2/mysql/event.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/event.MYD to /tmp/incr/incr2/mysql/event.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/incr/incr2/mysql/innodb_table_stats.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/incr/incr2/mysql/innodb_index_stats.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/proxies_priv.frm to /tmp/incr/incr2/mysql/proxies_priv.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/proxies_priv.MYI to /tmp/incr/incr2/mysql/proxies_priv.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/proxies_priv.MYD to /tmp/incr/incr2/mysql/proxies_priv.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/table_stats.frm to /tmp/incr/incr2/mysql/table_stats.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/table_stats.MYI to /tmp/incr/incr2/mysql/table_stats.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/table_stats.MYD to /tmp/incr/incr2/mysql/table_stats.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/column_stats.frm to /tmp/incr/incr2/mysql/column_stats.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/column_stats.MYI to /tmp/incr/incr2/mysql/column_stats.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/column_stats.MYD to /tmp/incr/incr2/mysql/column_stats.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/index_stats.frm to /tmp/incr/incr2/mysql/index_stats.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/index_stats.MYI to /tmp/incr/incr2/mysql/index_stats.MYI190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/index_stats.MYD to /tmp/incr/incr2/mysql/index_stats.MYD190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./mysql/gtid_slave_pos.frm to /tmp/incr/incr2/mysql/gtid_slave_pos.frm190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./test/db.opt to /tmp/incr/incr2/test/db.opt190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./performance_schema/db.opt to /tmp/incr/incr2/performance_schema/db.opt190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./full/db.opt to /tmp/incr/incr2/full/db.opt190826 14:33:36 [01]        ...done190826 14:33:36 [01] Copying ./full/incr.frm to /tmp/incr/incr2/full/incr.frm190826 14:33:36 [01]        ...done190826 14:33:36 Finished backing up non-InnoDB tables and files190826 14:33:36 [00] Writing /tmp/incr/incr2/xtrabackup_binlog_info190826 14:33:36 [00]        ...done190826 14:33:36 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...xtrabackup: The latest check point (for incremental): '1649247'xtrabackup: Stopping log copying thread..190826 14:33:36 >> log scanned up to (1649256)190826 14:33:36 Executing UNLOCK TABLES190826 14:33:36 All tables unlocked190826 14:33:36 [00] Copying ib_buffer_pool to /tmp/incr/incr2/ib_buffer_pool190826 14:33:36 [00]        ...done190826 14:33:36 Backup created in directory '/tmp/incr/incr2/'MySQL binlog position: filename 'mysqlbin.000001', position '1239', GTID of the last change '0-1-5'190826 14:33:36 [00] Writing /tmp/incr/incr2/backup-my.cnf190826 14:33:36 [00]        ...done190826 14:33:36 [00] Writing /tmp/incr/incr2/xtrabackup_info190826 14:33:36 [00]        ...donextrabackup: Transaction log of lsn (1649247) to (1649256) was copied.190826 14:33:37 completed OK![root@rec tmp]# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 20Server version: 10.2.26-MariaDB-log MariaDB ServerCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> insert into full.incr(tag) values("第3次增备后");Query OK, 1 row affected (0.30 sec)MariaDB [(none)]> exitBye[root@rec tmp]# innobackupex --user=root  --no-timestamp  --parallel=4  --incremental-basedir=/tmp/incr/incr2/ --incremental /tmp/incr/incr3xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin --parallel=4 xtrabackup: recognized client arguments: 190826 14:34:00 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully.           At the end of a successful backup run innobackupex           prints "completed OK!".190826 14:34:00  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root'  (using password: NO).190826 14:34:00  version_check Connected to MySQL server190826 14:34:00  version_check Executing a version check against the server...190826 14:34:00  version_check Done.190826 14:34:00 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not setUsing server version 10.2.26-MariaDB-loginnobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)incremental backup from 1649247 is enabled.xtrabackup: uses posix_fadvise().xtrabackup: cd to /var/lib/mysqlxtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = ./xtrabackup:   innodb_log_files_in_group = 2xtrabackup:   innodb_log_file_size = 50331648InnoDB: Number of pools: 1190826 14:34:00 >> log scanned up to (1650361)xtrabackup: Generating a list of tablespacesInnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0xtrabackup: using the full scan for incremental backupxtrabackup: Starting 4 threads for parallel data files transfer190826 14:34:01 [04] Copying ./ibdata1 to /tmp/incr/incr3/ibdata1.delta190826 14:34:01 [02] Copying ./mysql/innodb_table_stats.ibd to /tmp/incr/incr3/mysql/innodb_table_stats.ibd.delta190826 14:34:01 [02]        ...done190826 14:34:01 [03] Copying ./mysql/gtid_slave_pos.ibd to /tmp/incr/incr3/mysql/gtid_slave_pos.ibd.delta190826 14:34:01 [03]        ...done190826 14:34:01 [04]        ...done190826 14:34:01 [01] Copying ./mysql/innodb_index_stats.ibd to /tmp/incr/incr3/mysql/innodb_index_stats.ibd.delta190826 14:34:01 [01]        ...done190826 14:34:01 [02] Copying ./full/incr.ibd to /tmp/incr/incr3/full/incr.ibd.delta190826 14:34:01 [02]        ...done190826 14:34:01 >> log scanned up to (1650361)190826 14:34:02 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...190826 14:34:02 Executing FLUSH TABLES WITH READ LOCK...190826 14:34:02 Starting to backup non-InnoDB tables and files190826 14:34:02 [01] Copying ./mysql/db.opt to /tmp/incr/incr3/mysql/db.opt190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/db.frm to /tmp/incr/incr3/mysql/db.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/db.MYI to /tmp/incr/incr3/mysql/db.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/db.MYD to /tmp/incr/incr3/mysql/db.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/host.frm to /tmp/incr/incr3/mysql/host.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/host.MYI to /tmp/incr/incr3/mysql/host.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/host.MYD to /tmp/incr/incr3/mysql/host.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/user.frm to /tmp/incr/incr3/mysql/user.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/user.MYI to /tmp/incr/incr3/mysql/user.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/user.MYD to /tmp/incr/incr3/mysql/user.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/roles_mapping.frm to /tmp/incr/incr3/mysql/roles_mapping.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/roles_mapping.MYI to /tmp/incr/incr3/mysql/roles_mapping.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/roles_mapping.MYD to /tmp/incr/incr3/mysql/roles_mapping.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/func.frm to /tmp/incr/incr3/mysql/func.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/func.MYI to /tmp/incr/incr3/mysql/func.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/func.MYD to /tmp/incr/incr3/mysql/func.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/plugin.frm to /tmp/incr/incr3/mysql/plugin.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/plugin.MYI to /tmp/incr/incr3/mysql/plugin.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/plugin.MYD to /tmp/incr/incr3/mysql/plugin.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/servers.frm to /tmp/incr/incr3/mysql/servers.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/servers.MYI to /tmp/incr/incr3/mysql/servers.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/servers.MYD to /tmp/incr/incr3/mysql/servers.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/tables_priv.frm to /tmp/incr/incr3/mysql/tables_priv.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/tables_priv.MYI to /tmp/incr/incr3/mysql/tables_priv.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/tables_priv.MYD to /tmp/incr/incr3/mysql/tables_priv.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/columns_priv.frm to /tmp/incr/incr3/mysql/columns_priv.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/columns_priv.MYI to /tmp/incr/incr3/mysql/columns_priv.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/columns_priv.MYD to /tmp/incr/incr3/mysql/columns_priv.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_topic.frm to /tmp/incr/incr3/mysql/help_topic.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_topic.MYI to /tmp/incr/incr3/mysql/help_topic.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_topic.MYD to /tmp/incr/incr3/mysql/help_topic.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_category.frm to /tmp/incr/incr3/mysql/help_category.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_category.MYI to /tmp/incr/incr3/mysql/help_category.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_category.MYD to /tmp/incr/incr3/mysql/help_category.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_relation.frm to /tmp/incr/incr3/mysql/help_relation.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_relation.MYI to /tmp/incr/incr3/mysql/help_relation.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_relation.MYD to /tmp/incr/incr3/mysql/help_relation.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_keyword.frm to /tmp/incr/incr3/mysql/help_keyword.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_keyword.MYI to /tmp/incr/incr3/mysql/help_keyword.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/help_keyword.MYD to /tmp/incr/incr3/mysql/help_keyword.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_name.frm to /tmp/incr/incr3/mysql/time_zone_name.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_name.MYI to /tmp/incr/incr3/mysql/time_zone_name.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_name.MYD to /tmp/incr/incr3/mysql/time_zone_name.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone.frm to /tmp/incr/incr3/mysql/time_zone.frm190826 14:34:02 >> log scanned up to (1650361)190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone.MYI to /tmp/incr/incr3/mysql/time_zone.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone.MYD to /tmp/incr/incr3/mysql/time_zone.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_transition.frm to /tmp/incr/incr3/mysql/time_zone_transition.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_transition.MYI to /tmp/incr/incr3/mysql/time_zone_transition.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_transition.MYD to /tmp/incr/incr3/mysql/time_zone_transition.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/incr/incr3/mysql/time_zone_transition_type.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_transition_type.MYI to /tmp/incr/incr3/mysql/time_zone_transition_type.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_transition_type.MYD to /tmp/incr/incr3/mysql/time_zone_transition_type.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/incr/incr3/mysql/time_zone_leap_second.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_leap_second.MYI to /tmp/incr/incr3/mysql/time_zone_leap_second.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/time_zone_leap_second.MYD to /tmp/incr/incr3/mysql/time_zone_leap_second.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/proc.frm to /tmp/incr/incr3/mysql/proc.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/proc.MYI to /tmp/incr/incr3/mysql/proc.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/proc.MYD to /tmp/incr/incr3/mysql/proc.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/procs_priv.frm to /tmp/incr/incr3/mysql/procs_priv.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/procs_priv.MYI to /tmp/incr/incr3/mysql/procs_priv.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/procs_priv.MYD to /tmp/incr/incr3/mysql/procs_priv.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/general_log.frm to /tmp/incr/incr3/mysql/general_log.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/general_log.CSM to /tmp/incr/incr3/mysql/general_log.CSM190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/general_log.CSV to /tmp/incr/incr3/mysql/general_log.CSV190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/slow_log.frm to /tmp/incr/incr3/mysql/slow_log.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/slow_log.CSM to /tmp/incr/incr3/mysql/slow_log.CSM190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/slow_log.CSV to /tmp/incr/incr3/mysql/slow_log.CSV190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/event.frm to /tmp/incr/incr3/mysql/event.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/event.MYI to /tmp/incr/incr3/mysql/event.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/event.MYD to /tmp/incr/incr3/mysql/event.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/incr/incr3/mysql/innodb_table_stats.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/incr/incr3/mysql/innodb_index_stats.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/proxies_priv.frm to /tmp/incr/incr3/mysql/proxies_priv.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/proxies_priv.MYI to /tmp/incr/incr3/mysql/proxies_priv.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/proxies_priv.MYD to /tmp/incr/incr3/mysql/proxies_priv.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/table_stats.frm to /tmp/incr/incr3/mysql/table_stats.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/table_stats.MYI to /tmp/incr/incr3/mysql/table_stats.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/table_stats.MYD to /tmp/incr/incr3/mysql/table_stats.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/column_stats.frm to /tmp/incr/incr3/mysql/column_stats.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/column_stats.MYI to /tmp/incr/incr3/mysql/column_stats.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/column_stats.MYD to /tmp/incr/incr3/mysql/column_stats.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/index_stats.frm to /tmp/incr/incr3/mysql/index_stats.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/index_stats.MYI to /tmp/incr/incr3/mysql/index_stats.MYI190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/index_stats.MYD to /tmp/incr/incr3/mysql/index_stats.MYD190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./mysql/gtid_slave_pos.frm to /tmp/incr/incr3/mysql/gtid_slave_pos.frm190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./test/db.opt to /tmp/incr/incr3/test/db.opt190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./performance_schema/db.opt to /tmp/incr/incr3/performance_schema/db.opt190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./full/db.opt to /tmp/incr/incr3/full/db.opt190826 14:34:02 [01]        ...done190826 14:34:02 [01] Copying ./full/incr.frm to /tmp/incr/incr3/full/incr.frm190826 14:34:02 [01]        ...done190826 14:34:02 Finished backing up non-InnoDB tables and files190826 14:34:02 [00] Writing /tmp/incr/incr3/xtrabackup_binlog_info190826 14:34:02 [00]        ...done190826 14:34:02 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...xtrabackup: The latest check point (for incremental): '1650352'xtrabackup: Stopping log copying thread..190826 14:34:02 >> log scanned up to (1650361)190826 14:34:02 Executing UNLOCK TABLES190826 14:34:02 All tables unlocked190826 14:34:02 [00] Copying ib_buffer_pool to /tmp/incr/incr3/ib_buffer_pool190826 14:34:02 [00]        ...done190826 14:34:02 Backup created in directory '/tmp/incr/incr3/'MySQL binlog position: filename 'mysqlbin.000001', position '1460', GTID of the last change '0-1-6'190826 14:34:02 [00] Writing /tmp/incr/incr3/backup-my.cnf190826 14:34:02 [00]        ...done190826 14:34:02 [00] Writing /tmp/incr/incr3/xtrabackup_info190826 14:34:02 [00]        ...donextrabackup: Transaction log of lsn (1650352) to (1650361) was copied.190826 14:34:03 completed OK![root@rec tmp]# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 23Server version: 10.2.26-MariaDB-log MariaDB ServerCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> insert into full.incr(tag) values("第4次增备后");Query OK, 1 row affected (0.30 sec)MariaDB [(none)]> exitBye[root@rec tmp]# innobackupex --user=root  --no-timestamp  --parallel=4  --incremental-basedir=/tmp/incr/incr3/ --incremental /tmp/incr/incr4xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin --parallel=4 xtrabackup: recognized client arguments: 190826 14:34:47 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully.           At the end of a successful backup run innobackupex           prints "completed OK!".190826 14:34:47  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root'  (using password: NO).190826 14:34:47  version_check Connected to MySQL server190826 14:34:47  version_check Executing a version check against the server...190826 14:34:47  version_check Done.190826 14:34:47 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not setUsing server version 10.2.26-MariaDB-loginnobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)incremental backup from 1650352 is enabled.xtrabackup: uses posix_fadvise().xtrabackup: cd to /var/lib/mysqlxtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = ./xtrabackup:   innodb_log_files_in_group = 2xtrabackup:   innodb_log_file_size = 50331648InnoDB: Number of pools: 1190826 14:34:48 >> log scanned up to (1651467)xtrabackup: Generating a list of tablespacesInnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0xtrabackup: using the full scan for incremental backupxtrabackup: Starting 4 threads for parallel data files transfer190826 14:34:48 [01] Copying ./ibdata1 to /tmp/incr/incr4/ibdata1.delta190826 14:34:48 [02] Copying ./mysql/innodb_table_stats.ibd to /tmp/incr/incr4/mysql/innodb_table_stats.ibd.delta190826 14:34:48 [02]        ...done190826 14:34:48 [03] Copying ./mysql/innodb_index_stats.ibd to /tmp/incr/incr4/mysql/innodb_index_stats.ibd.delta190826 14:34:48 [03]        ...done190826 14:34:48 [04] Copying ./mysql/gtid_slave_pos.ibd to /tmp/incr/incr4/mysql/gtid_slave_pos.ibd.delta190826 14:34:48 [04]        ...done190826 14:34:48 [01]        ...done190826 14:34:48 [02] Copying ./full/incr.ibd to /tmp/incr/incr4/full/incr.ibd.delta190826 14:34:48 [02]        ...done190826 14:34:49 >> log scanned up to (1651467)190826 14:34:49 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...190826 14:34:49 Executing FLUSH TABLES WITH READ LOCK...190826 14:34:49 Starting to backup non-InnoDB tables and files190826 14:34:49 [01] Copying ./mysql/db.opt to /tmp/incr/incr4/mysql/db.opt190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/db.frm to /tmp/incr/incr4/mysql/db.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/db.MYI to /tmp/incr/incr4/mysql/db.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/db.MYD to /tmp/incr/incr4/mysql/db.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/host.frm to /tmp/incr/incr4/mysql/host.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/host.MYI to /tmp/incr/incr4/mysql/host.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/host.MYD to /tmp/incr/incr4/mysql/host.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/user.frm to /tmp/incr/incr4/mysql/user.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/user.MYI to /tmp/incr/incr4/mysql/user.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/user.MYD to /tmp/incr/incr4/mysql/user.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/roles_mapping.frm to /tmp/incr/incr4/mysql/roles_mapping.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/roles_mapping.MYI to /tmp/incr/incr4/mysql/roles_mapping.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/roles_mapping.MYD to /tmp/incr/incr4/mysql/roles_mapping.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/func.frm to /tmp/incr/incr4/mysql/func.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/func.MYI to /tmp/incr/incr4/mysql/func.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/func.MYD to /tmp/incr/incr4/mysql/func.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/plugin.frm to /tmp/incr/incr4/mysql/plugin.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/plugin.MYI to /tmp/incr/incr4/mysql/plugin.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/plugin.MYD to /tmp/incr/incr4/mysql/plugin.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/servers.frm to /tmp/incr/incr4/mysql/servers.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/servers.MYI to /tmp/incr/incr4/mysql/servers.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/servers.MYD to /tmp/incr/incr4/mysql/servers.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/tables_priv.frm to /tmp/incr/incr4/mysql/tables_priv.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/tables_priv.MYI to /tmp/incr/incr4/mysql/tables_priv.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/tables_priv.MYD to /tmp/incr/incr4/mysql/tables_priv.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/columns_priv.frm to /tmp/incr/incr4/mysql/columns_priv.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/columns_priv.MYI to /tmp/incr/incr4/mysql/columns_priv.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/columns_priv.MYD to /tmp/incr/incr4/mysql/columns_priv.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_topic.frm to /tmp/incr/incr4/mysql/help_topic.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_topic.MYI to /tmp/incr/incr4/mysql/help_topic.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_topic.MYD to /tmp/incr/incr4/mysql/help_topic.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_category.frm to /tmp/incr/incr4/mysql/help_category.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_category.MYI to /tmp/incr/incr4/mysql/help_category.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_category.MYD to /tmp/incr/incr4/mysql/help_category.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_relation.frm to /tmp/incr/incr4/mysql/help_relation.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_relation.MYI to /tmp/incr/incr4/mysql/help_relation.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_relation.MYD to /tmp/incr/incr4/mysql/help_relation.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_keyword.frm to /tmp/incr/incr4/mysql/help_keyword.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_keyword.MYI to /tmp/incr/incr4/mysql/help_keyword.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/help_keyword.MYD to /tmp/incr/incr4/mysql/help_keyword.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone_name.frm to /tmp/incr/incr4/mysql/time_zone_name.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone_name.MYI to /tmp/incr/incr4/mysql/time_zone_name.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone_name.MYD to /tmp/incr/incr4/mysql/time_zone_name.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone.frm to /tmp/incr/incr4/mysql/time_zone.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone.MYI to /tmp/incr/incr4/mysql/time_zone.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone.MYD to /tmp/incr/incr4/mysql/time_zone.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone_transition.frm to /tmp/incr/incr4/mysql/time_zone_transition.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone_transition.MYI to /tmp/incr/incr4/mysql/time_zone_transition.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone_transition.MYD to /tmp/incr/incr4/mysql/time_zone_transition.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/incr/incr4/mysql/time_zone_transition_type.frm190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone_transition_type.MYI to /tmp/incr/incr4/mysql/time_zone_transition_type.MYI190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone_transition_type.MYD to /tmp/incr/incr4/mysql/time_zone_transition_type.MYD190826 14:34:49 [01]        ...done190826 14:34:49 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/incr/incr4/mysql/time_zone_leap_second.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/time_zone_leap_second.MYI to /tmp/incr/incr4/mysql/time_zone_leap_second.MYI190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/time_zone_leap_second.MYD to /tmp/incr/incr4/mysql/time_zone_leap_second.MYD190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/proc.frm to /tmp/incr/incr4/mysql/proc.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/proc.MYI to /tmp/incr/incr4/mysql/proc.MYI190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/proc.MYD to /tmp/incr/incr4/mysql/proc.MYD190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/procs_priv.frm to /tmp/incr/incr4/mysql/procs_priv.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/procs_priv.MYI to /tmp/incr/incr4/mysql/procs_priv.MYI190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/procs_priv.MYD to /tmp/incr/incr4/mysql/procs_priv.MYD190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/general_log.frm to /tmp/incr/incr4/mysql/general_log.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/general_log.CSM to /tmp/incr/incr4/mysql/general_log.CSM190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/general_log.CSV to /tmp/incr/incr4/mysql/general_log.CSV190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/slow_log.frm to /tmp/incr/incr4/mysql/slow_log.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/slow_log.CSM to /tmp/incr/incr4/mysql/slow_log.CSM190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/slow_log.CSV to /tmp/incr/incr4/mysql/slow_log.CSV190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/event.frm to /tmp/incr/incr4/mysql/event.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/event.MYI to /tmp/incr/incr4/mysql/event.MYI190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/event.MYD to /tmp/incr/incr4/mysql/event.MYD190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/incr/incr4/mysql/innodb_table_stats.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/incr/incr4/mysql/innodb_index_stats.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/proxies_priv.frm to /tmp/incr/incr4/mysql/proxies_priv.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/proxies_priv.MYI to /tmp/incr/incr4/mysql/proxies_priv.MYI190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/proxies_priv.MYD to /tmp/incr/incr4/mysql/proxies_priv.MYD190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/table_stats.frm to /tmp/incr/incr4/mysql/table_stats.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/table_stats.MYI to /tmp/incr/incr4/mysql/table_stats.MYI190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/table_stats.MYD to /tmp/incr/incr4/mysql/table_stats.MYD190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/column_stats.frm to /tmp/incr/incr4/mysql/column_stats.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/column_stats.MYI to /tmp/incr/incr4/mysql/column_stats.MYI190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/column_stats.MYD to /tmp/incr/incr4/mysql/column_stats.MYD190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/index_stats.frm to /tmp/incr/incr4/mysql/index_stats.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/index_stats.MYI to /tmp/incr/incr4/mysql/index_stats.MYI190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/index_stats.MYD to /tmp/incr/incr4/mysql/index_stats.MYD190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./mysql/gtid_slave_pos.frm to /tmp/incr/incr4/mysql/gtid_slave_pos.frm190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./test/db.opt to /tmp/incr/incr4/test/db.opt190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./performance_schema/db.opt to /tmp/incr/incr4/performance_schema/db.opt190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./full/db.opt to /tmp/incr/incr4/full/db.opt190826 14:34:50 [01]        ...done190826 14:34:50 [01] Copying ./full/incr.frm to /tmp/incr/incr4/full/incr.frm190826 14:34:50 [01]        ...done190826 14:34:50 Finished backing up non-InnoDB tables and files190826 14:34:50 [00] Writing /tmp/incr/incr4/xtrabackup_binlog_info190826 14:34:50 [00]        ...done190826 14:34:50 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...xtrabackup: The latest check point (for incremental): '1651458'xtrabackup: Stopping log copying thread..190826 14:34:50 >> log scanned up to (1651467)190826 14:34:50 Executing UNLOCK TABLES190826 14:34:50 All tables unlocked190826 14:34:50 [00] Copying ib_buffer_pool to /tmp/incr/incr4/ib_buffer_pool190826 14:34:50 [00]        ...done190826 14:34:50 Backup created in directory '/tmp/incr/incr4/'MySQL binlog position: filename 'mysqlbin.000001', position '1681', GTID of the last change '0-1-7'190826 14:34:50 [00] Writing /tmp/incr/incr4/backup-my.cnf190826 14:34:50 [00]        ...done190826 14:34:50 [00] Writing /tmp/incr/incr4/xtrabackup_info190826 14:34:50 [00]        ...donextrabackup: Transaction log of lsn (1651458) to (1651467) was copied.190826 14:34:50 completed OK![root@rec tmp]# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 26Server version: 10.2.26-MariaDB-log MariaDB ServerCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> insert into full.incr(tag) values("第5次增备后");Query OK, 1 row affected (0.30 sec)MariaDB [(none)]> exitBye[root@rec tmp]# innobackupex --apply-log  --redo-only /tmp/fullbak/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=0 --redo-log-version=1 xtrabackup: recognized client arguments: 190826 14:35:30 innobackupex: Starting the apply-log operationIMPORTANT: Please check that the apply-log run completes successfully.           At the end of a successful apply-log run innobackupex           prints "completed OK!".innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)xtrabackup: cd to /tmp/fullbak/xtrabackup: This target seems to be not prepared yet.InnoDB: Number of pools: 1xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1648463)xtrabackup: using the following InnoDB configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = .xtrabackup:   innodb_log_files_in_group = 1xtrabackup:   innodb_log_file_size = 8388608xtrabackup: using the following InnoDB configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = .xtrabackup:   innodb_log_files_in_group = 1xtrabackup:   innodb_log_file_size = 8388608xtrabackup: Starting InnoDB instance for recovery.xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)InnoDB: PUNCH HOLE support availableInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Uses event mutexesInnoDB: GCC builtin __atomic_thread_fence() is used for memory barrierInnoDB: Compressed tables use zlib 1.2.7InnoDB: Number of pools: 1InnoDB: Using CPU crc32 instructionsInnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100MInnoDB: Completed initialization of buffer poolInnoDB: page_cleaner coordinator priority: -20InnoDB: Highest supported file format is Barracuda.InnoDB: Log scan progressed past the checkpoint lsn 1648463InnoDB: Doing recovery: scanned up to log sequence number 1648472 (0%)InnoDB: Database was not shutdown normally!InnoDB: Starting crash recovery.InnoDB: xtrabackup: Last MySQL binlog file position 1322, file name ./mysqlbin.000002InnoDB: xtrabackup: Last MySQL binlog file position 1322, file name ./mysqlbin.000002xtrabackup: starting shutdown with innodb_fast_shutdown = 1InnoDB: Starting shutdown...InnoDB: Shutdown completed; log sequence number 1648481InnoDB: Number of pools: 1190826 14:35:31 completed OK![root@rec tmp]# innobackupex --apply-log  --redo-only /tmp/fullbak/  --incremental-dir=/tmp/incr/incr1 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=0 --redo-log-version=1 xtrabackup: recognized client arguments: 190826 14:36:06 innobackupex: Starting the apply-log operationIMPORTANT: Please check that the apply-log run completes successfully.           At the end of a successful apply-log run innobackupex           prints "completed OK!".innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)incremental backup from 1648463 is enabled.xtrabackup: cd to /tmp/fullbak/xtrabackup: This target seems to be already prepared with --apply-log-only.InnoDB: Number of pools: 1xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1648874)xtrabackup: using the following InnoDB configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = /tmp/incr/incr1/xtrabackup:   innodb_log_files_in_group = 1xtrabackup:   innodb_log_file_size = 8388608xtrabackup: Generating a list of tablespacesInnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0xtrabackup: page size for /tmp/incr/incr1//ibdata1.delta is 16384 bytes space id is 0Applying /tmp/incr/incr1//ibdata1.delta to ./ibdata1...xtrabackup: page size for /tmp/incr/incr1//mysql/innodb_index_stats.ibd.delta is 16384 bytes space id is 2Applying /tmp/incr/incr1//mysql/innodb_index_stats.ibd.delta to ./mysql/innodb_index_stats.ibd...xtrabackup: page size for /tmp/incr/incr1//mysql/gtid_slave_pos.ibd.delta is 16384 bytes space id is 3Applying /tmp/incr/incr1//mysql/gtid_slave_pos.ibd.delta to ./mysql/gtid_slave_pos.ibd...xtrabackup: page size for /tmp/incr/incr1//mysql/innodb_table_stats.ibd.delta is 16384 bytes space id is 1Applying /tmp/incr/incr1//mysql/innodb_table_stats.ibd.delta to ./mysql/innodb_table_stats.ibd...xtrabackup: page size for /tmp/incr/incr1//full/incr.ibd.delta is 16384 bytes space id is 6Applying /tmp/incr/incr1//full/incr.ibd.delta to ./full/incr.ibd...xtrabackup: using the following InnoDB configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = /tmp/incr/incr1/xtrabackup:   innodb_log_files_in_group = 1xtrabackup:   innodb_log_file_size = 8388608xtrabackup: Starting InnoDB instance for recovery.xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)InnoDB: PUNCH HOLE support availableInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Uses event mutexesInnoDB: GCC builtin __atomic_thread_fence() is used for memory barrierInnoDB: Compressed tables use zlib 1.2.7InnoDB: Number of pools: 1InnoDB: Using CPU crc32 instructionsInnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100MInnoDB: Completed initialization of buffer poolInnoDB: page_cleaner coordinator priority: -20InnoDB: Highest supported file format is Barracuda.InnoDB: Log scan progressed past the checkpoint lsn 1648874InnoDB: Doing recovery: scanned up to log sequence number 1648883 (0%)InnoDB: Database was not shutdown normally!InnoDB: Starting crash recovery.InnoDB: xtrabackup: Last MySQL binlog file position 1018, file name ./mysqlbin.000001InnoDB: xtrabackup: Last MySQL binlog file position 1018, file name ./mysqlbin.000001xtrabackup: starting shutdown with innodb_fast_shutdown = 1InnoDB: Starting shutdown...InnoDB: Shutdown completed; log sequence number 1648892InnoDB: Number of pools: 1190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/db.opt to ./mysql/db.opt190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/db.frm to ./mysql/db.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/db.MYI to ./mysql/db.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/db.MYD to ./mysql/db.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/host.frm to ./mysql/host.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/host.MYI to ./mysql/host.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/host.MYD to ./mysql/host.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/user.frm to ./mysql/user.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/user.MYI to ./mysql/user.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/user.MYD to ./mysql/user.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/roles_mapping.frm to ./mysql/roles_mapping.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/roles_mapping.MYI to ./mysql/roles_mapping.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/roles_mapping.MYD to ./mysql/roles_mapping.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/func.frm to ./mysql/func.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/func.MYI to ./mysql/func.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/func.MYD to ./mysql/func.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/plugin.frm to ./mysql/plugin.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/plugin.MYI to ./mysql/plugin.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/plugin.MYD to ./mysql/plugin.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/servers.frm to ./mysql/servers.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/servers.MYI to ./mysql/servers.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/servers.MYD to ./mysql/servers.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/tables_priv.frm to ./mysql/tables_priv.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/tables_priv.MYI to ./mysql/tables_priv.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/tables_priv.MYD to ./mysql/tables_priv.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/columns_priv.frm to ./mysql/columns_priv.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/columns_priv.MYI to ./mysql/columns_priv.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/columns_priv.MYD to ./mysql/columns_priv.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_topic.frm to ./mysql/help_topic.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_topic.MYI to ./mysql/help_topic.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_topic.MYD to ./mysql/help_topic.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_category.frm to ./mysql/help_category.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_category.MYI to ./mysql/help_category.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_category.MYD to ./mysql/help_category.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_relation.frm to ./mysql/help_relation.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_relation.MYI to ./mysql/help_relation.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_relation.MYD to ./mysql/help_relation.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_keyword.frm to ./mysql/help_keyword.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_keyword.MYI to ./mysql/help_keyword.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_keyword.MYD to ./mysql/help_keyword.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_name.frm to ./mysql/time_zone_name.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_name.MYI to ./mysql/time_zone_name.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_name.MYD to ./mysql/time_zone_name.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone.frm to ./mysql/time_zone.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone.MYI to ./mysql/time_zone.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone.MYD to ./mysql/time_zone.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition.frm to ./mysql/time_zone_transition.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition.MYI to ./mysql/time_zone_transition.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition.MYD to ./mysql/time_zone_transition.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition_type.frm to ./mysql/time_zone_transition_type.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition_type.MYI to ./mysql/time_zone_transition_type.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition_type.MYD to ./mysql/time_zone_transition_type.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_leap_second.frm to ./mysql/time_zone_leap_second.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_leap_second.MYI to ./mysql/time_zone_leap_second.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_leap_second.MYD to ./mysql/time_zone_leap_second.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proc.frm to ./mysql/proc.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proc.MYI to ./mysql/proc.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proc.MYD to ./mysql/proc.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/procs_priv.frm to ./mysql/procs_priv.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/procs_priv.MYI to ./mysql/procs_priv.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/procs_priv.MYD to ./mysql/procs_priv.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/general_log.frm to ./mysql/general_log.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/general_log.CSM to ./mysql/general_log.CSM190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/general_log.CSV to ./mysql/general_log.CSV190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/slow_log.frm to ./mysql/slow_log.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/slow_log.CSM to ./mysql/slow_log.CSM190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/slow_log.CSV to ./mysql/slow_log.CSV190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/event.frm to ./mysql/event.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/event.MYI to ./mysql/event.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/event.MYD to ./mysql/event.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/innodb_table_stats.frm to ./mysql/innodb_table_stats.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/innodb_index_stats.frm to ./mysql/innodb_index_stats.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proxies_priv.frm to ./mysql/proxies_priv.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proxies_priv.MYI to ./mysql/proxies_priv.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proxies_priv.MYD to ./mysql/proxies_priv.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/table_stats.frm to ./mysql/table_stats.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/table_stats.MYI to ./mysql/table_stats.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/table_stats.MYD to ./mysql/table_stats.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/column_stats.frm to ./mysql/column_stats.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/column_stats.MYI to ./mysql/column_stats.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/column_stats.MYD to ./mysql/column_stats.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/index_stats.frm to ./mysql/index_stats.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/index_stats.MYI to ./mysql/index_stats.MYI190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/index_stats.MYD to ./mysql/index_stats.MYD190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/gtid_slave_pos.frm to ./mysql/gtid_slave_pos.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/full/db.opt to ./full/db.opt190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/full/incr.frm to ./full/incr.frm190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/test/db.opt to ./test/db.opt190826 14:36:09 [01]        ...done190826 14:36:09 [01] Copying /tmp/incr/incr1/performance_schema/db.opt to ./performance_schema/db.opt190826 14:36:09 [01]        ...done190826 14:36:09 [00] Copying /tmp/incr/incr1//xtrabackup_binlog_info to ./xtrabackup_binlog_info190826 14:36:09 [00]        ...done190826 14:36:09 [00] Copying /tmp/incr/incr1//xtrabackup_info to ./xtrabackup_info190826 14:36:09 [00]        ...done190826 14:36:09 completed OK![root@rec tmp]# innobackupex --apply-log  --redo-only /tmp/fullbak/  --incremental-dir=/tmp/incr/incr2xtrabackup: 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=0 --redo-log-version=1 xtrabackup: recognized client arguments: 190826 14:36:12 innobackupex: Starting the apply-log operationIMPORTANT: Please check that the apply-log run completes successfully.           At the end of a successful apply-log run innobackupex           prints "completed OK!".innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)incremental backup from 1648874 is enabled.xtrabackup: cd to /tmp/fullbak/xtrabackup: This target seems to be already prepared with --apply-log-only.InnoDB: Number of pools: 1xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1649247)xtrabackup: using the following InnoDB configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = /tmp/incr/incr2/xtrabackup:   innodb_log_files_in_group = 1xtrabackup:   innodb_log_file_size = 8388608xtrabackup: Generating a list of tablespacesInnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0xtrabackup: page size for /tmp/incr/incr2//ibdata1.delta is 16384 bytes space id is 0Applying /tmp/incr/incr2//ibdata1.delta to ./ibdata1...xtrabackup: page size for /tmp/incr/incr2//mysql/gtid_slave_pos.ibd.delta is 16384 bytes space id is 3Applying /tmp/incr/incr2//mysql/gtid_slave_pos.ibd.delta to ./mysql/gtid_slave_pos.ibd...xtrabackup: page size for /tmp/incr/incr2//mysql/innodb_index_stats.ibd.delta is 16384 bytes space id is 2Applying /tmp/incr/incr2//mysql/innodb_index_stats.ibd.delta to ./mysql/innodb_index_stats.ibd...xtrabackup: page size for /tmp/incr/incr2//mysql/innodb_table_stats.ibd.delta is 16384 bytes space id is 1Applying /tmp/incr/incr2//mysql/innodb_table_stats.ibd.delta to ./mysql/innodb_table_stats.ibd...xtrabackup: page size for /tmp/incr/incr2//full/incr.ibd.delta is 16384 bytes space id is 6Applying /tmp/incr/incr2//full/incr.ibd.delta to ./full/incr.ibd...xtrabackup: using the following InnoDB configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = /tmp/incr/incr2/xtrabackup:   innodb_log_files_in_group = 1xtrabackup:   innodb_log_file_size = 8388608xtrabackup: Starting InnoDB instance for recovery.xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)InnoDB: PUNCH HOLE support availableInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Uses event mutexesInnoDB: GCC builtin __atomic_thread_fence() is used for memory barrierInnoDB: Compressed tables use zlib 1.2.7InnoDB: Number of pools: 1InnoDB: Using CPU crc32 instructionsInnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100MInnoDB: Completed initialization of buffer poolInnoDB: page_cleaner coordinator priority: -20InnoDB: Highest supported file format is Barracuda.InnoDB: Log scan progressed past the checkpoint lsn 1649247InnoDB: Doing recovery: scanned up to log sequence number 1649256 (0%)InnoDB: Database was not shutdown normally!InnoDB: Starting crash recovery.InnoDB: xtrabackup: Last MySQL binlog file position 1239, file name ./mysqlbin.000001InnoDB: xtrabackup: Last MySQL binlog file position 1239, file name ./mysqlbin.000001xtrabackup: starting shutdown with innodb_fast_shutdown = 1InnoDB: Starting shutdown...InnoDB: Shutdown completed; log sequence number 1649265InnoDB: Number of pools: 1190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/db.opt to ./mysql/db.opt190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/db.frm to ./mysql/db.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/db.MYI to ./mysql/db.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/db.MYD to ./mysql/db.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/host.frm to ./mysql/host.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/host.MYI to ./mysql/host.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/host.MYD to ./mysql/host.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/user.frm to ./mysql/user.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/user.MYI to ./mysql/user.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/user.MYD to ./mysql/user.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/roles_mapping.frm to ./mysql/roles_mapping.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/roles_mapping.MYI to ./mysql/roles_mapping.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/roles_mapping.MYD to ./mysql/roles_mapping.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/func.frm to ./mysql/func.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/func.MYI to ./mysql/func.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/func.MYD to ./mysql/func.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/plugin.frm to ./mysql/plugin.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/plugin.MYI to ./mysql/plugin.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/plugin.MYD to ./mysql/plugin.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/servers.frm to ./mysql/servers.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/servers.MYI to ./mysql/servers.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/servers.MYD to ./mysql/servers.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/tables_priv.frm to ./mysql/tables_priv.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/tables_priv.MYI to ./mysql/tables_priv.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/tables_priv.MYD to ./mysql/tables_priv.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/columns_priv.frm to ./mysql/columns_priv.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/columns_priv.MYI to ./mysql/columns_priv.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/columns_priv.MYD to ./mysql/columns_priv.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_topic.frm to ./mysql/help_topic.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_topic.MYI to ./mysql/help_topic.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_topic.MYD to ./mysql/help_topic.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_category.frm to ./mysql/help_category.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_category.MYI to ./mysql/help_category.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_category.MYD to ./mysql/help_category.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_relation.frm to ./mysql/help_relation.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_relation.MYI to ./mysql/help_relation.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_relation.MYD to ./mysql/help_relation.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_keyword.frm to ./mysql/help_keyword.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_keyword.MYI to ./mysql/help_keyword.MYI190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_keyword.MYD to ./mysql/help_keyword.MYD190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/time_zone_name.frm to ./mysql/time_zone_name.frm190826 14:36:14 [01]        ...done190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/time_zone_name.MYI to ./mysql/time_zone_name.MYI190826 14:36:14 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_name.MYD to ./mysql/time_zone_name.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone.frm to ./mysql/time_zone.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone.MYI to ./mysql/time_zone.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone.MYD to ./mysql/time_zone.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition.frm to ./mysql/time_zone_transition.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition.MYI to ./mysql/time_zone_transition.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition.MYD to ./mysql/time_zone_transition.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition_type.frm to ./mysql/time_zone_transition_type.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition_type.MYI to ./mysql/time_zone_transition_type.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition_type.MYD to ./mysql/time_zone_transition_type.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_leap_second.frm to ./mysql/time_zone_leap_second.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_leap_second.MYI to ./mysql/time_zone_leap_second.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_leap_second.MYD to ./mysql/time_zone_leap_second.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proc.frm to ./mysql/proc.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proc.MYI to ./mysql/proc.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proc.MYD to ./mysql/proc.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/procs_priv.frm to ./mysql/procs_priv.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/procs_priv.MYI to ./mysql/procs_priv.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/procs_priv.MYD to ./mysql/procs_priv.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/general_log.frm to ./mysql/general_log.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/general_log.CSM to ./mysql/general_log.CSM190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/general_log.CSV to ./mysql/general_log.CSV190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/slow_log.frm to ./mysql/slow_log.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/slow_log.CSM to ./mysql/slow_log.CSM190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/slow_log.CSV to ./mysql/slow_log.CSV190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/event.frm to ./mysql/event.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/event.MYI to ./mysql/event.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/event.MYD to ./mysql/event.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/innodb_table_stats.frm to ./mysql/innodb_table_stats.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/innodb_index_stats.frm to ./mysql/innodb_index_stats.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proxies_priv.frm to ./mysql/proxies_priv.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proxies_priv.MYI to ./mysql/proxies_priv.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proxies_priv.MYD to ./mysql/proxies_priv.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/table_stats.frm to ./mysql/table_stats.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/table_stats.MYI to ./mysql/table_stats.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/table_stats.MYD to ./mysql/table_stats.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/column_stats.frm to ./mysql/column_stats.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/column_stats.MYI to ./mysql/column_stats.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/column_stats.MYD to ./mysql/column_stats.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/index_stats.frm to ./mysql/index_stats.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/index_stats.MYI to ./mysql/index_stats.MYI190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/index_stats.MYD to ./mysql/index_stats.MYD190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/gtid_slave_pos.frm to ./mysql/gtid_slave_pos.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/full/db.opt to ./full/db.opt190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/full/incr.frm to ./full/incr.frm190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/test/db.opt to ./test/db.opt190826 14:36:15 [01]        ...done190826 14:36:15 [01] Copying /tmp/incr/incr2/performance_schema/db.opt to ./performance_schema/db.opt190826 14:36:15 [01]        ...done190826 14:36:15 [00] Copying /tmp/incr/incr2//xtrabackup_binlog_info to ./xtrabackup_binlog_info190826 14:36:15 [00]        ...done190826 14:36:15 [00] Copying /tmp/incr/incr2//xtrabackup_info to ./xtrabackup_info190826 14:36:15 [00]        ...done190826 14:36:15 completed OK![root@rec tmp]# innobackupex --apply-log  --redo-only /tmp/fullbak/  --incremental-dir=/tmp/incr/incr3xtrabackup: 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=0 --redo-log-version=1 xtrabackup: recognized client arguments: 190826 14:36:19 innobackupex: Starting the apply-log operationIMPORTANT: Please check that the apply-log run completes successfully.           At the end of a successful apply-log run innobackupex           prints "completed OK!".innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)incremental backup from 1649247 is enabled.xtrabackup: cd to /tmp/fullbak/xtrabackup: This target seems to be already prepared with --apply-log-only.InnoDB: Number of pools: 1xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1650352)xtrabackup: using the following InnoDB configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = /tmp/incr/incr3/xtrabackup:   innodb_log_files_in_group = 1xtrabackup:   innodb_log_file_size = 8388608xtrabackup: Generating a list of tablespacesInnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0xtrabackup: page size for /tmp/incr/incr3//ibdata1.delta is 16384 bytes space id is 0Applying /tmp/incr/incr3//ibdata1.delta to ./ibdata1...xtrabackup: page size for /tmp/incr/incr3//mysql/innodb_table_stats.ibd.delta is 16384 bytes space id is 1Applying /tmp/incr/incr3//mysql/innodb_table_stats.ibd.delta to ./mysql/innodb_table_stats.ibd...xtrabackup: page size for /tmp/incr/incr3//mysql/gtid_slave_pos.ibd.delta is 16384 bytes space id is 3Applying /tmp/incr/incr3//mysql/gtid_slave_pos.ibd.delta to ./mysql/gtid_slave_pos.ibd...xtrabackup: page size for /tmp/incr/incr3//mysql/innodb_index_stats.ibd.delta is 16384 bytes space id is 2Applying /tmp/incr/incr3//mysql/innodb_index_stats.ibd.delta to ./mysql/innodb_index_stats.ibd...xtrabackup: page size for /tmp/incr/incr3//full/incr.ibd.delta is 16384 bytes space id is 6Applying /tmp/incr/incr3//full/incr.ibd.delta to ./full/incr.ibd...xtrabackup: using the following InnoDB configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = /tmp/incr/incr3/xtrabackup:   innodb_log_files_in_group = 1xtrabackup:   innodb_log_file_size = 8388608xtrabackup: Starting InnoDB instance for recovery.xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)InnoDB: PUNCH HOLE support availableInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Uses event mutexesInnoDB: GCC builtin __atomic_thread_fence() is used for memory barrierInnoDB: Compressed tables use zlib 1.2.7InnoDB: Number of pools: 1InnoDB: Using CPU crc32 instructionsInnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100MInnoDB: Completed initialization of buffer poolInnoDB: page_cleaner coordinator priority: -20InnoDB: Highest supported file format is Barracuda.InnoDB: Log scan progressed past the checkpoint lsn 1650352InnoDB: Doing recovery: scanned up to log sequence number 1650361 (0%)InnoDB: Database was not shutdown normally!InnoDB: Starting crash recovery.InnoDB: xtrabackup: Last MySQL binlog file position 1460, file name ./mysqlbin.000001InnoDB: xtrabackup: Last MySQL binlog file position 1460, file name ./mysqlbin.000001xtrabackup: starting shutdown with innodb_fast_shutdown = 1InnoDB: Starting shutdown...InnoDB: Shutdown completed; log sequence number 1650370InnoDB: Number of pools: 1190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/db.opt to ./mysql/db.opt190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/db.frm to ./mysql/db.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/db.MYI to ./mysql/db.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/db.MYD to ./mysql/db.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/host.frm to ./mysql/host.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/host.MYI to ./mysql/host.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/host.MYD to ./mysql/host.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/user.frm to ./mysql/user.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/user.MYI to ./mysql/user.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/user.MYD to ./mysql/user.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/roles_mapping.frm to ./mysql/roles_mapping.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/roles_mapping.MYI to ./mysql/roles_mapping.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/roles_mapping.MYD to ./mysql/roles_mapping.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/func.frm to ./mysql/func.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/func.MYI to ./mysql/func.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/func.MYD to ./mysql/func.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/plugin.frm to ./mysql/plugin.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/plugin.MYI to ./mysql/plugin.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/plugin.MYD to ./mysql/plugin.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/servers.frm to ./mysql/servers.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/servers.MYI to ./mysql/servers.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/servers.MYD to ./mysql/servers.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/tables_priv.frm to ./mysql/tables_priv.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/tables_priv.MYI to ./mysql/tables_priv.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/tables_priv.MYD to ./mysql/tables_priv.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/columns_priv.frm to ./mysql/columns_priv.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/columns_priv.MYI to ./mysql/columns_priv.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/columns_priv.MYD to ./mysql/columns_priv.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_topic.frm to ./mysql/help_topic.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_topic.MYI to ./mysql/help_topic.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_topic.MYD to ./mysql/help_topic.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_category.frm to ./mysql/help_category.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_category.MYI to ./mysql/help_category.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_category.MYD to ./mysql/help_category.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_relation.frm to ./mysql/help_relation.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_relation.MYI to ./mysql/help_relation.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_relation.MYD to ./mysql/help_relation.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_keyword.frm to ./mysql/help_keyword.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_keyword.MYI to ./mysql/help_keyword.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_keyword.MYD to ./mysql/help_keyword.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_name.frm to ./mysql/time_zone_name.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_name.MYI to ./mysql/time_zone_name.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_name.MYD to ./mysql/time_zone_name.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone.frm to ./mysql/time_zone.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone.MYI to ./mysql/time_zone.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone.MYD to ./mysql/time_zone.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition.frm to ./mysql/time_zone_transition.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition.MYI to ./mysql/time_zone_transition.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition.MYD to ./mysql/time_zone_transition.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition_type.frm to ./mysql/time_zone_transition_type.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition_type.MYI to ./mysql/time_zone_transition_type.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition_type.MYD to ./mysql/time_zone_transition_type.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_leap_second.frm to ./mysql/time_zone_leap_second.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_leap_second.MYI to ./mysql/time_zone_leap_second.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_leap_second.MYD to ./mysql/time_zone_leap_second.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proc.frm to ./mysql/proc.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proc.MYI to ./mysql/proc.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proc.MYD to ./mysql/proc.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/procs_priv.frm to ./mysql/procs_priv.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/procs_priv.MYI to ./mysql/procs_priv.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/procs_priv.MYD to ./mysql/procs_priv.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/general_log.frm to ./mysql/general_log.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/general_log.CSM to ./mysql/general_log.CSM190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/general_log.CSV to ./mysql/general_log.CSV190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/slow_log.frm to ./mysql/slow_log.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/slow_log.CSM to ./mysql/slow_log.CSM190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/slow_log.CSV to ./mysql/slow_log.CSV190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/event.frm to ./mysql/event.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/event.MYI to ./mysql/event.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/event.MYD to ./mysql/event.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/innodb_table_stats.frm to ./mysql/innodb_table_stats.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/innodb_index_stats.frm to ./mysql/innodb_index_stats.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proxies_priv.frm to ./mysql/proxies_priv.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proxies_priv.MYI to ./mysql/proxies_priv.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proxies_priv.MYD to ./mysql/proxies_priv.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/table_stats.frm to ./mysql/table_stats.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/table_stats.MYI to ./mysql/table_stats.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/table_stats.MYD to ./mysql/table_stats.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/column_stats.frm to ./mysql/column_stats.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/column_stats.MYI to ./mysql/column_stats.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/column_stats.MYD to ./mysql/column_stats.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/index_stats.frm to ./mysql/index_stats.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/index_stats.MYI to ./mysql/index_stats.MYI190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/index_stats.MYD to ./mysql/index_stats.MYD190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/gtid_slave_pos.frm to ./mysql/gtid_slave_pos.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/full/db.opt to ./full/db.opt190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/full/incr.frm to ./full/incr.frm190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/test/db.opt to ./test/db.opt190826 14:36:21 [01]        ...done190826 14:36:21 [01] Copying /tmp/incr/incr3/performance_schema/db.opt to ./performance_schema/db.opt190826 14:36:21 [01]        ...done190826 14:36:21 [00] Copying /tmp/incr/incr3//xtrabackup_binlog_info to ./xtrabackup_binlog_info190826 14:36:21 [00]        ...done190826 14:36:21 [00] Copying /tmp/incr/incr3//xtrabackup_info to ./xtrabackup_info190826 14:36:21 [00]        ...done190826 14:36:21 completed OK![root@rec tmp]# /etc/init.d/mysql stopStopping mysql (via systemctl):                            [  确定  ][root@rec tmp]# cd /var/lib/[root@rec lib]# ll总用量 24drwxr-xr-x.  4 root           root             32 8月  23 15:43 AccountsServicedrwxr-xr-x.  2 root           root             26 8月  26 09:58 alsadrwxr-xr-x.  2 root           root           4096 8月  23 15:55 alternativesdrwx------.  3 root           root             18 8月  23 16:04 authconfigdrwxr-xr-x.  2 root           root              6 9月  12 2017 bluetoothdrwxr-xr-x.  2 root           root              6 11月  2 2018 boltddrwxr-xr-x.  5 root           root             46 8月  23 15:44 certmongerdrwxr-xr-x.  2 chrony         chrony           19 8月  26 14:08 chronydrwxr-xr-x.  3 root           root             17 8月  23 15:41 colordrwxr-xr-x.  4 colord         colord           67 8月  23 16:27 colorddrwxr-xr-x.  2 root           root             24 8月  23 16:27 dbusdrwxr-xr-x.  2 root           root              6 5月  15 2018 dhclientdrwxr-xr-x.  2 root           root              6 10月 31 2018 dnsmasqdrwxr-xr-x.  3 root           root             34 8月  23 15:45 flatpakdrwxr-xr-x.  2 root           root              6 10月 31 2018 fprintdrwxr-xr-x.  3 root           root             39 8月  23 16:31 fwupddrwxr-xr-x.  2 root           root              6 11月  9 2018 fwupdatedrwxr-xr-x.  2 root           root              6 4月  11 2018 gamesdrwxrwx--T.  7 gdm            gdm              97 8月  26 09:51 gdmdrwxr-xr-x.  2 geoclue        geoclue           6 10月 31 2018 geocluedrwxr-xr-x.  4 root           root             55 8月  26 09:50 gssproxydrwxr-xr-x.  2 root           root              6 10月 31 2018 hypervdrwxr-xr-x.  2 root           root              6 11月  3 2018 initramfsdrwxr-xr-x.  4 root           root             35 8月  23 15:37 ipa-clientdrwxr-xr-x.  8 root           root             90 8月  23 15:43 iscsidrwxr-xr-x.  9 root           root            106 8月  23 15:44 libvirtdrwxr-xr-x.  2 root           root              6 11月  6 2016 lldpaddrwxr-xr-x.  2 root           root             30 8月  26 10:44 logrotatedrwx------.  2 root           root              6 8月  23 15:42 machinesdrwxr-xr-x.  2 root           root             37 8月  23 16:26 miscdrwxr-x---.  2 root           slocate          24 8月  26 10:44 mlocatedrwxr-xr-x.  6 mysql          mysql          4096 8月  26 14:36 mysqldrwxr-xr-x. 17 mysql          mysql          4096 8月  26 14:00 mysql.bak1drwxr-xr-x.  6 mysql          mysql          4096 8月  26 14:21 mysql.bak2drwxr-xr-x.  4 root           root             45 8月  23 15:41 net-snmpdrwx------.  2 root           root           4096 8月  26 09:55 NetworkManagerdrwxr-xr-x.  5 root           root            105 8月  23 15:44 nfsdrwxr-xr-x.  2 ntp            ntp               6 4月  13 2018 ntpdrwxr-xr-x.  2 root           root              6 11月  6 2016 os-proberdrwxr-xr-x.  2 root           root             29 8月  26 09:56 PackageKitdrwxr-xr-x.  2 root           root             27 8月  23 15:43 plymouthdrwxr-x---.  3 root           polkitd          28 8月  23 15:42 polkit-1drwx------.  2 postfix        root             25 8月  23 16:26 postfixdrwx------.  2 pulse          pulse             6 4月  13 2018 pulsedrwx------.  2 rpc            rpc               6 10月 31 2018 rpcbinddrwxr-xr-x.  2 root           root           4096 8月  26 09:55 rpmdrwxr-xr-x.  3 root           root             19 8月  23 15:55 rpm-statedrwx------.  2 root           root             29 8月  26 14:36 rsyslogdrwxr-xr-x.  4 root           root             33 8月  23 15:43 sambadrwxr-xr-x.  2 root           root              6 11月  3 2018 selinuxdrwx------.  2 setroubleshoot setroubleshoot   71 8月  23 16:52 setroubleshootdrwxr-xr-x. 10 root           root            120 8月  23 15:45 sssdrwxr-xr-x.  4 root           root             35 8月  23 15:43 statelessdrwxr-xr-x.  5 root           root             70 8月  23 16:26 systemddrwx------.  2 tss            tss               6 8月   4 2017 tpmdrwxr-xr-x.  2 root           root              6 11月  5 2018 tuneddrwx------.  2 root           root              6 11月  3 2018 udisks2drwxr-xr-x.  2 unbound        unbound          22 8月  23 15:44 unbounddrwxr-xr-x.  2 root           root            127 8月  26 10:01 upowerdrwxr-xr-x.  2 root           root            109 8月  26 09:50 VBoxGuestAdditionsdrwxr-xr-x.  2 root           root             29 8月  26 09:55 xkbdrwxr-xr-x.  6 root           root             80 8月  26 10:30 yum[root@rec lib]# rm -rf mysql[root@rec lib]# mkdir -p mysql[root@rec lib]# innobackupex --defaults-file=/etc/my.cnf --copy-back  /tmp/fullbak/xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin xtrabackup: recognized client arguments: 190826 14:37:23 innobackupex: Starting the copy-back operationIMPORTANT: Please check that the copy-back run completes successfully.           At the end of a successful copy-back run innobackupex           prints "completed OK!".innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)190826 14:37:23 [01] Copying ibdata1 to /var/lib/mysql/ibdata1190826 14:37:23 [01]        ...done190826 14:37:24 [01] Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/gtid_slave_pos.ibd to /var/lib/mysql/mysql/gtid_slave_pos.ibd190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/db.opt to /var/lib/mysql/mysql/db.opt190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/db.MYI to /var/lib/mysql/mysql/db.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/db.MYD to /var/lib/mysql/mysql/db.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/host.frm to /var/lib/mysql/mysql/host.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/host.MYI to /var/lib/mysql/mysql/host.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/host.MYD to /var/lib/mysql/mysql/host.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/user.MYI to /var/lib/mysql/mysql/user.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/user.MYD to /var/lib/mysql/mysql/user.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/roles_mapping.frm to /var/lib/mysql/mysql/roles_mapping.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/roles_mapping.MYI to /var/lib/mysql/mysql/roles_mapping.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/roles_mapping.MYD to /var/lib/mysql/mysql/roles_mapping.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/func.MYI to /var/lib/mysql/mysql/func.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/func.MYD to /var/lib/mysql/mysql/func.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/plugin.MYI to /var/lib/mysql/mysql/plugin.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/plugin.MYD to /var/lib/mysql/mysql/plugin.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/servers.MYI to /var/lib/mysql/mysql/servers.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/servers.MYD to /var/lib/mysql/mysql/servers.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/tables_priv.MYI to /var/lib/mysql/mysql/tables_priv.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/tables_priv.MYD to /var/lib/mysql/mysql/tables_priv.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/columns_priv.MYI to /var/lib/mysql/mysql/columns_priv.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/columns_priv.MYD to /var/lib/mysql/mysql/columns_priv.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_topic.MYI to /var/lib/mysql/mysql/help_topic.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_topic.MYD to /var/lib/mysql/mysql/help_topic.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_category.MYI to /var/lib/mysql/mysql/help_category.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_category.MYD to /var/lib/mysql/mysql/help_category.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_relation.MYI to /var/lib/mysql/mysql/help_relation.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_relation.MYD to /var/lib/mysql/mysql/help_relation.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_keyword.MYI to /var/lib/mysql/mysql/help_keyword.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/help_keyword.MYD to /var/lib/mysql/mysql/help_keyword.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_name.MYI to /var/lib/mysql/mysql/time_zone_name.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_name.MYD to /var/lib/mysql/mysql/time_zone_name.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone.MYI to /var/lib/mysql/mysql/time_zone.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone.MYD to /var/lib/mysql/mysql/time_zone.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_transition.MYI to /var/lib/mysql/mysql/time_zone_transition.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_transition.MYD to /var/lib/mysql/mysql/time_zone_transition.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/lib/mysql/mysql/time_zone_transition_type.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/lib/mysql/mysql/time_zone_transition_type.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/lib/mysql/mysql/time_zone_leap_second.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/lib/mysql/mysql/time_zone_leap_second.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/proc.MYI to /var/lib/mysql/mysql/proc.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/proc.MYD to /var/lib/mysql/mysql/proc.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/procs_priv.MYI to /var/lib/mysql/mysql/procs_priv.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/procs_priv.MYD to /var/lib/mysql/mysql/procs_priv.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/event.MYI to /var/lib/mysql/mysql/event.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/event.MYD to /var/lib/mysql/mysql/event.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/proxies_priv.MYI to /var/lib/mysql/mysql/proxies_priv.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/proxies_priv.MYD to /var/lib/mysql/mysql/proxies_priv.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/table_stats.frm to /var/lib/mysql/mysql/table_stats.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/table_stats.MYI to /var/lib/mysql/mysql/table_stats.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/table_stats.MYD to /var/lib/mysql/mysql/table_stats.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/column_stats.frm to /var/lib/mysql/mysql/column_stats.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/column_stats.MYI to /var/lib/mysql/mysql/column_stats.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/column_stats.MYD to /var/lib/mysql/mysql/column_stats.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/index_stats.frm to /var/lib/mysql/mysql/index_stats.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/index_stats.MYI to /var/lib/mysql/mysql/index_stats.MYI190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/index_stats.MYD to /var/lib/mysql/mysql/index_stats.MYD190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./mysql/gtid_slave_pos.frm to /var/lib/mysql/mysql/gtid_slave_pos.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./full/incr.ibd to /var/lib/mysql/full/incr.ibd190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./full/db.opt to /var/lib/mysql/full/db.opt190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./full/incr.frm to /var/lib/mysql/full/incr.frm190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./test/db.opt to /var/lib/mysql/test/db.opt190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./ib_buffer_pool to /var/lib/mysql/ib_buffer_pool190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./xtrabackup_binlog_pos_innodb to /var/lib/mysql/xtrabackup_binlog_pos_innodb190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./xtrabackup_master_key_id to /var/lib/mysql/xtrabackup_master_key_id190826 14:37:24 [01]        ...done190826 14:37:24 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info190826 14:37:24 [01]        ...done190826 14:37:24 completed OK![root@rec lib]# chown mysql.mysql -R mysql[root@rec lib]# /etc/init.d/mysql start Starting mysql (via systemctl):                            [  确定  ][root@rec lib]# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 9Server version: 10.2.26-MariaDB-log MariaDB ServerCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> select * from full.incr;                         +----+------------------+| id | tag              |+----+------------------+|  1 | 第1次增备后      ||  2 | 第2次增备后      ||  3 | 第3次增备后      |+----+------------------+3 rows in set (0.00 sec)MariaDB [(none)]> exitBye[root@rec lib]# cd /tmp/incr/incr3/[root@rec incr3]# ll总用量 8412-rw-r-----. 1 root root     438 8月  26 14:34 backup-my.cnfdrwxr-x---. 2 root root      79 8月  26 14:34 full-rw-r-----. 1 root root     942 8月  26 14:34 ib_buffer_pool-rw-r-----. 1 root root  196608 8月  26 14:34 ibdata1.delta-rw-r-----. 1 root root      44 8月  26 14:34 ibdata1.metadrwxr-x---. 2 root root    4096 8月  26 14:34 mysqldrwxr-x---. 2 root root      20 8月  26 14:34 performance_schemadrwxr-x---. 2 root root      20 8月  26 14:34 test-rw-r-----. 1 root root      27 8月  26 14:34 xtrabackup_binlog_info-rw-r-----. 1 root root     139 8月  26 14:34 xtrabackup_checkpoints-rw-r-----. 1 root root     587 8月  26 14:34 xtrabackup_info-rw-r-----. 1 root root 8388608 8月  26 14:36 xtrabackup_logfile[root@rec incr3]# cat xtrabackup_info uuid = 7eb52f1e-c7cb-11e9-ac43-0800279bc167name = tool_name = innobackupextool_command = --user=root --no-timestamp --parallel=4 --incremental-basedir=/tmp/incr/incr2/ --incremental /tmp/incr/incr3tool_version = 2.4.15ibbackup_version = 2.4.15server_version = 10.2.26-MariaDB-logstart_time = 2019-08-26 14:34:00end_time = 2019-08-26 14:34:02lock_time = 0binlog_pos = filename 'mysqlbin.000001', position '1460', GTID of the last change '0-1-6'innodb_from_lsn = 1649247innodb_to_lsn = 1650352partial = Nincremental = Yformat = filecompact = Ncompressed = Nencrypted = N[root@rec incr3]# exit登出