What is the MySQL equivalent of PostgreSQL's EXPLAIN ANALYZE
I'd like to get a detailed query plan in MySQL similar to EXPLAIN ANALYZE shows in PostgreSQL. Is there an equivalent?
EDIT: While not a direct equivalent or as detailed as Explain Analyze here are some tools that you can look at
mysql offers EXPLAIN and procedure analyse()
http://dev.mysql.com/doc/refman/5.0/en/explain.html
http://dev.mysql.com/doc/refman/5.0/en/procedure-analyse.html
在MySQL有EXPLAIN EXTENDED之前，我没有使用过PostgreSQL，它比EXPLAIN提供的信息更多，并且可能会给你提供你正在寻找的信息。
just for clarity, comment on accepted answer (don't have enough karma to add comment)
procedure analyse() is for a different purpose that EXPLAIN, it analyzes the data set of specified column and suggests the best data type, ie it's useful when we have 1000 rows of varchar(255) and want to check how much length do we really need, fe it might tell that varchar(23) would suffice
链接地址: http://www.djcxy.com/p/54928.html上一篇: 错误仅与相关