[Jakarta-jmeter Wiki] Update of "LogAnalysis" by kenstir

[Apache Wiki <wi...@apache.org>]

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: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org