MySQL Bugs: #47255: Locking ndbd-angle process to a CPU/Core

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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'.