MySQL Forums
Forum List  »  NDB clusters

Re: Cannot delete rows from a NDB table
Posted by: Mikael Ronström
Date: November 09, 2017 03:27AM

MaxNoOfTriggers specifies how many meta data objects you can have at most.
So this setting defines how many tables you can define with triggers. For
example defining an ordered index uses one trigger object, defining a
foreign key uses at least 3 trigger objects.

MaxNoOfFiredTriggers sets the number of concurrently firing triggers you
can have. So this is short term memory that you have that is used for
execution of transactions.

Your problem was that MaxNoOfFiredTriggers was too low for your environment.
Normally this is very unusual, but I presume there is something special that
you do, either large transactions or a highly concurrent environment combined
with various foreign keys.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cannot delete rows from a NDB table
501
November 09, 2017 03:27AM


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.