MySql 查询分析器 - 免费解决方案
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/2056840/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MySql query analyzer - free solutions
提问by frank
Is there a good Query Analyzer for MySQL (that's either free, or has a trial), that can analyse a query and make suggestions for indexes, like the "Display estimated execution plan" in Microsoft SQL Server management studio?
是否有一个很好的 MySQL 查询分析器(免费或试用),可以分析查询并为索引提出建议,例如 Microsoft SQL Server 管理工作室中的“显示估计的执行计划”?
回答by Yaronius
You may want to try Percona tools for MySQL. Look at this article
您可能想尝试用于 MySQL 的 Percona 工具。看看这篇文章
回答by rap-2-h
Maybe "MySQL Explain Explain" can help (verbose version of MySQL EXPLAIN
command, forkable on github).
也许“ MySQL Explain Explain”可以提供帮助(MySQLEXPLAIN
命令的详细版本,可在github 上分叉)。