Percona-Xtrabackup 2.3.3 慢查詢依舊堵塞MariaDB備份（三）
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)
+---------------------+
| 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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 轉到MariaDB備份
- 慢查詢
- MySQL慢查詢MySql
- MySQL 慢查詢MySql
- mongodb慢查詢分析MongoDB
- MSSQL查詢收縮和備份進度SQL
- 詭異的”慢查詢“
- MySQL：慢查詢日誌MySql
- MySQL 慢查詢優化MySql優化
- MongoDB慢查詢與索引MongoDB索引
- SQL慢查詢排查思路SQL
- Greenplum邏輯備份增強-備份期間不鎖metadata(pg_class)，不堵塞DDL
- TiDB 查詢優化及調優系列（三）慢查詢診斷監控及排查TiDB優化
- 如何在Linux中執行MySQL/MariaDB查詢LinuxMySql
- RMAN備份恢復典型案例——RMAN備份&系統變慢
- 瑞士軍刀redis - 慢查詢Redis
- MySQL 慢查詢那點事MySql
- 【mysql】explain命令分析慢查詢MySqlAI
- [Mysql]慢查詢最佳化MySql
- 詳解MySQL--慢查詢MySql
- SnapshotService 查詢備份倉庫下所有快照 querySnapshotByRepo分析
- 使用 NineData 實現備份集的實時查詢
- 慢查詢日誌開啟分析
- 慢查詢分析調優工具～mysqldumpslowMySql
- MySQL慢查詢分析工具之mysqldumpslowMySql
- 資料庫查詢慢的原因資料庫
- Mysql 慢查詢優化實踐MySql優化
- HighgoDB查詢慢SQL和阻塞SQLGoSQL
- 快速學會慢查詢SQL排查SQL
- 故障分析 | 血的教訓-由慢查詢引發的備份等待導致資料庫連線打滿資料庫
- 關於MySQL 通用查詢日誌和慢查詢日誌分析MySql
- mysql查詢效率慢的SQL語句MySql
- LinkedList真的是查詢慢增刪快？
- mysql慢查詢，死鎖解決方案MySql
- mysql之 slow log 慢查詢日誌MySql
- 慢查詢分析調優工具～show profile
- Redis慢查詢日誌學習功能Redis
- SQL Server查詢慢的解決方案SQLServer
- MySQL Slow Query log(慢查詢日誌)MySql