MySQL Forums
Forum List  »  NDB clusters

Insert large longtest failed on NDB
Posted by: Eric Poon
Date: November 03, 2022 11:27AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Insert large longtest failed on NDB
85
November 03, 2022 11:27AM
29
November 04, 2022 01:31PM


Sorry, only registered users may post in this forum.

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.