Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0, 10.1, 10.2, 10.3, 10.4, 10.5, 10.6
-
Component/s: Storage Engine - InnoDB
-
Labels:
Description
Loading the InnoDB buffer pool at startup is only using a single thread. This can be easily confirmed by starting the server and checking that perf top -H only shows one thread being active.
There is no reason at all to pass the parameter sync=true to buf_read_page_background(). If we allow buf_load() to submit asynchronous reads, multiple page checksums will be computed in parallel by the read completion threads while further pages are being read into the buffer pool.
Attachments
Issue Links
- blocks
-
MDEV-25417 reduce InnoDB buffer pool load time
-
- Closed
-
- relates to
-
MDEV-11378 AliSQL: [Perf] Issue#23 MERGE INNODB AIO REQUEST
-
- Needs Feedback
-