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

Increase maximum possible value for table_definition_cache to match table_open_cache

Details

    Description

      In MariaDB 10.0.35+ the maximum possible value of table_open_cache was increased from 512K to 1024K (see https://jira.mariadb.org/browse/MDEV-11429). It makes sense to increase maximum possible value of table_definition_cache accordingly, to help avoid "General error: 1615 Prepared statement needs to be re-prepared" errors in some environments with a lot of tables.

      Attachments

        Activity

          Descending order - Click to sort in ascending order
          serg Sergei Golubchik added a comment -

          ok to push

          serg Sergei Golubchik added a comment - ok to push
          sanja Oleksandr Byelkin added a comment -

          revision-id: 1481d7a58b537d75f0a110e8a0514706adec669e (mariadb-10.0.37-41-g1481d7a58b5)
          parent(s): d0d0f88f2cd4da23c2c2da702da51fb533e7fb8a
          author: Oleksandr Byelkin
          committer: Oleksandr Byelkin
          timestamp: 2019-01-11 11:55:07 +0100
          message:

          MDEV-17475: Increase maximum possible value for table_definition_cache to match table_open_cache

          Allow table definition cache be bigger than open table cache (due to problem with VIEWs and prepared statements).

          sanja Oleksandr Byelkin added a comment - revision-id: 1481d7a58b537d75f0a110e8a0514706adec669e (mariadb-10.0.37-41-g1481d7a58b5) parent(s): d0d0f88f2cd4da23c2c2da702da51fb533e7fb8a author: Oleksandr Byelkin committer: Oleksandr Byelkin timestamp: 2019-01-11 11:55:07 +0100 message: MDEV-17475 : Increase maximum possible value for table_definition_cache to match table_open_cache Allow table definition cache be bigger than open table cache (due to problem with VIEWs and prepared statements).
          sanja Oleksandr Byelkin added a comment -

          it should be bigger if view used

          so 2x or 1.5x

          sanja Oleksandr Byelkin added a comment - it should be bigger if view used so 2x or 1.5x
          sanja Oleksandr Byelkin added a comment - - edited

          To avoid misinterpretation, what "accordingly" mean hear? (the same, 2 times more, 4 times less)

          sanja Oleksandr Byelkin added a comment - - edited To avoid misinterpretation, what "accordingly" mean hear? (the same, 2 times more, 4 times less)

          People

            sanja Oleksandr Byelkin
            valerii Valerii Kravchuk
            Votes:
            1 Vote for this issue
            Watchers:
            4 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.