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.

Server overload problems

Discussion in 'General Discussion' started by Jan Klerks, Mar 30, 2004.

  1. Jan Klerks

    Jan Klerks Member

    Joined:
    Mar 30, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    I have about the same problems as this fellow, having a high swap causing the server load averaged to go up. (running a vBulletin 3 on it)

    I have:
    Processor #1 Vendor: GenuineIntel
    Processor #1 Name: Intel(R) Pentium(R) III CPU 1133MHz
    Processor #1 speed: 1135.366 MHz
    Processor #1 cache size: 256 KB

    Memory Information
    Memory: 509632k/523136k available (1269k kernel code, 11052k reserved, 90k data, 220k init, 0k highmem)

    This is my current my.cnf setting


    [mysqld]
    set-variable = max_connections=300
    set-variable = key_buffer=16M
    set-variable = myisam_sort_buffer_size=64M
    set-variable = join_buffer=1M
    set-variable = record_buffer=2M
    set-variable = sort_buffer=2M
    set-variable = table_cache=1024
    set-variable = thread_cache_size=64
    set-variable = wait_timeout=1800
    set-variable = connect_timeout=10
    set-variable = max_allowed_packet=16M
    set-variable = max_connect_errors=10

    [safe_mysqld]
    open_files_limit=8192

    [mysqldump]
    quick
    set-variable = max_allowed_packet=16M

    [myisamchk]
    set-variable = key_buffer=64M
    set-variable = sort_buffer=64M
    set-variable = read_buffer=16M
    set-variable = write_buffer=16M

    Anyone has any suggestions of this is correct?
     
  2. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    you could try by lowering the buffers.

    don't forget to restart mysql after that for the changes to take effect.
     
  3. Jan Klerks

    Jan Klerks Member

    Joined:
    Mar 30, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Any examples? Thanks,
     
  4. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    You wrote it yourself ;)

    [myisamchk]
    set-variable = key_buffer=64M
    set-variable = sort_buffer=64M
    set-variable = read_buffer=16M
    set-variable = write_buffer=16M


    Reduce the above values and see. Most of the time these values need to be tested where it is being implemented depending on the mysql load.
     
  5. cronjob78

    cronjob78 Member

    Joined:
    Feb 24, 2004
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    I had a problem like this with a phpBB message board and was going to upgrade to vBulletin as I thought the problem was specific to phpBB. vBulletin say the minimum amount of RAM you should have is 1GB. I had 128 MB so upgraded in preparation for the change over last week.

    The server is running fine now and the load rarely gets near 1.0. The messag eboards are never slow. It costs about $40/month for the extra RAM for me but its worth it. Do it and let us know how you get on. I might even go for 2GB.
     
  6. Jan Klerks

    Jan Klerks Member

    Joined:
    Mar 30, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Yep, upgrading server sure did the trick. :)
     
  7. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
    A gig of ram should be the minimum for hosting active database intensive websites.
     
Loading...

Share This Page