-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.5.4 WHM mysqlmymon.com
compiled by George Liu (eva2000) vbtechsupport.com
-------------------------------------------------------------

Report Generated:
Mon Sep 28 10:41:56 UTC 2015

-------------------------------------------------
mysqltuner output
-------------------------------------------------
mysqltuner.pl [found]

 >>  MySQLTuner 1.3.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.42-cll
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 3G (Tables: 8938)
[--] Data in MRG_MYISAM tables: 19M (Tables: 3)
[--] Data in InnoDB tables: 675M (Tables: 4648)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 95M (Tables: 38)
[!!] Total fragmented tables: 792

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 21h 24m 50s (6M q [80.359 qps], 297K conn, TX: 303B, RX: 1B)
[--] Reads / Writes: 75% / 25%
[--] Total buffers: 2.5G global + 34.5M per thread (200 max threads)
[OK] Maximum possible memory usage: 9.2G (54% of installed RAM)
[OK] Slow queries: 0% (10K/6M)
[OK] Highest usage of available connections: 32% (64/200)
[!!] Key buffer size / total MyISAM indexes: 0B/1.2G
[!!] Key buffer hit rate: 0.0% (74M cached / 74M reads)
[OK] Query cache efficiency: 68.3% (2M cached / 4M selects)
[!!] Query cache prunes per day: 237099
[OK] Sorts requiring temporary tables: 1% (4K temp sorts / 282K sorts)
[!!] Joins performed without indexes: 39544
[!!] Temporary tables created on disk: 31% (177K on disk / 557K total)
[OK] Thread cache hit rate: 99% (883 created / 297K connections)
[!!] Table cache hit rate: 0% (728 open / 3M opened)
[OK] Open file limit used: 2% (1K/43K)
[OK] Table locks acquired immediately: 99% (2M immediate / 2M locks)
[OK] InnoDB buffer pool / data size: 760.0M/675.7M
[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
    Increasing the query_cache size over 128M may reduce performance
    Adjust your join queries to always utilize indexes
    Temporary table size is already large - reduce result set size
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Increase table_cache gradually to avoid file descriptor limits
    Read this before increasing table_cache over 64: http://bit.ly/1mi7c4C
Variables to adjust:
    key_buffer_size (> 1.2G)
    query_cache_size (> 768M) [see warning above]
    join_buffer_size (> 16.0M, or always use indexes with joins)
    table_cache (> 728)


Report Complete:
Mon Sep 28 10:42:08 UTC 2015
----------------------------