Get the App
SLTechnology News&Howtos  ›  Database  › 

MySQL5.7.11 mysqlpump multithreaded logical backup tool

Shulou Source: shulou.com Published: 2022-06-01 04:44:49 10月03日 Update

2016.03.14

In order to experience the new experience of version 5.7.11, I can't wait to test the new features and features. What I've been thinking about these days is the 5.7.11 fixed version of mysqlpump. Before MySQL 5.7.11, officials also made it clear that mysqlpump does not support consistent backups.

Until 5.7.11 was fixed. One of the most interesting things is:

1. Support for multi-threaded table-based export (--default-parallelism, default is 2mai Mishi parallelism schemas, which controls parallel export libraries)

two。 Export with a progress bar (--watch-progress, enabled by default)

3. Support direct compression export import (parameter-compress-output, and support ZLIB and LZ4)

Database: MySQL 5.7.11

System: CentOS6.5 x64

Amount of test data: 6.1G

[root@zhangMySQL5711 mysql] # mysqlpump-uroot-pzhangmysql-- single-transaction-B zhangdb > pump.sqlDump progress: 0 tables, 250 tables 80745 rows

Dump progress: 16/165 tables, 770247/29474007 rows

Dump progress: 25/315 tables, 1209539/29521538 rows

Dump progress: 41/452 tables, 1543620/29526630 rows

Dump progress: 42/452 tables, 1817564/29526630 rows

Dump progress: 48/452 tables, 2391505/29526630 rows

Dump progress: 56/452 tables, 2803286/29526630 rows

Dump progress: 56/452 tables, 3238286/29526630 rows

Dump progress: 56/452 tables, 3604536/29526630 rows

Dump progress: 56/452 tables, 3877036/29526630 rows

Dump progress: 57/452 tables, 4176414/29526630 rows

Dump progress: 57/452 tables, 4462164/29526630 rows

Dump progress: 57/452 tables, 4599164/29526630 rows

Dump progress: 63/452 tables, 4874850/29526630 rows

Dump progress: 63/452 tables, 5162850/29526630 rows

Dump progress: 63/452 tables, 5454100/29526630 rows

Dump progress: 63/452 tables, 5779600/29526630 rows

Dump progress: 63/452 tables, 6112100/29526630 rows

Dump progress: 64/452 tables, 6733289/29526630 rows

Dump progress: 65/452 tables, 7091126/29526630 rows

Dump progress: 77/452 tables, 7461652/29526630 rows

Dump progress: 80/452 tables, 7807596/29526630 rows

Dump progress: 87/452 tables, 8185024/29526630 rows

Dump progress: 87/452 tables, 8430774/29526630 rows

Dump progress: 87/452 tables, 8689024/29526630 rows

Dump progress: 87/452 tables, 9076524/29526630 rows

Dump progress: 88/452 tables, 9193037/29526630 rows

Dump progress: 88/452 tables, 9414287/29526630 rows

Dump progress: 88/452 tables, 9539037/29526630 rows

Dump progress: 88/452 tables, 9730787/29526630 rows

Dump progress: 88/452 tables, 9924287/29526630 rows

Dump progress: 88/452 tables, 10018537/29526630 rows

Dump progress: 90/452 tables, 10391305/29526630 rows

Dump progress: 90/452 tables, 10655555/29526630 rows

Dump progress: 90/452 tables, 11472555/29526630 rows

Dump progress: 90/452 tables, 11803055/29526630 rows

Dump progress: 90/452 tables, 12692305/29526630 rows

Dump progress: 90/452 tables, 13109805/29526630 rows

Dump progress: 90/452 tables, 14025805/29526630 rows

Dump progress: 90/452 tables, 14462555/29526630 rows

Dump progress: 90/452 tables, 15162305/29526630 rows

Dump progress: 90/452 tables, 15678555/29526630 rows

Dump progress: 90/452 tables, 16001305/29526630 rows

Dump progress: 90/452 tables, 16508055/29526630 rows

Dump progress: 91/452 tables, 16948143/29526630 rows

Dump progress: 91/452 tables, 17045893/29526630 rows

Dump progress: 92/452 tables, 17193630/29526630 rows

Dump progress: 93/452 tables, 17236301/29526630 rows

Dump progress: 94/452 tables, 17243551/29526630 rows

Dump progress: 94/452 tables, 17377051/29526630 rows

Dump progress: 94/452 tables, 17424051/29526630 rows

Dump progress: 94/452 tables, 17518051/29526630 rows

Dump progress: 94/452 tables, 17611801/29526630 rows

Dump progress: 94/452 tables, 17657051/29526630 rows

Dump progress: 94/452 tables, 17776801/29526630 rows

Dump progress: 94/452 tables, 17828801/29526630 rows

Dump progress: 94/452 tables, 17972551/29526630 rows

Dump progress: 94/452 tables, 18036551/29526630 rows

Dump progress: 94/452 tables, 18116301/29526630 rows

Dump progress: 94/452 tables, 18155301/29526630 rows

Dump progress: 94/452 tables, 18209551/29526630 rows

Dump progress: 94/452 tables, 18328801/29526630 rows

Dump progress: 94/452 tables, 18378051/29526630 rows

Dump progress: 94/452 tables, 18480551/29526630 rows

Dump progress: 94/452 tables, 18509551/29526630 rows

Dump progress: 94/452 tables, 18624801/29526630 rows

