How Does MySQL Make Use Of Multicore Cpus
Last updated on AUGUST 21, 2017
Applies to:MySQL Server - Version 4.0 to 8.0 [Release 4.0 to 8.0]
Modern CPUs ( since early 2000s ) are no longer single core parts.
They are not only multi core, but also the individual cores are capable of executing multiple software threads in parallel.
For example, the Intel Xeon E7-8894-v4 has 24 cores, but reports 48 threads or "vCPUS" to the OS due to its SMT implementation.
This combination of multi core + Simultaneous Multi-Threading appears to the OS as distinct CPUs on which it can execute threads.
How does MySQL make use of all available (v)CPUs allocated to the OS on a running system.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms