How to force MySQL to use 4 cores on a Quad Core Processor
I am looking to make MySQL server take full advantage of my CPU. It is alleged that the 64bit version does take advantage, however it is only using 1 of my 4 cores available (64bit 5.1 MySQL Server for Windows).
Is there a configuration option that needs to be set in the my.ini file or is there something else that needs to be "set" in order for this to work.
I have also tried elevating the task to no avail, and all 4 cores are checked off for it to use, however it is acting like a 32 bit application, even though it is most definitely the 64bit distribution.