Re: MySql crashes
Posted by:
Rick James
Date: March 16, 2016 05:39PM
One of the error messages sounds like you are running MyISAM? Are you running both MyISAM and InnoDB?
1GB is _tiny_!
Just MyISAM: key_buffer_size = 40M; innodb_buffer_pool_size = 0
Just InnoDB: key_buffer_size = 5M; innodb_buffer_pool_size = 200M
Both: key_buffer_size = 20M; innodb_buffer_pool_size = 100M
(Peter's 700M out of 1000M seems dangerously high!)
max_connections = 10
thread_cache_size = 4
table_open_cache = 100
Some of these may be lower than necessary, but let's get rid of the crashes, then decide what can be (and needs to be) raised.
Subject
Written By
Posted
Re: MySql crashes
March 16, 2016 05:39PM
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.