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

System variables retentive setting (a.k.a. SET PERSIST)

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      I use 0 for autocommit variable. I was surprised a bit to find that setting

      SET global AUTOCOMMIT=0;

      is valid only until service restart. Then I get default (1) value again. To make it persistent I wrote it into my.cfg/my.ini file. Now it works.
      But I would like to ask possibility to set the variable usind "SET" command with some keyword to make it retentive.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ralf.gebhardt@mariadb.com Ralf Gebhardt
              Reporter:
              balta Tadas BalaiĊĦis
              Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated: