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.

Mysqld constantly crashing

Discussion in 'General Discussion' started by JamesSmith, Apr 22, 2004.

  1. JamesSmith

    JamesSmith Well-Known Member

    Joined:
    Sep 17, 2003
    Messages:
    185
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    UK, Luton
    Since the 9.2.0-S29 update a few days ago, one of our web servers is having a problem with mysqld constantly crashing.

    Mysqld shoots to 99% cpu / mem, no one can then connect to mysql, databases appear missing in CPanel etc. Restarting it fixes it, but its happening every few hours.

    Sometimes theres a few wrapping processes, and mysqldadmin processes on the server when its crashed. Could there be a bug being caused by people accessing CPanel / PHPMyAdmin?

    Server is at this minute is running MySQL 4.0.17, I am running fixmysqlbsd, which by the looks of it is updating it to MySQL 4.0.18.

    Server is running FreeBSD 4.8 RELEASE.

    Anyone have ideas?
     
  2. ehsanix

    ehsanix Member

    Joined:
    Mar 3, 2004
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    I have the same problem on both redhat 9 and enterprize server with cpanel runing.

    from yesterday morning I have the exact problem.

    As I checked mysqladmin process list at the time of crach there where a lot of processes querying at the same time and doesnt go away !!!!

    Also it doesnt let me to restart mysql service. I had to kill mysql proces in WHM !!!!
     
  3. JamesSmith

    JamesSmith Well-Known Member

    Joined:
    Sep 17, 2003
    Messages:
    185
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    UK, Luton
    Upgrading to MySQL 4.0.18 hasnt fixed the problem.

    Gone back to Panel 9.2.0-R27, prob is still there.

    I think this is a bug.
     
  4. JamesSmith

    JamesSmith Well-Known Member

    Joined:
    Sep 17, 2003
    Messages:
    185
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    UK, Luton
    Need a fix ASAP, this is getting laborious.
     
  5. vandal

    vandal Member

    Joined:
    May 14, 2004
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    what ever happend with this?
     
  6. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    check the mysql error log file to see why it's crashing. Usually in the /var/lib/mysql folder called hostname.err.

    Mickalo
     
  7. vandal

    vandal Member

    Joined:
    May 14, 2004
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    i'm not having this problem, just wondering what happend with resolving this/what was causing this
     
  8. JamesSmith

    JamesSmith Well-Known Member

    Joined:
    Sep 17, 2003
    Messages:
    185
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    UK, Luton
    Hi,

    If I remember rightly caused by a ton of mysql sleep processes by a site with extremely poor coding.

    That site was removed from the server.
     
  9. vandal

    vandal Member

    Joined:
    May 14, 2004
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    so it had nothing to do with cpanel? was just a fluke that it happend at the same time as a mysql update?
     
  10. JamesSmith

    JamesSmith Well-Known Member

    Joined:
    Sep 17, 2003
    Messages:
    185
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    UK, Luton
    I believe so yes,
     
  11. Doctor

    Doctor Well-Known Member

    Joined:
    Apr 26, 2003
    Messages:
    180
    Likes Received:
    0
    Trophy Points:
    16
    I don't think this is any fluke.

    My MySQL crashes after recompiling Apache and upgrading CPanel as well. This happens to all my servers. Apparently, MySQL processes don't die and they just run until the load and memory accumulates to a level that it crashes the MySQL server. Please help.
     
  12. duranduran

    duranduran Well-Known Member

    Joined:
    Apr 30, 2004
    Messages:
    198
    Likes Received:
    0
    Trophy Points:
    16
    Hi, In your /usr/local/lib/php.ini

    found mysql.allow_persistent=On

    and setup mysql.allow_persistent=Off

    Then execute :

    service httpd restart
     
Loading...

Share This Page