Page 2 of 4

Re: Mysql crash after some hours even i have 8gb Ram

Posted: Sun Nov 08, 2015 7:53 pm
by SCelik
Just start with creating a swap file... 4GB min ~ 8GB max...

Re: Mysql crash after some hours even i have 8gb Ram

Posted: Sun Nov 08, 2015 7:59 pm
by tomer628
SCelik wrote:Just start with creating a swap file... 4GB min ~ 8GB max...
OK.
i created 8GB swap file..

Re: Mysql crash after some hours even i have 8gb Ram

Posted: Mon Nov 09, 2015 12:26 am
by SCelik
What is the output of

Code: Select all

free -m
?

Re: Mysql crash after some hours even i have 8gb Ram

Posted: Mon Nov 09, 2015 4:27 am
by tomer628
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

Re: Mysql crash after some hours even i have 8gb Ram

Posted: Mon Nov 09, 2015 1:48 pm
by SCelik
Is there any crash after you activated swap?

Re: Mysql crash after some hours even i have 8gb Ram

Posted: Mon Nov 09, 2015 2:31 pm
by tomer628
At that meantime no.
But I need to test it between 3-7 days.
If it past, so I (you) fix that..
I will update..

For now this #free - m

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

Re: Mysql crash after some hours even i have 8gb Ram

Posted: Mon Nov 09, 2015 3:22 pm
by tjebbeke
Adding swap helps most of the time such mysql problems. Probably your swap doesn't need that size.

Re: Mysql crash after some hours even i have 8gb Ram

Posted: Mon Nov 09, 2015 7:27 pm
by SCelik
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.

Re: Mysql crash after some hours even i have 8gb Ram

Posted: Mon Nov 09, 2015 8:18 pm
by tomer628
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.
OK...
how can i do that ?

Re: Mysql crash after some hours even i have 8gb Ram

Posted: Mon Nov 09, 2015 8:58 pm
by tjebbeke
tomer628 wrote:
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.
OK...
how can i do that ?
mysqltuner.com is an very useful tool to tune your MySQL server.