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 Usuage Rocketing

Discussion in 'General Discussion' started by Millar, Jan 7, 2007.

  1. Millar

    Millar Active Member

    Joined:
    Dec 23, 2006
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    My serer useage is always in the black zone. Meaning sometimes cpanel and WHM won't load because there is not enough memory left.

    This is what is in the black zone:
    ID Current Use Soft Limit Hard Limit Units Description
    privvmpages 97,891 98,304 104,448 4KB pages Memory allocation limit

    When I shut down my MySQL server, it is fine but it seems MySQL server is eating loads of memory. Is this normal or is there a way to lower the amount of memory used?
     
  2. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,577
    Likes Received:
    40
    Trophy Points:
    48
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    you need to tune your mysql server /etc/my.cnf

    there are plenty of how too's on the form
     
  3. Millar

    Millar Active Member

    Joined:
    Dec 23, 2006
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    It's kind of bear at the moment, this is it:
    I think maybe none of that can be configured to save mem?

    Could anyone like post a more detailed one so that I can make modifications?
     
  4. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,577
    Likes Received:
    40
    Trophy Points:
    48
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    here is one I use for a 512MB sever edit to suit your needs as every server is different depending your usage


    [mysqld]
    max_connections = 500
    key_buffer = 150M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 1M
    table_cache = 1500
    thread_cache_size = 128
    wait_timeout = 14400
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1
    skip-innodb

    [mysqld_safe]
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M
     
  5. Millar

    Millar Active Member

    Joined:
    Dec 23, 2006
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    NVM, found one and it has solved the problem.

    Thx!
     
Loading...

Share This Page