Percona-Xtrabackup 2.3.3 慢查詢依舊堵塞MariaDB備份（三）

haoge0205發表於2016-02-01
MariaDB [yoon]> select version();
+---------------------+
| version()           |
+---------------------+
| 10.0.12-MariaDB-log |
+---------------------+
1 row in set (0.00 sec)


MariaDB [(none)]> create database yoon;
Query OK, 1 row affected (0.01 sec)


MariaDB [(none)]> use yoon;
Database changed
MariaDB [yoon]> create table yoon (id int,name varchar(20));
Query OK, 0 rows affected (0.05 sec)


MariaDB [yoon]> insert into yoon values (1,'Yoon');
Query OK, 1 row affected (0.01 sec)


MariaDB [yoon]> select * from yoon;
+------+------+
| id   | name |
+------+------+
|    1 | Yoon |
+------+------+
1 row in set (0.00 sec)




[root@b28-12-93 bak]# innobackupex --compress --parallel=4 --user=yoon --password=yoon /my/bak/
160201 17:40:42 innobackupex: Starting the backup operation


IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".


160201 17:40:42  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/my/log/mysql.sock' as 'yoon'  (using password: YES).
160201 17:40:42  version_check Connected to MySQL server
160201 17:40:42  version_check Executing a version check against the server...
160201 17:40:46  version_check Done.
160201 17:40:46 Connecting to MySQL server host: localhost, user: yoon, password: set, port: 3306, socket: /my/log/mysql.sock
Using server version 10.0.12-MariaDB-log
innobackupex version 2.3.3 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 525ca7d)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /my/data
xtrabackup: open files limit requested 0, set to 65535
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = /my/log
xtrabackup:   innodb_data_file_path = ibdata1:256M:autoextend
xtrabackup:   innodb_log_group_home_dir = /my/log
xtrabackup:   innodb_log_files_in_group = 4
xtrabackup:   innodb_log_file_size = 268435456
2016-02-01 17:40:46 7ffc4d6d5720 InnoDB: Using Linux native AIO
xtrabackup: using O_DIRECT
160201 17:40:46 >> log scanned up to (841376038309)
xtrabackup: Generating a list of tablespaces
xtrabackup: Starting 4 threads for parallel data files transfer
160201 17:40:46 [02] Compressing ./yoon/yoon.ibd to /my/bak//2016-02-01_17-40-42/yoon/yoon.ibd.qp
160201 17:40:46 [04] Compressing ./hank/adv_PlanOrientation.ibd to /my/bak//2016-02-01_17-40-42/hank/adv_PlanOrientation.ibd.qp
160201 17:40:46 [03] Compressing ./hank/tj_ItemSourceStatistics.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_ItemSourceStatistics.ibd.qp
160201 17:40:46 [01] Compressing /my/log/ibdata1 to /my/bak//2016-02-01_17-40-42/ibdata1.qp
160201 17:40:46 [04]        ...done
160201 17:40:46 [02]        ...done
160201 17:40:46 [04] Compressing ./hank/tj_RelItemCosts.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_RelItemCosts.ibd.qp
160201 17:40:46 [02] Compressing ./hank/tj_SourceStatistics.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_SourceStatistics.ibd.qp
160201 17:40:47 >> log scanned up to (841376038309)
160201 17:40:47 [04]        ...done
160201 17:40:47 [04] Compressing ./hank/tj_SearchDataTmpl.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_SearchDataTmpl.ibd.qp
160201 17:40:48 >> log scanned up to (841376038309)
160201 17:40:48 [03]        ...done
160201 17:40:48 [03] Compressing ./hank/tj_VisitDataTmpl.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_VisitDataTmpl.ibd.qp
160201 17:40:49 >> log scanned up to (841376038309)
160201 17:40:50 >> log scanned up to (841376038309)
160201 17:40:51 >> log scanned up to (841376038309)
160201 17:40:52 >> log scanned up to (841376038309)
160201 17:40:53 >> log scanned up to (841376038309)
160201 17:40:54 >> log scanned up to (841376038309)
160201 17:40:55 >> log scanned up to (841376038309)
160201 17:40:56 >> log scanned up to (841376038309)
160201 17:40:57 >> log scanned up to (841376038309)
160201 17:40:58 >> log scanned up to (841376038309)
160201 17:40:59 >> log scanned up to (841376038309)
160201 17:40:59 [02]        ...done
160201 17:40:59 [02] Compressing ./hank/tj_ComprehensiveStatistics.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_ComprehensiveStatistics.ibd.qp
160201 17:40:59 [02]        ...done
160201 17:40:59 [02] Compressing ./hank/tj_SeKeyWordsStatistics.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_SeKeyWordsStatistics.ibd.qp
160201 17:41:00 >> log scanned up to (841376038309)
160201 17:41:01 >> log scanned up to (841376038309)
160201 17:41:02 >> log scanned up to (841376038309)
160201 17:41:03 >> log scanned up to (841376038309)
160201 17:41:03 [04]        ...done
160201 17:41:03 [04] Compressing ./hank/tj_ItemSourceDetailStatistics.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_ItemSourceDetailStatistics.ibd.qp
160201 17:41:04 >> log scanned up to (841376038309)
160201 17:41:05 >> log scanned up to (841376038309)
160201 17:41:06 >> log scanned up to (841376038309)
160201 17:41:07 >> log scanned up to (841376038309)
160201 17:41:08 >> log scanned up to (841376038309)
160201 17:41:09 >> log scanned up to (841376038309)
160201 17:41:10 >> log scanned up to (841376038309)
160201 17:41:11 [04]        ...done
160201 17:41:11 [04] Compressing ./hank/tj_RegData.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_RegData.ibd.qp
160201 17:41:11 >> log scanned up to (841376038309)
160201 17:41:11 [04]        ...done
160201 17:41:11 [04] Compressing ./hank/FinancialProject.ibd to /my/bak//2016-02-01_17-40-42/hank/FinancialProject.ibd.qp
160201 17:41:11 [04]        ...done
160201 17:41:11 [04] Compressing ./hank/tj_OrdersItemAB.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_OrdersItemAB.ibd.qp
160201 17:41:12 >> log scanned up to (841376038309)
160201 17:41:13 [04]        ...done
160201 17:41:13 [04] Compressing ./hank/OperatAccountReport.ibd to /my/bak//2016-02-01_17-40-42/hank/OperatAccountReport.ibd.qp
160201 17:41:13 >> log scanned up to (841376038309)
160201 17:41:13 [04]        ...done
160201 17:41:13 [01]        ...done
160201 17:41:13 [04] Compressing ./hank/tj_LoginData.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_LoginData.ibd.qp
160201 17:41:13 [01] Compressing ./hank/tj_ItemData.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_ItemData.ibd.qp
160201 17:41:14 >> log scanned up to (841376038309)
160201 17:41:14 [04]        ...done
160201 17:41:14 [04] Compressing ./hank/Division.ibd to /my/bak//2016-02-01_17-40-42/hank/Division.ibd.qp
160201 17:41:15 [04]        ...done
160201 17:41:15 [04] Compressing ./hank/tj_Source.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_Source.ibd.qp
160201 17:41:15 >> log scanned up to (841376038309)
160201 17:41:15 [04]        ...done
160201 17:41:15 [04] Compressing ./hank/tj_AppInit.ibd to /my/bak//2016-02-01_17-40-42/hank/tj_AppInit.ibd.qp
160201 17:41:16 >> log scanned up to (841376038309)
160201 17:41:17 >> log scanned up to (841376038309)
160201 17:41:18 >> log scanned up to (841376038309)

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28939273/viewspace-1985295/，如需轉載，請註明出處，否則將追究法律責任。

相關文章