host is swapping?

Follow

bob bob

• November 22, 2018 11:13

Hi everyone , i keep on getting alerts that my host is swapping.

but i am not sure how to stop it, i am running the database on an lxc container on proxmox and set the swapping to 0.

I also tried to edit a file and change swapiness to 1 or 0 but i am getting access denied , even as root.

 

please assist.

0

• 

  Bart Oles

  • November 22, 2018 11:25

  Hi Bob,
  
  The swapines advisor is checking if you have it set to 1 which is a recommended value for database servers. If you have some grant issues on the server and would like to disable that you can go to Cluster->Performance->Advisor and disable it there.
  Please see the
  attached screenshot. 

   

  Kind regards,
  Bart

  0

  Comment actions Permalink
• 

  bob bob

  • November 22, 2018 11:34

  I have no write permissions to /proc/sys/vm/swappiness?

  even though:

  -rw-r--r-- 1 root root 0 Nov  5 13:01 swappiness

  0

  Comment actions Permalink
• 

  bob bob

  • November 22, 2018 11:37

  lsattr: Inappropriate ioctl for device While reading flags on ./swappiness

  0

  Comment actions Permalink
• 

  Ben M

  • November 28, 2018 19:47

  Using sysctl:

  sudo sysctl vm.swappiness=1

  To make it persist through a reboot, edit sysctl.conf:

  sudo nano /etc/sysctl.conf

  Add vm.swappiness=1 somewhere in there (bottom).

  0

  Comment actions Permalink
• 

  Ben M

  • November 28, 2018 19:54

  Hmm.. read about proxmox, not sure how it works and how containers work - closer to VMWare or Docker? Anyway, this article may be of assistance: Proxmox - Best performance - Disable swappiness

  0

  Comment actions Permalink

Please sign in to leave a comment.