ini output nya terus gimana gan?
>> MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: admin
Please enter your MySQL administrative password:
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.45-log
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 24M (Tables: 23)
[!!] InnoDB is enabled but isn't being used
[!!] Total fragmented tables: 3
-------- Security Recommendations -------------------------------------------
ERROR 1142 (42000) at line 1: SELECT command denied to user 'admin'@'localhost' for table 'user'
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 13h 38m 29s (14M q [297.933 qps], 2M conn, TX: 8B, RX: 2B)
[--] Reads / Writes: 65% / 35%
[--] Total buffers: 3.6G global + 4.2M per thread (220 max threads)
[OK] Maximum possible memory usage: 4.5G (29% of installed RAM)
[OK] Slow queries: 0% (1/14M)
[!!] Highest connection usage: 100% (221/220)
[OK] Key buffer size / total MyISAM indexes: 3.0G/1.3M
[OK] Key buffer hit rate: 100.0% (442M cached / 1K reads)
[OK] Query cache efficiency: 82.9% (6M cached / 8M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 228K sorts)
[!!] Joins performed without indexes: 661732
[OK] Temporary tables created on disk: 5% (51 on disk / 919 total)
[OK] Thread cache hit rate: 98% (45K created / 2M connections)
[OK] Table cache hit rate: 61% (278 open / 450 opened)
[OK] Open file limit used: 0% (333/655K)
[!!] Table locks acquired immediately: 90%
-------- Recommendations -----------------------------------------------------
General recommendations:
Add skip-innodb to MySQL configuration to disable InnoDB
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce or eliminate persistent connections to reduce connection usage
Adjust your join queries to always utilize indexes
Optimize queries and/or use InnoDB to reduce lock wait
Variables to adjust:
max_connections (> 220)
wait_timeout (< 600)
interactive_timeout (< 3600)
join_buffer_size (> 1.0M, or always use indexes with joins)