Mysql crash after some hours even i have 8gb Ram

[SCelik]

Just start with creating a swap file... 4GB min ~ 8GB max...

[tomer628]

Just start with creating a swap file... 4GB min ~ 8GB max...

OK.
i created 8GB swap file..

[SCelik]

What is the output of

Code: Select all

free -m

?

[tomer628]

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

[SCelik]

Is there any crash after you activated swap?

[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

[tjebbeke]

Adding swap helps most of the time such mysql problems. Probably your swap doesn't need that size.

[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.

[tomer628]

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 ?

[tjebbeke]

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.