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 killing my server

Discussion in 'General Discussion' started by Sykoi, Jul 21, 2006.

  1. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    For the past month+, MySQL has been making my server use nearly all of its CPU and RAM, and I, along with numerous others - have no idea what to do. So I have turned to cPanel forums.
    Here is the post I made on WHT.

    I am currently using MySQL 4.0.27 (I think), and have updated the PHP module to the latest version, but have no idea how to update my server's MySQL to the latest version.



    Thanks in advanced, and sorry for asking such simple questions, my Sysadmins are currently out of town and both have been unable to fully fix this problem.
     
  2. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    This is a very important problem, can anyone help me?

    A process I found running that I have not seen til today:
     
    #2 Sykoi, Jul 30, 2006
    Last edited: Jul 30, 2006
  3. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    I just tracked the MySQL process and heres the results:
    (Thats only a few % of the full track report)
     
  4. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    This issue has been discussed many times in these forums. It is unlikely to be a MySQL problem. You might have insecure scripts looping indefinitely killing your server. You need to track down these scripts and either patch or secure them.
     
  5. Kerstin

    Kerstin Well-Known Member

    Joined:
    Apr 9, 2005
    Messages:
    136
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Berlin
    I think alike . Even though, many factors are determining to killing your machine.
    Background processes, hardware and so on. I have similar problems like this but ground the is unknown. :(
     
  6. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    You were right... I finally got around to checking what queries were being ran on my server, and I tracked down a guestbook which was insecure and allowed anyone to post to it... Needless to say, it had over 20mb of signatures from spammers, and was being loaded into memory every time someone new posted (Several times a day)

    Also, I updated to MySQL 5.0 (Was using 4.0.27, a severely out of date and exploit-filled version), and want to update phpmyadmin... Is there an automated way through WHM?
     
    #6 Sykoi, Aug 2, 2006
    Last edited: Aug 2, 2006
  7. Kerstin

    Kerstin Well-Known Member

    Joined:
    Apr 9, 2005
    Messages:
    136
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Berlin
    What you mean with signatures from spammers ? ;)
    It is a problem of your own configuration of your machine if you have spamming problems.

    Ckeck out his link:

    http://aromal.net/

    You should block and identify the ip adresses by a firewall of your spammers.
     
Loading...

Share This Page