Bug #47255 Locking ndbd-angle process to a CPU/Core
Submitted: 10 Sep 2009 15:47
Reporter: Geert Vanderkelen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S4 (Feature request)
Version:mysql-5.1-telco-7.0 OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D5 (Feature request) / R6 (Needs Assessment) / E6 (Needs Assessment)

[10 Sep 2009 15:47] Geert Vanderkelen
Description:
Currently it is not possible to lock the ndbd-angle to a certain CPU. LockMaintThreadsToCPU and LockExecuteThreadToCPU are only for threads within the 'main' ndbd process.

How to repeat:
Cluster running configured with:
[NDBD DEFAULT]
LockExecuteThreadToCPU=2
LockMaintThreadsToCPU=1

# the angle
shell> taskset -pc 15176
pid 15176's current affinity list: 0-3
# the actual ndbd process
shell> taskset -pc 19598
pid 19598's current affinity list: 2

Suggested fix:
Workaround: set the affinity using taskset after starting the ndbd-angle.

Future: add config 'LockAngle'.