MySQL Forums
Forum List  »  General

Re: MySql crashes
Posted by: Rick James
Date: March 19, 2016 10:38PM

For 512MB and MySQL running by itself.
Or for 1GB and other applications running.

innodb_buffer_pool_size = 250500500 --> 40M
thread_concurrency = 8 --> 4

key_buffer = 16M --> remove, redundant
key_buffer_size = 15M --> 10M

No, I can't say for sure that this will prevent the crashes.

You have turned off swapping: "KiB Swap: 0 total, 0 used, 0 free.", so if anything runs out of RAM, it will crash rather than slow down (serverly) and swap.

> perror 12
OS error code 12: Not enough space

Options: ReplyQuote


Subject
Written By
Posted
March 16, 2016 03:59AM
March 16, 2016 09:54AM
March 16, 2016 11:06AM
March 16, 2016 11:38AM
March 16, 2016 05:39PM
March 19, 2016 02:56PM
Re: MySql crashes
March 19, 2016 10:38PM
March 20, 2016 11:53AM
March 21, 2016 05:12PM
March 25, 2016 07:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.