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 is crashing my computer

Discussion in 'General Discussion' started by traian20031, Jan 27, 2004.

  1. traian20031

    traian20031 Registered

    Joined:
    Aug 30, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hi,
    I have a server that currently runs WHM 8.6.0, cPanel 8.7.0-R26, and RH9.

    The problem is that the server is always overloaded (Server Load 2.21 (1 cpu) ) and I found it to be due to MySQL. Now I've update MySQL to the newest version (4.0.17) and it still overloads. I used it on two different servers and both seem to crash everyday or so...

    Both servers were/is P4 2.4GHz/1GB RAM. I have a huge forum that loads music and pictures constantly but it is not a reason to crash the server that often. This is what CPU Usage shows:
    789 root 0 99.9 0.1 /usr/local/apache/bin/httpd-DSSL

    913 mysql 0 99.9 1.5 /usr/sbin/mysqld--basedir=/--datadir=/var/lib/mysql--user=mysql--pid-file=/var/lib/mysql/server.XXXXXXXXXX.net.pid--skip-locking--socket=/var/lib/mysql/mysql.sock


    What I was thinking is that I should allow less resources to MySQL but I don't know how to do that.
    When I check my.cnf it shows the follwing:
    ________________________________
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    _________________________________

    Anyhelp will be greatly appreciated...
     
  2. twhiting9275

    twhiting9275 Well-Known Member

    Joined:
    Sep 26, 2002
    Messages:
    538
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Here's a sample my.cf, works pretty good for me.
    That does a lot of the "optimization" for you, but if you don't have a server with decent stats, and run constant queries, then you're going to have problems.
     
  3. maverick

    maverick Well-Known Member

    Joined:
    Jan 6, 2003
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    Thanks for posting that up. To give it some context though, could you let us know what the specs are of your server (RAM/CPU)?

    Mav.
     
  4. traian20031

    traian20031 Registered

    Joined:
    Aug 30, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    thanks, I'm going to try this for a while see how it works out for me.
     
Loading...

Share This Page