Im trying to set up database cache on my server centos 5 amd athlon 64 bit.. I am attempting to input similar settings to my previous server fedora 4..
Code:
[mysqld]
Query_cache_limit=2M
Query_cache_size=25%
Query_cache_type=1
Thread_cache_size=128
Key_buffer = 25%
Join_buffer = 4M
Table_cache=25%
Sort_buffer=4M
Read_rnd_buffer_size=1%
Tmp_table_size=10% (or 32M, whichever is greater)
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
but when i go restart mysql i get the following error /usr/libexec/mysqld: unknown variable 'Query_cache_type=1'
Is there something changed in between version/ or i've missed when changing to centos?
