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 load

Discussion in 'Database Discussions' started by Runtime, Aug 3, 2005.

  1. Runtime

    Runtime Member

    Joined:
    Jun 28, 2005
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Today MySQL overloaded the server for around 1h.
    To be more precise all the connections permitted from the /etc/my.cnf file
    were opened.

    I've fixed the problem with MySQL restart. However, the thing I need to know is which users has
    caused this (or which user script). Before restarting the MySQL I used the mtop command, but this did not work since mtop requires at least 1 free connection to MySQL.

    There's no mysql.log :(

    My question is from where I can see information about past events ?

    I tried with sa -m -c | less, but the information there did not help me to solve this case.

    Any ideas are appreciated. Thanks !
     
  2. abubin

    abubin Well-Known Member

    Joined:
    Dec 7, 2004
    Messages:
    393
    Likes Received:
    1
    Trophy Points:
    18
    you can try look in the processes tab under phpmyadmin. It does show who is accessing mysql at that instance.
     
  3. Runtime

    Runtime Member

    Joined:
    Jun 28, 2005
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    I did that, but it does show who access it on the moment, and I need information about past events. :(
     
Loading...

Share This Page