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.

How to optimize ?

Discussion in 'General Discussion' started by fuzioneer, Apr 4, 2005.

  1. fuzioneer

    fuzioneer Well-Known Member

    Joined:
    Dec 12, 2003
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    I have a nice and stable setup until recently that is, i believe its just pure weight of traffic specifically phpnuke or similar sites which are hammering mysql etc.

    I want to optimize for this type of use i.e. dynamic sites but its not my area of expertise. I did do sme tweaking in the past so i offer up my Mysql and Apache config to scrutiny in the hope that an "expert" can help with tweaking it.

    [mysqld]
    max_connections = 500
    key_buffer = 16M
    myisam_sort_buffer_size = 32M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 1M
    table_cache = 1500
    thread_cache_size = 32
    wait_timeout = 14400
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10
    thread_concurrency=4
    query_cache_limit = 1M
    query_cache_size = 100M
    query_cache_type = 1
    skip-innodb
    log-slow-queries = /var/log/slow_queries.log
    #log-long-format long_query_time = 5

    [mysqld_safe]
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M


    Relevant Apache Config:

    RLimitMEM 233994581
    RLimitCPU 240
    Timeout 200
    KeepAlive Off
    MaxKeepAliveRequests 100
    KeepAliveTimeout 15
    MinSpareServers 5
    MaxSpareServers 15
    StartServers 5
    MaxClients 400
    MaxRequestsPerChild 0

    The server in Question is running CentOS 3.4, it has 2GB RAM, 3.4Ghz HT P4
     
Loading...

Share This Page