Question

Empy 4gb Partition Swap, sometimes mysql crash

hello i added about a week ago a 4g swap space on my host (1 GB Memory / 20 GB Disk), however its still stay empty also psichycal ram is nearly to max usage (sometimes mysql crash…), why?

ps i have several wordpress sites on my drop bye thank you all

Subscribe
Share

like tutorial report

If MySQL is crashing due to a lack of RAM, you may want to look in to resizing your droplet up a level. If it started using swap heavily enough it’d severely degrade performance.

You said that you went through the tutorial - what level did you set your ‘swapiness’ to?

hello already accomplished tutorial instruction, thank you there are my free -m

total used free shared buffers cached Mem: 994 841 152 45 2 174 -/+ buffers/cache: 664 329 Swap: 4095 45 4050

pos here what u get by typing

free -m

also checkout for this tutorial https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-ubuntu-14-04


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hello,

In addition to TimRCM I could suggest adjusting your InnoDB buffer pull size so that it matches your available RAM.

You could, for example, use the MySQL tuner script to get some recommendations:

https://github.com/major/MySQLTuner-perl

Regards, Bobby

This comment has been deleted