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

          Ascending order - Click to sort in descending order
          valerii Valerii Kravchuk created issue -
          ratzpo Rasmus Johansson (Inactive) made changes -
          Field Original Value New Value
          Fix Version/s 10.0 [ 16000 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Assignee Oleksandr Byelkin [ sanja ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Issue Type Task [ 3 ] Bug [ 1 ]
          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)
          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 -

          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 made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          sanja Oleksandr Byelkin made changes -
          Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          serg Sergei Golubchik added a comment -

          ok to push

          serg Sergei Golubchik added a comment - ok to push
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          sanja Oleksandr Byelkin made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          sanja Oleksandr Byelkin made changes -
          Component/s OTHER [ 10125 ]
          Fix Version/s 10.4.2 [ 23229 ]
          Fix Version/s 10.1.38 [ 23209 ]
          Fix Version/s 10.0.38 [ 23211 ]
          Fix Version/s 10.3.13 [ 23215 ]
          Fix Version/s 10.2.22 [ 23250 ]
          Fix Version/s 10.0 [ 16000 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 90134 ] MariaDB v4 [ 155066 ]
          mariadb-jira-automation Jira Automation (IT) made changes -
          Zendesk Related Tickets 162207

          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.