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 Execution Identification to Test Result
2017-10-04, ∼3057🔥, 0💬
Popular Posts:
How to generate test credit card numbers? Test credit card numbers are frequently needed in testing ...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
How to access Response Status Code 400 as Success? My sampler failed, because the server returns the...
How to turn on Chrome WebDriver logging with Selenium Python API? If you want to turn on logging on ...