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, 1830🔥, 0💬
Popular Posts:
How to validate domain name format? In order to help your programming or testing tasks, FYIcenter.co...
Where to find online test tools? FYIcenter.com has prepared a number of online test tools: Data Look...
Where to find test data generators? FYIcenter.com has prepared a number of test data generators for ...
How to generate user full names? Test user names are frequently needed in testing applications that ...
How to generate test fractional numbers? Test fractional numbers are numbers with fractions that are...