Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-34169

Don't allow innodb_open_files to be lesser than number of non-user tablespace.

Details

    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
          thiru Thirunarayanan Balathandayuthapani added a comment -

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

          thiru Thirunarayanan Balathandayuthapani added a comment - https://github.com/MariaDB/server/pull/3255
          marko Marko Mäkelä added a comment -

          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 Marko Mäkelä added a comment - 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

            thiru Thirunarayanan Balathandayuthapani
            thiru Thirunarayanan Balathandayuthapani
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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