TG ( Transaction Generator ) is a simple load testing tool for commercial and free relational databases ( Example : ORACLE and MySQL, etc ).
Unlike other common load testing tools which send HTTP requests to the target application, TG generates SQL based transactions. Specifically, TG simulates a heavy load on the target database server with multiple virtual clients sending SQL statements at random which are specified manually.
TG enables various verification tests concerning the database system which include 1) testing the performance, 2) detecting the bottleneck in the database, 3) tuning the application, and other useful features.
<figure.1-1>
Windows platform
<figure.1-2>
Linux platform
<thumbnails>
startup
monitor
verbose
error
Database
Agents
Variables
Transactions
Jobs
Architechture
TG is developed using Java and runs on JVM(Java Virtual Machine). JVM is provided to various operating systems, for example Windows and Linux, UNIX, etc... Therefore TG can run on any platform.
TG uses JDBC( Java DataBase Connectivity ) driver to connect to the database. Therefore, TG can connect and send queries to any databases which is provided JDBC driver.
<figure.2>
TG simulates multiple users accessing the database simulatenously using the Java THREAD function. Incidentally, at TG we call THREAD "Agent". Each agent connects to the database and execute transactions in a random order according to the ratio which is previously specified.
<figure.3 *ORACLE Database sample >
TG generates a load with sending a series of SQL statements on the target database server which is registered as a transaction.
You can register multiple transactions on TG and set an execution-ratio to each transactions.
TG choose a transaction according to these execution-ratio.
And, You can use random variables into SQL statements which construct a transaction. For example, TG can access various data every time it execute transactions with random variable at the "WHERE" statement.
<figure.4>
Interface
You can choose two types of interface to control TG. 1) interactive command-line interface and 2) GUI based interface which is called TGC( TG Controller ). Using TGC, you can configure transactions and control agents more easily.
TGC and TG communicate with each other via the network. Therefore you can run both TG and TGC in different nodes at the same time. This is effective for arranging TG in a high performance server and controlling it from TGC which is running on a PC.
At the moment, TGC is available on windows and linux platform.
<figure.5>
Download TG
TG software is free. You can get TG using the following links.
