The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL ProcessList

Discussion in 'General Discussion' started by AlaskanWolf, Feb 5, 2002.

  1. AlaskanWolf

    AlaskanWolf Well-Known Member

    Joined:
    Aug 11, 2001
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    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.....
     
  2. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    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.....
     
  3. asmithjr

    asmithjr Well-Known Member

    Joined:
    Jun 13, 2003
    Messages:
    468
    Likes Received:
    1
    Trophy Points:
    18
    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.
     
Loading...

Share This Page