Collections:
Generate Test Summary Report from MySQL
How to generate test summary report from the test result table in MySQL?
✍: FYIcenter.com
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-10-04, 1477👍, 0💬
Popular Posts:
Why I am getting gzip compressed HTTP response in SoapUI? If you run a HTTP request for some Website...
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...
How to validate domain name format? In order to help your programming or testing tasks, FYIcenter.co...
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...