MySQL Bugs: #111868: benchmarksql performance degradation since 8.0.27

Bug #111868	benchmarksql performance degradation since 8.0.27
Submitted:	25 Jul 2023 2:54	Modified:	25 Jul 2023 12:37
Reporter:	yuanyue Zheng	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S5 (Performance)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Run Benchmarksql 5 minutes with 100 warehouses, performance degradation since 8.0.27
terminals	8.0.25	8.0.26	8.0.27	8.0.28	8.0.33
16	31490.87	31933.51	29714.01	29686.22	28538.86	
64	67768.26	66116.84	56933.99	56428.92	52323.21	
128	68241.78	66387.57	57698.51	58006.24	53736.86	
256	67672.77	66399.89	56748.29	57539.08	53628.16	
512	66987.62	66037.70	56853.44	56263.16	52494.95	

How to repeat:
run benchmarksql.

props.mysql:

db=mysql
driver=com.mysql.cj.jdbc.Driver
conn=jdbc:mysql://xxx.xxx.xxx.xxx:3306/tpcc
user=xxxx
password=xxxx

warehouses=100
loadWorkers=100

terminals=512
//To run specified transactions per terminal- runMins must equal zero
runTxnsPerTerminal=0
//To run for specified minutes- runTxnsPerTerminal must equal zero
runMins=5
//Number of total transactions per minute
limitTxnsPerMin=0

//Set to true to run in 4.x compatible mode. Set to false to use the
//entire configured database evenly.
terminalWarehouseFixed=false

//The following five values must add up to 100
//The default percentages of 45, 43, 4, 4 & 4 match the TPC-C spec
newOrderWeight=45
paymentWeight=43
orderStatusWeight=4
deliveryWeight=4
stockLevelWeight=4

// Directory name to create for collecting detailed result data.
// Comment this out to suppress.
resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS
osCollectorScript=./misc/os_collector_linux.py
osCollectorInterval=1
//osCollectorSSHAddr=user@dbhost
//osCollectorDevices=net_eth0 blk_xvde

Hi Mr. Zheng,

Thank you for your performance bug report.

There are ,however, already dozens of the reports like yours that show a degradation of the performance during the lifetime of 8.0.

Hence, your report is a duplicate of:

https://bugs.mysql.com/bug.php?id=111538

but, there are many, many other similar reports.

We are advising that you try to use new features in 8.0 and 8.1 which would render better performance.

Duplicate.

I face the same problem. It is probably this bug https://bugs.mysql.com/bug.php?id=112737

HI Mr. GUANGYOU,

We do not think that the verified bug that you mention is the one which is the original bug for this report.

Simply, benchmarksql is testing relational database servers on a number of DDL and DML statements, while the bug that you are mentioning is affecting only SELECT statements.