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
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Sergei Petrunia [ psergey ] |
| Description |
I used AWS {{c5.2xlarge}}, 50Gb EBS ssd with 150 IOPs.
|
| Attachment | setup-os-ubuntu.sh [ 46877 ] | |
| Attachment | setup-percona-current.sh [ 46878 ] | |
| Attachment | setup-mariadb-current.sh [ 46879 ] |
| Description |
I used AWS {{c5.2xlarge}}, 50Gb EBS ssd with 150 IOPs.
|
I used AWS {{c5.2xlarge}}, 50Gb EBS ssd with 150 IOPs.
Servers: * MariaDB 10.3 current, revision 2999492c3278528ceb9f37bd6cfca5ca5295ef9a * Percona Server 5.7 current, revision 6604e02a4ae73a8d542ba70e71ad91f2af4514cb Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} |
| Description |
I used AWS {{c5.2xlarge}}, 50Gb EBS ssd with 150 IOPs.
Servers: * MariaDB 10.3 current, revision 2999492c3278528ceb9f37bd6cfca5ca5295ef9a * Percona Server 5.7 current, revision 6604e02a4ae73a8d542ba70e71ad91f2af4514cb Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} |
I used AWS {{c5.2xlarge}}, 50Gb EBS ssd with 150 IOPs.
Servers: * MariaDB 10.3 current, revision 2999492c3278528ceb9f37bd6cfca5ca5295ef9a * Percona Server 5.7 current, revision 6604e02a4ae73a8d542ba70e71ad91f2af4514cb Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} |
| Attachment | setup-sysbench-ubuntu.sh [ 46880 ] |
| Attachment | run-sysbench.sh [ 46881 ] |
| Description |
I used AWS {{c5.2xlarge}}, 50Gb EBS ssd with 150 IOPs.
Servers: * MariaDB 10.3 current, revision 2999492c3278528ceb9f37bd6cfca5ca5295ef9a * Percona Server 5.7 current, revision 6604e02a4ae73a8d542ba70e71ad91f2af4514cb Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} |
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 Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} |
| Attachment | out-percona-5.7-rocksdb.log [ 46882 ] |
| Attachment | out-mariadb-10.3-rocksdb.log [ 46883 ] |
| 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 Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} |
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 Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} Results: Percona 5.7 {noformat} n_threads, qps 20, 4117.79 50, 9487.79 80, 13952.85 100, 16852.61 150, 21942.59 {noformat} MariaDB 10.3 {noformat} n_threads, qps 20, 3125.01 50, 7494.81 80, 11821.79 100, 14749.30 150, 20313.95 {noformat} |
| Attachment | screenshot-1.png [ 46884 ] |
| Link |
This issue relates to |
| Summary | Run MyRocks benchmark: MariaDB vs Percona Server | Run MyRocks benchmark: MariaDB vs Percona Server vs FB/MySQL |
| 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 Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} Results: Percona 5.7 {noformat} n_threads, qps 20, 4117.79 50, 9487.79 80, 13952.85 100, 16852.61 150, 21942.59 {noformat} MariaDB 10.3 {noformat} n_threads, qps 20, 3125.01 50, 7494.81 80, 11821.79 100, 14749.30 150, 20313.95 {noformat} |
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 Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Facebook/MySQL 5.6 {noformat} log-bin=pslp binlog-format=row sync_binlog=1 rocksdb_block_cache_size=2G {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} Results: Percona 5.7 {noformat} n_threads, qps 20, 4117.79 50, 9487.79 80, 13952.85 100, 16852.61 150, 21942.59 {noformat} MariaDB 10.3 {noformat} n_threads, qps 20, 3125.01 50, 7494.81 80, 11821.79 100, 14749.30 150, 20313.95 {noformat} |
| 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 Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Facebook/MySQL 5.6 {noformat} log-bin=pslp binlog-format=row sync_binlog=1 rocksdb_block_cache_size=2G {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} Results: Percona 5.7 {noformat} n_threads, qps 20, 4117.79 50, 9487.79 80, 13952.85 100, 16852.61 150, 21942.59 {noformat} MariaDB 10.3 {noformat} n_threads, qps 20, 3125.01 50, 7494.81 80, 11821.79 100, 14749.30 150, 20313.95 {noformat} |
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 Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Facebook/MySQL 5.6 {noformat} log-bin=pslp binlog-format=row sync_binlog=1 rocksdb_block_cache_size=2G {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} Results: Percona 5.7 {noformat} n_threads, qps 20, 4117.79 50, 9487.79 80, 13952.85 100, 16852.61 150, 21942.59 {noformat} MariaDB 10.3 {noformat} n_threads, qps 20, 3125.01 50, 7494.81 80, 11821.79 100, 14749.30 150, 20313.95 {noformat} FB/MySQL-5.6 {noformat} n_threads, qps 20, 3291.02 50, 7711.92 80, 11394.20 100, 13300.78 150, 18795.42 {noformat} |
| Attachment | image-2018-12-26-12-14-32-900.png [ 46885 ] |
| 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 Settings that were added to my.cnf: MariaDB: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Facebook/MySQL 5.6 {noformat} log-bin=pslp binlog-format=row sync_binlog=1 rocksdb_block_cache_size=2G {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} Results: Percona 5.7 {noformat} n_threads, qps 20, 4117.79 50, 9487.79 80, 13952.85 100, 16852.61 150, 21942.59 {noformat} MariaDB 10.3 {noformat} n_threads, qps 20, 3125.01 50, 7494.81 80, 11821.79 100, 14749.30 150, 20313.95 {noformat} FB/MySQL-5.6 {noformat} n_threads, qps 20, 3291.02 50, 7711.92 80, 11394.20 100, 13300.78 150, 18795.42 {noformat} |
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: {noformat} log_bin=1 rocksdb_block_cache_size=2G binlog_format=row sync_binlog=1 {noformat} Percona Server: {noformat} rocksdb_block_cache_size=2G log_bin=1 {noformat} Facebook/MySQL 5.6 {noformat} log-bin=pslp binlog-format=row sync_binlog=1 rocksdb_block_cache_size=2G {noformat} Sysbench prepare and run commands: {code:sh} 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 {code} {code:sh} 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 {code} Results: Percona 5.7 {noformat} n_threads, qps 20, 4117.79 50, 9487.79 80, 13952.85 100, 16852.61 150, 21942.59 {noformat} MariaDB 10.3 {noformat} n_threads, qps 20, 3125.01 50, 7494.81 80, 11821.79 100, 14749.30 150, 20313.95 {noformat} FB/MySQL-5.6 {noformat} n_threads, qps 20, 3291.02 50, 7711.92 80, 11394.20 100, 13300.78 150, 18795.42 {noformat} |
| Attachment | screenshot-2.png [ 46886 ] |
| Link |
This issue relates to |
| Component/s | Storage Engine - RocksDB [ 13901 ] |
| Link |
This issue relates to |
| Attachment | screenshot-3.png [ 47884 ] |
| Workflow | MariaDB v3 [ 91396 ] | MariaDB v4 [ 130963 ] |