Insert large longtest failed on NDB

[Eric Poon]

Hello Everyone,

We want to use longtext column to save big data for an application. I got the error below when trying to insert a 500M string into a longtext column on a NDB. The same insert can be done on a SQL node as a standalone InnoDB.

I checked the documents, default value of MaxDMLOperationsPerTransaction is already maximum 4294967295. The NDB is isolated and should not have concurrent operations. I don't know what we can do.

Anyone please help.

Error:
Error Code: 1296. Got error 261 'DML count in transaction exceeds config parameter MaxDMLOperationsPerTransaction/MaxNoOfConcurrentOp' from NDBCLUSTER

Table:
CREATE TABLE `big_data_test` (
`id` int NOT NULL AUTO_INCREMENT,
`val` longtext,
`record_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=ndbcluster AUTO_INCREMENT=5 DEFAULT CHARSET=ascii;

SQL:
INSERT INTO big_data_test (val, record_id)
VALUES (REPEAT('x',1024*1024*500),3);

NDB:
1 management node 2G RAM
2 data nodes 6G RAM
1 SQL node 4G RAM

[ndbd default]
NoOfReplicas=1
DataMemory=1G
SharedGlobalMemory=1G
FragmentLogFileSize=64M
TimeBetweenLocalCheckpoints=12



Edited 2 time(s). Last edit at 11/03/2022 11:29AM by Eric Poon.