lately, i have noticed mysql running at high cpu %'s and i want to know the queries involved.
i know i can tail -f /var/log/httpd/access_log to find the latest apache hits.. there must be a way to do this for mysql.. any guru know??
cheers,
k.
SHOW PROCESSLIST;
I think...or click "show processes" in phpmyadmin.