MySQL Forums
Forum List  »  NDB clusters

Re: Error 4009
Posted by: Mauritz Sundell
Date: January 10, 2024 06:18AM

Hi Nisa

Without more information it is hard to say anything of slow queries except the general stuff as:

* it is a big query, even if it has a small result set it may scan lots of row maybe some useful index is missing

* row lock contention, maybe there are concurrent transactions updating the same rows. Maybe even dead locks.

Regards,
Mauritz

Options: ReplyQuote


Subject
Views
Written By
Posted
152
January 05, 2024 09:35PM
64
January 10, 2024 06:05AM
Re: Error 4009
61
January 10, 2024 06:18AM
84
January 10, 2024 06:34AM


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.