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

Remove big_tables system variable

Details

    Description

      The documentation and the source code both mention that the big_tables system variable is no longer needed.

      Should it be deprecated and/or removed?:

      https://github.com/MariaDB/server/blob/mariadb-10.4.5/sql/sys_vars.cc#L4126

      https://mariadb.com/kb/en/library/server-system-variables/#big_tables

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          sanja Oleksandr Byelkin added a comment - - edited

          OK to push after adding test for deprecated message.

          sanja Oleksandr Byelkin added a comment - - edited OK to push after adding test for deprecated message.
          serg Sergei Golubchik added a comment -

          Not removed. Marked deprecated for now.

          big_tables was used to tell the server to use on-disk temp tables to avoid "table is full" error when in-memory temp tables are used. This usage became unnecessary many years ago, the server can switch from in-memory to on-disk temp tables automatically.

          But big_tables can also be used to make the server to create temp-tables on disk right away, skiping the in-memory step. One can achieve the same effect now by setting tmp_memory_table_size=0.

          serg Sergei Golubchik added a comment - Not removed. Marked deprecated for now. big_tables was used to tell the server to use on-disk temp tables to avoid "table is full" error when in-memory temp tables are used. This usage became unnecessary many years ago, the server can switch from in-memory to on-disk temp tables automatically. But big_tables can also be used to make the server to create temp-tables on disk right away, skiping the in-memory step. One can achieve the same effect now by setting tmp_memory_table_size=0 .

          People

            serg Sergei Golubchik
            GeoffMontee Geoff Montee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.