Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have MySQL Cluster instance and want one column (BLOB) to be stored on disk instead of memory.
I tried to follow this tutorial:
And this is output I am getting:

mysql> CREATE DATABASE test1;
Query OK, 1 row affected (0.00 sec)
mysql> use test1;
Database changed
    -> ADD UNDOFILE 'undofile.dat'
    -> ENGINE = NDB;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '16M
ENGINE = NDB' at line 3

Here is syntax for this command:
Any ideas why this is not working? I cannot find where I am violating this command syntax.

share|improve this question
Why do you put = for some parameters and not others? – Mat Aug 18 '13 at 8:03
@Mat That is copied from tutorial I have provided. Even without any = error is still the same. – Michał Herman Aug 18 '13 at 8:07
Is the error still there if you convert the 16M to 16*1024*1024 (and the 1M respectively)? – ypercubeᵀᴹ Aug 18 '13 at 11:02
Also test what happens if you put equal signs everywhere CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' INITIAL_SIZE = 16M UNDO_BUFFER_SIZE = 1M ENGINE = NDB; – ypercubeᵀᴹ Aug 18 '13 at 11:13
up vote 1 down vote accepted

CREATE LOGFILE GROUP and CREATE TABLESPACE accept only bytes as unit.

With MB converted to bytes logfile group was created successfully for me.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.