Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.