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, 1978🔥, 0💬
Popular Posts:
How to validate and decode MAC (Media Access Control) addresses? In order to help your programming o...
How to generate ISBN numbers? To help you to obtain some ISBN numbers for testing purpose, FYIcenter...
What are date and time test values? Date and time test values are frequently needed in testing date ...
How to generate user full names? Test user names are frequently needed in testing applications that ...
How to validate and decode MAC (Media Access Control) addresses? In order to help your programming o...