Record too big in NDB engine
I recently updated ndb engine version from
$ ndbd -V
MySQL distrib mysql-5.6.29 ndb-7.4.11, for Linux (x86_64)
to
$ ndbd -V
MySQL distrib mysql-8.0.17 ndb-8.0.17-rc, for Linux (x86_64)
Now, I can't create a table with a moderate varchar primary key and a longtext field in ndb engine:
mysql> CREATE TABLE `m` ( `id` varchar(200) NOT NULL, `c` longtext NOT NULL, PRIMARY KEY (`id`)) ENGINE=ndbcluster;
ERROR 1005 (HY000): Can't create table 'm'
mysql> show warnings;
+---------+------+-----------------------------------------+
| Level | Code | Message |
+---------+------+-----------------------------------------+
| Warning | 1296 | Got error 738 'Record too big' from NDB |
| Error | 1005 | Can't create table 'm' |
+---------+------+-----------------------------------------+
I can create the table reducing varchar size up to 13 bytes, or using mediumtext instead of longtext, or using innodb engine.
After the docs, max key length is 3072 bytes, and max record size over 14K, so the table seems to be under those thresholds
Any explanation about the Record too big error?
Thank you in advance
Raul Andres
Subject
Views
Written By
Posted
Record too big in NDB engine
1494
October 21, 2019 01:47AM
655
October 24, 2019 09:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.