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

Remove LOGFILE-related commands

    XMLWordPrintable

Details

    Description

      MariaDB Server's grammar supports the CREATE LOGFILE, ALTER LOGFILE, and DROP LOGFILE statements. These statements seem to have been inherited from MySQL NDB Cluster.

      https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html

      https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html

      https://dev.mysql.com/doc/refman/5.7/en/drop-logfile-group.html

      https://mariadb.com/kb/en/library/create-logfile-group/

      https://mariadb.com/kb/en/library/alter-logfile-group/

      https://mariadb.com/kb/en/library/drop-logfile-group/

      The MySQL NDB Cluster-compatible statements will actually still succeed on MariaDB, but will throw a warning. e.g.:

      MariaDB [db1]> CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undo.dat' INITIAL_SIZE = 10M;
      Query OK, 0 rows affected, 1 warning (0.00 sec)
       
      MariaDB [db1]> SHOW WARNINGS;
      +---------+------+------------------------------------------------------------------------------------------------+
      | Level   | Code | Message                                                                                        |
      +---------+------+------------------------------------------------------------------------------------------------+
      | Warning | 1478 | Table storage engine 'InnoDB' does not support the create option 'TABLESPACE or LOGFILE GROUP' |
      +---------+------+------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)

      Is there any reason to keep these in MariaDB?

      Attachments

        Issue Links

          Activity

            People

              ralf.gebhardt Ralf Gebhardt
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.