coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: dke on July 17, 2006, 12:47:56 PM

Title: Optimization of Apache 2.x and mysql 4.x for win32 any tips?
Post by: dke on July 17, 2006, 12:47:56 PM
Hi all,

I would like to know if there is anything i could do to reduce cpu load, my guess is there are lot of stuff that could be optimized through the configurations of mysql/apache but im not sure which, ive searched and found somthing about "Query_Cache" for mysql, im not sure where to find this setting but i checked in the "winmysqladmin1.4" gui and found inside "variables" "Query_Cache_Type ON" so my guess is this is already enabled on my server by default, but the Query_Cache_Size is 0, im a rookie on these things, any tips would be highly appriciated!

thanks in advance
Title: Re: Optimization of Apache 2.x and mysql 4.x for win32 any tips?
Post by: Nibbler on July 17, 2006, 12:56:59 PM
You need to set it to something other than 0 for it to work. This is not the place to get help setting up a server.
Title: Re: Optimization of Apache 2.x and mysql 4.x for win32 any tips?
Post by: dke on July 17, 2006, 01:01:47 PM
thanks nib, any clue where i should post for optimization tips?
Title: Re: Optimization of Apache 2.x and mysql 4.x for win32 any tips?
Post by: Nibbler on July 17, 2006, 01:13:45 PM
For basic use of mysql, see the mysql manual. Otherwise search the webs for tips, but most of it will likely be beyond you.