My Oracle Support Banner

How Does MySQL Make Use Of Multicore Cpus (Doc ID 1494558.1)

Last updated on FEBRUARY 27, 2020

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

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.