MySQL ProcessList

[AlaskanWolf]

I know there has to be some configuration\'s messed up on some of my servers

When i do a mysqladmin processlist in shell (right after i do a top and show more then 1 mysql process running)

nothing shows up, just

+-------+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------+-----------+----+---------+------+-------+------------------+
| 20085 | root | localhost | | Query | 0 | | show processlist |
+-------+------+-----------+----+---------+------+-------+------------------+

likewise in the WHM

Now these boxes have more then 100 customers on them, and i know there quite a few sql databases running etc...it has to show at least something.....

[feanor]

I've actually got the same issue on a few machines....
I'd imagine it either means permissions are skewed someplace where it is looking for a socket file / the sql server isn't being used / or the backend sql admin scripts didn't get upgraded along with the rpm that took the engine to 3.23.45.

Researching beginning now.....

[asmithjr]

I checked the Show MySQL Processes in WHM today and noticed several users had ID that were showing sleep times in the sleep column.

+------+-----------+-----------+-------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-----------+-----------+-------------+---------+------+-------+------------------+
| 7513 | mailwatch | localhost | mailscanner | Sleep | 81 | | |
| 7517 | mailwatch | localhost | mailscanner | Sleep | 4 | | |
| 7518 | root | localhost | | Query | 0 | | show processlist |
+------+-----------+-----------+-------------+---------+------+-------+------------------+


Not much information in the forum for this.
All appear to be from the Open-Realty product from open-realty.org.
I did a search on their forum and found nothing also.

Would it be wise to kill the processes using
mysqladmin kill ID
?

I killed them but left the mailwatch ones here as an example.