On Windows® - but I guess it’s the same on another O.S. that does not support cluster - I noticed the following behavior when trying to execute a CREATE LOGFILE GROUP syntax like this:
CREATE
LOGFILE GROUP `test`
ADD UNDOFILE ‘test’
INITIAL_SIZE = 33M
UNDO_BUFFER_SIZE = 8M
ENGINE = NDBCLUSTER;
In v.5.1.25-rc, v.5.1.24-rc and v.5.1.23-rc, only SQL warnings are shown:
mysql> CREATE
-> LOGFILE GROUP `test`
-> ADD UNDOFILE ‘test’
-> INITIAL_SIZE = 33M
-> UNDO_BUFFER_SIZE = 8M
-> ENGINE = NDBCLUSTER;
Query OK, 0 rows affected, 2 warnings (0.01 sec)
mysql> SHOW WARNINGS;
…