How to configure the virtual machine that is used to run the database.

1, the Vcpus number is equal to or less than the physical core of a single physical CPU.

For example, a 4-way 8-core physical server that creates a virtual machine, the number of cores recommended for the virtual machines is 8 cores, or smaller.

2, the number of slots recommended "1"

3, the VRAM number of virtual machine is not higher than the number of NUMA node memory.

For example, the physical server is 4-Channel 8-core, 256G of memory, then the virtual machine memory should be (256-(256x4x0.01+1))/4x0.95 = 57GB

Formula: Memory per NUMA node = (number of physical memory-(number of physical memory XCPU slots x0.01+1g))/cpu slot x0.95

Simplified formula: Memory/CPU The number of slots, minus 10% margin.

This article is from "I'm Still alive" blog, please be sure to keep this source http://hujizhou.blog.51cto.com/514907/1619356

How to configure the virtual machine that is used to run the database.