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

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...