Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6, 10.10(EOL), 10.11, 11.1(EOL), 11.2(EOL), 11.3(EOL)
Description
Ever since MDEV-12227 and MDEV-26782 were implemented, writes of pages of the InnoDB temporary tablespace should be rare. Because the lifetime of temporary tables is expected to be short, it would seem to make sense to assume that all temporary tablespace pages will remain in the buffer pool, and to disable the read-ahead for pages of the temporary tablespace.
Having read-ahead enabled for temporary tablespace pages would cause debug assertion failures in MDEV-28699. It is simplest to disable the read-ahead.
Attachments
Issue Links
- blocks
-
MDEV-28699 Shrink temporary tablespaces without restart
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue blocks |
| Description | Disable the read-ahead logic for temporary tablespace. |
Ever since Having read-ahead enabled for temporary tablespace pages would cause debug assertion failures in |
| Labels | performance |
| Fix Version/s | 10.6.16 [ 29014 ] | |
| Fix Version/s | 10.10.7 [ 29018 ] | |
| Fix Version/s | 10.11.6 [ 29020 ] | |
| Fix Version/s | 11.1.3 [ 29023 ] | |
| Fix Version/s | 11.2.2 [ 29035 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.10 [ 27530 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.1 [ 28549 ] | |
| Fix Version/s | 11.3 [ 28565 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Link | This issue is part of TODO-4253 [ TODO-4253 ] |
| Link | This issue is part of TODO-4253 [ TODO-4253 ] |
| Fix Version/s | 11.2.2 [ 29035 ] |