Where can I find running queries using the command line?

[Tim Hancock]

Hi All,

I'm trying to find out which queries are currently running on our MySQL database. We are using 5.0.15 on a remote Linux box so we can't use the MySQL Administrator to see the slow running query report.

I have a problem with users reporting slow response times and I need to see what is happening on the database server to diagnose the cause.

Any pointers would be greatly appreciated.

Thanks,

Tim.

EDIT: Don't worry, I have found what I needed by reading the slow query log file.



Edited 1 time(s). Last edit at 12/21/2005 08:31AM by Tim Hancock.