MySQL Bugs: #98070: Optimize write performance when group commit

Bug #98070	Optimize write performance when group commit
Submitted:	25 Dec 2019 12:33	Modified:	26 Dec 2019 7:39
Reporter:	Zhao Jianwei	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S5 (Performance)
Version:	8.0.18	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Contribution

Description:
Hi, guys
 
When group commit, leader will wake up followers through broadcast, but if the follower wait for other leader, it will continue to wait again. so here optimize the logic by waking up one by one. it can improve the write performance.

Here is the code contribution based on MySQL 8.0.18,  I have tested through sysbench oltp_insert.lua,  it can improve TPS.

How to repeat:
see the patch.

patch file ( Already OCA :) )

Attachment: x.diff (application/octet-stream, text), 12.78 KiB.

Hello Zhao Jianwei,

Thank you for the report and contribution.
I believe you have signed the Oracle Contribution Agreement (OCA) but your account still don't reflect the same. If you have sent signed OCA recently then it may take sometime to reflect. Please ensure to re-send the patch via "contribution" tab once your OCA is accepted. Otherwise we would not be able to accept it.

regards,
Umesh

Hi,
I didn't know why here my account didn't reflect the OCA label.

See my other contribution :  https://bugs.mysql.com/bug.php?id=95134

It seems that you are part of your company's OCA which is linked with company's email address and hence request you to submit the contribution using that account instead of personal one.

regards,
Umesh