بهینه سازی MySQL با اسکریپت mysqltuner

با سلام خروجی این است لطفا راهنمایی کنید با تشکر فراوان خداخیرتون بده

[root@server ~]# perl mysqltuner.pl
>> MySQLTuner 1.6.13 - 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 5.5.31-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
[--] Data in MyISAM tables: 134M (Tables: 517)
[--] Data in InnoDB tables: 1G (Tables: 557)
[--] Data in MEMORY tables: 0B (Tables: 2)
[OK] Total fragmented tables: 0

-------- Security Recommendations ------------------------------------------------------------------
[!!] User '@localhost' is an anonymous account.
[!!] User '@server.aminpal.com' is an anonymous account.
[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: 2h 18m 46s (41K q [4.956 qps], 9K conn, TX: 94M, RX: 5M)
[--] Reads / Writes: 90% / 10%
[--] Binary logging is enabled (GTID MODE: OFF)
[--] Physical Memory : 1.8G
[--] Max MySQL memory : 421.4M
[--] Other process memory: 230.9M
[--] Total buffers: 176.0M global + 1.6M per thread (151 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 185.8M (9.90% of installed RAM)
[OK] Maximum possible memory usage: 421.4M (22.45% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/41K)
[OK] Highest usage of available connections: 3% (6/151)
[OK] Aborted connections: 0.02% (2/9139)
[!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
[!!] Query cache may be disabled by default due to mutex contention.
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 14K sorts)
[OK] No joins without indexes
[!!] Temporary tables created on disk: 91% (14K on disk / 15K total)
[!!] Table cache hit rate: 0% (64 open / 12K opened)
[OK] Open file limit used: 1% (20/1K)
[OK] Table locks acquired immediately: 99% (33K immediate / 33K locks)
[OK] Binlog cache memory access: 100.00% ( 1161 Memory / 1161 Total)

-------- Performance schema ------------------------------------------------------------------------
[--] Performance schema is disabled.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.

-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 18.9% (3M used / 16M cache)
[OK] Key buffer size / total MyISAM indexes: 16.0M/34.6M
[OK] Read Key buffer hit rate: 99.7% (154K cached / 496 reads)
[OK] Write Key buffer hit rate: 95.6% (27K cached / 1K writes)

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

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[!!] InnoDB buffer pool / data size: 128.0M/1.2G
[OK] InnoDB buffer pool instances: 1
[OK] InnoDB Used buffer: 99.94% (8187 used/ 8192 total)
[OK] InnoDB Read buffer efficiency: 99.92% (25128041 hits/ 25146932 total)
[!!] InnoDB Write Log efficiency: 28.04% (646 hits/ 2304 total)
[OK] InnoDB log waits: 0.00% (0 waits / 1658 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:
Remove Anonymous User accounts - there are 2 anonymous accounts.
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries which have no LIMIT clause
Increase table_open_cache gradually to avoid file descriptor limits
Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
Beware that open_files_limit (1024) variable
should be greater than table_open_cache ( 64)
Variables to adjust:
query_cache_type (=0)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
table_open_cache (> 64)
innodb_buffer_pool_size (>= 1G) if possible.