[MDEV-32145] Disable read-ahead for temporary tablespace Created: 2023-09-11  Updated: 2023-10-21  Resolved: 2023-09-11

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.6, 10.10, 10.11, 11.1, 11.2, 11.3
Fix Version/s: 10.6.16, 10.10.7, 10.11.6, 11.1.3

Type: Bug Priority: Major
Reporter: Thirunarayanan Balathandayuthapani Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 0
Labels: performance

Issue Links:
Blocks
blocks MDEV-28699 Shrink temporary tablespaces without ... Closed

 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.
Generated at Thu Feb 08 10:29:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.