benchdb

command
v1.3.0 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Jun 12, 2022 License: GPL-3.0 Imports: 18 Imported by: 0

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), for zzz 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), for zzz times.

  • select:xxx_yyy:zzz select rows with ID range in [xxx, yyy), for zzz times.

  • gc does a manually triggered GC, so we can compare the performance before and after GC.

  • query:xxx:zzz run a sql query xxx, for zzz 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

The Go Gopher

There is no documentation for this package.

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL