I have two quite large web sites running on a dedicated server and as they are getting more popular every month, I am getting concerned about performance issues. First of all, some info on the sites:
- Each have about 5,000 registered users
- Combined, they get about 80,000 total and 20,000 unique hits monthly
The server specs are:
CPU: 1 x Intel Celeron 2GHz
During peak hours, the server load goes as high as 9.00 (and the total CPU load 80%), but doesn't stay there for too long, the average high period server load is 4.50, and during quiet hours it goes below 1.00.
As far as I can see using the top command from the SSH, the most cpu consuming processes are mysql functions. My question is, do you think there is something wrong with the way I programmed the database connections, or is it normal to have such high server loads on this server with so much traffic coming in?
And finally, do you think the server can handle so much load, or should I upgrade, or investigate possible programming mistakes?
I will be grateful to everyone who share their opinions on this matter. Thank you.