MySQL Forums
Forum List  »  NDB clusters

Re: mysql 8 NDB php connections drop, cant connect
Posted by: Martin Sköld
Date: October 01, 2021 08:22AM

How can you determine a bottleneck in one of the ndbd, has it high CPU load?
Also, is it configured to use more cores, but you only see it using one?
That can be changed with manual configuration, see
If you have AutomaticThreadConfig set then you should use available cores.
Assuming of course you are using ndbmtd

Another thing, failing to connect to a mysql server usually has nothing to do
with the load of the Ndb Cluster. If the MySQL server is heavily loaded due to
certain queries (joins) that cannot be pushed to the Ndb nodes, then that could be a factor.
You should be able to connect, but have transactions time out due to
heavy load on the cluster. The failing to connect is probably something else.

Edited 2 time(s). Last edit at 10/01/2021 03:12PM by Martin Sköld.

Options: ReplyQuote

Written By
Re: mysql 8 NDB php connections drop, cant connect
October 01, 2021 08:22AM

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.