MySQL Forums
Forum List  »  InnoDB

Re: innodb keeps crashing due to out-of-memory errors
Posted by: Kostas Pyliouras
Date: March 03, 2005 07:30PM

- If you are not using myisam tables heavily you can descrease the key_buffer as Innodb does not use the keybuffer.

- In addition you could then decrease myisam_sort_buffer_size to a low value

- be aware that temporary tables are in myisam format and you seem to use them, so by descreasing myisam you suffer performance losses there

- check ulimit -a maybe you have some memory restrictions

- update your mysql version to the newest ;)

- I am not sure if the too low thread stack could cause problems, this might be a ulimit too

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: innodb keeps crashing due to out-of-memory errors
2860
March 03, 2005 07:30PM


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.