query-cache-size for specific database

I have 2 databases but i want to cache query for just 1

[smagdy]

Hello,

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

[justageek]

As far as I know you would have to have 2 instances of mysql running to do it or you could use 'SELECT SQL_NO_CACHE ...' on the queries you do not want cached.

JAG