Тюнинг MySQL

Помогите поднастроить MySQL. Имею следующий конфиг.

[mysqld]

port = 3306

socket = /var/lib/mysql/mysql.sock

pid-file = /var/lib/mysql/mysql/mysqld.pid

tmpdir = /tmp

default-storage-engine=myisam

skip-innodb

skip-bdb

skip-name-resolve

low-priority-updates

skip-external-locking

skip-character-set-client-handshake

bind-address = 127.0.0.1

max_connections = 60

key_buffer_size = 95M

max_allowed_packet = 16M

table_open_cache = 4

sort_buffer_size=1M

read_rnd_buffer_size=1M

read_buffer_size = 512K

net_buffer_length = 16K

thread_stack = 128K

table_cache = 100

tmp_table_size=32M

max_heap_table_size=32M

thread_cache_size = 4

query_cache_limit = 1M

query_cache_size=32M

query_cache_type = 1

join_buffer_size=1M

log-slow-queries=/var/lib/mysql/slow.log

interactive_timeout=60

wait_timeout=60

long_query_time=5

Вот что выдает mysqltuner.pl после суток работы.

-------- General Statistics --------------------------------------------------

[--] Skipped version check for MySQLTuner script

[OK] Currently running supported MySQL version 5.5.32-MariaDB-log

[OK] Operating on 32-bit architecture with less than 2GB RAM

-------- Storage Engine Statistics -------------------------------------------

[--] Status: +Archive -BDB +Federated -InnoDB -ISAM -NDBCluster

[--] Data in MyISAM tables: 148M (Tables: 76)

[!!] Total fragmented tables: 1

-------- Security Recommendations -------------------------------------------

[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------

[--] Up for: 10h 23m 33s (423K q [11.327 qps], 62K conn, TX: 904M, RX: 62M)

[--] Reads / Writes: 62% / 38%

[--] Total buffers: 159.0M global + 3.6M per thread (60 max threads)

[OK] Maximum possible memory usage: 376.5M (36% of installed RAM)

[OK] Slow queries: 0% (3/423K)

[OK] Highest usage of available connections: 55% (33/60)

[OK] Key buffer size / total MyISAM indexes: 95.0M/93.4M

[OK] Key buffer hit rate: 100.0% (304M cached / 82K reads)

[OK] Query cache efficiency: 68.0% (170K cached / 250K selects)

[!!] Query cache prunes per day: 58154

[!!] Sorts requiring temporary tables: 19% (200 temp sorts / 1K sorts)

[!!] Temporary tables created on disk: 26% (159 on disk / 602 total)

[OK] Thread cache hit rate: 99% (379 created / 62K connections)

[!!] Table cache hit rate: 17% (100 open / 584 opened)

[OK] Open file limit used: 19% (203/1K)

[OK] Table locks acquired immediately: 99% (127K immediate / 127K locks)

-------- Recommendations -----------------------------------------------------

General recommendations:

Run OPTIMIZE TABLE to defragment tables for better performance

MySQL started within last 24 hours - recommendations may be inaccurate

When making adjustments, make tmp_table_size/max_heap_table_size equal

Reduce your SELECT DISTINCT queries without LIMIT clauses

Increase table_cache gradually to avoid file descriptor limits

Variables to adjust:

query_cache_size (> 32M)

sort_buffer_size (> 1M)

read_rnd_buffer_size (> 1M)

tmp_table_size (> 32M)

max_heap_table_size (> 32M)

table_cache (> 100)

Как подобрать эти параметры, особенно интересно то что выделено крассным. На VDS крутится пару сайтов, в общем 15 000 хостов в день. Все работает гладко и вроде не глючит. Но данный тест не дает покоя.