[OK] Logged in using credentials from debian maintenance account.
>> MySQLTuner 1.5.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.6.25-2
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in MEMORY tables: 143K (Tables: 2)
[--] Data in MyISAM tables: 7M (Tables: 241)
[--] Data in InnoDB tables: 5M (Tables: 59)
[!!] Total fragmented tables: 40
-------- Security Recommendations -------------------------------------------
[OK] There is no anonymous account in all database users
[OK] All database users have passwords assigned
[!!] User 'checklicense@%' hasn't specific host restriction.
[!!] User 'longer@%' hasn't specific host restriction.
[--] There is 605 basic passwords in the list.
-------- Performance Metrics -------------------------------------------------
[--] Up for: 4h 32m 38s (33K q [2.047 qps], 514 conn, TX: 4M, RX: 9M)
[--] Reads / Writes: 21% / 79%
[--] Binary logging is disabled
[--] Total buffers: 192.0M global + 1.1M per thread (151 max threads)
[OK] Maximum reached memory usage: 352.4M (17% of installed RAM)
[OK] Maximum possible memory usage: 357.2M (18.12% of installed RAM)
[OK] Slow queries: 0% (4/33K)
[OK] Highest usage of available connections: 14% (22/151)
[!!] Aborted connections: 26.85% (138/514)
[!!] Key buffer used: 21.4% (3M used / 16M cache)
[OK] Key buffer size / total MyISAM indexes: 16.0M/2.7M
[OK] Read Key buffer hit rate: 99.8% (170K cached / 315 reads)
[!!] Write Key buffer hit rate: 52.2% (26K cached / 12K writes)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (1 temp sorts / 843 sorts)
[!!] Joins performed without indexes: 126
[OK] Temporary tables created on disk: 9% (26 on disk / 269 total)
[OK] Thread cache hit rate: 94% (28 created / 514 connections)
[OK] Table cache hit rate: 95% (148 open / 155 opened)
[OK] Open file limit used: 16% (172/1K)
[OK] Table locks acquired immediately: 99% (33K immediate / 33K locks)
[!!] Connections aborted: 26%
-------- InnoDB Metrics -----------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 128.0M/5.1M
[!!] InnoDB buffer pool <= 1G and innodb_buffer_pool_instances(!=1).
[!!] InnoDB Used buffer: 8.89% (728 used/ 8191 total)
[OK] InnoDB Read buffer efficiency: 99.81% (347695 hits/ 348349 total)
[!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
[OK] InnoDB log waits: 0.00% (0 waits / 112 writes)
-------- Replication Metrics -------------------------------------------------
[--] 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
Reduce or eliminate unclosed connections and network issues
Adjust your join queries to always utilize indexes
Your applications are not closing MySQL connections properly
Variables to adjust:
query_cache_type (=1)
join_buffer_size (> 256.0K, or always use indexes with joins)
innodb_buffer_pool_instances (=1)
