I have a server with 4 physical Xeon processors, each with 8 cores and each core is capable of 2 threads.
When I run MySQL queries I'm only seeing 1 CPU go to 100% in top and the total CPU usage at only 1.5%. I'm using MyISM as the MySQL engine.
Is it possible for MySQL to use all 64 threads instead of just the single one it is using right now?
If so, what outside of the default config do I need to change?
So far I tried everything in this article: Possible to make MySQL use more then one core
The only other idea I had was to run the query 64 different times and piece the results together which actually does engage all the threads but that seems a rather crude way to accomplish the multi-threading.