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');
Recent Comments