Thursday, 15 August 2013

How to benchmark php/mysql site -


I would like to know how to benchmark a php / mysql site.

We have a web app almost complete and ready to live, we know how many people are going to use it in a year's time, but it does not know exactly how much the average user takes on the bandwidth It is, how much time they burn the database etc. We need to purchase the correct server to determine.

Is there any server side Linux that can monitor these statistics per user? So can we take this data and extrapolate it?

If I am going about this completely wrong then please let me know, but I believe this is a continuous activity for new web applications.

EDIT: I may have asked for the wrong information, we can see how long the database query takes, and how long it takes to load the page but it does not know that on the server What has been loaded. The question I am asking is, can we handle 100 users on an average ... 1000? What types of server requirements are required to kill 1M users etc.

Thank you for your help.

A tool that I find quite useful is (this is the most basic) Allows you to set up your browser to use jmeter, so you revolve around your website and it will record you everything.

Once you are happy that it is a decent test of most of your website you can then save the test in jmeter and copy it to set a set number of threads and copy Thread can be said to run your test with many loops.

For example, you can run the testplan for every 50 clients running 10 times.

Then you can ramp up the numbers up and down to see the effect of the performance on the site, it underlines the reaction time for you.

This lets you tune into different standards, try different caching strategies and check the effect of the real world of those changes.


No comments:

Post a Comment