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.

Dedicated Server Optimisation Help

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

  1. Kenpachi

    Kenpachi Member

    Joined:
    Nov 28, 2010
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    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

    Code:
    [mysqld]
    innodb_file_per_table=1
    Mysqltuner Resutls

    Code:
    >>  MySQLTuner 1.2.1 mod - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Modified by George Liu (eva2000) at http://vbtechsupport.com/
     >>  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 http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
       - For MySQL 5.1 http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
       - For MySQL 5.5 http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html
       - For MySQL 5.6 http://dev.mysql.com/doc/refman/5.6/en/slow-query-log.html
        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%)
    
     
Loading...

Share This Page