Question
Empy 4gb Partition Swap, sometimes mysql crash
- Posted April 4, 2016
- Server OptimizationWordPressUbuntu
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
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!
Sign in to AnswerThese 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
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
also checkout for this tutorial https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-ubuntu-14-04