Can MySql Crash Out of the Blue with No Reason

Discussion in 'Site & Server Administration' started by NetHostia, Nov 3, 2008.

  1. #1
    I have a site on a dedicated, has been running smoothly for 2 months now, and suddenly with no reason, the site slowed down dramatically.

    I checked to make sure it wasn't a ddos, and concluded that it wasn't a ddos since the apache wasn't overloaded and the site is still up but just take a long time to load.

    I got a feeling it's something to do with Mysql but can't find the problem.

    Can someone help? I can pay $$$, by the way it's running CentOS, DirectAdmin
     
    NetHostia, Nov 3, 2008 IP
  2. Christian Little

    Christian Little Peon

    Messages:
    1,753
    Likes Received:
    80
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Run the following query in MysqL: "show processlist"

    That will show you all the users connected to MySQL and what they are doing at that exact second. If you see any that look suspicious, then type "kill xx" where xx is the ID of that user. That will kick them off the server.

    What you could have is a bunch of zombie processes running wild on your database, which would slow it down if you have a lot of them.
     
    Christian Little, Nov 3, 2008 IP
  3. Mxhub

    Mxhub Active Member

    Messages:
    474
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    55
    #3
    Sometimes, you have to repair database ..This will improve the performance after that.

    A full check on your server is require since we are not sure whether it is mysql causing the problem..

    --
    joseph
     
    Mxhub, Nov 3, 2008 IP