After running the load test customer’s often download the database and run queries to determine their sites performance. Here are some common SQL queries to get you started:

Analyze the avg, max, and min time for each step in a transaction:

SELECT step, COUNT(*), AVG(time_active), MAX(time_active), MIN(time_active)
FROM step GROUP BY step;

General query to look at loading of objects, may want to increase or decrease the count. Depends on the size of the test:

SELECT path, COUNT(*), avg(time_active), MIN(time_active), MAX(time_active) FROM object
GROUP BY path HAVING COUNT(*) > 100 ORDER BY avg(time_active) DESC;

Get error msg grouped by error, host, status:

SELECT err_msg, host, status_code, COUNT(*), AVG(time_active)
FROM object GROUP BY err_msg, host, status_code

Give a breakdown of a specific path over the duration of the test:

SELECT date_format(start_time, '%H:%i'), COUNT(*), avg(time_active),
MIN(time_active), MAX(time_active), avg(time_to_first_byte), MIN(time_to_first_byte),
MAX(time_to_first_byte) FROM object WHERE path = '/'
GROUP BY date_format(start_time, '%H:%i')
ORDER BY date_format(start_time, '%H:%i');

Summary Information, much like what you see in the charts created in the BrowserMob Dashboard.

SELECT script_name, date_format(start_time, '%H:%i'), COUNT(*), 
avg(time_active), MIN(time_active), MAX(time_active), SUM(bytes) 
FROM tx GROUP BY script_name, date_format(start_time, '%H:%i') 
ORDER BY script_name, date_format(start_time, '%H:%i')

We hope that you find these a useful starting point for your load testing analysis.

Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">

 

© 2012 The BrowserMob Blog Suffusion theme by Sayontan Sinha