Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
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
-
- Open
-
Activity
Field | Original Value | New Value |
---|---|---|
Status | Open [ 1 ] | In Progress [ 3 ] |
issue.field.resolutiondate | 2021-09-06 07:52:04.0 | 2021-09-06 07:52:04.444 |
Fix Version/s | 10.5.13 [ 26026 ] | |
Fix Version/s | 10.6.5 [ 26034 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Link | This issue relates to MDEV-11378 [ MDEV-11378 ] |
Workflow | MariaDB v3 [ 124833 ] | MariaDB v4 [ 159663 ] |
Link |
This issue blocks |