Optimization of Apache 2.x and mysql 4.x for win32 any tips?

[dke]

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

[Nibbler]

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.

[dke]

thanks nib, any clue where i should post for optimization tips?

[Nibbler]

For basic use of mysql, see the mysql manual. Otherwise search the webs for tips, but most of it will likely be beyond you.