Page 1 of 1

mysql query cache size

PostPosted: 01. January 2009 18:35
by evow04
Hi,

i have a problem; i´m using xampp 1.7 from the .zip without installled services
in the my.cnf config file for mysql i added the lines :
query_cache_type = 1
query_cache_size = 64M
query_cache_limit = 4

when i run phpmyadmin,
it gives me : query cache size 0
if i run my script to valide it gives me Query Cache Size failed (not active)

somehow i can not activate this, does anyone have tips to get it working?

Re: mysql query cache size

PostPosted: 01. January 2009 19:09
by Wiedmann
in the my.cnf config file for mysql i added the lines :

Maybe you have add these lines in a wrong "my.cnf" or in the wrong section inside this file.

(Restart MySQL)

Re: mysql query cache size

PostPosted: 01. January 2009 19:54
by evow04
hi Wiedmann ,
thanks for the reply,

the cnf file is in the x:/xxx/mysql/bin/ folder
this is de default location where xampp places it as far i know.
after the editing i rebooted the whole xampp with the stop.bat following the start.bat
(also tried it with closing it with taskmanager)

i have placed these lines in the bottom like i edit an other config file.
is this wrong?

Re: mysql query cache size

PostPosted: 01. January 2009 22:54
by Wiedmann
i have placed these lines in the bottom like i edit an other config file.
is this wrong?

You must place these lines in the [mysqld] section.

(sorry, don't know if this is the last section in your "my.cnf", and thus "in the bottom" is possible.

Re: mysql query cache size

PostPosted: 01. January 2009 23:32
by evow04
Wiedmann, you are my hero!
i placed it after the [mysqld] and now it works like a charm!!
thank you sooo much ;-)