MySQLTuner 1.6.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
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 10.2.7-MariaDB-10.2.7+maria~xenial-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Aria +CSV +InnoDB +MRG_MyISAM +SEQUENCE +TokuDB 
[--] Data in MyISAM tables: 58K (Tables: 15)
[--] Data in InnoDB tables: 18M (Tables: 68)
[--] Data in TokuDB tables: 755G (Tables: 19)
[!!] Total fragmented tables: 25

-------- Security Recommendations  -------------------------------------------
[OK] There is no anonymous account in all database users
[OK] All database users have passwords assigned
[!!] User 'apps_write@%' hasn't specific host restriction.
[--] There is 605 basic passwords in the list.

-------- Performance Metrics -------------------------------------------------
[--] Up for: 1d 18h 10m 32s (3M q [26.128 qps], 17K conn, TX: 9B, RX: 2B)
[--] Reads / Writes: 76% / 24%
[--] Binary logging is enabled (GTID MODE: OFF)
[--] Total buffers: 392.0M global + 19.5M per thread (65 max threads)
[OK] Maximum reached memory usage: 802.2M (10.05% of installed RAM)
[OK] Maximum possible memory usage: 1.6G (20.82% of installed RAM)
[OK] Slow queries: 0% (20/3M)
[OK] Highest usage of available connections: 32% (21/65)
[OK] Aborted connections: 0.03%  (5/17017)
[!!] Query cache efficiency: 12.4% (319K cached / 2M selects)
[!!] Query cache prunes per day: 11741
[OK] Sorts requiring temporary tables: 0% (14 temp sorts / 25K sorts)
[!!] Joins performed without indexes: 15183
[OK] Temporary tables created on disk: 14% (379K on disk / 2M total)
[OK] Thread cache hit rate: 99% (21 created / 17K connections)
[OK] Table cache hit rate: 97% (203 open / 209 opened)
[OK] Open file limit used: 0% (97/16K)
[OK] Table locks acquired immediately: 100% (2M immediate / 2M locks)
[OK] Binlog cache memory access: 91.40% ( 109373 Memory / 119659 Total)

-------- MyISAM Metrics -----------------------------------------------------
[!!] Key buffer used: 18.3% (3M used / 16M cache)
[OK] Key buffer size / total MyISAM indexes: 16.0M/180.0K
[!!] Read Key buffer hit rate: 78.6% (28 cached / 6 reads)

-------- InnoDB Metrics -----------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 64.0M/18.8M
[OK] InnoDB buffer pool instances: 1
[!!] InnoDB Used buffer: 29.47% (1207 used/ 4096 total)
[OK] InnoDB Read buffer efficiency: 99.86% (646846 hits/ 647735 total)
[!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
[OK] InnoDB log waits: 0.00% (0 waits / 38058 writes)

-------- AriaDB Metrics -----------------------------------------------------
[--] AriaDB is disabled.

-------- 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
    Adjust your join queries to always utilize indexes
Variables to adjust:
    query_cache_limit (> 1M, or use smaller result sets)
    query_cache_size (> 80M)
    join_buffer_size (> 256.0K, or always use indexes with joins)