The output from 'mysqladmin processlist' looks like this:
+-------+------+-----------+-------+---------+------+-------------------+------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------+-----------+-------+---------+------+-------------------+------------------------+
| 4411 | root | localhost | mydb1 | Sleep | 86 | | |
| 12911 | root | localhost | mydb1 | Sleep | 50 | | |
| 65142 | root | localhost | mydb1 | Query | 4 | copy to tmp table | OPTIMIZE TABLE my_tble |
| 65428 | root | localhost | | Query | 0 | | show processlist |
+-------+------+-----------+-------+---------+------+-------------------+------------------------+
From an 'Id' value in that table, how can I trace back to the PID of the process which created the connection, to figure out who is doing what? All the connections are via a local socket.