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.
Recent Comments