Forum Moderators: open
On my VDS server, I have 2 databases but i want to use query-cache-size for just 1 of them..
Because 1 is big, the other is very small.. so how to do it?
Here is the settings:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 32M
join_buffer = 2M
max_allowed_packet = 16M
max_connections=300
wait_timeout=100
connect_timeout=10
table_cache = 64
sort_buffer_size = 64M
max_heap_table_size = 64M
net_buffer_length = 16K
read_buffer_size = 512K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query-cache-type = 1
query-cache-size = 16M
query_cache_limit = 1M
tmp_table_size = 64M
Thanks in advance