重庆思庄Oracle、Redhat认证学习论坛

标题: mysql enterprise backup 的进行备份的实际例子 [打印本页]

作者: 郑全 时间: 2015-4-24 09:55
标题: mysql enterprise backup 的进行备份的实际例子

[root@sztech1 ~]# mysqlbackup -uroot -proot --socket=/usr/local/mysql/mysql.sock --backup_dir=/u01/dbback/ backup-and-apply-log

mysqlbackup: INFO: Starting with following command line ...
mysqlbackup -uroot -pxxxx --socket=/usr/local/mysql/mysql.sock
--backup_dir=/u01/dbback/ backup-and-apply-log

mysqlbackup: INFO:
mysqlbackup: INFO: MySQL server version is '5.6.23-log'.
mysqlbackup: INFO: Got some server configuration information from running server.

IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup-and-apply-log' run mysqlbackup
prints "mysqlbackup completed OK!".

150424 08:15:32 mysqlbackup: INFO: MEB logfile created at /u01/dbback/meta/MEB_2015-04-24.08-15-32_backup_apply_log.log

--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /usr/local/mysql/data/
innodb_data_home_dir =
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data/
innodb_log_files_in_group = 3
innodb_log_file_size = 536870912
innodb_page_size = 16384
innodb_checksum_algorithm = innodb
innodb_undo_directory = /usr/local/mysql/data/
innodb_undo_tablespaces = 0
innodb_undo_logs = 128

--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /u01/dbback/datadir
innodb_data_home_dir = /u01/dbback/datadir
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /u01/dbback/datadir
innodb_log_files_in_group = 3
innodb_log_file_size = 536870912
innodb_page_size = 16384
innodb_checksum_algorithm = innodb
innodb_undo_directory = /u01/dbback/datadir
innodb_undo_tablespaces = 0
innodb_undo_logs = 128

mysqlbackup: INFO: Unique generated backup id for this is 14298345324967585

mysqlbackup: INFO: Creating 14 buffers each of size 16777216.
150424 08:15:34 mysqlbackup: INFO: Full Backup operation starts with following threads
                1 read-threads    6 process-threads    1 write-threads
150424 08:15:34 mysqlbackup: INFO: System tablespace file format is Antelope.
150424 08:15:34 mysqlbackup: INFO: Starting to copy all innodb files...
150424 08:15:34 mysqlbackup: INFO: Copying /usr/local/mysql/data/ibdata1 (Antelope file format).
150424 08:15:34 mysqlbackup: INFO: Found checkpoint at lsn 379176813.
150424 08:15:34 mysqlbackup: INFO: Starting log scan from lsn 379176448.
150424 08:15:34 mysqlbackup: INFO: Copying log...
150424 08:15:34 mysqlbackup: INFO: Log copied, lsn 379176813.
150424 08:15:36 mysqlbackup: INFO: Copying /usr/local/mysql/data/employees/departments.ibd (Antelope file format).
150424 08:15:36 mysqlbackup: INFO: Copying /usr/local/mysql/data/employees/dept_emp.ibd (Antelope file format).
150424 08:15:37 mysqlbackup: INFO: Copying /usr/local/mysql/data/employees/dept_manager.ibd (Antelope file format).
150424 08:15:37 mysqlbackup: INFO: Copying /usr/local/mysql/data/employees/employees.ibd (Antelope file format).
150424 08:15:37 mysqlbackup: INFO: Copying /usr/local/mysql/data/employees/salaries.ibd (Antelope file format).
mysqlbackup: Progress in MB: 200
150424 08:15:47 mysqlbackup: INFO: Copying /usr/local/mysql/data/employees/titles.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/mysql/innodb_index_stats.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/mysql/innodb_table_stats.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/mysql/slave_master_info.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/mysql/slave_relay_log_info.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/mysql/slave_worker_info.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/actor.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/address.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/category.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/city.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/country.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/customer.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/film.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/film_actor.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/film_category.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/inventory.ibd (Antelope file format).
150424 08:15:48 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/language.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/payment.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/rental.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/staff.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/sakila/store.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/sztech/dept.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/sztech/emp.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/sztech/emp_bak.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/sztech/emp_bak1.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/world/city.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/world/country.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/world/countrylanguage.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/world/deletedcity.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Copying /usr/local/mysql/data/world/mytable.ibd (Antelope file format).
150424 08:15:49 mysqlbackup: INFO: Completing the copy of innodb files.
150424 08:15:49 mysqlbackup: INFO: Starting to copy Binlog files...
150424 08:15:50 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
150424 08:15:50 mysqlbackup: INFO: Starting to lock all the tables...
150424 08:15:50 mysqlbackup: INFO: All tables are locked and flushed to disk
150424 08:15:50 mysqlbackup: INFO: Opening backup source directory '/usr/local/mysql/data/'
150424 08:15:50 mysqlbackup: INFO: Starting to backup all non-innodb files in
        subdirectories of '/usr/local/mysql/data/'
