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!

/etc/my.cnf optimisation

Discussion in 'Workarounds and Optimization' started by shwebdev, Aug 28, 2012.

  1. shwebdev

    shwebdev Registered

    Joined:
    Aug 28, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brisbane, Queensland, Australia, Australia
    cPanel Access Level:
    Root Administrator
    Hi,

    Server often runs at 60% using 7% memory. Spikes occasionally into 100's. The server load is about 2.0 but goes up and down constantly alot.

    This is my /etc/my.cnf:

    [mysqld]
    innodb_buffer_pool_size=20M
    key_buffer_size = 512M
    max_allowed_packet=100M
    max_connections=500
    max_heap_table_size=24M
    open_files_limit=5000
    query_cache_size=8M
    table_cache = 2200
    thread_cache_size=4
    tmp_table_size=40M
    log-slow-queries=/var/lib/mysql/slow.log

    Code:
    MYSQL Tuner:
    
     >>  MySQLTuner 1.1.2 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at [url]http://mysqltuner.com/[/url]
     >>  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: 3G (Tables: 1307)
    [--] Data in InnoDB tables: 2M (Tables: 69)
    [!!] Total fragmented tables: 59
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 2h 17m 19s (471K q [57.231 qps], 38K conn, TX: 1B, RX: 42M)
    [--] Reads / Writes: 99% / 1%
    [--] Total buffers: 566.0M global + 2.7M per thread (500 max threads)
    [OK] Maximum possible memory usage: 1.9G (34% of installed RAM)
    [OK] Slow queries: 0% (1/471K)
    [OK] Highest usage of available connections: 3% (17/500)
    [OK] Key buffer size / total MyISAM indexes: 512.0M/520.0M
    [OK] Key buffer hit rate: 99.9% (64M cached / 47K reads)
    [OK] Query cache efficiency: 64.1% (203K cached / 317K selects)
    [!!] Query cache prunes per day: 1152803
    [OK] Sorts requiring temporary tables: 2% (786 temp sorts / 32K sorts)
    [!!] Joins performed without indexes: 247
    [OK] Temporary tables created on disk: 1% (397 on disk / 32K total)
    [OK] Thread cache hit rate: 96% (1K created / 38K connections)
    [OK] Table cache hit rate: 74% (452 open / 609 opened)
    [OK] Open file limit used: 15% (764/5K)
    [OK] Table locks acquired immediately: 99% (116K immediate / 116K locks)
    [OK] InnoDB data size / buffer pool: 2.3M/20.0M
    
    Code:
    Server Specs:
    
    Memory: 5563532k/5698560k available (2545k kernel code, 126188k reserved, 1753k data, 196k init)
    
    Total processors: 4
    
    Processor #1
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
    
        Speed
            2933.530 MHz
    
        Cache
            3072 KB
    
    Processor #2
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
    
        Speed
            2933.530 MHz
    
        Cache
            3072 KB
    
    Processor #3
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
    
        Speed
            2933.530 MHz
    
        Cache
            3072 KB
    
    Processor #4
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
    
        Speed
            2933.530 MHz
    
        Cache
            3072 KB
     

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