Skip to content

SQL performance benchmarks

Kirill Yukhin edited this page Jan 18, 2018 · 7 revisions

TPC-C benchmark

Start benchmark

curl -X POST \
     -F token={TOKEN} \
     -F ref=master \
     -F "variables[BRANCH]={BRANCH}" \
     -F "variables[TIME]={TIME}" \
     https://gitlab.com/api/v4/projects/4294910/trigger/pipeline

Where:

  • {TOKEN} is trigger token. You should get it here (see tab "Pipeline triggers")
  • {BRANCH} is name of the tarantool branch to be tested. By default, it is 1.8
  • {TIME} is the time of the test run in seconds. By default, it is 2400 (i.e. 40 min).

You can see the status of the benchmark run here.

Results

You can see the results here: http://bench.tarantool.org?tab=tab-tpcc

Sysbench benchmark

Sysbench consists of 11 tests:

  • oltp_read_only
  • oltp_point_select
  • oltp_insert
  • oltp_update_index
  • oltp_update_non_index
  • select_random_points
  • select_random_ranges
  • bulk_insert
  • oltp_write_only
  • oltp_read_write
  • oltp_delete

Start benchmark:

curl -X POST \
     -F token={TOKEN} \
     -F ref=master \
     -F "variables[BRANCH]={BRANCH}" \
     -F "variables[TIME]={TIME}" \
     https://gitlab.com/api/v4/projects/4186534/trigger/pipeline

Where:

  • {TOKEN} is trigger token. You should get it here (see tab "Pipeline triggers")
  • {BRANCH} is name of the tarantool branch to be tested. By default, it is 1.8
  • {TIME} is the time of the test run in seconds of EACH test. By default, it is 220.

You can see the status of the benchmark run here

Results

You can see the results here: http://bench.tarantool.org?tab=tab-sysbench

Clone this wiki locally