gs mysqltuner 16-04-29

[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.61-log
[OK] Operating on 64-bit architecture
 
-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM 
[--] Data in InnoDB tables: 631M (Tables: 36)
[!!] Total fragmented tables: 36
[!!] failed to execute: SHOW TABLE STATUS FROM \`#mysql50#.history\`
[!!] FAIL Execute SQL / return code: 256
 
-------- Database Metrics --------------------------------------------------------------------------
[--] Skip Database metrics from information schema missing in this version
 
-------- Indexes Metrics ---------------------------------------------------------------------------
[--] Skip Index metrics from information schema missing in this version
 
-------- Security Recommendations ------------------------------------------------------------------
[OK] There are no anonymous accounts for any database users
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE (password = '' OR password IS NULL) AND plugin NOT IN ('unix_socket', 'win_socket')
[!!] FAIL Execute SQL / return code: 256
[OK] All database users have passwords assigned
[!!] User 'miklosandras@%' hasn't specific host restriction.
[!!] User 'root@%' hasn't specific host restriction.
[!!] There is no basic password file list!
 
-------- CVE Security Recommendations --------------------------------------------------------------
[--] Skipped due to --cvefile option undefined
 
-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 9h 50m 50s (540K q [15.243 qps], 33K conn, TX: 3G, RX: 303M)
[--] Reads / Writes: 99% / 1%
[--] Binary logging is disabled
[--] Physical Memory     : 6.7G
[--] Max MySQL memory    : 854.5M
[--] Other process memory: 365.7M
[--] Total buffers: 42.0M global + 1.6M per thread (500 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[--] Global Buffers
[--]  +-- Key Buffer: 16.0M
[--]  +-- Max Tmp Table: 16.0M
[--] Query Cache Buffers
[--]  +-- Query Cache: ON - ON DEMAND
[--]  +-- Query Cache Size: 0B
[--] Per Thread Buffers
[--]  +-- Read Buffer: 256.0K
[--]  +-- Read RND Buffer: 512.0K
[--]  +-- Sort Buffer: 512.0K
[--]  +-- Thread stack: 256.0K
[--]  +-- Join Buffer: 128.0K
[OK] Maximum reached memory usage: 79.4M (1.16% of installed RAM)
[OK] Maximum possible memory usage: 854.5M (12.45% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (812/540K)
[OK] Highest usage of available connections: 4% (23/500)
[OK] Aborted connections: 0.02%  (7/33294)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (3 temp sorts / 251K sorts)
[!!] Joins performed without indexes: 152
[OK] Temporary tables created on disk: 25% (40K on disk / 155K total)
[!!] Table cache hit rate: 3% (64 open / 2K opened)
[OK] Open file limit used: 1% (47/2K)
[OK] Table locks acquired immediately: 100% (1M immediate / 1M locks)
 
-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.
 
-------- Performance schema ------------------------------------------------------------------------
[--] Performance schema is disabled.
 
-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 18.2% (3M used / 16M cache)
[OK] Key buffer size / total MyISAM indexes: 16.0M/90.0K
[OK] Read Key buffer hit rate: 100.0% (44M cached / 1 reads)
[OK] Write Key buffer hit rate: 100.0% (10M cached / 0 writes)
 
-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is disabled.
 
-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Buffers
[--]  +-- InnoDB Buffer Pool: 8.0M
[--]  +-- InnoDB Additional Mem Pool: 1.0M
[--]  +-- InnoDB Log Buffer: 1.0M
[--]  +-- InnoDB Log Buffer Free: 0B
[--]  +-- InnoDB Log Buffer Used: 512B
[!!] InnoDB buffer pool / data size: 8.0M/631.7M
[OK] InnoDB Used buffer: 100.00% (512 used/ 512 total)
[OK] InnoDB Read buffer efficiency: 98.47% (4710398625 hits/ 4783618414 total)
[!!] InnoDB Write Log efficiency: 7.04% (147 hits/ 2089 total)
[OK] InnoDB log waits: 0.00% (0 waits / 2236 writes)
 
-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.
 
-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.
 
-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] This is a standalone server.
 
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Restrict Host for user@% to user@SpecificDNSorIp
    MySQL started within last 24 hours - recommendations may be inaccurate
    Adjust your join queries to always utilize indexes
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    Beware that open_files_limit (2500) variable 
    should be greater than table_open_cache ( 64)
Variables to adjust:
    query_cache_size (>= 8M)
    join_buffer_size (> 128.0K, or always use indexes with joins)
    table_open_cache (> 64)
    innodb_buffer_pool_size (>= 631M) if possible.