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!

Dedicated Server Optimisation Help

Discussion in 'Workarounds and Optimization' started by Kenpachi, Jul 25, 2012.

  1. Kenpachi

    Kenpachi Member

    Nov 28, 2010
    Likes Received:
    Trophy Points:
    Hello :)

    recently i've upgrade my server from VPS to Dedicated to handle my site traffic and load. So i request the experts to shed their knowledge in optimising my current DS :)

    Server Configuration is:

    HDD 1x 500 GB SATARAM
    4 GB RAM
    CPU Intel Xeon 5050 3.0 Ghz

    My.Cnf variables are default

    Mysqltuner Resutls

    >>  MySQLTuner 1.2.1 mod - Major Hayden <>
     >>  Bug reports, feature requests, and downloads at
     >>  Modified by George Liu (eva2000) at
     >>  Run with '--help' for additional options and output filtering
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.1.63-cll
    [OK] Operating on 64-bit architecture
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 1020M (Tables: 283)
    [--] Data in InnoDB tables: 208K (Tables: 13)
    [--] Data in MEMORY tables: 3M (Tables: 2)
    [!!] Total fragmented tables: 24
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 1d 23h 46m 18s (9M q [54.443 qps], 583K conn, TX: 97B, RX: 2B)
    [--] Reads / Writes: 85% / 15%
    [--] Total buffers: 34.0M global + 2.7M per thread (151 max threads)
    [OK] Maximum possible memory usage: 449.2M (11% of installed RAM)
    [OK] Slow queries: 0% (1K/9M)
    [!!] Highest connection usage: 100%  (152/151)
    [OK] Key buffer size / total MyISAM indexes: 8.0M/485.9M
    [OK] Key buffer hit rate: 99.2% (253M cached / 2M reads)
    [!!] Query cache is disabled. In certain usage cases you may want to leave Query cache disabled i.e. InnoDB table usage
    [OK] Sorts requiring temporary tables: 0% (41 temp sorts / 1M sorts)
    [OK] Temporary tables created on disk: 17% (8K on disk / 45K total)
    [!!] Thread cache is disabled
    [!!] Table cache hit rate: 0% (64 open / 153K opened)
    [OK] Open file limit used: 2% (88/4K)
    [OK] Table locks acquired immediately: 99% (12M immediate / 12M locks)
    [OK] InnoDB data size / buffer pool: 208.0K/8.0M
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        Enable the slow query log to troubleshoot bad queries.
        Do not forget to disable slow query logging after troubleshooting
       - For MySQL 5.0
       - For MySQL 5.1
       - For MySQL 5.5
       - For MySQL 5.6
        Reduce or eliminate persistent connections to reduce connection usage
        Set thread_cache_size to 4 as a starting value
        Increase table_cache gradually to avoid file descriptor limits
    Variables to adjust:
        max_connections (> 151)
        wait_timeout (< 28800)
        interactive_timeout (< 28800)
        query_cache_size (>= 8M)
        thread_cache_size (start at 4)
        table_cache (> 64, table_open_cache hit rate <20%)

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