Print Page - mysql cache

Title: mysql cache
Post by: skelly on October 25, 2006, 06:24:28 PM

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

Title: Re: mysql cache
Post by: Nibbler on October 25, 2006, 06:30:18 PM

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

Code Select


query_cache_type = 1
query_cache_size = 64M

This is not a suitable place for server setup help.

Title: Re: mysql cache
Post by: Joachim Müller on October 25, 2006, 06:32:01 PM

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

Title: Re: mysql cache
Post by: skelly on October 25, 2006, 07:29:41 PM

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 :) )

Title: Re: mysql cache
Post by: Nibbler on October 25, 2006, 08:08:15 PM

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

Code Select

SHOW STATUS LIKE 'Qc%';

Please, no more non-coppermine questions.

Title: Re: mysql cache
Post by: skelly on October 25, 2006, 08:53:31 PM

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

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: skelly on October 25, 2006, 06:24:28 PM