Dear Wiki user, You have subscribed to a wiki page or wiki category on "Jakarta-jmeter Wiki" for change notification.
The following page has been changed by kenstir: http://wiki.apache.org/jakarta-jmeter/LogAnalysis The comment on the change is: New subsection re: summarizing jtl csv files ------------------------------------------------------------------------------ = Summarizing Huge Datasets = + == Shell Script to Aggregate Per Minute == 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. @@ -268, +269 @@ <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) == This script does two things. First it filters the JTL file for a regular expression. Then it strips them and outputs a CSV file. This also includes the conversion of the timestamp to a readable format. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
