Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- root@ubuntu3:/var/lib/mysql# dd if=/dev/urandom count=4 bs=1 seek=5000 of=test1.ibd conv=notrunc
- 4+0 records in
- 4+0 records out
- 4 bytes copied, 0.000744241 s, 5.4 kB/s
- root@ubuntu3:/var/lib/mysql# xtrabackup --backup --user root -pStockSale77 --stream=xbstream --compress --compress-threads=4 --parallel=4 --no-version-check > /dev/null
- 170405 12:33:07 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
- Using server version 5.7.16-10-57
- xtrabackup version 2.4.6 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 8ec05b7)
- xtrabackup: uses posix_fadvise().
- xtrabackup: cd to /var/lib/mysql/
- xtrabackup: open files limit requested 0, set to 1024
- xtrabackup: using the following InnoDB configuration:
- xtrabackup: innodb_data_home_dir = .
- xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
- xtrabackup: innodb_log_group_home_dir = ./
- xtrabackup: innodb_log_files_in_group = 2
- xtrabackup: innodb_log_file_size = 50331648
- InnoDB: Number of pools: 1
- 170405 12:33:07 >> log scanned up to (2528891)
- xtrabackup: Generating a list of tablespaces
- InnoDB: Checksum mismatch in datafile: ./test1.ibd, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
- InnoDB: Checksum mismatch in datafile: ./pxc_test/test1.ibd, Space ID:44, Flags: 33. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
- InnoDB: Allocated tablespace ID 5 for mysql/help_category, old maximum was 0
- xtrabackup: Starting 4 threads for parallel data files transfer
- 170405 12:33:08 [04] Compressing and streaming ./ibdata1
- 170405 12:33:08 [03] Compressing and streaming ./mysql/help_category.ibd
- 170405 12:33:08 [02] Compressing and streaming ./mysql/gtid_executed.ibd
- 170405 12:33:08 [03] ...done
- 170405 12:33:08 [03] Compressing and streaming ./mysql/innodb_table_stats.ibd
- 170405 12:33:08 [01] Compressing and streaming ./mysql/engine_cost.ibd
- 170405 12:33:08 [02] ...done
- 170405 12:33:08 [02] Compressing and streaming ./mysql/plugin.ibd
- 170405 12:33:08 [03] ...done
- 170405 12:33:08 [03] Compressing and streaming ./mysql/server_cost.ibd
- 170405 12:33:08 [02] ...done
- 170405 12:33:08 [02] Compressing and streaming ./mysql/help_keyword.ibd
- 170405 12:33:08 [01] ...done
- 170405 12:33:08 [01] Compressing and streaming ./mysql/slave_worker_info.ibd
- 170405 12:33:08 [03] ...done
- 170405 12:33:08 [03] Compressing and streaming ./mysql/time_zone_transition.ibd
- 170405 12:33:08 [02] ...done
- 170405 12:33:08 [02] Compressing and streaming ./mysql/time_zone.ibd
- 170405 12:33:08 [01] ...done
- 170405 12:33:08 [01] Compressing and streaming ./mysql/help_topic.ibd
- 170405 12:33:08 [02] ...done
- 170405 12:33:08 [02] Compressing and streaming ./mysql/time_zone_leap_second.ibd
- 170405 12:33:08 [03] ...done
- 170405 12:33:08 [03] Compressing and streaming ./mysql/slave_relay_log_info.ibd
- 170405 12:33:08 [02] ...done
- 170405 12:33:08 [02] Compressing and streaming ./mysql/innodb_index_stats.ibd
- 170405 12:33:08 [03] ...done
- 170405 12:33:08 [03] Compressing and streaming ./mysql/time_zone_name.ibd
- 170405 12:33:08 [02] ...done
- 170405 12:33:08 [02] Compressing and streaming ./mysql/help_relation.ibd
- 170405 12:33:08 [03] ...done
- 170405 12:33:08 [03] Compressing and streaming ./mysql/servers.ibd
- 170405 12:33:08 [03] ...done
- 170405 12:33:08 [03] Compressing and streaming ./mysql/time_zone_transition_type.ibd
- 170405 12:33:08 [03] ...done
- 170405 12:33:08 [03] Compressing and streaming ./mysql/slave_master_info.ibd
- 170405 12:33:08 [03] ...done
- 170405 12:33:08 [03] Compressing and streaming ./sys/sys_config.ibd
- 170405 12:33:08 [03] ...done
- 170405 12:33:08 [02] ...done
- 170405 12:33:08 [04] ...done
- 170405 12:33:08 [01] ...done
- 170405 12:33:08 >> log scanned up to (2528891)
- 170405 12:33:09 Executing LOCK TABLES FOR BACKUP...
- 170405 12:33:09 Starting to backup non-InnoDB tables and files
- 170405 12:33:09 [00] Compressing and streaming xtrabackup_backupfiles/db.opt
- 170405 12:33:09 [00] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_waits_history_long.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_stages_summary_global_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/memory_summary_by_user_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/hosts.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/host_cache.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_waits_current.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_waits_summary_by_host_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/file_instances.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_waits_summary_by_instance.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_statements_history_long.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/threads.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/replication_applier_status_by_worker.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_stages_summary_by_host_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_statements_summary_by_account_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_stages_summary_by_account_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_waits_history.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/replication_connection_configuration.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/users.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/table_lock_waits_summary_by_table.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/metadata_locks.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/session_variables.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_stages_current.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/setup_consumers.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/socket_instances.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/status_by_user.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/replication_group_member_stats.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/table_io_waits_summary_by_table.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/objects_summary_global_by_type.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/replication_applier_configuration.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/status_by_account.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_stages_history_long.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/file_summary_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/memory_summary_by_account_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/setup_instruments.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_transactions_current.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/session_account_connect_attrs.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_statements_summary_by_program.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/setup_timers.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/replication_connection_status.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/replication_group_members.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/status_by_thread.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/session_status.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/status_by_host.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_statements_summary_by_user_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_statements_history.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_statements_summary_global_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/prepared_statements_instances.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/table_io_waits_summary_by_index_usage.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_waits_summary_by_account_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/user_variables_by_thread.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_statements_summary_by_host_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_transactions_history.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/setup_actors.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/replication_applier_status.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/file_summary_by_instance.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/socket_summary_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_transactions_summary_global_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/db.opt to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/performance_timers.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/mutex_instances.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/replication_applier_status_by_coordinator.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/rwlock_instances.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/variables_by_thread.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_stages_summary_by_user_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_stages_history.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/setup_objects.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/memory_summary_global_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/memory_summary_by_host_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/global_variables.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/cond_instances.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_statements_summary_by_digest.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_waits_summary_by_user_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/accounts.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/session_connect_attrs.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_waits_summary_global_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_statements_current.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/memory_summary_by_thread_by_event_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/table_handles.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/events_transactions_history_long.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/socket_summary_by_instance.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./performance_schema/global_status.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./pxc_test/test1.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/time_zone_name.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/event.MYD to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/proxies_priv.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/help_keyword.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/time_zone_transition_type.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/general_log.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/ndb_binlog_index.MYI to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/procs_priv.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/slave_relay_log_info.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/innodb_table_stats.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/time_zone_leap_second.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/proc.MYI to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/proxies_priv.MYD to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/proxies_priv.MYI to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/slave_master_info.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/innodb_index_stats.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/engine_cost.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/user.MYI to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/ndb_binlog_index.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/help_category.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/procs_priv.MYD to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/servers.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/gtid_executed.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/event.MYI to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/db.MYD to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/server_cost.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/procs_priv.MYI to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/slow_log.CSM to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/proc.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/slave_worker_info.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/func.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/db.MYI to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/ndb_binlog_index.MYD to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/time_zone_transition.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/slow_log.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/db.opt to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/general_log.CSV to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/columns_priv.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/slow_log.CSV to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/time_zone.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/func.MYI to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/general_log.CSM to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/tables_priv.MYI to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/db.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/help_topic.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/user.MYD to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/event.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/proc.MYD to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/func.MYD to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/columns_priv.MYD to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/help_relation.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/plugin.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/user.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/tables_priv.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/tables_priv.MYD to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./mysql/columns_priv.MYI to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/user_summary_by_statement_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024user_summary_by_stages.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/user_summary.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024io_by_thread_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/sys_config_update_set_user.TRN to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024memory_by_user_by_current_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024user_summary_by_statement_type.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024host_summary.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024waits_by_user_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/statements_with_errors_or_warnings.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/memory_by_thread_by_current_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024memory_global_by_current_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/host_summary_by_file_io_type.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024session.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/schema_table_statistics_with_buffer.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/sys_config.TRG to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024innodb_buffer_stats_by_table.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024statements_with_errors_or_warnings.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/sys_config.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/user_summary_by_file_io.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/schema_index_statistics.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024host_summary_by_file_io.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024host_summary_by_file_io_type.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/metrics.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/schema_tables_with_full_table_scans.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/user_summary_by_file_io_type.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024memory_global_total.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024statements_with_full_table_scans.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/host_summary_by_stages.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/sys_config_insert_set_user.TRN to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024memory_by_host_by_current_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/schema_table_statistics.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024host_summary_by_stages.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024user_summary_by_file_io_type.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024statement_analysis.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/processlist.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/host_summary_by_statement_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024schema_table_lock_waits.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024io_global_by_file_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/schema_table_lock_waits.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/waits_by_host_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/memory_by_host_by_current_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/memory_by_user_by_current_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/io_global_by_file_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/memory_global_by_current_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/statements_with_sorting.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/schema_auto_increment_columns.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024io_global_by_wait_by_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/io_by_thread_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/host_summary_by_file_io.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/memory_global_total.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024waits_by_host_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024user_summary.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024statements_with_sorting.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/user_summary_by_stages.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/statements_with_full_table_scans.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024schema_table_statistics_with_buffer.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024memory_by_thread_by_current_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024ps_schema_table_statistics_io.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/session.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/schema_object_overview.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/innodb_buffer_stats_by_schema.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024statements_with_temp_tables.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/db.opt to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/host_summary.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024waits_global_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/io_global_by_file_by_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024innodb_buffer_stats_by_schema.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024processlist.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024wait_classes_global_by_avg_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024host_summary_by_statement_type.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024innodb_lock_waits.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024latest_file_io.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/statements_with_temp_tables.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024schema_index_statistics.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/ps_check_lost_instrumentation.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/innodb_lock_waits.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/wait_classes_global_by_avg_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/innodb_buffer_stats_by_table.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/schema_unused_indexes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/latest_file_io.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/waits_global_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/waits_by_user_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024user_summary_by_statement_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024io_global_by_wait_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/statement_analysis.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/io_global_by_wait_by_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/schema_redundant_indexes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024schema_flattened_keys.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/io_global_by_wait_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024host_summary_by_statement_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024schema_tables_with_full_table_scans.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024user_summary_by_file_io.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024ps_digest_avg_latency_distribution.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024io_global_by_file_by_bytes.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/wait_classes_global_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/statements_with_runtimes_in_95th_percentile.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/session_ssl_status.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/version.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024wait_classes_global_by_latency.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/user_summary_by_statement_type.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/host_summary_by_statement_type.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 [01] Compressing and streaming ./sys/x@0024schema_table_statistics.frm to <STDOUT>
- 170405 12:33:09 [01] ...done
- 170405 12:33:09 Finished backing up non-InnoDB tables and files
- 170405 12:33:09 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
- xtrabackup: The latest check point (for incremental): '2528882'
- xtrabackup: Stopping log copying thread.
- .170405 12:33:09 >> log scanned up to (2528891)
- 170405 12:33:09 Executing UNLOCK TABLES
- 170405 12:33:09 All tables unlocked
- 170405 12:33:09 [00] Compressing and streaming ib_buffer_pool to <STDOUT>
- 170405 12:33:09 [00] ...done
- 170405 12:33:09 Backup created in directory '/var/lib/mysql/xtrabackup_backupfiles/'
- 170405 12:33:09 [00] Compressing and streaming backup-my.cnf
- 170405 12:33:09 [00] ...done
- 170405 12:33:09 [00] Compressing and streaming xtrabackup_info
- 170405 12:33:09 [00] ...done
- xtrabackup: Transaction log of lsn (2528882) to (2528891) was copied.
- 170405 12:33:09 completed OK!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement