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

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