MySQL Forums
Forum List  »  Quality Assurance

sysbench test show that 8.0.21 is faster than 8.0.23
Posted by: Liu Jack
Date: April 09, 2021 02:12AM

The sysbench (1.0.20) test command was

sysbench --test=oltp_read_write --tables=10 --table-size=1000000 --report-interval=10 --time=3600 --threads=50 --db-driver=mysql --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-password='xxx' --mysql-db=sbtest run

============= 8.0.21 test result =============

SQL statistics:
queries performed:
read: 15339058
write: 4382588
other: 2191294
total: 21912940
transactions: 1095647 (304.28 per sec.)
queries: 21912940 (6085.57 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)

General statistics:
total time: 3600.8045s
total number of events: 1095647

Latency (ms):
min: 2.74
avg: 164.30
max: 5033.06
95th percentile: 707.07
sum: 180014353.79

Threads fairness:
events (avg/stddev): 21912.9400/80.08
execution time (avg/stddev): 3600.2871/0.22

============= 8.0.23 test reuslt ================

SQL statistics:
queries performed:
read: 2969064
write: 848304
other: 424152
total: 4241520
transactions: 212076 (58.89 per sec.)
queries: 4241520 (1177.79 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)

General statistics:
total time: 3601.2587s
total number of events: 212076

Latency (ms):
min: 3.57
avg: 848.89
max: 6098.82
95th percentile: 1973.38
sum: 180029441.14

Threads fairness:
events (avg/stddev): 4241.5200/32.35
execution time (avg/stddev): 3600.5888/0.34


Both tests are performed on the same machine.
Are there any performance issue with 8.0.23?

Options: ReplyQuote


Subject
Views
Written By
Posted
sysbench test show that 8.0.21 is faster than 8.0.23
55
April 09, 2021 02:12AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.