Can I choose which CPUs / Cores to be used by MySQL?
Maybe not the answer you were looking for, but you could use a hypervisor like vmware esxi and use processor affinity to lock the virtual machine to any number of specific cpus.