README ¶
BenchDB
BenchDB is a command line tool to test the performance of TiDB.
Quick Start
Make sure you have started PD and TiKV, then run:
./benchdb -run="create|truncate|insert:0_10000|update-random:0_10000:100000|select:0_10000:10"
Arguments
run
The run
argument defines the workflow of the test. You can define
multiple jobs, separated by |
. The jobs are executed sequentially.
The run
argument has the following options:
-
create
creates a table. Currently it's just a typical simple table, with a few columns. -
truncate
truncates the table. -
insert:xxx_yyy
inserts rows with ID in[xxx, yyy)
. e.g.insert:0_10000
inserts 10000 rows with ID in range[0, 9999)
. -
update-random:xxx_yyy:zzz
updates a row with a random ID in range[xxx, yyy)
, forzzz
times. e.g.update-random:100_200:50
updates 50 random rows with ID in range[100, 200)
. -
update-range:xxx_yyy:zzz
update a range of rows with ID in range[xxx, yyy)
, forzzz
times. -
select:xxx_yyy:zzz
select rows with ID range in[xxx, yyy)
, forzzz
times. -
gc
does a manually triggered GC, so we can compare the performance before and after GC. -
query:xxx:zzz
run a sql queryxxx
, forzzz
times.
The output shows the execution time.
table
The name of the table, so we can create many tables for different tests without the need to clean up.
Default is bench_db
.
blob
The blob column size in bytes, so we can test performance for different row size.
Default is 1000
.
batch
The batch number of statements in a transaction, used for insert and update-random only, to speed up the test workflow.
Default is 100
.
addr
The PD address. Default is 127.0.0.1:2379
.
L
The log level. Default is warn
.
Documentation ¶
There is no documentation for this package.