high load/high iowait/ once a day
the problem
for probably over a week now, everyday around the same time 3-5pm eastern US my server will spike in load all the way up to 150+ and my iowait will spike up into the 90% range, the server will become unresponsive for a period of 20-30 minutes and then everything will die down to normal ranges
the answer from my provider
that I have too many mysql connection to one of my forums database, this is their answer even though i explained twice that it happens everyday at certain times, I do admit, its a busy forum but the time of day my problem occurs is one of the least busy, with maybe 50-100 total users online, later in the night when there are 200-300 users online i have no problems with the server, it handles the load fine with load hovering around 3-4. and iowait maybe spkiking to 10 everyonce in awhile
what I thought it was
i thought maybe it has something to do with the centos/kernal bug i have read about recently but checking it seems my kernal isnt one affected
this happened one time before a couple of months ago around the same time i had serverwizards upgrade my kernal and secure the box, the symtoms went away but now are back
Linux srv01.xxxxxx*********** 2.6.15 #1 Tue Jan 10 13:45:32 EST 2006 i686 athlon i386 GNU/Linux
server specs
amd athlon 3000 barton
2157.941 MHz
1GB of ram
hd1: 80GB ATA no raid
hd2: 40GB ATA no raid
centOS 3
MySQL 4.0.25
PHP/4.3.10
optimized for vB with help at vB.com
*******************
i am a linux noob and can run commands and paste any info anyone may need if they can help, just tryingto get some possible ideas before i reopen a ticket or pay someone to look into it for me, thanks in advance
