Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

How to optimize ?

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

  1. fuzioneer

    fuzioneer Well-Known Member

    Joined:
    Dec 12, 2003
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    166
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice