阿里云-云小站(无限量代金券发放中)
【腾讯云】云服务器、云数据库、COS、CDN、短信等热卖云产品特惠抢购

MySQL5.7.11 mysqlpump 多线程逻辑备份工具

152次阅读
没有评论

共计 7427 个字符,预计需要花费 19 分钟才能阅读完成。

为了体验 MySQL5.7.11 版本带来的新体验,俺也是迫不及待的想测试一下,新的特性和新功能。这几天心里一直想着的就是 MySQL5.7.11 修复版的 mysqlpump。在 MySQL 5.7.11 之前官方也明确说了 mysqlpump 不支持一致性备份。

直到 MySQL5.7.11 中被修复了。其中最为有看点的就是:
1. 支持基于表的多线程导出功能 (–default-parallelism,默认为 2,–parallel-schemas,控制并行导出的库)
2. 导出的时候带有进度条(–watch-progress,默认开启)
3. 支持直接压缩导出导入(参数 –compress-output,而且支持 ZLIB 和 LZ4)

MySQL 5.7 mysqlpump 备份工具说明   见 http://www.linuxidc.com/Linux/2016-08/134468.htm

数据库:MySQL 5.7.11
系统:CentOS6.5 x64
测试数据量:6.1G

[root@linuxidcMySQL5711 mysql]#mysqlpump -uroot -plinuxidcmysql –single-transaction -B linuxidcdb >pump.sql
Dump progress: 0/4 tables, 250/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@linuxidcMySQL5711 mysql]

本文永久更新链接地址 :http://www.linuxidc.com/Linux/2016-08/134467.htm

正文完
星哥玩云-微信公众号
post-qrcode
 0
星锅
版权声明:本站原创文章,由 星锅 于2022-01-22发表,共计7427字。
转载说明:除特殊说明外本站文章皆由CC-4.0协议发布,转载请注明出处。
【腾讯云】推广者专属福利,新客户无门槛领取总价值高达2860元代金券,每种代金券限量500张,先到先得。
阿里云-最新活动爆款每日限量供应
评论(没有评论)
验证码
【腾讯云】云服务器、云数据库、COS、CDN、短信等云产品特惠热卖中