如何检查我的mysql数据库中当前正在运行的查询? [英] how to check the queries that are currently running in my mysql database?
本文介绍了如何检查我的mysql数据库中当前正在运行的查询?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试找出一种方法来了解所有使我的数据库变慢的查询.我使用了命令SHOW PROCESSLIST
,它在命令部分下仅显示BLOB.我如何查看耗时最多且由谁运行的实际查询?
I am trying to figure out a way to know all the queries which are slowing my database. I used the command SHOW PROCESSLIST
and it shows only BLOB under command section. How I can I see the actual queries which are taking most time and who is running them ?
推荐答案
SHOW FULL PROCESSLIST\G
应该向您显示查询,用户和源IP地址.
SHOW FULL PROCESSLIST\G
should show you queries, users and source IP addresses.
这篇关于如何检查我的mysql数据库中当前正在运行的查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文