On a new dedicated root server with Ubuntu 20.04.01, running only MySQL 8.x the system starts to swap extensively while enough RAM is available.
System:
- RAM 230GB
- Swap space 64GB
- InoDB_Buffer set to 170GB
- AMD EPYC 7502
- Ubuntu 20.04.01
- Swapiness 0,10
Filesystem Size Used Avail Use% Mounted on
tmpfs 23G 16M 22G 1% /run
/dev/mapper/vg0-root 30G 3.6G 25G 13% /
tmpfs 111G 0 111G 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
/dev/md0 485M 251M 209M 55% /boot
/dev/mapper/vg0-data 393G 245G 129G 66% /mnt/data
/dev/mapper/vg0-tmp 5.0G 33M 5.0G 1% /tmp
/dev/mapper/vg0-home 200G 52G 149G 26% /home
tmpfs 23G 0 23G 0% /run/user/1000
tmpfs 23G 0 23G 0% /run/user/1001
Only service running is MySQL with importing a large DB from MySQLdump (Table > 800M Datasets).
This does not happen on a smaller server with 128GB. Something seems to be misconfigured.
What could be the reason for swapping so extensively and how can this be fixed? It does not look like a stable system to me when swapping this much.