Re: Mysql crash after some hours even i have 8gb Ram
Posted: Sun Nov 08, 2015 7:53 pm
Just start with creating a swap file... 4GB min ~ 8GB max...
Community Forum
https://forum.vestacp.com/
OK.SCelik wrote:Just start with creating a swap file... 4GB min ~ 8GB max...
Code: Select all
free -m
SCelik wrote:What is the output of?Code: Select all
free -m
Code: Select all
# free -m
total used free shared buffers cached
Mem: 7680 3634 4046 2 278 1367
-/+ buffers/cache: 1988 5692
Swap: 8191 0 8191
Code: Select all
# free -m
total used free shared buffers cached
Mem: 7680 5159 2521 3 329 2707
-/+ buffers/cache: 2122 5557
Swap: 8191 0 8191
OK...SCelik wrote:This is first step for tuning your server. Swap is needed for extreme traffic. (For a moment mostly.) At normal usage, there is nothing to do with swap. You have to tune your mysql for your needs.
mysqltuner.com is an very useful tool to tune your MySQL server.tomer628 wrote:OK...SCelik wrote:This is first step for tuning your server. Swap is needed for extreme traffic. (For a moment mostly.) At normal usage, there is nothing to do with swap. You have to tune your mysql for your needs.
how can i do that ?