homepage Welcome to WebmasterWorld Guest from 54.227.25.58
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
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.

any tips?

thanks

 

Eltiti




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

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




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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved