MySQL Forums
Forum List  »  NDB clusters

Re: Errors during 'Initial Load' on NDB cluster
Posted by: Mikael Ronström
Date: June 21, 2021 05:11AM

Starting up 10000 threads in parallel issuing requests to 2 MySQL Servers
are very likely to cause issues. The commercial version of MySQL Cluster
has a thread pool service to handle things like this.

However it is rarely a good idea to have 10000 threads hitting at a
single database service. It is bound to lead to timeouts and other types
of resource errors.

So some sort of control of the parallelism sounds like a good idea. In
benchmarks one can see that up to around 500 concurrent threads works
fairly ok, after that the throughput drops with increasing number of
concurrent connections.

Options: ReplyQuote

Written By
Re: Errors during 'Initial Load' on NDB cluster
June 21, 2021 05:11AM

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.