Db (Sql) Automated Stress/Load Tools

DB (SQL) automated stress/load tools?

JMeter from Apache can handle different server types. I use it for load tests against web applications, others in the team use it for DB calls. It can be configured in many ways to get the load you need. It can be run in console mode and even be clustered using different clients to minimize client overhead ( and so falsifying the results).

It's a java application and a bit complex at first sight. But still we love it. :-)

Load and Performance Testing of a Database

Usually, SysBench is used to test queries performance on MySQL. It is not just for MySQL, though. I have only a basic knowledge of it, so I suggest you don't ask me and read documentation:
http://sysbench.sourceforge.net/

Are web automation tools right for developing custom load/stress testing tools?

Essentially, yes. But to get a true test this would most definitely need multithreading or, preferably, be run on numerous clients against the site to reflect concurrent usage. This would make information gathering difficult (WCAT is very good for this but has a bit of steep learning curve).

I had considered writing something myself when I needed to do some stress testing as neither WCAT nor WAST really fit the bill. Had I looked into WebAii I would have considered it.

How to make load testing, query analysis in asp.net web application for a academic project

A free tool for load testing is Microsoft's WCat.

From the product description:

Web Capacity Analysis Tool (WCAT) is a
lightweight HTTP load generation tool
primarily designed to measure the
performance of a web server within a
controlled environment. WCAT can
simulate thousands of concurrent users
making requests to a single web site
or multiple web sites. The WCAT
engine uses a simple script to define
the set of HTTP requests to be played
back to the web server. Extensibility
is provided through plug-in DLLs and a
standard, simple API.

DB Testing for Web Application

Few toos in my mind which can be used for stress testing of your mysql server.

1. hammerdb:
   one of the open source database (i.e. mysql, oracle, sql server, etc) load testing tool.

2. mysql-stress-test-pl:
   Helps to run a test case in mysql server and also offer to compare the results of the test run.
   Following link provides all about syntax and their usages to run test cases:
   https://dev.mysql.com/doc/mysqltest/2.0/en/mysql-stress-test-pl.html

3. mysqltuner:
   performance tunning scripts helps to check current status of the server provides helpful recommendation as well. Please refer following link for the script:
   https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl

In addition, I have not used sysbench, mysqlslap but heard good feedback about them. You can try if you have time to explore.

Tools for Generating Mock Data?

Take a look at databene benerator, a test data generator that looks close to your requirements.

• it can generate data for an existing table definition (or even anonymize production data)
• it can generate larges data set (unlimited size)
• it supports various input (CSV, Flat Files, DBUnit) and output format (CSV, Flat Files, DBUnit, XML, Excel, Scripts)
• it can be used on the command line or through a maven plugin
• it's open source and customizable

I would give it a try.

BTW, a list of similar products is available on databene benerator's web site.

---

Related Topics