Video Demo:
Https://pan.baidu.com/s/1qYRMp7Q
Tool sysbench0.5 128 Concurrent 10 sheets 1 million rows
Hardware configuration R720 64G RAID10 (15000 rpm)
100 seconds for separate pressure measurement
Sysbench--test=/root/soft/sysbench-0.5/sysbench/tests/db/oltp.lua--mysql-table-engine=innodb--oltp-table-size= 1000000--max-requests=0--max-time=100--num-threads=128--oltp-tables-count=10--report-interval=10--mysql-host= 192.168.143.244--mysql-port=4000--mysql-user=admin--mysql-password=159753--mysql-db=test Run
############################################
PD+TIDB is deployed in a single machine 192.168.143.244
PORT: 4000
TIKV two sets of 192.168.143.245/246
Parameters
[ROCKSDB.DEFAULTCF]
Block-cache-size (30G)
[ROCKSDB.WRITECF]
Block-cache-size (10G)
[ROCKSDB.RAFTCF]
Block-cache-size (10G)
[10s] threads:128, tps:823.93, reads:11680.25, writes:3313.20, Response time:363.02ms (95%), errors:0.00, Reconnec ts:0.00
[20s] threads:128, tps:781.00, reads:10920.40, writes:3117.30, Response time:368.50ms (95%), errors:0.00, Reconnec ts:0.00
[30s] threads:128, tps:780.20, reads:10919.70, writes:3118.60, Response time:366.96ms (95%), errors:0.00, Reconnec ts:0.00
[40s] threads:128, tps:728.80, reads:10214.74, writes:2920.51, Response time:371.27ms (95%), errors:0.00, Reconnec ts:0.00
[50s] threads:128, tps:672.90, reads:9417.76, writes:2690.39, Response time:393.23ms (95%), errors:0.00, reconnect s:0.00
[60s] threads:128, tps:617.00, reads:8632.80, writes:2469.40, Response time:418.37ms (95%), errors:0.00, reconnect s:0.00
[70s] threads:128, tps:610.20, reads:8536.60, writes:2434.20, Response time:413.39ms (95%), errors:0.00, reconnect s:0.00
[80s] threads:128, tps:634.50, reads:8885.50, writes:2544.10, Response time:413.76ms (95%), errors:0.00, reconnect s:0.00
[90s] threads:128, tps:676.30, reads:9475.40, writes:2707.20, Response time:392.52ms (95%), errors:0.00, reconnect s:0.00
[100s] threads:128, tps:645.10, reads:9031.90, writes:2579.20, Response time:404.45ms (95%), errors:0.00, reconnect s:0.00
############################################
MariaDB BP (30G)
[10s] threads:128, tps:2678.24, reads:37599.85, writes:10720.26, Response time:70.10ms (95%), errors:0.00, Reconne cts:0.00
[20s] threads:128, tps:2851.70, reads:39931.01, writes:11405.40, Response time:58.07ms (95%), errors:0.00, Reconne cts:0.00
[30s] threads:128, tps:2846.10, reads:39843.50, writes:11384.70, Response time:58.52ms (95%), errors:0.00, Reconne cts:0.00
[40s] threads:128, tps:2490.69, reads:34935.71, writes:9972.07, Response time:60.70ms (95%), errors:0.00, Reconnec ts:0.00
[50s] threads:128, tps:2354.21, reads:32900.38, writes:9411.82, Response time:123.50ms (95%), errors:0.00, Reconne cts:0.00
[60s] threads:128, tps:2839.70, reads:39745.05, writes:11358.19, Response time:59.33ms (95%), errors:0.00, Reconne cts:0.00
[70s] threads:128, tps:2854.40, reads:39969.74, writes:11416.48, Response time:58.03ms (95%), errors:0.00, Reconne cts:0.00
[80s] threads:128, tps:2846.22, reads:39841.44, writes:11384.47, Response time:58.70ms (95%), errors:0.00, Reconne cts:0.00
[90s] threads:128, tps:2334.59, reads:32679.89, writes:9338.67, Response time:76.75ms (95%), errors:0.00, Reconnec ts:0.00
[100s] threads:128, tps:2843.30, reads:39819.07, writes:11374.99, Response time:59.16ms (95%), errors:0.00, Reconne cts:0.00
TIDB VS MariaDB10.1.19 Enterprise Performance Pressure measurement