[MDEV-19295] Remove LOGFILE-related commands Created: 2019-04-19  Updated: 2023-11-30

Status: Open
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Data Definition - Create Table
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Ralf Gebhardt
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-19293 Remove information_schema.TABLESPACES Open
relates to MDEV-19294 Remove TABLESPACE-related commands Closed

 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?


Generated at Thu Feb 08 08:50:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.