Name: mysql-benchmark-tool
Owner: HubSpot
Description: MySQL Benchmark Tool
Forked from: qaware/mysql-benchmark-tool
Created: 2016-07-15 20:53:46.0
Updated: 2016-07-15 20:53:47.0
Pushed: 2015-07-20 08:13:42.0
Homepage: null
Size: 2298
Language: Java
GitHub Committers
User | Most Recent Commit | # Commits |
---|
Other Committers
User | Most Recent Commit | # Commits |
---|
MySQL Benchmark Tool is a lightweight commandline tool for repeatedly executing SQL-Statements from a previously written MySQL-Log.
You can find precompiled jars in the bin folder: https://github.com/qaware/mysql-benchmark-tool/tree/master/bin
There's a blog post with more detailed explanation at: http://qaware.blogspot.de/2014/12/sql-benchmarking-tool-for-java.html
Here's a small abstract:
This article describes a simple java tool for recording and replaying MySQL queries while measuring their execution times. The replay mechanism makes the measurements comparable across different environments.
Why do we need another benchmarking tool? What's so special about this one?
Usage: MySQL Benckmark Tool [options]
Options:
-db
The database name. eg.: -db test_db
Default: test_db
-f
The result can be in default JETM style or CSV. JETM is default.
Default: JETM
-help, -h
Execute mysql query benchmark based on mysql logs
Default: false
-id
Only execute queries from the log with this connection id. This parameter
is optional.
-ignore
Ignore statements which start with these prefixes, case insensitive.
Enter a comma separated list of prefixes.
Default: []
-log
Location of the logfile which contains the mysql queries to execute
Default: benchmarking-queries.sql
-o
Location of the output file to write the results to
Default: results.txt
* -p
mysql password
-s
The connection string to the mysql server (without database name). eg.:
-c jdbc:mysql://localhost:3306/
Default: jdbc:mysql://localhost:3306/
* -u
mysql username
-verbose, -v
Print all results to console
Default: false