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 <[email protected]> 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: [email protected] >> For additional commands, e-mail: [email protected] >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
