Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Editing my.cnf

Status
Not open for further replies.

LucL

Programmer
Jan 23, 2006
117
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top