MySQL Forums
Forum List  »  NDB clusters

Re: ndbmtd not using all CPUs
Posted by: Mikael Ronström
Date: April 14, 2016 05:27PM

ndbmtd has a number of different thread types.
ldm threads uses the most CPU
tc, recv uses less CPU
send uses a fair amount of CPUs.

I don't know exactly what you did so it is hard to comment
more clearly.

The aim in ndbmtd is to make sure that the ldm threads are kept
busy. The other threads usually run between 30-70% loaded when
ldm threads reach around 90-95% load.

Why you get 100%, 200% and 350% I don't really know since there
is very little description of what you actually did.

Usually when I run benchmarks with MySQL Cluster like sysbench then
most of the CPU usage is in the mysqld process. A single thread
usually gives around 50% on mysqld and ndbtmd. Then as more threads
are added mysqld grows CPU usage fairly linearly whereas ndbmtd
becomes more and more effective as CPU usage goes up.

Options: ReplyQuote

Written By
March 05, 2016 06:00PM
March 06, 2016 12:07AM
Re: ndbmtd not using all CPUs
April 14, 2016 05:27PM

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.