Put this somewhere in your ~/bin:
watch ‘echo “show processlist” | mysql -u whateveruser –password=mypassword | grep -v “show processlist” ‘
Now run it and you will have a poor man’s monitor, kind of like top but for MySQL. That coupled with screen (or multiple terminals) may give you some quick and easy piece of mind.

This […]