如何检查我的mysql数据库中当前运行的查询？

I am trying to figure out a way to know all the queries which are slowing my database. I used the command SHOW PROCESSLISTand 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 PROCESSLIST，它只显示命令部分下的BLOB。我怎样才能看到花费最多时间的实际查询以及运行它们的人员？

1 个解决方案

#1

SHOW FULL PROCESSLIST\G should show you queries, users and source IP addresses.

显示完整的PROCESSLIST \ G应该显示查询，用户和源IP地址。