How Does MySQL Make Use Of Multicore Cpus
(Doc ID 1494558.1)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document