This is a simple tool to get some number on network latency.
Also it can be used to test prepared statement from JDBC.
Get the latest package from: http://public.dev.nuxeo.com/~ben/jdbctester/
Then install where you want:
tar xzvf jdbctester-*.tgz
Build:
mvn package
Create a binary package
./scripts/package.sh
Then untar where you want.
If you need to access other database than PostgreSQL, MySQL or MSSQL, you will have to add the JDBC Driver in the $JDBCTESTER_HOME/lib repository.
You need to create a configuration file that will contain the database access and the SQL query.
You can find 2 templates of configuration file in the jdbctester home:
Just copy one of them and edit to set your database credential and driver class.
You can use a simple round trip SQL query to test only the jdbc/network latency or choose to run complex prepared statement with parameters.
Note that by default jdbctester.sh set the following options, you shoud check that it matches your database locale:
-Duser.language=en -Duser.country=US
/path/to/jdbctester.sh PROPERTY_FILE [REPEAT]
REPEAT is number of time to repeat the SQL query, the default value is 10.
Example:
./jdbctester.sh postgresql.properties 10
This will create a jdbctester.log file and output something like this:
Connect to:jdbc:postgresql://localhost:5432/template1 from strix
Submiting 10 queries: SELECT 1;
Fetched rows: 10, total bytes: 25, bytes/rows: 2.5
connection:
count = 1
mean rate = 0.44 calls/s
1-minute rate = 0.00 calls/s
5-minute rate = 0.00 calls/s
15-minute rate = 0.00 calls/s
min = 946.97ms
max = 946.97ms
mean = 946.97ms
stddev = 0.00ms
median = 946.97ms
75% <= 946.97ms
95% <= 946.97ms
98% <= 946.97ms
99% <= 946.97ms
99.9% <= 946.97ms
execution:
count = 10
mean rate = 4.39 calls/s
1-minute rate = 0.00 calls/s
5-minute rate = 0.00 calls/s
15-minute rate = 0.00 calls/s
min = 35.60ms
max = 101.62ms
mean = 44.68ms
stddev = 20.06ms
median = 38.74ms
75% <= 40.07ms
95% <= 101.62ms
98% <= 101.62ms
99% <= 101.62ms
99.9% <= 101.62ms
fetching:
count = 10
mean rate = 4.39 calls/s
1-minute rate = 0.00 calls/s
5-minute rate = 0.00 calls/s
15-minute rate = 0.00 calls/s
min = 0.15ms
max = 17.35ms
mean = 1.87ms
stddev = 5.44ms
median = 0.15ms
75% <= 0.16ms
95% <= 17.35ms
98% <= 17.35ms
99% <= 17.35ms
99.9% <= 17.35ms
Nuxeo provides a modular, extensible Java-based open source software platform for enterprise content management and packaged applications for document management, digital asset management and case management. Designed by developers for developers, the Nuxeo platform offers a modern architecture, a powerful plug-in model and extensive packaging capabilities for building content applications.
More information on: http://www.nuxeo.com/