Result MysqlTuner and my.cnf after 2 weeks

gistfile1.txt

This is the result of MySQLTuner the 7th October.

>>  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] Logged in using credentials from debian maintenance account.
[!!] Currently running unsupported MySQL version 10.0.32-MariaDB-1~wheezy
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MRG_MyISAM 
[--] Data in InnoDB tables: 2G (Tables: 79)
[--] Data in MyISAM tables: 99M (Tables: 146)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
[!!] Total fragmented tables: 40

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

-------- Performance Metrics -------------------------------------------------
[--] Up for: 7d 23h 5m 34s (363M q [528.428 qps], 888K conn, TX: 2895B, RX: 79B)
[--] Reads / Writes: 97% / 3%
[--] Total buffers: 16.4G global + 2.7M per thread (300 max threads)
[OK] Maximum possible memory usage: 17.2G (54% of installed RAM)
[OK] Slow queries: 0% (28K/363M)
[OK] Highest usage of available connections: 67% (202/300)
[OK] Key buffer size / total MyISAM indexes: 164.0M/34.8M
[OK] Key buffer hit rate: 100.0% (665M cached / 50K reads)
[OK] Query cache efficiency: 44.9% (252M cached / 562M selects)
[!!] Query cache prunes per day: 319604
[!!] Sorts requiring temporary tables: 16% (2M temp sorts / 11M sorts)
[OK] Temporary tables created on disk: 21% (29K on disk / 136K total)
[OK] Thread cache hit rate: 99% (293 created / 888K connections)
[OK] Table cache hit rate: 69% (956 open / 1K opened)
[OK] Open file limit used: 6% (512/8K)
[OK] Table locks acquired immediately: 99% (120M immediate / 120M locks)
[OK] InnoDB buffer pool / data size: 16.0G/2.5G
[!!] InnoDB log waits: 261
-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
Variables to adjust:
    query_cache_size (> 128M)
    sort_buffer_size (> 2M)
    read_rnd_buffer_size (> 256K)
    innodb_log_buffer_size (>= 8M)
    
-------------------------------------------------------------------------------------------------------

And this is my my.cnf:

#
# * Fine Tuning
#

max_connections = 300
max_heap_table_size = 64M

# read_rnd_buffer_size = 32M
# sort_buffer_size = 8M
# join_buffer_size = 8M

query_cache_size = 128M
query_cache_limit = 1M
query_cache_type = 1
query_cache_strip_comments =1

thread_stack = 192K
transaction_isolation = READ-COMMITTED
tmp_table_size = 64M
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 16G

thread_cache_size       = 100
interactive_timeout     = 30
wait_timeout            = 1200
open_files_limit        = 800
innodb_file_per_table
key_buffer              = 16M
key_buffer_size         = 164M
table_open_cache        = 500
innodb_log_file_size    = 256M
thread_stack            = 192K
table_cache             = 4K
expire_logs_days        = 10
max_binlog_size         = 100M
# join_buffer_size      = 4M

[mysqldump]
quick
quote-names