[MDEV-25417] reduce InnoDB buffer pool load time - Jira

XML

Word

Printable

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Fix Version/s: 10.11.2, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3
Component/s: Storage Engine - InnoDB
Labels:
None

Description

When InnoDB starts up, it can be limited by innodb_io_capacity (or innodb_io_capacity_max). Currently, users can increase these temporarily at startup, but this is not ideal, and neither should be left elevated.

Based on the discussion at https://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/InnoDB.20tuning/near/234486913, this task is to add a new parameter for use in buffer pool load (and read-ahead).

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

hdd_1_thd.png
15 kB
2022-11-28 08:28
hdd_32_thd.png
23 kB
2022-11-28 09:02
ssd_1_thd.png
12 kB
2022-11-28 08:53
ssd_32_thd.png
17 kB
2022-11-28 09:04

Issue Links

is blocked by

MDEV-26547 Restoring InnoDB buffer pool dump is single-threaded for no reason

Closed

relates to

MDEV-29343 MariaDB 10.6.x slower mysqldump etc.

Closed

MDEV-9930 Allow to choose an aggressive InnoDB buffer pool load mode

Closed

Activity

People

Assignee:: Daniel Black

Reporter:: Ian Gilfillan

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2021-04-14 13:38

Updated:: 2022-11-28 09:28

Resolved:: 2022-11-28 09:28

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.