MySQL Forums
Forum List  »  InnoDB

Re: innodb keeps crashing due to out-of-memory errors
Posted by: Kostas Pyliouras
Date: March 04, 2005 09:02AM

Seems okay, although you could descrease the variables even more, if you have indexed everything properly sort buffers can be smaller.

How many concurrent connections do you have, the err file shows 16, is that typical or do you have more, as the number of threads is crucial for the memory consumption.

Even if no additional mem is available the system should start swapping first and not kill itself. Any swapping going on?

Options: ReplyQuote

Written By
Re: innodb keeps crashing due to out-of-memory errors
March 04, 2005 09:02AM

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.