Showing running processes is easy, just log in to the MySQL command line and issue ‘SHOW PROCESSLIST;’
mysql> SHOW PROCESSLIST;
+———-+——+————————-+————+———+——+———-+———————————————————————————————–+
| Id | User | Host | db | Command | Time | State | Info |
+———-+——+————————-+————+———+——+———-+———————————————————————————————–+
| 66041116 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST |
| 66042322 | sql | www.adampalmer.me/iodigitalsec:57281 | websonline | Query | 1 | Updating | UPDATE `video_tags` SET `quantity` = ’27’ WHERE CONVERT( `tag` USING utf8 ) = ‘sport’ LIMIT 1 |
+———-+——+————————-+————+———+——+———-+———————————————————————————————–+
2 rows in set (0.00 sec)

You can also use ‘SHOW’ to display a wide range of information: http://dev.mysql.com/doc/refman/5.0/en/show.html