命令行来优化mysql数据库中的所有表

.

0

linux命令:mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | gawk '{print "optimize table " $1 ";"}' | mysql -u uname dbname dbname uname -u mysql | ";"}' $1 " table "optimize '{print gawk | "+" -v grep | Tables_in -v grep | tables" "show -e dbname uname -u mysql mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | gawk '{print "optimize table " $1 ";"}' | mysql -u uname dbnamerootopen.com
linux命令:mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | gawk '{print "optimize table " $1 ";"}' | mysql -u uname dbname dbname uname -u mysql | ";"}' $1 " table "optimize '{print gawk | "+" -v grep | Tables_in -v grep | tables" "show -e dbname uname -u mysql mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | gawk '{print "optimize table " $1 ";"}' | mysql -u uname dbnamerootopen.com
zvaw 2018-02-02 13:58:48
输出

评论

相关推荐
共收录0条命令行
这里是记录和分享命令行的地方, 所有命令行都可以进行评论、提交替代方案.

热门文章