Помогите с оптимизировать конфига MySQL

Прочитал кучу мануалов, и никак не могу разобраться с настройкой MySQL.

Процесс mysql грузит сервер на 65%.

Сервер G540, 4GB, CentOS

Вот конфиг

[mysqld]

port		= 3306

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

skip-external-locking

key_buffer_size = 256M

max_allowed_packet = 32M

table_open_cache = 2048

sort_buffer_size = 4M

read_buffer_size = 4M

read_rnd_buffer_size = 3072K

myisam_sort_buffer_size = 64M

thread_cache_size = 120

query_cache_size = 64M

thread_concurrency = 8

max_connections = 400

max_heap_table_size = 96M

join_buffer_size = 2M

query_cache_limit = 2M

tmp_table_size = 48M

# add

#table_cache = 2048

#thread_stack = 128K

max_binlog_size=100M

long-query-time = 2

log-slow-queries=/tmp/mysql-slow.log

[mysqldump]

quick

max_allowed_packet = 16M



[mysql]

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates



[myisamchk]

key_buffer_size = 128M

sort_buffer_size = 128M

read_buffer = 2M

write_buffer = 2M



[mysqlhotcopy]

interactive-timeout

Анализ

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

[--] Skipped version check for MySQLTuner script

[OK] Currently running supported MySQL version 5.5.20-cll

[OK] Operating on 64-bit architecture



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

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

[--] Data in MyISAM tables: 1G (Tables: 1633)

[--] Data in InnoDB tables: 51M (Tables: 93)

[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)

[!!] Total fragmented tables: 160





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

[--] Up for: 9h 23m 44s (1M q [46.094 qps], 85K conn, TX: 5B, RX: 243M)

[--] Reads / Writes: 89% / 11%

[--] Total buffers: 512.0M global + 13.2M per thread (400 max threads)

[!!] Maximum possible memory usage: 5.7G (148% of installed RAM)

[OK] Slow queries: 0% (2K/1M)

[OK] Highest usage of available connections: 10% (40/400)

[OK] Key buffer size / total MyISAM indexes: 256.0M/222.5M

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

[OK] Query cache efficiency: 41.9% (526K cached / 1M selects)

[!!] Query cache prunes per day: 63538

[OK] Sorts requiring temporary tables: 1% (2K temp sorts / 262K sorts)

[!!] Joins performed without indexes: 2879

[!!] Temporary tables created on disk: 33% (30K on disk / 88K total)

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

[OK] Table cache hit rate: 98% (2K open / 2K opened)

[OK] Open file limit used: 78% (3K/4K)

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

[OK] InnoDB data size / buffer pool: 51.3M/128.0M



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

General recommendations:

    Run OPTIMIZE TABLE to defragment tables for better performance

    MySQL started within last 24 hours - recommendations may be inaccurate

    Reduce your overall MySQL memory footprint for system stability

    Adjust your join queries to always utilize indexes

    When making adjustments, make tmp_table_size/max_heap_table_size equal

    Reduce your SELECT DISTINCT queries without LIMIT clauses

Variables to adjust:

  *** MySQL's maximum memory usage is dangerously high ***

  *** Add RAM before increasing MySQL buffer variables ***

    query_cache_size (> 64M)

    join_buffer_size (> 2.0M, or always use indexes with joins)

    tmp_table_size (> 48M)

    max_heap_table_size (> 96M)

Скрин top

[ATTACH]106480[/ATTACH]