找到并打开 MySQL 配置文件，在 Ubuntu 上通常为 /etc/mysql/my.cnf。查找“日志记录和复制”部分
# * 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
Find and open your MySQL configuration file, usually /etc/mysql/my.cnf on Ubuntu. Look for the section that says “Logging and Replication”
# * 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
or in newer versions of mysql, comment OUT this lines of codes
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.
发布评论
评论（4）
Jet Profiler 是 mysql 的单一图形分析器。 查看评论< /a>
Single graphical profiler for mysql is Jet Profiler. see review
显示配置文件 或 EXPLAIN 可直接在 MySQL 中使用并提供大量信息。
我猜一些 MySQL gui 将能够以图形方式呈现它...
编辑：phpMyAdmin 也支持这一点，您只需要在显示的执行查询下启用分析，您可以在 演示服务器。
SHOW PROFILES or EXPLAIN are directly available in MySQL and provide tons of information.
I'm guess some MySQL gui will be able to present it graphically...
Edit: phpMyAdmin has support for this as well, you just need to enable profiling under displayed executed query, you can try that on demo server.
在mysql内部使用 EXPLAIN 怎么样？
What about using EXPLAIN right inside mysql?
找到并打开 MySQL 配置文件，在 Ubuntu 上通常为 /etc/mysql/my.cnf。查找“日志记录和复制”部分
，或者在较新版本的 mysql 中，注释掉这行代码
只需取消注释“log”变量即可打开日志记录。使用以下命令重新启动 MySQL：
sudo /etc/init.d/mysql restart
现在我们准备开始监视传入的查询。打开一个新终端并运行此命令来滚动日志文件，并在必要时调整路径。
Find and open your MySQL configuration file, usually /etc/mysql/my.cnf on Ubuntu. Look for the section that says “Logging and Replication”
or in newer versions of mysql, comment OUT this lines of codes
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.