topcommand, but without any of the bells and whistles?
Well, here you go:
> while [[ 1 ]];
mysql -u <username> -p<password> -h <host> -e "show full processlist";
Remember to replace the <username> <password> and <host> variables with the values for your database. Also, if you don't like the bounding box on the mysql output, you can have a cleaner output by using redirection instead of the -e flag:
mysql -u <username> -p<password> -h <host> <<< "show full processlist";