Exam XK0-005 topic 1 question 172 discussion

To persist the parameter value indefinitely -- that is, until the user wants to change it again – they must manually update the sysctl.conf file. The command calls the nano text editor, which lets the user edit the file directly in the terminal. When the file opens, the user scrolls to the end of the text and adds the following setting. "vm.swappiness=0" >> append /etc/sysctl.conf && sysctl -p sysctl -p ( ( allows you to load the settings from a configuration file )

Linux swappiness is a kernel parameter that determines how aggressively the Linux virtual machine (VM) swaps pages between memory and the swap space on the system's disk. Users can fine-tune the rate at which a Linux kernel can move pages into and out of active memory using the swappable parameter, which can be set between 0 and 200. The higher the number, the more aggressively the VM swaps data to disk. By default, the swappiness value on most Linux computers is set to 60. The user can change this level to a different setting either temporarily or indefinitely. Some database servers managed cache to use RAM, and is capable of managing what should be in RAM and what shouldn’t be. Allowing the Linux operating system to have too much control over what memory pages are in RAM is likely to lower your database performance. Therefore, it is recommended that swappiness should be set to 0.