G
Gerad
Guest
I have a MySQL database server and the load really spiked for about 30 minutes or so... I have no clue how or why it happened. Any thoughts on how I can track down the query that was causing the problem?
mysql> SHOW FULL PROCESSLIST\G
# mysql -u root -p -e 'show FULL processlist;' | grep -vi sleep | awk 'BEGIN { FS = "\t" } ; {print $6,$3,$4}' | sort -n
[root@delta ~]# netstat -ntp | grep 78983036