Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
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.
Also do a 'top' and make sure you know exactly what everything is doing. If there are processes running you're not familiar with, find out what they are, and kill them if they're not needed.
You can probably do some mysql tuning as well but I'm less familiar with that so can't offer specific suggestions (other than I expect you can get some more horsepower out of it just through tweaking).
I'd spend a lot more time fine tuning the program before looking at hardware upgrades.
There are other things you can do to get improvements apart from optimising the SQL itself, but they depend on what software you're using. For example if you're using Perl, then Apache::DBI connection pooling with mod_perl works very well.