Тюнинг mysql

Добрый день!

Есть mysql config:

[mysqld]

datadir=/var/lib/mysql

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

user=mysql



key_buffer=512M

table_cache=1024



thread_cache_size = 8

query_cache_size = 32M

thread_concurrency = 16

max_connections  = 3000



query_cache_type=1

query_cache_limit=2M

query_cache_size=256M



max_allowed_packet = 1M

sort_buffer_size = 4M

read_buffer_size = 4M

read_rnd_buffer_size = 8M

myisam_sort_buffer_size = 128M



long_query_time=3

slow_query_log_file=/tmp/slow-queries-log



[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

mysqltuner.pl выдает следующую инфу:

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

[--] Skipped version check for MySQLTuner script

[OK] Currently running supported MySQL version 5.5.19

[OK] Operating on 64-bit architecture



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

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

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

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

[!!] InnoDB is enabled but isn't being used

[!!] Total fragmented tables: 3



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

[OK] All database users have passwords assigned



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

[--] Up for: 4d 1h 46m 42s (50M q [142.263 qps], 5K conn, TX: 90B, RX: 6B)

[--] Reads / Writes: 96% / 4%

[--] Total buffers: 928.0M global + 16.4M per thread (3000 max threads)

[!!] Maximum possible memory usage: 48.9G (1270% of installed RAM)

[OK] Slow queries: 0% (191/50M)

[OK] Highest usage of available connections: 9% (274/3000)

[OK] Key buffer size / total MyISAM indexes: 512.0M/606.5M

[OK] Key buffer hit rate: 99.9% (869M cached / 523K reads)

[OK] Query cache efficiency: 58.2% (28M cached / 48M selects)

[!!] Query cache prunes per day: 611857

[OK] Sorts requiring temporary tables: 0% (30K temp sorts / 9M sorts)

[OK] Temporary tables created on disk: 0% (416 on disk / 1M total)

[OK] Thread cache hit rate: 78% (1K created / 5K connections)

[OK] Table cache hit rate: 68% (402 open / 585 opened)

[OK] Open file limit used: 2% (429/15K)

[OK] Table locks acquired immediately: 99% (22M immediate / 22M locks)

[!!] Connections aborted: 20%



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

General recommendations:

    Add skip-innodb to MySQL configuration to disable InnoDB

    Run OPTIMIZE TABLE to defragment tables for better performance

    Reduce your overall MySQL memory footprint for system stability

    Enable the slow query log to troubleshoot bad queries

    Increasing the query_cache size over 128M may reduce performance

    Your applications are not closing MySQL connections properly

Variables to adjust:

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

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

    query_cache_size (> 256M) [see warning above]

Вопрос к профи, что явно сделано в конфиге криво, что нужно изменить/добавить? К сожалению не большой спец в настройке mysql, из-за этого не до конца понимаю советы mysqltuner.

Заранее большое спасибо за советы!