You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Toni Menendez Lopez <to...@gmail.com> on 2012/05/17 21:44:15 UTC

Save results of Jmeter Tests in Mysql

Hello all,

I want to execute a long test in Jmeter, and I woould like to know if
exists the chance to save results in a Mysql table to later execute a
command in mysql with results.

IS there any listener for saving results of Jmeter in a Mysql or Oracle DB.

Thanks,

Toni.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


Re: Save results of Jmeter Tests in Mysql

Posted by oliver lloyd <ol...@hotmail.com>.
We spent some time working on this area. We did create a basic listener to write to mysql but in the end we decided to focus on loading the data after the test has completed, instead of real time - it's simpler and more reliable. The script we use is on github here: [https://github.com/oliverlloyd/jmeter-ec2], it probably does more than you need but the specific code to upload to mysql is in the import-results.sh file. This file is called from the main script towards the end, it's clearly marked.

On 17 May 2012, at 23:53, sebb wrote:

> On 17 May 2012 20:44, Toni Menendez Lopez <to...@gmail.com> wrote:
>> Hello all,
>> 
>> I want to execute a long test in Jmeter, and I woould like to know if
>> exists the chance to save results in a Mysql table to later execute a
>> command in mysql with results.
>> 
>> IS there any listener for saving results of Jmeter in a Mysql or Oracle DB.
> 
> Not in standard JMeter, but you can save the samples to a CSV file and
> use the database provider tools to add the contents to the database
> for subsequent analysis.
> 
> Should be easy enough to create a script to run JMeter and then upload
> the results on completion.
> 
> If you have Java programming skills you could potentially write a
> Listener to write samples to the database.
> Database inserts are generally much slower than writing to a file, so
> you would need to be careful that the Listener was able to process the
> records quickly enough so it did not affect JMeter throughput.
> 
>> Thanks,
>> 
>> Toni.
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>> For additional commands, e-mail: user-help@jmeter.apache.org
>> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


Re: Save results of Jmeter Tests in Mysql

Posted by sebb <se...@gmail.com>.
On 17 May 2012 20:44, Toni Menendez Lopez <to...@gmail.com> wrote:
> Hello all,
>
> I want to execute a long test in Jmeter, and I woould like to know if
> exists the chance to save results in a Mysql table to later execute a
> command in mysql with results.
>
> IS there any listener for saving results of Jmeter in a Mysql or Oracle DB.

Not in standard JMeter, but you can save the samples to a CSV file and
use the database provider tools to add the contents to the database
for subsequent analysis.

Should be easy enough to create a script to run JMeter and then upload
the results on completion.

If you have Java programming skills you could potentially write a
Listener to write samples to the database.
Database inserts are generally much slower than writing to a file, so
you would need to be careful that the Listener was able to process the
records quickly enough so it did not affect JMeter throughput.

> Thanks,
>
> Toni.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org