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.

MYSQL Optimisations

Discussion in 'Workarounds and Optimization' started by TallblokeUK, Feb 4, 2015.

  1. TallblokeUK

    TallblokeUK Registered

    Joined:
    Feb 4, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Highcliffe, United Kingdom
    cPanel Access Level:
    Root Administrator
    Does anyone have any feedback on improvements I could make :

    Code:
     >>  MySQLTuner 1.4.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    [OK] Currently running supported MySQL version 5.5.40-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
    [--] Data in MyISAM tables: 71M (Tables: 107)
    [--] Data in InnoDB tables: 1M (Tables: 79)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [!!] Total fragmented tables: 10
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 15h 47m 58s (18M q [318.385 qps], 16K conn, TX: 28B, RX: 8B)
    [--] Reads / Writes: 96% / 4%
    [--] Total buffers: 668.0M global + 2.8M per thread (151 max threads)
    [OK] Maximum possible memory usage: 1.1G (1% of installed RAM)
    [OK] Slow queries: 0% (2/18M)
    [OK] Highest usage of available connections: 6% (10/151)
    [OK] Key buffer size / total MyISAM indexes: 8.0M/18.2M
    [OK] Key buffer hit rate: 100.0% (38M cached / 11K reads)
    [OK] Query cache efficiency: 97.1% (17M cached / 18M selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 105K sorts)
    [OK] Temporary tables created on disk: 4% (2K on disk / 57K total)
    [OK] Thread cache hit rate: 99% (10 created / 16K connections)
    [!!] Table cache hit rate: 10% (265 open / 2K opened)
    [OK] Open file limit used: 2% (300/10K)
    [OK] Table locks acquired immediately: 99% (623K immediate / 623K locks)
    [OK] InnoDB buffer pool / data size: 128.0M/1.2M
    [OK] InnoDB log waits: 0
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        MySQL started within last 24 hours - recommendations may be inaccurate
        Enable the slow query log to troubleshoot bad queries
        Increase table_open_cache gradually to avoid file descriptor limits
        Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    Variables to adjust:
        table_open_cache (> 5000)
    
    Thanks in advance!
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. TallblokeUK

    TallblokeUK Registered

    Joined:
    Feb 4, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Highcliffe, United Kingdom
    cPanel Access Level:
    Root Administrator
    Thanks, didn't spot that one...such a n00b :)
     
Loading...

Share This Page