MySQL Forums
Forum List  »  NDB clusters

Cannot Create more than 6 or 8 tables
Posted by: Andrew Sillifant
Date: March 09, 2021 07:34AM

Hi there ,

I am using an NDB cluster with 2 data nodes and 2 SQL nodes.

When attempting to create more than 6 tables I get an error message "Cannot create table "name".

When attempting to create a tablespace and setting the tables to that tablespace I Can create more tables but only up to 8.

Am I doing something wrong ?

here is my config.ini :

[ndb_mgmd default]
# Directory for MGM node log files
DataDir=/var/lib/mysql-cluster

[ndb_mgmd]
#Management Node db1
HostName=10.21.227.36

[ndbd default]
NoOfReplicas=2 # Number of replicas
DataMemory=368G # Memory allocate for data storage
SharedGlobalMemory=32G
DiskPageBufferMemory=16G
BackupDataBufferSize=64M
BackupLogBufferSize=64M
LockPagesInMainMemory=1
NoOfFragmentLogFiles=300
SchedulerSpinTimer=400
SchedulerExecutionTimer=100
RealTimeScheduler=1
TimeBetweenGlobalCheckpoints=300
TimeBetweenEpochs=200
RedoBuffer=64M
MaxNoOfExecutionThreads=48
MaxNoOfConcurrentOperations=10000
MaxNoOfTables=20320
#MaxNoOfAttributes=4294967039
MaxAllocate=1G
#MaxNoOfOrderedIndexes=2294967039
[ndbd]
#Data Node db2
HostName=10.21.227.39
NodeId=2
DataDir=/usr/local/mysql/data
BackupDataDir=/usr/local/mysql/backup
[ndbd]
#Data Node db3
HostName=10.21.227.40
NodeId=3
DataDir=/usr/local/mysql/data
BackupDataDir=/usr/local/mysql/backup
[mysqld]
#SQL Node db4
HostName=10.21.227.37

[mysqld]
#SQL Node db5
HostName=10.21.227.38


Here are some of the table definitions :

CREATE TABLE WebPages (
PageId INT AUTO_INCREMENT PRIMARY KEY,
LoadedOn TIMESTAMP NOT NULL,
ModifiedOn TIMESTAMP DEFAULT NULL NULL,
Updates INT DEFAULT 0 NOT NULL,
HeadersLength INT NOT NULL,
StatsLength INT NOT NULL,
TotalLength NUMERIC(20) NOT NULL,
HREFs INT NOT NULL,
HashURL INT NOT NULL,
HashHTML BLOB NOT NULL,
URL VARCHAR(2048) NOT NULL,
HTML LONGBLOB NOT NULL
) TABLESPACE tbsp STORAGE DISK ENGINE= NDB;
//
CREATE TABLE PointInTimeWrite (
WriteId INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
WrittenOn TIMESTAMP NOT NULL,
WriteHash VARCHAR(1024) NULL
) TABLESPACE tbsp STORAGE DISK ENGINE= NDB;
//
CREATE TABLE Imports (
FileName VARCHAR(256) NOT NULL PRIMARY KEY,
ImportedWebPages INT NOT NULL,
ImportedAllWebPages NUMERIC(9) NOT NULL
) TABLESPACE tbsp STORAGE DISK ENGINE= NDB;
//
CREATE TABLE WebPageHeaders (
HeaderId INT AUTO_INCREMENT PRIMARY KEY,
PageId INT NOT NULL,
ModifiedOn TIMESTAMP DEFAULT NULL NULL,
Updates INT DEFAULT 0 NOT NULL,
HeaderKeyLength INT NOT NULL,
HeaderKey VARCHAR(225) NULL,
HeaderValueLength INT NOT NULL,
HeaderValue LONGTEXT NULL
) TABLESPACE tbsp STORAGE DISK ENGINE= NDB;
//
CREATE TABLE WebPageStats (
StatId INT AUTO_INCREMENT PRIMARY KEY,
PageID INT NOT NULL,
ModifiedOn TIMESTAMP DEFAULT NULL NULL,
Updates INT DEFAULT 0 NOT NULL,
CodeType INT NOT NULL,
Length INT NOT NULL,
Stats BLOB NOT NULL,
B64S_Length INT NOT NULL,
B64S_Stats BLOB NOT NULL
) TABLESPACE tbsp STORAGE DISK ENGINE= NDB;
//
CREATE TABLE Configuration (
SchemaType VARCHAR(256) NOT NULL,
CreatedOn TIMESTAMP DEFAULT NULL NULL
) TABLESPACE tbsp STORAGE DISK ENGINE= NDB;

CREATE TABLE WebPagesUnicode_X01
(PageId INT NOT NULL PRIMARY KEY,
ModifiedOn TIMESTAMP DEFAULT NULL NULL,
Updates INT DEFAULT 0 NOT NULL,
URL_Length INT NULL,
URL VARCHAR(1000) NULL,
HTML_Length INT NULL,
HTML VARCHAR(1000) NULL,
URL_B64S_Length INT NULL,
URL_B64S VARCHAR(1000) NULL,
HTML_B64S_Length INT NULL,
HTML_B64S VARCHAR(1000) NULL)
TABLESPACE ts_1 STORAGE DISK ENGINE=NDB;

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot Create more than 6 or 8 tables
413
March 09, 2021 07:34AM


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.