mysql query cache size

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql query cache size

Postby evow04 » 01. January 2009 18:35

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?
evow04
 
Posts: 9
Joined: 12. December 2008 10:25

Re: mysql query cache size

Postby Wiedmann » 01. January 2009 19:09

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)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: mysql query cache size

Postby evow04 » 01. January 2009 19:54

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?
evow04
 
Posts: 9
Joined: 12. December 2008 10:25

Re: mysql query cache size

Postby Wiedmann » 01. January 2009 22:54

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: mysql query cache size

Postby evow04 » 01. January 2009 23:32

Wiedmann, you are my hero!
i placed it after the [mysqld] and now it works like a charm!!
thank you sooo much ;-)
evow04
 
Posts: 9
Joined: 12. December 2008 10:25


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 64 guests