MySQL Forums :: Performance :: Estimate Server Hardware Requirements


Advanced Search

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

Hi,

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.

Thanks

Options: ReplyQuote


Subject Views Written By Posted
Estimate Server Hardware Requirements 22145 Usman Sookia 01/20/2009 02:33AM
Re: Estimate Server Hardware Requirements 9688 Rick James 01/20/2009 09:12PM
Re: Estimate Server Hardware Requirements 7787 Cindy On Show 05/11/2009 12:50AM
Re: Estimate Server Hardware Requirements 5418 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.