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, 1765🔥, 0💬
Popular Posts:
Where to find test data generators? FYIcenter.com has prepared a number of test data generators for ...
How to find out my browser request headers? To help you to see your browser request headers, FYIcent...
How to set Content-Type to application/json? The server requires the Content-Type to be application/...
Where to find tutorials on Apache JMeter test tool? I want to know how to use Apache JMeter. Here is...
How to valid UUID/GUID strings? In order to help your programming or testing tasks, FYIcenter.com ha...