[MDEV-34169] Don't allow innodb_open_files to be lesser than number of non-user tablespace. - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL)
Fix Version/s: 10.5.26, 10.6.19, 10.11.9, 11.1.6, 11.2.5, 11.4.3
Component/s: Storage Engine - InnoDB
Labels:
None

Description

InnoDB only closes the user tablespace when the number of open
files exceeds innodb_open_files limit. In that case, InnoDB should
make sure that innodb_open_files value should be greater
than number of undo tablespace, system and temporary tablespace.

Attachments

Activity

Ascending order - Click to sort in descending order

Thirunarayanan Balathandayuthapani added a comment - 2024-05-15 10:06

https://github.com/MariaDB/server/pull/3255

Thirunarayanan Balathandayuthapani added a comment - 2024-05-15 10:06 https://github.com/MariaDB/server/pull/3255

Marko Mäkelä added a comment - 2024-06-05 10:11

This looks OK. But please test if the minimum allowed innodb_open_files should be adjusted for the number of data files in the system or the temporary tablespace. That is, test with a multi-file innodb_temp_data_file_path.

Marko Mäkelä added a comment - 2024-06-05 10:11 This looks OK. But please test if the minimum allowed innodb_open_files should be adjusted for the number of data files in the system or the temporary tablespace. That is, test with a multi-file innodb_temp_data_file_path .

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Thirunarayanan Balathandayuthapani

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2024-05-15 10:02

Updated:: 2024-06-10 10:59

Resolved:: 2024-06-07 10:54

Git Integration

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

MariaDB Server