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');
© 2012 The BrowserMob Blog Suffusion theme by Sayontan Sinha