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?
Subject
Views
Written By
Posted
sysbench test show that 8.0.21 is faster than 8.0.23
721
April 09, 2021 02:12AM
Sorry, you can't reply to this topic. It has been closed.
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.