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 robertpnz: http://wiki.apache.org/jakarta-jmeter/LogAnalysis The comment on the change is: jtlmin.sh.txt ?? ------------------------------------------------------------------------------ Script: attachment:jtlmin.sh.txt [[BR]] JMeter's output graph is too granular to depict throughput for extended test intervals (anything from 2 to 24 hours). An Excel constraint its maximum of 65536 rows. So to produce a throughput graph, JTL files of ~100k rows should be summarized into increments of 1 minute (or 2,5,n minutes depending on requirements). [[BR]]For each minute: throughput = count of transactions in that minute ; response time = average of 'elapsed' values in that minute. - [[BR]]The script `jtlmin.sh` summarizes large JTL files into 1 minute increments producing an OUT file that can be imported to Excel and a graph produced, as above. Example: + [[BR]]The script `jtlmin.sh` summarizes large JTL files into 1 minute increments producing an OUT file that can be imported to Excel and a graph produced. The core functionality in `jtlmin.sh` is this piece of awk code: - {{{ - $ jtlmin.sh - Usage: jtlmin.sh <filename> - Summarizes JMeter JTL output into 1-minute blocks - - $ jtlmin.sh queryBalance.jtl - Processing queryBalance.jtl - - $ ls q* - queryBalance.jtl queryBalance.jtl.OUT - - $ head queryBalance.jtl.OUT - /c/jmeter/performance/Myserver/output/queryBalance.jtl - unixtime date time thruput(tpm) response(ms) - 1160354940 2006.Oct.09 13:49 65 0 - 1160355000 2006.Oct.09 13:50 0 0 - 1160355060 2006.Oct.09 13:51 0 0 - 1160355120 2006.Oct.09 13:52 56 0 - 1160355180 2006.Oct.09 13:53 98 108 - 1160355240 2006.Oct.09 13:54 84 125 - 1160355300 2006.Oct.09 13:55 0 0 - 1160355360 2006.Oct.09 13:56 0 0 - }}} - - The core functionality in `jtlmin.sh` is this piece of awk code: {{{ # scan a JTL file for records in a specified interval # and return record count & average response time. @@ -278, +253 @@ } }}} + An example session, using `jtlmin.sh` to process a JTL file. The file produced, `queryBalance.jtl.OUT`, can now be used to produce throughput graph. Response times can also be included on the secondary axis, as in the diagram above. These graphs were very good at showing when the integration layer was slow to respond and when throughput varied from the original JMeter plan. + {{{ + $ jtlmin.sh + Usage: jtlmin.sh <filename> + Summarizes JMeter JTL output into 1-minute blocks + + $ jtlmin.sh queryBalance.jtl + Processing queryBalance.jtl + + $ ls q* + queryBalance.jtl queryBalance.jtl.OUT + + $ head queryBalance.jtl.OUT + /c/jmeter/performance/Myserver/output/queryBalance.jtl + unixtime date time thruput(tpm) response(ms) + 1160354940 2006.Oct.09 13:49 65 0 + 1160355000 2006.Oct.09 13:50 0 0 + 1160355060 2006.Oct.09 13:51 0 0 + 1160355120 2006.Oct.09 13:52 56 0 + 1160355180 2006.Oct.09 13:53 98 108 + 1160355240 2006.Oct.09 13:54 84 125 + 1160355300 2006.Oct.09 13:55 0 0 + 1160355360 2006.Oct.09 13:56 0 0 + }}} + --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
