Syntax:
SHOW [FULL] PROCESSLIST

SHOW PROCESSLIST shows you which threads are running. You can also get
this information using the mysqladmin processlist command. If you have
the PROCESS privilege, you can see all threads. Otherwise, you can see
only your own threads (that is, threads associated with the MySQL
account that you are using). If you do not use the FULL keyword, only
the first 100 characters of each statement are shown in the Info field.

URL: http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html

