AlaskanWolf

Well-Known Member
Aug 11, 2001
537
0
316
Fremont CA
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

Well-Known Member
Aug 13, 2001
836
0
316
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 :p / 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

Well-Known Member
Jun 13, 2003
510
5
168
mysqladmin processlist

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.