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]
Generic Linux
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.

Goal

How does MySQL make use of all available (v)CPUs allocated to the OS on a running system.

Solution

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