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


Subject
Views
Written By
Posted
Re: Errors during 'Initial Load' on NDB cluster
454
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.