mysqltuner output 2GB

mysqltuner.txt

[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.47-0+deb8u1-log
[OK] Operating on 64-bit architecture
 
-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA 
[--] Data in InnoDB tables: 306M (Tables: 549)
[--] Data in MyISAM tables: 5M (Tables: 203)
[!!] Total fragmented tables: 549
 
-------- Security Recommendations ------------------------------------------------------------------
[OK] There are no anonymous accounts for any database users
[OK] All database users have passwords assigned
[!!] There is no basic password file list!
 
-------- CVE Security Recommendations --------------------------------------------------------------
[--] Skipped due to --cvefile option undefined
 
-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 16m 15s (2 q [0.002 qps], 252 conn, TX: 181B, RX: 137B)
[--] Reads / Writes: 100% / 0%
[--] Binary logging is disabled
[--] Total buffers: 371.0M global + 2.7M per thread (180 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 373.7M (18.64% of installed RAM)
[OK] Maximum possible memory usage: 854.8M (42.63% of installed RAM)
[OK] Slow queries: 0% (0/2)
[OK] Highest usage of available connections: 0% (1/180)
[OK] Aborted connections: 1.98%  (5/252)
[!!] Query cache should be disabled by default due to mutex contention.
[OK] Thread cache hit rate: 99% (1 created / 252 connections)
[OK] Table cache hit rate: 100% (400 open / 0 opened)
[OK] Open file limit used: 44% (455/1K)
[OK] Table locks acquired immediately: 100% (337 immediate / 337 locks)
 
-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.
 
-------- Performance schema ------------------------------------------------------------------------
[--] Performance schema is disabled.
[--] Memory used by P_S: 0B
 
-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 18.2% (3M used / 16M cache)
[OK] Key buffer size / total MyISAM indexes: 16.0M/1.7M
 
-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is disabled.
 
-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[!!] InnoDB buffer pool / data size: 8.0M/306.9M
[OK] InnoDB buffer pool instances: 1
[OK] InnoDB Used buffer: 97.85% (501 used/ 512 total)
[OK] InnoDB Read buffer efficiency: 95.08% (67273 hits/ 70755 total)
[OK] InnoDB Write log efficiency: 99.94% (30728 hits/ 30745 total)
[OK] InnoDB log waits: 0.00% (0 waits / 17 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
    MySQL started within last 24 hours - recommendations may be inaccurate
Variables to adjust:
    query_cache_type (=0)
    innodb_buffer_pool_size (>= 306M) if possible.