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

make tmpdir a session modifiable variable

    XMLWordPrintable

    Details

      Description

      Currently, @@tmpdir is a read-only variable. Sometimes a DBA might need to run a particularly disk-consuming operation and doesn't want to exhaust all usual /tmp space. In these cases an ability to change @@session.tmpdir would be quite handy.

      Because the user case is real and @@tmpdir is read-only, engines work around it by implementing their own tmpdir-like variables. For example, there is @@innodb_tmpdir and @@rocksdb_tmpdir.

      • changing @@tmpdir, even a session value, must require FILE privilege.
      • global @@tmpdir can be set to a list of directories to be used in a round-robin fashion. I don't think we necessarily have to support it for a session variable, allowing only one dir there should be enough.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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