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.

/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
     
Loading...

Share This Page