Ted Naleid somehow read my mind today from 4 years ago, and saved my sanity with the following very helpful tidbit, that you can just plug right into your terminal:
watch -n 5 --differences "mysql -u [username] -p[password] -e 'show processlist'"
Basically sets up a way to watch queries come in on your MySQL server. it doesn’t give you enough time to read them, but you should be able to see which of them are taking forever, and then take action accordingly. Happy Querying!
Get up and running with NGINX
A great primer to get started using NGINX, probably the best web server out there for open source stuff at this time:
You know they’ve got something killer when 1/5 of the top 1000 websites in the world use it, including Facebook, WordPress, and TechCrunch.