CODEWITHSUNDEEP
mysql
vinny
vinny

Reputation: 165

how to check the queries that are currently running in my mysql database?

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 ?

Upvotes: 1

Views: 4399

Answers (1)

Sahil Muthoo
Sahil Muthoo

Reputation: 12496

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

Upvotes: 3

Related Questions