blocks|key|1565100|text|我不知道是否有类似的分析应用程序，但使用EXPLAIN语法来分析查询是很常见的。您可以使用它们来找出要创建的最佳索引，或者您可以尝试更改整个查询，看看它如何改变效率，等等。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1565101|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I don't know about any profiling apps as such, but it's commonplace to use the EXPLAIN syntax for analysing queries. You can use these to figure out the best indexes to create, or you can try changing the overall query and see how it changes the efficiency, etc.

blocks|key|1780192|text|社区服务器5.0.37版中的一个很酷的特性是MySQL's+new+profiler。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1780193|这可能会给你提供你正在寻找的信息。|1780194|entityMap|0|LINK|mutability|MUTABLE|url|http://web.archive.org/web/20110609054749/http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html^0|M|K|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

Something cool that is in version 5.0.37 of the community server is <a href="http://web.archive.org/web/20110609054749/http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html" rel="noreferrer">MySQL's new profiler</a>. 

This may give you what info you are looking for.

blocks|key|1780272|text|如果5.0.37版不可用，您可能需要查看mytop。它只是输出服务器的当前状态，但允许您按照mercutio提到的方式对特定查询运行EXPLAIN。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1780273|entityMap|0|LINK|mutability|MUTABLE|url|http://jeremy.zawodny.com/mysql/mytop/^0|K|5|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If version 5.0.37 isn't available, you might want to look at <a href="http://jeremy.zawodny.com/mysql/mytop/" rel="nofollow noreferrer">mytop</a>. It simply outputs the current status of the server, but allows you to run EXPLAIN as (mentioned by mercutio) on particular queries.

blocks|key|1565288|text|您是想监视性能，还是只想查看哪些查询正在执行？如果是后者，您可以配置MySQL来记录它所给出的所有查询。在RedHat+Linux机器上，您可以添加|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1565289|log+=+/var/lib/mysql/query.log|offset|length|style|CODE|1565290|到/etc/my.cnf的mysqld部分，然后重启MySQL。|1565291|请记住，在繁忙的数据库场景中，这些日志可能会变得非常大。|1565292|entityMap^0|0|0|U|0|1|B|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

Are you wanting to monitor performance, or just see which queries are executing? If the latter, you can configure MySQL to log all queries it's given. On a RedHat Linux box, you might add

<code>log = /var/lib/mysql/query.log</code>

to the [mysqld] section of <code>/etc/my.cnf</code> before restarting MySQL.

Remember that in a busy database scenario, those logs can grow quite large.

blocks|key|1565330|text|如果是付费版本，Jet+Profiler就很好。LogMonitor只是将其指向mysql日志文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1565331|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Jet Profiler is good if it's a paid version. The LogMonitor just point it to the mysql log file.

blocks|key|1780404|text|JET+profiler是一个实时查询性能和诊断工具！我在工作中使用它。优秀的软件和支持。Review+Jet+Profiler+for+MySQL|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1780405|entityMap|0|LINK|mutability|MUTABLE|url|http://mysql-tools.com/en/overview-mysql-tools/73-other/91-review-jet-profiler-for-mysql.html^0|19|T|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Try JET profiler is a real-time query performance and diagnostics tool!
I use it in my work. Excellent software and support.
<a href="http://mysql-tools.com/en/overview-mysql-tools/73-other/91-review-jet-profiler-for-mysql.html">Review Jet Profiler for MySQL</a>

blocks|key|1780460|text|在我看来，我在raw找到了一切……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1780461|找到并打开你的MySQL配置文件，通常是Ubuntu上的/etc/mysql/my.cnf。查找“日志记录和复制”部分|1780462|#+*+Logging+and+Replication
#+Both+location+gets+rotated+by+the+cronjob.
#+Be+aware+that+this+log+type+is+a+performance+killer.

log+=+/var/log/mysql/mysql.log|code-block|syntax|javascript|1780463|或者在较新版本的mysql中，注释掉这几行代码|1780464|general_log_file++++++++=+/var/log/mysql/mysql.log
general_log+++++++++++++=+1
log_error++++++++++++++++=+/var/log/mysql/error.log|1780465|只需取消“log”变量的注释即可打开日志记录。使用以下命令重启MySQL+:+sudo+/etc/init.d/mysql+Restart|1780466|现在，我们已经准备好开始监视传入的查询。打开一个新的终端，运行此命令滚动日志文件，并在必要时调整路径。|1780467|tail+-f+/var/log/mysql/mysql.log|1780468|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|11|8|@]|9|@]|A|$G|H]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

In my opinion I've found everything here in raw....

Find and open your MySQL configuration file, usually /etc/mysql/my.cnf on Ubuntu. Look for the section that says “Logging and Replication”

<pre><code># * Logging and Replication
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.

log = /var/log/mysql/mysql.log
</code></pre>

or in newer versions of mysql, comment OUT this lines of codes

<pre><code>general_log_file = /var/log/mysql/mysql.log
general_log = 1
log_error = /var/log/mysql/error.log
</code></pre>

Just uncomment the “log” variable to turn on logging. Restart MySQL with this command:
 sudo /etc/init.d/mysql restart

Now we’re ready to start monitoring the queries as they come in. Open up a new terminal and run this command to scroll the log file, adjusting the path if necessary.

<pre><code>tail -f /var/log/mysql/mysql.log
</code></pre>

blocks|key|1565544|text|不确定图形用户界面，但有一个命令帮助我使用工作台在MySQL中分析了很多存储过程：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1565545|SET+profiling+=+1;
call+your_procedure;
SHOW+PROFILES;
SET+profiling+=+0;|code-block|syntax|javascript|1565546|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Not sure about graphical user interface but there is a command that has helped me profile stored procedures a lot in MySQL using workbench:

<pre><code>SET profiling = 1;
call your_procedure;
SHOW PROFILES;
SET profiling = 0;
</code></pre>

blocks|key|1780630|text|使用Neor+Profiler+SQL，非常棒！该应用程序对所有用户都是免费的。https://www.profilesql.com/download/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1780631|📷|atomic|1780632|​|1780633|entityMap|0|LINK|mutability|MUTABLE|url|https://www.profilesql.com/download/|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/af4aef282b18039b1795d7c2febb7f40.png|imageAlt^0|14|10|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|C|$]]|$1|I|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]|Q|$5|R|M|S|C|$T|U|V|-4]]]]

Using Neor Profiler SQL, is excellent! and the application is free for all users. <a href="https://www.profilesql.com/download/" rel="nofollow noreferrer">https://www.profilesql.com/download/</a> <a href="https://i.stack.imgur.com/F5lji.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F5lji.png" alt="image of query flow" /></a>

"Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services."

I find using SQL Server Profiler extremely useful during development, testing and when I am debugging database application problems. Does anybody know if there is an equivalent program for MySql?

Is there a Profiler equivalent for MySql?

日志文件

SQL Server

数据库

服务器

Ubuntu

MySQL

Linux

"Microsoft SQL Server事件探查器是SQL跟踪的图形用户界面，用于监视数据库引擎或Analysis Services的实例。“我发现在开发、测试和调试数据库应用程序问题时，使用SQL Server事件探查器非常有用。有没有人知道MySql有没有类似的程序？

问是否有用于MySql的Profiler等价物？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否有用于MySql的Profiler等价物？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否有用于MySql的Profiler等价物？
EN