Tons of mysql processes how to find the table and mysql commands used?

[postcd]

Hello,

when i run htop command i see alot of mysql processes like this:



But when i run command "mysqladmin processlist" i see usually nothing..

Quote:
[root@* ~]# mysqladmin processlist
+--------+------+-----------+-----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------+-----+---------+------+-------+------------------+
| 455317 | hqs | localhost | hqs | Sleep | 3 | | |
| 455320 | hqs | localhost | hqs | Sleep | 0 | | |
| 455321 | root | localhost | | Query | 0 | | show processlist |
+--------+------+-----------+-----+---------+------+-------+------------------+
so i want to ask how can i track what are these mysql processes that i see in htop, so i see which db and which table is used?

Continue reading...