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 created issue -
          thiru Thirunarayanan Balathandayuthapani made changes -
          Field Original Value New Value
          Status Open [ 1 ] Confirmed [ 10101 ]
          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
          thiru Thirunarayanan Balathandayuthapani made changes -
          Assignee Thirunarayanan Balathandayuthapani [ thiru ] Marko Mäkelä [ marko ]
          Status Confirmed [ 10101 ] In Review [ 10002 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 11.0 [ 28320 ]
          Fix Version/s 11.3 [ 28565 ]
          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 .
          marko Marko Mäkelä made changes -
          Assignee Marko Mäkelä [ marko ] Thirunarayanan Balathandayuthapani [ thiru ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          marko Marko Mäkelä made changes -
          issue.field.resolutiondate 2024-06-07 10:54:11.0 2024-06-07 10:54:10.692
          marko Marko Mäkelä made changes -
          Fix Version/s 10.5.26 [ 29832 ]
          Fix Version/s 10.6.19 [ 29833 ]
          Fix Version/s 10.11.9 [ 29834 ]
          Fix Version/s 11.1.6 [ 29835 ]
          Fix Version/s 11.2.5 [ 29836 ]
          Fix Version/s 11.4.3 [ 29837 ]
          Fix Version/s 10.5 [ 23123 ]
          Fix Version/s 10.6 [ 24028 ]
          Fix Version/s 10.11 [ 27614 ]
          Fix Version/s 11.1 [ 28549 ]
          Fix Version/s 11.2 [ 28603 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]

          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.