Welcome to WebmasterWorld Guest from 188.8.131.52 , register , free tools , login , search , pro membership , help , library , announcements , recent posts , open posts Become a Pro Member
dedciated quad servers soned msg:657917 1:06 pm on Aug 17, 2005 (gmt 0) am thinking of getting one some day, our current server, dual P4 3.0 ghz 1GB ram is getting overloaded. We will upgrade to 2GB ram this week, but I'm afraid this may not be enough.
We have a php-mysql job site and as you know, it's very database-intensive. we're averaging close to 4000 uniques a day and growing.
Our paying customers are complaing of the slowness and mysql disconnects during peak hours.
Eltiti msg:657918 1:16 pm on Aug 17, 2005 (gmt 0)
Please don't take this the wrong way, but I don't think this is something that would/should overload a (dual processor!) server...
If I were you, I'd start by taking a close look at the data model and the queries used, to see if they can be optimized. Perhaps you could add a few indices? (Improving the data model and adding indices can often give *huge* performance gains!)
Angelis msg:657919 1:31 pm on Aug 17, 2005 (gmt 0)
My server is about half the spec of that with about 5k visitors and downloads daily of about 3gb and it isnt overloaded.
As the poster above mentioned it maybe better to look at the coding structure to see why it is happening, also make sure all your sql queries are closed etc.
walkman msg:657920 1:33 pm on Aug 17, 2005 (gmt 0)
[ ...] webmasterworld.com
I get over 15K uniques a day (divided over two sites). Single processor, 1 GB ram. Fast as hell. Hire a new programer to check your scripts