When I being interviewed for a MySQL DBA position
Avoid Swappiness in MySQL
Swapping is process that occurs when system moves part of memory to a special disk space called “swap”. The event usually appears when your system runs out of physical memory and instead of freeing up some RAM, the system pushed the information into disk. As you might have guess the disk is much slower than your RAM.
By default the option is enabled:
vm.swappiness = 60
sysctl -w vm.swappiness=0
numactl --interleave=all
Kernel IO Scheduling Tuning
echo noop > /sys/block/sda/queue/scheduler
InnoDB Thread tuning
Swappiness
NUMA
Huge Pages
Avoid Swappiness in MySQL
Swapping is process that occurs when system moves part of memory to a special disk space called “swap”. The event usually appears when your system runs out of physical memory and instead of freeing up some RAM, the system pushed the information into disk. As you might have guess the disk is much slower than your RAM.
By default the option is enabled:
vm.swappiness = 60
sysctl -w vm.swappiness=0
numactl --interleave=all
Kernel IO Scheduling Tuning
echo noop > /sys/block/sda/queue/scheduler
InnoDB Thread tuning
Swappiness
NUMA
Huge Pages
No comments:
Post a Comment