“表格不支持优化，而是执行重新创建+分析"是什么?意思是? [英] What does "Table does not support optimize, doing recreate + analyze instead" mean?

问题描述

我正在使用MySQL 5.5，并尝试使用OPTIMIZE TABLE查询进行索引重建.我收到以下错误:

I am working on MySQL 5.5 and trying to do index rebuild using an OPTIMIZE TABLE query. I am getting the error below:

表不支持优化，而是进行重新创建+分析

Table does not support optimize, doing recreate + analyze instead

这是什么意思? MySQL引擎不允许索引重建吗?在MySQL 5.5 Engine级别上，此消息背后的内容是什么?

What does this mean? Is MySQL engine not allowing Index Rebuild? What is being done behind this message, at MySQL 5.5 Engine level?

推荐答案

那确实是一条信息性消息.

That's really an informational message.

就像，您正在对 InnoDB进行优化表(使用InnoDB存储引擎的表，而不是

Likely, you're doing OPTIMIZE on an InnoDB table (table using the InnoDB storage engine, rather than the MyISAM storage engine).

InnoDB不支持MyISAM支持的OPTIMIZE.它做一些不同的事情.它创建一个空表，并将现有表中的所有行复制到该表中，从本质上删除旧表并重命名新表，然后运行ANALYZE来收集统计信息.这是InnoDB可以进行最优化的最接近的结果.

InnoDB doesn't support the OPTIMIZE the way MyISAM does. It does something different. It creates an empty table, and copies all of the rows from the existing table into it, and essentially deletes the old table and renames the new table, and then runs an ANALYZE to gather statistics. That's the closest that InnoDB can get to doing an OPTIMIZE.

您收到的消息基本上是MySQL服务器，重复了InnoDB存储引擎告诉MySQL服务器的内容:

The message you are getting is basically MySQL server repeating what the InnoDB storage engine told MySQL server:

表不支持优化，InnoDB存储引擎说...

Table does not support optimize is the InnoDB storage engine saying...

我(InnoDB存储引擎)没有像我的朋友(MyISAM存储引擎)那样执行OPTIMIZE操作."

"I (the InnoDB storage engine) don't do an OPTIMIZE operation like my friend (the MyISAM storage engine) does."

改为进行重新创建+分析" 是InnoDB存储引擎说的...

"doing recreate + analyze instead" is the InnoDB storage engine saying...

我决定执行一组不同个操作，这些操作将获得相同的结果."

"I have decided to perform a different set of operations which will achieve an equivalent result."

这篇关于“表格不支持优化，而是执行重新创建+分析"是什么?意思是?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！