Dump progress: 94/452 tables, 18719551/29526630 rows

Dump progress: 94/452 tables, 18789551/29526630 rows

Dump progress: 94/452 tables, 18888301/29526630 rows

Dump progress: 94/452 tables, 19020301/29526630 rows

Dump progress: 95/452 tables, 19070378/29526630 rows

Dump progress: 95/452 tables, 19211128/29526630 rows

Dump progress: 95/452 tables, 19269878/29526630 rows

Dump progress: 95/452 tables, 19373878/29526630 rows

Dump progress: 95/452 tables, 19437628/29526630 rows

Dump progress: 98/452 tables, 19515141/29526630 rows

Dump progress: 98/452 tables, 19588141/29526630 rows

Dump progress: 98/452 tables, 19627891/29526630 rows

Dump progress: 98/452 tables, 19701391/29526630 rows

Dump progress: 98/452 tables, 19723391/29526630 rows

Dump progress: 98/452 tables, 19788141/29526630 rows

Dump progress: 98/452 tables, 19819141/29526630 rows

Dump progress: 98/452 tables, 19888141/29526630 rows

Dump progress: 99/452 tables, 19928833/29526630 rows

Dump progress: 101/452 tables, 20142102/29526630 rows

Dump progress: 101/452 tables, 20237602/29526630 rows

Dump progress: 101/452 tables, 20407602/29526630 rows

Dump progress: 101/452 tables, 20537602/29526630 rows

Dump progress: 101/452 tables, 20656602/29526630 rows

Dump progress: 101/452 tables, 20811352/29526630 rows

Dump progress: 101/452 tables, 20874102/29526630 rows

Dump progress: 101/452 tables, 21031602/29526630 rows

Dump progress: 101/452 tables, 21131602/29526630 rows

Dump progress: 101/452 tables, 21278102/29526630 rows

Dump progress: 101/452 tables, 21352852/29526630 rows

Dump progress: 104/452 tables, 21527999/29526630 rows

Dump progress: 107/452 tables, 21630721/29526630 rows

Dump progress: 107/452 tables, 21649221/29526630 rows

Dump progress: 107/452 tables, 21723721/29526630 rows

Dump progress: 107/452 tables, 21758471/29526630 rows

Dump progress: 107/452 tables, 21836471/29526630 rows

Dump progress: 107/452 tables, 21916221/29526630 rows

Dump progress: 107/452 tables, 21944721/29526630 rows

Dump progress: 107/452 tables, 22014721/29526630 rows

Dump progress: 107/452 tables, 22048221/29526630 rows

Dump progress: 107/452 tables, 22111471/29526630 rows

Dump progress: 107/452 tables, 22179471/29526630 rows

Dump progress: 107/452 tables, 22217221/29526630 rows

Dump progress: 107/452 tables, 22288721/29526630 rows

Dump progress: 107/452 tables, 22319221/29526630 rows

Dump progress: 107/452 tables, 22380221/29526630 rows

Dump progress: 107/452 tables, 22411971/29526630 rows

Dump progress: 107/452 tables, 22488721/29526630 rows

Dump progress: 107/452 tables, 22551471/29526630 rows

Dump progress: 107/452 tables, 22570971/29526630 rows

Dump progress: 107/452 tables, 22643471/29526630 rows

Dump progress: 107/452 tables, 22706221/29526630 rows

Dump progress: 108/452 tables, 22744342/29526630 rows

Dump progress: 108/452 tables, 23085342/29526630 rows

Dump progress: 108/452 tables, 23403092/29526630 rows

Dump progress: 108/452 tables, 23601842/29526630 rows

Dump progress: 108/452 tables, 23852342/29526630 rows

Dump progress: 112/452 tables, 23894226/29526630 rows

Dump progress: 117/452 tables, 23968536/29526630 rows

Dump progress: 117/452 tables, 23998786/29526630 rows

Dump progress: 117/452 tables, 24059286/29526630 rows

Dump progress: 117/452 tables, 24125286/29526630 rows

Dump progress: 124/452 tables, 24249875/29526630 rows

Dump progress: 127/452 tables, 24460692/29526630 rows

Dump progress: 129/452 tables, 24534638/29526630 rows

Dump progress: 130/452 tables, 24820991/29526630 rows

Dump progress: 130/452 tables, 25212491/29526630 rows

Dump progress: 130/452 tables, 25386241/29526630 rows

Dump progress: 131/452 tables, 25774761/29526630 rows

Dump progress: 131/452 tables, 26173761/29526630 rows

Dump progress: 138/452 tables, 26861561/29526630 rows

Dump progress: 141/452 tables, 27331040/29526630 rows

Dump progress: 142/452 tables, 27605532/29526630 rows

Dump progress: 143/452 tables, 28430203/29526630 rows

Dump progress: 143/452 tables, 28635953/29526630 rows

Dump progress: 143/452 tables, 29262703/29526630 rows

Dump progress: 143/452 tables, 29533453/29526630 rows

Dump progress: 178/452 tables, 29859085/29526630 rows

Dump progress: 351/452 tables, 29910716/29526630 rows

Dump completed in 187454 milliseconds

[root@zhangMySQL5711 mysql] the next article details the use of mysqlpump tools.

Tags: Support that is data experience testing backup tools threads consistency impatience consistency functionality parameters Tianxin official database new features time most version Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker MariaDB vpn Redmi Linux

Related Articles