MySQL in a Nutshell

Name

mysql_list_processes( )

Synopsis

mysql_list_processes([connection])

This returns a results set containing information on the server threads for the current connection: the connection identifier, the hostname, the database name, and the command. An identifier may be given to retrieve information for a different connection.

...
$processes = mysql_list_processes($connection);
while ($row = mysql_fetch_array($processes)){
   print "$row['Id'], $row['Host'],
          $row['db'], $row['Command']";
}
...