Welcome to WebmasterWorld Guest from 54.167.22.37

Forum Moderators: phranque

Message Too Old, No Replies

dedciated quad servers

     

soned

1:06 pm on Aug 17, 2005 (gmt 0)

10+ Year Member



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.

any tips?

thanks

Eltiti

1:16 pm on Aug 17, 2005 (gmt 0)

10+ Year Member



4000 uniques a day

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

1:31 pm on Aug 17, 2005 (gmt 0)

10+ Year Member



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

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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month