Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
I used AWS c5.2xlarge, 50Gb EBS ssd with 150 IOPs. The scripts to setup servers, sysbench, and run the benchmark are attached. (one only needs to edit my.cnf and start servers)
Servers:
- MariaDB 10.3 current, revision 2999492c3278528ceb9f37bd6cfca5ca5295ef9a
- Percona Server 5.7 current, revision 6604e02a4ae73a8d542ba70e71ad91f2af4514cb
- Facebook/MySQL-5.6 current, revision 5e398eab68dbf58312ab1544f0e42084552967e1
Settings that were added to my.cnf:
MariaDB:
log_bin=1
|
rocksdb_block_cache_size=2G
|
binlog_format=row
|
sync_binlog=1
|
Percona Server:
rocksdb_block_cache_size=2G
|
log_bin=1
|
Facebook/MySQL 5.6
log-bin=pslp
|
binlog-format=row
|
sync_binlog=1
|
rocksdb_block_cache_size=2G
|
Sysbench prepare and run commands:
sysbench /usr/share/sysbench/oltp_update_non_index.lua \
|
--table-size=1000000 \
|
--threads=$threads \
|
--time=60 \
|
--rand-type=uniform \
|
--db-driver=mysql \
|
--mysql-socket=/tmp/mysql20.sock \
|
--mysql-user=root \
|
--mysql_storage_engine=$engine \
|
prepare
|
sysbench /usr/share/sysbench/oltp_update_non_index.lua \
|
--table-size=1000000 \
|
--threads=$threads \
|
--time=60 \
|
--rand-type=uniform \
|
--db-driver=mysql \
|
--mysql-socket=/tmp/mysql20.sock \
|
--mysql-user=root \
|
--mysql_storage_engine=$engine \
|
run
|
Results:
Percona 5.7
n_threads, qps
|
20, 4117.79
|
50, 9487.79
|
80, 13952.85
|
100, 16852.61
|
150, 21942.59
|
MariaDB 10.3
n_threads, qps
|
20, 3125.01
|
50, 7494.81
|
80, 11821.79
|
100, 14749.30
|
150, 20313.95
|
FB/MySQL-5.6
n_threads, qps
|
20, 3291.02
|
50, 7711.92
|
80, 11394.20
|
100, 13300.78
|
150, 18795.42
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
MDEV-17261 sysbench oltp read only too slow for MyRocks.
-
- Closed
-
-
-
- Closed
-