Optimising my MySQL Config

I run a dedicated server that hosts a number of phpnuke community sites, most of them are fledgling sites and as such dont attract much traffic, however 2 sites are busy and 2 are upcoming.

Over the past few weeks I have noted an increased lag on the sites and recently access times have increased.

i have used sar to monitor the server, and cpu usage not excessive, but memory is being hammered. The server has an Athlon 2400+ and 1Gb of memory, the memory is completely used up and excessive page swapping is happening, this is what is slowing everything down i believe.

My my.cnf file is here:-

[mysqld]
set-variable = max_connections=500
safe-show-database

[mysql]
local-infile=1

what should i be changing to optimize MySQL for use with primarily phpnuke sites.

 

 

 

 

Top