'Re: [Grinder-use] Calculating Transactions per sec'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       grinder-use
Subject:    Re: [Grinder-use] Calculating Transactions per sec
From:       "Calum Fitzgerald" <calum.fitzgerald () gmail ! com>
Date:       2008-11-13 10:39:48
Message-ID: 4acb0070811130239k13180a6fsd7d30ca4e5c86a3e () mail ! gmail ! com
[Download RAW message or body]

Hi Anil,

Personally I have no plan to port to Oracle or MySQL at the
moment...someone had mentioned they planned on doing an oracle port if
they had time...but they are a busy person so I wouldn't wait. :-)

I chose postgres because i thought it most closely followed Oracle and
it was free. I probably don't have the capacity to handle a couple of
ports at the moment whilst I'm still working on the features. Once I'm
pretty sure that the db does everything it needs to then I'll look at
porting it myself....but if you fancy doing a MySQL port then I'm more
than happy to help.

so onto the SQL that you need for working out the TPS...I'll explain
it in terms of views that you need to look at in the ground report db
to create it....if you want me to post the actual sql then I will in a
followup email...I'm also assuming that you are testing a website and
therefore generating http data

element_max_time_http (this works out how many milliseconds after the
start of the load run the last test finishes)
element_buckets_http (this uses max time and creates buckets of 1
second in size and sorts the data accordingly, elements and pages are
split as the pages would falsely inflate the TPS if included)
total_element_per_second_stats_http (this creates a per second summary
of all the elements/transactions from the elements_buckets data)
mean_load_run_throughput_stats_http (this sums up all the per second
elements/transactions in the total_elements_per_second data to give
you your TPS)

there are corresponding page views which will give you your PPS (pages
per second)

you should be able to use the sql to create views in MySQL...not sure
if the syntax would have to change a little...and maybe the function
to create the buckets might have a different name

I use the views to populate materialised views so that I only take the
processing hit once when doing the calculations but that might just
add further complication.

Hope this helps

Cheers
Cal


2008/11/13  <anil_jacob@comcast.net>:
> 
> Calum,
> 
> Thanks for the explanation, makes sense.
> 
> Is there a plan to port this utility to Oracle or MySql?
> 
> Which is the SQL are you refering to here? - "you should be able to copy the sql \
> across to msql pretty easily to calculate transactions per second". 
> Anil
> 
> -------------- Original message ----------------------
> From: "Calum Fitzgerald" <calum.fitzgerald@gmail.com>
> > have a look at the db i created in postgres for processing the raw files:
> > 
> > ground.sourceforge.net
> > 
> > You should be able to copy the sql across to msql pretty easily to
> > calculate transactions per second. Version 0.3 should be out next week
> > sometime.
> > 
> > basically you need to break down your raw data into buckets of a
> > certain length of time....for arguments sake buckets of 1 second in
> > duration
> > then you need to work out how many transactions finish within that
> > bucket. So if your load run lasts 100 seconds you'll have 100 buckets
> > to work out how many transactions finished in each.
> > 
> > (grinder 3.0 specific but the principle should be easy to move to 3.1,
> > and you only really need the data file)
> > 
> > for each test you know the start time since the start of the load run
> > and the length of duration that the test took....adding the length of
> > the duration that the test took to the start time gives you the finish
> > time. This will tell you what bucket your test finished in.
> > 
> > All you need to do after that is count up the number of tests that
> > finish in each bucket and you get your transactions per bucket (or in
> > this case per second)
> > 
> > clear as mud I'm sure but its saturday and my brain is still a little fuzzy
> > 
> > Cal
> > 
> > 2008/11/8  <anil_jacob@comcast.net>:
> > > 
> > > How do I calculate the Transactions per second for a test from the grinder
> > data and out log files?
> > > Any documentation on how to do this?
> > > 
> > > Need to upload TPS, response time for each test to a mysql database for
> > tracking purposes.
> > > 
> > > Thanks
> > > Anil
> > > 
> > > -------------------------------------------------------------------------
> > > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> > > Build the coolest Linux based applications with Moblin SDK & win great prizes
> > > Grand prize is a trip for two to an Open Source event anywhere in the world
> > > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > > _______________________________________________
> > > grinder-use mailing list
> > > grinder-use@lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/grinder-use
> > > 
> > 
> > -------------------------------------------------------------------------
> > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> > Build the coolest Linux based applications with Moblin SDK & win great prizes
> > Grand prize is a trip for two to an Open Source event anywhere in the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > _______________________________________________
> > grinder-use mailing list
> > grinder-use@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/grinder-use
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> grinder-use mailing list
> grinder-use@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/grinder-use
> 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
grinder-use mailing list
grinder-use@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/grinder-use


[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic