Generate Test Summary Report from MySQL

Q

How to generate test summary report from the test result table in MySQL?

✍: FYIcenter.com

A

You can follow this tutorial to generate test summary report from the test result table in MySQL.

1. Run "\fyicenter\First-Load-Test-6.jmx multiple files.

2. Run MySQL client tool with the following query:

select testID, runID, label, count(label) as count, 
   ceil(avg(elapsed)) as average, min(elapsed) as min, max(elapsed) as max
   from jmeter_test_result 
   group by testID, runID, label;
   
+--------+----------------+----------+-------+---------+------+------+
| testID | runID          | label    | count | average | min  | max  |
+--------+----------------+----------+-------+---------+------+------+
|    123 | 20171117230054 | Facebook |    25 |      95 |   39 |  415 |
|    123 | 20171117230054 | Google   |    25 |      64 |   40 |  171 |
|    123 | 20171117230850 | Facebook |    25 |     101 |   39 |  342 |
|    123 | 20171117230850 | Google   |    25 |      61 |   41 |  204 |
|    123 | 20171117230853 | Facebook |    25 |      89 |   38 |  320 |
|    123 | 20171117230853 | Google   |    25 |      52 |   40 |   87 |
+--------+----------------+----------+-------+---------+------+------+

 

Using BeanShell Script in JMeter

Add Excution Identification to Test Result

Saving Test Results to MySQL Database

⇑⇑ Apache JMeter Tutorials

2017-11-18, 372👍, 0💬