...
Summarizing Huge Datasets
Shell Script to Aggregate Per Minute
Wiki Markup |
---|
attachment:perf-excel2.png [BR] As a software tester, sometimes you are called upon to performance test a web service (see \[:../UserManual/BuildWSTest:BuildWSTest\]) and present results in a nice chart to impress your manager. JMeter is commonly used to thrash the server and produce insane amounts of throughput data. If you're running 1000 tpm this can be rather a lot of data (180,000 transactions for a 3 hour test run). Even using the *Simple Data Writer*, this is beyond the capability of JMeter's inbuilt graphics package and is too much to import to Excel. |
...
No Format |
---|
<?xml version="1.0" encoding="UTF-8"?> <testResults version="1.2"> <httpSample t="511" lt="461" ts="1184177284608" s="true" lb="http://www.website.com/home.html" rc="200" rm="OK" tn="Thread Group 1-1" dt="text"/> <httpSample t="581" lt="481" ts="1184177284718" s="true" lb="http://www.website.com/home.html" rc="200" rm="OK" tn="Thread Group 1-1" dt="text"/> ... |
Postgres Script to Quickly Aggregate a CSV-format JTL
If you use CSV format logs, this method of summarizing one or more CSV files orders of magnitude faster than importing it into the Aggregate Report Listener. It requires PostgreSQL. Usage:
jtlsummary.sh jtl_csv_result_files...
Extracting JTL files to CSV with Python (JMeter 2.3.x)
...