MySQL - 'optimise' 函数？

Question

我注意到在 phpMyAdmin 中，您可以在表上单击“优化”，它会运行:

OPTIMIZE TABLE table_name

这实际上是做什么的？

我是否应该每天运行一些 cron 作业来在我的表上运行 OPTIMIZE TABLE？

谢谢

Answer 1

来自 InformIT

An optimized table structure is different than a well-designed table. Table structure optimization has to do with reclaiming unused space after deletions and basically cleaning up the table after structural modifications have been made. The OPTIMIZE SQL command takes care of this, using the following syntax:

OPTIMIZE TABLE table_name[,table_name]

把它想象成对你的表格进行碎片整理。 cron 作业可能是个好主意，但在低负载/无负载期间执行它，因为它会锁定表。