Hi Guys,
I've edited out /etc/my.cnf to contain two new lines that deal with query caching..
query_cache_type=1
query_cache_size=25M
Then I saved the file and restarted Mysql. This is under Linux Redhat.
For some reason when I reconnect and check the variables using
"SHOW VARIABLES LIKE '%query_cache%';"
query_cache_size is still 0 and none of the changes made in the file are applied. This is after shutting down and restarting mysql and shutting down and restarting the client.
Am I missing something? Doesn't matter if I connect to the DB as user or admin the variable changes simply aren't applied.
Thanks!
Luc L.
I've edited out /etc/my.cnf to contain two new lines that deal with query caching..
query_cache_type=1
query_cache_size=25M
Then I saved the file and restarted Mysql. This is under Linux Redhat.
For some reason when I reconnect and check the variables using
"SHOW VARIABLES LIKE '%query_cache%';"
query_cache_size is still 0 and none of the changes made in the file are applied. This is after shutting down and restarting mysql and shutting down and restarting the client.
Am I missing something? Doesn't matter if I connect to the DB as user or admin the variable changes simply aren't applied.
Thanks!
Luc L.