Latency
Last updated
Was this helpful?
Last updated
Was this helpful?
Our approach to SQL performance benchmarking is to use sysbench, an
industry standard benchmarking tool. We also benchmark Dolt using, an industry standard transactional
throughput metric.
Dolt is slightly slower than MySQL on the sysbench test suite.
The goal is to get Dolt to match MySQL latency for common operations.
Dolt is currently 10% slower than MySQL, approximately 10% faster
on writes and 33% slower on reads. The multiple column represents this
relationship with regard to a particular benchmark.
Dolt gets about 40% of the transactional throughput on TPC-C than MySQL, 40 transactions per second versus about 100 for MySQL. Most applications are not sensitive to transactional throughput beyond a handful per second.
It's important recognize that these are industry standard tests, and are OLTP oriented. Performance results may vary but Dolt is generally competitive on latency with MySQL and Postgres.
Below are the results of running sysbench MySQL tests against Dolt
SQL Server for the most recent release of Dolt in the current default
storage format. We will update this with every release. The tests
attempt to run as many queries as possible in a fixed 2 minute time
window. The Dolt and MySQL columns show the median latency in
milliseconds (ms) of each query during that 2 minute time window.
The Dolt version is 1.52.2.
covering_index_scan
1.86
0.65
0.35
groupby_scan
13.22
17.63
1.33
index_join
1.44
2.39
1.66
index_join_scan
1.44
1.42
0.99
index_scan
34.33
30.81
0.9
oltp_point_select
0.18
0.26
1.44
oltp_read_only
3.43
5.18
1.51
select_random_points
0.33
0.6
1.82
select_random_ranges
0.37
0.62
1.68
table_scan
34.95
31.94
0.91
types_table_scan
74.46
130.13
1.75
reads_mean_multiplier
1.3
oltp_delete_insert
8.9
6.32
0.71
oltp_insert
4.03
3.07
0.76
oltp_read_write
8.9
11.45
1.29
oltp_update_index
4.18
3.13
0.75
oltp_update_non_index
4.18
3.07
0.73
oltp_write_only
5.67
6.32
1.11
types_delete_insert
8.28
6.67
0.81
writes_mean_multiplier
0.88
tpcc-scale-factor-1
97.68
39.49
2.47
tpcc_tps_multiplier
2.47