mysql cache

[skelly]

Hi
I have installed the last version c.p.g. to be all right  but I have read in the forum
what possible to improve mysql with the cache.
as it does him to activate it in server windows 2003
I have looked at the my.ini file but I don't understand anything
you excuse me if this post is off topic
if you are able to give I help me thanks of heart
Lory

[Nibbler]

You need to make sure it is enabled and then set the size, like this:

Code Select Expand


query_cache_type = 1
query_cache_size = 64M


This is not a suitable place for server setup help.

[Joachim Müller]

Have I mentioned already that self-hosting is not recommended at all, especially if you have little to no experience in webserver administration?

[skelly]

Hi

I don't have a lot of experience but I want to learn and I put the whole wish there.
Ok i insert
query_cache_type = 1
query_cache_size = 64M

in my.ini and restart

You need to make sure it is enabled......... I can see if it is enabled?
or where him enabled

I had inserted in my.ini query_cache_type = 1 and query_cache_size = 64M  but nothing didn't change

Thank you are very kind ( gau gau less because he thinks that I am incapable....i joke   )

[Nibbler]

You can see the query cache stats using phpmyadmin or by running the query

Code Select Expand

SHOW STATUS LIKE 'Qc%';

Please, no more non-coppermine questions.

[skelly]

OK resolved
you excuse if have gone out theme it doesn't happen anymore
thanks for the help
hi Nibbler