MySQL Forums
Forum List  »  NDB clusters

Advanced Search
New Topic

Re: Can't create table
Posted by: Mauritz Sundell
Date: April 17, 2021 03:29PM

Hi Maurice,

Also both data nodes must be restarted after management node.

If that has been done one can verify that configuration used by data nodes with below:

ndb_config --config-from-node=3 --query=NodeId,MaxNoOfOrderedIndexes,MaxNoOfUniqueHashIndexes,MaxNoOfTables
ndb_config --config-from-node=4 --query=NodeId,MaxNoOfOrderedIndexes,MaxNoOfUniqueHashIndexes,MaxNoOfTables

If it shows the correct values (like 3,200000,200000,20000) try reduce all three to 20000, having more than 20320 for any of them is no gain.

Regards,
Mauritz

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Can't create table
1121
Maurice Sobiera
April 14, 2021 01:57PM
Re: Can't create table
470
Magnus Blåudd
April 14, 2021 02:51PM
Re: Can't create table
444
Maurice Sobiera
April 15, 2021 03:51AM
Re: Can't create table
479
Mauritz Sundell
April 15, 2021 06:02AM
Re: Can't create table
478
Maurice Sobiera
April 16, 2021 08:01AM
Re: Can't create table
493
Mauritz Sundell
April 16, 2021 11:31AM
Re: Can't create table
393
Maurice Sobiera
April 17, 2021 04:33AM
Re: Can't create table
434
Mauritz Sundell
April 17, 2021 03:29PM
Re: Can't create table
377
Maurice Sobiera
April 28, 2021 10:50AM
Re: Can't create table
421
Mauritz Sundell
April 28, 2021 11:51AM
Re: Can't create table
696
Maurice Sobiera
April 28, 2021 02:18PM
Re: Can't create table
427
Mauritz Sundell
April 28, 2021 02:59PM
Re: Can't create table
401
Maurice Sobiera
April 29, 2021 12:56AM
Re: Can't create table
364
Mauritz Sundell
April 29, 2021 02:49AM


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.