Enabling Swap Space

Swap space is necessary for the database components to function properly.

Swap Size

For production servers, set swap to 50% of the physical memory.

For testing systems, set swap to 100% of the physical memory.

Check available memory:

free
             total       used       free     shared    buffers     cached
Mem:       1922136    1274196     647940         32      92508     315664
-/+ buffers/cache:     866024    1056112
Swap:      2064380      31016    2033364

Enabling Swap

The following instructions describe how to create swap without restarting the server.

Create 1 GB file (1M * 1024). Increase count= as appropriate.

sudo dd if=/dev/zero of=/swapfile bs=1M count=1024

Set permissions and configure the swap file.

sudo chmod 0600 /swapfile
sudo mkswap /swapfile

Enable swap.

sudo swapon /swapfile

Enable swap on boot.

sudo echo "/swapfile swap swap defaults 0 0" >> /etc/fstab

Verify that the swap is enabled.

free

The output must contain a row with Swap total not equal to zero.

             total       used       free     shared    buffers     cached
Mem:       7697000    6104904    1592096         32      86628    3062424
-/+ buffers/cache:    2955852    4741148
Swap:      1023996          0    1023996