150424 08:15:50 mysqlbackup: INFO: Copying the database directory 'employees'
150424 08:15:50 mysqlbackup: INFO: Copying the database directory 'innodb_memcache'
150424 08:15:50 mysqlbackup: INFO: Copying the database directory 'mysql'
150424 08:15:51 mysqlbackup: INFO: Copying the database directory 'performance_schema'
150424 08:15:51 mysqlbackup: INFO: Copying the database directory 'sakila'
150424 08:15:51 mysqlbackup: INFO: Copying the database directory 'sys'
150424 08:15:51 mysqlbackup: INFO: Copying the database directory 'sztech'
150424 08:15:51 mysqlbackup: INFO: Copying the database directory 'test'
150424 08:15:51 mysqlbackup: INFO: Copying the database directory 'world'
150424 08:15:51 mysqlbackup: INFO: Completing the copy of all non-innodb files.
150424 08:15:51 mysqlbackup: INFO: Completed the copy of binlog files...
150424 08:15:52 mysqlbackup: INFO: A copied database page was modified at 379176813.
          (This is the highest lsn found on page)
          Scanned log up to lsn 379176813.
          Was able to parse the log up to lsn 379176813.
          Maximum page number for a log record 0
150424 08:15:52 mysqlbackup: INFO: All tables unlocked
150424 08:15:52 mysqlbackup: INFO: All MySQL tables were locked for 1.881 seconds.
150424 08:15:52 mysqlbackup: INFO: Reading all global variables from the server.
150424 08:15:52 mysqlbackup: INFO: Completed reading of all global variables from the server.
150424 08:15:52 mysqlbackup: INFO: Creating server config files server-my.cnf and server-all.cnf in /u01/dbback/
150424 08:15:52 mysqlbackup: INFO: Full Backup operation completed successfully.
150424 08:15:52 mysqlbackup: INFO: Backup created in directory '/u01/dbback/'
150424 08:15:52 mysqlbackup: INFO: MySQL binlog position: filename mysql-binlog.000023, position 120

-------------------------------------------------------------
   Parameters Summary
-------------------------------------------------------------
   Start LSN                  : 379176448
   End LSN                    : 379176813
-------------------------------------------------------------

mysqlbackup: INFO: Creating 14 buffers each of size 65536.
150424 08:15:52 mysqlbackup: INFO: Apply-log operation starts with following threads
                1 read-threads    1 process-threads
mysqlbackup: INFO: Using up to 100 MB of memory.
150424 08:15:52 mysqlbackup: INFO: ibbackup_logfile's creation parameters:
          start lsn 379176448, end lsn 379176813,
          start checkpoint 379176813.
mysqlbackup: INFO: InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
mysqlbackup: INFO: InnoDB: Setting log file size to 536870912
InnoDB: Progress in MB: 100 200 300 400 500
mysqlbackup: INFO: InnoDB: Setting log file size to 536870912
InnoDB: Progress in MB: 100 200 300 400 500
mysqlbackup: INFO: InnoDB: Setting log file size to 536870912
InnoDB: Progress in MB: 100 200 300 400 500
150424 08:16:00 mysqlbackup: INFO: We were able to parse ibbackup_logfile up to
          lsn 379176813.
mysqlbackup: INFO: Last MySQL binlog file position 0 120, file name mysql-binlog.000023:120
150424 08:16:00 mysqlbackup: INFO: The first data file is '/u01/dbback/datadir/ibdata1'
          and the new created log files are at '/u01/dbback/datadir'
150424 08:16:00 mysqlbackup: INFO: Apply-log operation completed successfully.
150424 08:16:00 mysqlbackup: INFO: Full backup prepared for recovery successfully.

mysqlbackup completed OK!
[root@sztech1 ~]#

作者: 郑全 时间: 2015-4-24 09:58

备份后的内容：

[root@sztech1 dbback]# pwd
/u01/dbback
[root@sztech1 dbback]# ls -ltr
总用量 32
-rw-r--r-- 1 root root 246 4月 24 08:15 backup-my.cnf
-rw-r--r-- 1 root root 3810 4月 24 08:15 server-my.cnf
-rw-r--r-- 1 root root 12752 4月 24 08:15 server-all.cnf
drwx------ 11 root root 4096 4月 24 08:15 datadir
drwx------ 2 root root 4096 4月 24 08:16 meta
[root@sztech1 dbback]#

