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
494
January 05, 2024 09:35PM
222
January 10, 2024 06:05AM
Re: Error 4009
208
January 10, 2024 06:18AM
451
January 10, 2024 06: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.