Mysql 优化存储3

franket

发布于 2022-03-21 18:28:33

3370

结果是类似这样的

[root@opti-slave tmp]# cat optimize.sql 
optimize table azheng_db.answers;
optimize table azheng_db.feedbacks;
optimize table azheng_db.logged_exceptions;
optimize table azheng_db.question_answers;
optimize table azheng_db.questions;
optimize table azheng_db.rule_answers;
optimize table azheng_db.rule_feedbacks;
...
...
...

执行优化

[root@opti-slave hunter]# time nohup  mysql -u root -p  < optimize.sql   2>&1  >> optim.log
nohup: redirecting stderr to stdout
Enter password:

输入密码后，就开始了优化过程

可以另开一个终端进行监视

[root@opti-slave hunter]# tail -f optim.log 
bat_db.spec_items	optimize	status	OK
Table	Op	Msg_type	Msg_text
...
...
...

也可以使用 show processlist 在数据库里查看当前状态

mysql> show processlist;
+----+------+-----------+------+---------+------+-------------------+-----------------------------------------+-----------+---------------+
| Id | User | Host      | db   | Command | Time | State             | Info                                    | Rows_sent | Rows_examined |
+----+------+-----------+------+---------+------+-------------------+-----------------------------------------+-----------+---------------+
| 24 | root | localhost | NULL | Query   |   21 | copy to tmp table | optimize table func_db.sport_stat_items |         0 |             0 |
| 29 | root | localhost | NULL | Query   |    0 | init              | show processlist                        |         0 |             0 |
+----+------+-----------+------+---------+------+-------------------+-----------------------------------------+-----------+---------------+
2 rows in set (0.01 sec)

mysql>

本文系转载，前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

数据库