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, 1764🔥, 0💬
Popular Posts:
How to Pass Windows Environment Variable to JMeter? I want to use Windows temporary folder environme...
How to generate test credit card numbers? Test credit card numbers are frequently needed in testing ...
Where to find test data generators? FYIcenter.com has prepared a number of test data generators for ...
Where to find tutorials on UFT (Unified Functional Testing) tool? I want to know how to use UFT. Her...
How to generate ISBN numbers? To help you to obtain some ISBN numbers for testing purpose, FYIcenter...