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

              Assignee:
              ralf.gebhardt@mariadb.com Ralf Gebhardt
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: