my.cnf Query cache problem

[sastro]

I found that Query cache is disabled from mysqltuner.pl

 

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

[--] Skipped version check for MySQLTuner script

[OK] Currently running supported MySQL version 5.1.50

[OK] Operating on 64-bit architecture

 

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

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

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

[OK] Total fragmented tables: 0

 

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

[--] Up for: 15s (10 q [0.667 qps], 7 conn, TX: 7K, RX: 633)

[--] Reads / Writes: 100% / 0%

[--] Total buffers: 24.0M global + 2.7M per thread (151 max threads)

[OK] Maximum possible memory usage: 439.2M (17% of installed RAM)

[OK] Slow queries: 0% (0/10)

[OK] Highest usage of available connections: 0% (1/151)

[!!] Key buffer size / total MyISAM indexes: 8.0M/572.8M

[!!] Query cache is disabled

[OK] Temporary tables created on disk: 0% (0 on disk / 2 total)

[!!] Thread cache is disabled

[OK] Table cache hit rate: 53% (8 open / 15 opened)

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

[OK] Table locks acquired immediately: 100% (18 immediate / 18 locks)

[!!] Connections aborted: 14%

 

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

General recommendations:

    MySQL started within last 24 hours - recommendations may be inaccurate

    Enable the slow query log to troubleshoot bad queries

    Set thread_cache_size to 4 as a starting value

    Your applications are not closing MySQL connections properly

Variables to adjust:

    key_buffer_size (> 572.8M)

    query_cache_size (>= 8M)

    thread_cache_size (start at 4)

 

Here my my.conf

 

[mysqld]
skip-innodb
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

old_passwords=1

[mysqld_safe]
key_buffer_size  = 570M
query_cache_type=1
query_cache_size = 8M
query_cache_limit=1048576
thread_cache_size = 4
table_cache = 128

log-error=/var/log/mysql/mysql_error.log
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 5
pid-file=/var/run/mysqld/mysqld.pid
max_connections=50

 

MySQL server version 5.1.50

 

Please help

[sastro]

I just removed [mysqld_safe] and it works.