MySQL Forums :: Performance :: Estimate Server Hardware Requirements

Advanced Search

Estimate Server Hardware Requirements
Posted by: Usman Sookia ()
Date: January 20, 2009 02:33AM


For my current project, I have 10 000 users that may access an e-reporting website (PHP Symfony on Apache, mySQL on Windows) concurrently and I have an SLA which states that every page request should last less than 3 sec. I have pages that access a table of 36 million rows!! For one query executed by 1 user, the best I estimate I could do is 1 sec on my development configuration which is the following --> Os: Windows Server 2003 SP2,RAM: 2 GB, CPU: Pentium 4, 2.80 GHz, HDrive: 80 GB IDE.
How can I estimate the server requirements (memory, processors) for the production environment so that it meets the above SLA? All that I know about the customer is that they plan to use Windows OS on their servers.
Please help!! I could go into real problems if I do not get this right.


Options: ReplyQuote

Subject Views Written By Posted
Estimate Server Hardware Requirements 22031 Usman Sookia 01/20/2009 02:33AM
Re: Estimate Server Hardware Requirements 9652 Rick James 01/20/2009 09:12PM
Re: Estimate Server Hardware Requirements 7721 Cindy On Show 05/11/2009 12:50AM
Re: Estimate Server Hardware Requirements 5395 Rick James 05/11/2009 01:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.