MySQL 中文网

不小心点到头条，没看都两年前的贴了 。~。~
MySQL 版本 5.1.31

Test >> show global variables like 'myisam_repair_threads';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| myisam_repair_threads | 2 |

Test >> repair table t1;
+---------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------+--------+----------+----------+
| Test.t1 | repair | status | OK |
+---------+--------+----------+----------+
1 row in set (7.92 sec)

Test >> show global variables like 'myisam_repair_threads';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| myisam_repair_threads | 7 |

Test >> repair table t1;
+---------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------+--------+----------+----------+
| Test.t1 | repair | status | OK |
+---------+--------+----------+----------+
1 row in set (5.24 sec)

虚拟机测得，repair耗时有点长。