Hello,
can help me anyone for optimize my Mysql for one vps?
can help me anyone for optimize my Mysql for one vps?
this is my.cnfroot@viper [~]# ./mysqltuner.pl
>> MySQLTuner 1.2.0 - Major Hayden <[email protected]>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.66-cll
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 8G (Tables: 777)
[--] Data in MEMORY tables: 0B (Tables: 2)
[!!] Total fragmented tables: 58
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 5s (74 q [14.800 qps], 9 conn, TX: 145K, RX: 12K)
[--] Reads / Writes: 51% / 49%
[--] Total buffers: 80.0M global + 3.9M per thread (200 max threads)
[OK] Maximum possible memory usage: 855.0M (83% of installed RAM)
[OK] Slow queries: 0% (0/74)
[OK] Highest usage of available connections: 1% (2/200)
[!!] Key buffer size / total MyISAM indexes: 16.0M/1.7G
[!!] Key buffer hit rate: 88.6% (1K cached / 188 reads)
[!!] Query cache efficiency: 18.9% (7 cached / 37 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 5 sorts)
[OK] Temporary tables created on disk: 20% (1 on disk / 5 total)
[OK] Thread cache hit rate: 77% (2 created / 9 connections)
[OK] Table cache hit rate: 74% (20 open / 27 opened)
[OK] Open file limit used: 4% (41/1K)
[OK] Table locks acquired immediately: 100% (75 immediate / 75 locks)
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Variables to adjust:
key_buffer_size (> 1.7G)
query_cache_limit (> 1M, or use smaller result sets)
root@viper [~]#
Thank you![mysqld]
skip-innodb
set-variable = max_connections=200
query_cache_type=1
query_cache_size=32M
query_cache_limit=1M
sort_buffer_size=2M
read_rnd_buffer_size=512K
tmp_table_size=32M
max_heap_table_size=32M
thread_cache_size=24
key_buffer_size=16M
table_cache=256
join_buffer_size=1M
log-slow-queries=/var/lib/mysql/slow.log