[root@sztech1 dbback]# tree *
backup-my.cnf [error opening dir]
datadir
├── employees
│   ├── db.opt
│   ├── departments.frm
│   ├── departments.ibd
│   ├── dept_emp.frm
│   ├── dept_emp.ibd
│   ├── dept_manager.frm
│   ├── dept_manager.ibd
│   ├── employees.frm
│   ├── employees.ibd
│   ├── salaries.frm
│   ├── salaries.ibd
│   ├── titles.frm
│   └── titles.ibd
├── ibbackup_logfile
├── ibdata1
├── ib_logfile0
├── ib_logfile1
├── ib_logfile2
├── innodb_memcache
│   ├── cache_policies.frm
│   ├── config_options.frm
│   ├── containers.frm
│   ├── db.opt
│   └── demo_test.frm
├── mysql
│   ├── backup_history.CSM
│   ├── backup_history.CSV
│   ├── backup_history.frm
│   ├── backup_progress.CSM
│   ├── backup_progress.CSV
│   ├── backup_progress.frm
│   ├── columns_priv.frm
│   ├── columns_priv.MYD
│   ├── columns_priv.MYI
│   ├── db.frm
│   ├── db.MYD
│   ├── db.MYI
│   ├── event.frm
│   ├── event.MYD
│   ├── event.MYI
│   ├── func.frm
│   ├── func.MYD
│   ├── func.MYI
│   ├── general_log.CSM
│   ├── general_log.CSV
│   ├── general_log.frm
│   ├── help_category.frm
│   ├── help_category.MYD
│   ├── help_category.MYI
│   ├── help_keyword.frm
│   ├── help_keyword.MYD
│   ├── help_keyword.MYI
│   ├── help_relation.frm
│   ├── help_relation.MYD
│   ├── help_relation.MYI
│   ├── help_topic.frm
│   ├── help_topic.MYD
│   ├── help_topic.MYI
│   ├── innodb_index_stats.frm
│   ├── innodb_index_stats.ibd
│   ├── innodb_table_stats.frm
│   ├── innodb_table_stats.ibd
│   ├── ndb_binlog_index.frm
│   ├── ndb_binlog_index.MYD
│   ├── ndb_binlog_index.MYI
│   ├── plugin.frm
│   ├── plugin.MYD
│   ├── plugin.MYI
│   ├── proc.frm
│   ├── proc.MYD
│   ├── proc.MYI
│   ├── procs_priv.frm
│   ├── procs_priv.MYD
│   ├── procs_priv.MYI
│   ├── proxies_priv.frm
│   ├── proxies_priv.MYD
│   ├── proxies_priv.MYI
│   ├── servers.frm
│   ├── servers.MYD
│   ├── servers.MYI
│   ├── slave_master_info.frm
│   ├── slave_master_info.ibd
│   ├── slave_relay_log_info.frm
│   ├── slave_relay_log_info.ibd
│   ├── slave_worker_info.frm
│   ├── slave_worker_info.ibd
│   ├── slow_log.CSM
│   ├── slow_log.CSV
│   ├── slow_log.frm
│   ├── tables_priv.frm
│   ├── tables_priv.MYD
│   ├── tables_priv.MYI
│   ├── time_zone.frm
│   ├── time_zone_leap_second.frm
│   ├── time_zone_leap_second.MYD
│   ├── time_zone_leap_second.MYI
│   ├── time_zone.MYD
│   ├── time_zone.MYI
│   ├── time_zone_name.frm
│   ├── time_zone_name.MYD
│   ├── time_zone_name.MYI
│   ├── time_zone_transition.frm
│   ├── time_zone_transition.MYD
│   ├── time_zone_transition.MYI
│   ├── time_zone_transition_type.frm
│   ├── time_zone_transition_type.MYD
│   ├── time_zone_transition_type.MYI
│   ├── user.frm
│   ├── user.MYD
│   └── user.MYI
├── mysql-binlog.000019
├── mysql-binlog.000020
├── mysql-binlog.000021
├── mysql-binlog.000022
├── mysql-binlog.000023
├── mysql-binlog.index
├── performance_schema
│   ├── accounts.frm
│   ├── cond_instances.frm
│   ├── db.opt
│   ├── events_stages_current.frm
│   ├── events_stages_history.frm
│   ├── events_stages_history_long.frm
│   ├── events_stages_summary_by_account_by_event_name.frm
│   ├── events_stages_summary_by_host_by_event_name.frm
│   ├── events_stages_summary_by_thread_by_event_name.frm
│   ├── events_stages_summary_by_user_by_event_name.frm
│   ├── events_stages_summary_global_by_event_name.frm
│   ├── events_statements_current.frm
│   ├── events_statements_history.frm
│   ├── events_statements_history_long.frm
│   ├── events_statements_summary_by_account_by_event_name.frm
│   ├── events_statements_summary_by_digest.frm
│   ├── events_statements_summary_by_host_by_event_name.frm
│   ├── events_statements_summary_by_thread_by_event_name.frm
│   ├── events_statements_summary_by_user_by_event_name.frm
│   ├── events_statements_summary_global_by_event_name.frm
│   ├── events_waits_current.frm
│   ├── events_waits_history.frm
│   ├── events_waits_history_long.frm
│   ├── events_waits_summary_by_account_by_event_name.frm
│   ├── events_waits_summary_by_host_by_event_name.frm
│   ├── events_waits_summary_by_instance.frm
│   ├── events_waits_summary_by_thread_by_event_name.frm
│   ├── events_waits_summary_by_user_by_event_name.frm
│   ├── events_waits_summary_global_by_event_name.frm
│   ├── file_instances.frm
│   ├── file_summary_by_event_name.frm
│   ├── file_summary_by_instance.frm
│   ├── host_cache.frm
│   ├── hosts.frm
│   ├── mutex_instances.frm
│   ├── objects_summary_global_by_type.frm
│   ├── performance_timers.frm
│   ├── rwlock_instances.frm
│   ├── session_account_connect_attrs.frm
│   ├── session_connect_attrs.frm
│   ├── setup_actors.frm
│   ├── setup_consumers.frm
│   ├── setup_instruments.frm
│   ├── setup_objects.frm
│   ├── setup_timers.frm
│   ├── socket_instances.frm
│   ├── socket_summary_by_event_name.frm
│   ├── socket_summary_by_instance.frm
│   ├── table_io_waits_summary_by_index_usage.frm
│   ├── table_io_waits_summary_by_table.frm
│   ├── table_lock_waits_summary_by_table.frm
│   ├── threads.frm
│   └── users.frm
├── sakila
│   ├── actor.frm
│   ├── actor.ibd
│   ├── actor_info.frm
│   ├── address.frm
│   ├── address.ibd
│   ├── category.frm
│   ├── category.ibd
│   ├── city.frm
│   ├── city.ibd
│   ├── country.frm
│   ├── country.ibd
│   ├── customer_create_date.TRN
│   ├── customer.frm
│   ├── customer.ibd
│   ├── customer_list.frm
│   ├── customer.TRG
│   ├── db.opt
│   ├── del_film.TRN
│   ├── film_actor.frm
│   ├── film_actor.ibd
│   ├── film_category.frm
│   ├── film_category.ibd
│   ├── film.frm
│   ├── film.ibd
│   ├── film_list.frm
│   ├── film_text.frm
│   ├── film_text.MYD
│   ├── film_text.MYI
│   ├── film.TRG
│   ├── ins_film.TRN
│   ├── inventory.frm
│   ├── inventory.ibd
│   ├── language.frm
│   ├── language.ibd
│   ├── nicer_but_slower_film_list.frm
│   ├── payment_date.TRN
│   ├── payment.frm
│   ├── payment.ibd
│   ├── payment.TRG
│   ├── rental_date.TRN
│   ├── rental.frm
│   ├── rental.ibd
│   ├── rental.TRG
│   ├── sales_by_film_category.frm
│   ├── sales_by_store.frm
│   ├── staff.frm
│   ├── staff.ibd
│   ├── staff_list.frm
│   ├── store.frm
│   ├── store.ibd
│   └── upd_film.TRN
├── sys
│   ├── db.opt
│   ├── host_summary_by_file_io.frm
│   ├── host_summary_by_file_io_type.frm
│   ├── host_summary_by_stages.frm
│   ├── host_summary_by_statement_latency.frm
│   ├── host_summary_by_statement_type.frm
│   ├── host_summary.frm
│   ├── innodb_buffer_stats_by_schema.frm
│   ├── innodb_buffer_stats_by_table.frm
│   ├── io_by_thread_by_latency.frm
│   ├── io_global_by_file_by_bytes.frm
│   ├── io_global_by_file_by_latency.frm
│   ├── io_global_by_wait_by_bytes.frm
│   ├── io_global_by_wait_by_latency.frm
│   ├── latest_file_io.frm
│   ├── processlist.frm
│   ├── ps_check_lost_instrumentation.frm
│   ├── schema_index_statistics.frm
│   ├── schema_object_overview.frm
│   ├── schema_table_statistics.frm
│   ├── schema_table_statistics_with_buffer.frm
│   ├── schema_tables_with_full_table_scans.frm
│   ├── schema_unused_indexes.frm
│   ├── statement_analysis.frm
│   ├── statements_with_errors_or_warnings.frm
│   ├── statements_with_full_table_scans.frm
│   ├── statements_with_runtimes_in_95th_percentile.frm
│   ├── statements_with_sorting.frm
│   ├── statements_with_temp_tables.frm
│   ├── user_summary_by_file_io.frm
│   ├── user_summary_by_file_io_type.frm
│   ├── user_summary_by_stages.frm
│   ├── user_summary_by_statement_latency.frm
│   ├── user_summary_by_statement_type.frm
│   ├── user_summary.frm
│   ├── version.frm
│   ├── wait_classes_global_by_avg_latency.frm
│   ├── wait_classes_global_by_latency.frm
│   ├── waits_by_host_by_latency.frm
│   ├── waits_by_user_by_latency.frm
│   ├── waits_global_by_latency.frm
│   ├── x@0024host_summary_by_file_io.frm
│   ├── x@0024host_summary_by_file_io_type.frm
│   ├── x@0024host_summary_by_stages.frm
│   ├── x@0024host_summary_by_statement_latency.frm
│   ├── x@0024host_summary_by_statement_type.frm
│   ├── x@0024host_summary.frm
│   ├── x@0024innodb_buffer_stats_by_schema.frm
│   ├── x@0024innodb_buffer_stats_by_table.frm
│   ├── x@0024io_by_thread_by_latency.frm
│   ├── x@0024io_global_by_file_by_bytes.frm
│   ├── x@0024io_global_by_file_by_latency.frm
│   ├── x@0024io_global_by_wait_by_bytes.frm
│   ├── x@0024io_global_by_wait_by_latency.frm
│   ├── x@0024latest_file_io.frm
│   ├── x@0024processlist.frm
│   ├── x@0024ps_digest_95th_percentile_by_avg_us.frm
│   ├── x@0024ps_digest_avg_latency_distribution.frm
│   ├── x@0024ps_schema_table_statistics_io.frm
│   ├── x@0024schema_index_statistics.frm
│   ├── x@0024schema_table_statistics.frm
│   ├── x@0024schema_table_statistics_with_buffer.frm
│   ├── x@0024statement_analysis.frm
│   ├── x@0024statements_with_errors_or_warnings.frm
│   ├── x@0024statements_with_full_table_scans.frm
│   ├── x@0024statements_with_runtimes_in_95th_percentile.frm
│   ├── x@0024statements_with_sorting.frm
│   ├── x@0024statements_with_temp_tables.frm
│   ├── x@0024user_summary_by_file_io.frm
│   ├── x@0024user_summary_by_file_io_type.frm
│   ├── x@0024user_summary_by_stages.frm
│   ├── x@0024user_summary_by_statement_latency.frm
│   ├── x@0024user_summary_by_statement_type.frm
│   ├── x@0024user_summary.frm
│   ├── x@0024wait_classes_global_by_avg_latency.frm
│   ├── x@0024wait_classes_global_by_latency.frm
│   ├── x@0024waits_by_host_by_latency.frm
│   ├── x@0024waits_by_user_by_latency.frm
│   └── x@0024waits_global_by_latency.frm
├── sztech
│   ├── db.opt
│   ├── dept.frm
│   ├── dept.ibd
│   ├── emp_bak1.frm
│   ├── emp_bak1.ibd
│   ├── emp_bak.frm
│   ├── emp_bak.ibd
│   ├── emp.frm
│   ├── emp.ibd
│   ├── job.frm
│   ├── job.MYD
│   ├── job.MYI
│   └── location.frm
├── test
│   ├── db.opt
│   └── demo_test.frm
└── world
    ├── City_AD.TRN
    ├── city.frm
    ├── city.ibd
    ├── city.TRG
    ├── country.frm
    ├── country.ibd
    ├── countrylanguage.frm
    ├── countrylanguage.ibd
    ├── db.opt
    ├── deletedcity.frm
    ├── deletedcity.ibd
    ├── mytable.frm
    └── mytable.ibd
meta
├── backup_content.xml
├── backup_create.xml
├── backup_variables.txt
└── MEB_2015-04-24.08-15-32_backup_apply_log.log
server-all.cnf [error opening dir]
server-my.cnf [error opening dir]

9 directories, 329 files

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)