Bug #102289 buf_flush_or_remove_pages causes large tps fluctuation with write-heavy workload
Submitted: 19 Jan 2021 6:06 Modified: 20 Jan 2021 6:41
Reporter: Zhou Xinjing (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S5 (Performance)
Version:5.7, 8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: flush_list, innodb, perf

To submit contributions, please log in.

[19 Jan 2021 6:15] Zhou Xinjing 
The patch implements the above-mentioned approach.

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: flush-list-scan-opt.diff (application/octet-stream, text), 5.89 KiB.
[20 Jan 2021 6:16] Zhou Xinjing 
Patch for 8.0.33

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: flush-list-scan-opt-8.0.diff (application/octet-stream, text), 5.94 KiB.
[20 Jan 2021 12:15] Zhou Xinjing 
Previous patch does not handle concurrent io_fix accesses correctly. Here is an updated patch.

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: flush-list-scan-opt-8.0.diff (application/octet-stream, text), 6.85 KiB.