Java开发网 - 数据库所有表刚刚优化，应该比较快了

Topic: 数据库所有表刚刚优化，应该比较快了

1.数据库所有表刚刚优化，应该比较快了

Posted by: 阿熊
Posted on: 2003-08-29 13:51

使用EMS MySQL
To call the Optimize Tables Wizard select the Services | Optimize Tables menu item.

OPTIMIZE TABLE works the following way:
· if the table has deleted or split rows, repair the table;

· if the index pages are not sorted, sort them;

· if the statistics are not up to date (and the repair couldn't be done by sorting the index), update them.

2.Re:数据库所有表刚刚优化，应该比较快了 [Re: zua]	Copy to clipboard
Posted by: davidself Posted on: 2003-08-30 01:58 的确快了一些，谢谢。

3.Re:数据库所有表刚刚优化，应该比较快了 [Re: zua]	Copy to clipboard
Posted by: sopato Posted on: 2003-09-07 01:10 呵呵，定时优化，保持状态！！！

4.Re:数据库所有表刚刚优化，应该比较快了 [Re: zua]	Copy to clipboard
Posted by: payaqa Posted on: 2003-09-07 14:09 不过我有一次在自己机器上优化表，把表弄坏了。

5.Re:数据库所有表刚刚优化，应该比较快了 [Re: zua]	Copy to clipboard
Posted by: 阿熊 Posted on: 2003-09-07 15:36 所以要先备份再优化优化期间要关闭mysql

6.Re:数据库所有表刚刚优化，应该比较快了 [Re: zua]	Copy to clipboard
Posted by: NeoBSD Posted on: 2003-09-20 18:25 EMS MySQL用着怎么样?