MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
innodb keeps crashing due to out-of-memory errors
7080
Eddie Moojen
March 03, 2005 06:55PM
Re: innodb keeps crashing due to out-of-memory errors
2879
Kostas Pyliouras
March 03, 2005 07:30PM
Re: innodb keeps crashing due to out-of-memory errors
2924
Eddie Moojen
March 04, 2005 07:16AM
Re: innodb keeps crashing due to out-of-memory errors
2373
Kostas Pyliouras
March 04, 2005 09:02AM
Re: innodb keeps crashing due to out-of-memory errors
2589
Eddie Moojen
March 07, 2005 03:38AM
Re: innodb keeps crashing due to out-of-memory errors
2440
Kostas Pyliouras
March 08, 2005 06:35PM
Re: innodb keeps crashing due to out-of-memory errors
2285
Eddie Moojen
March 09, 2005 08:51AM
Re: innodb keeps crashing due to out-of-memory errors
2299
Kostas Pyliouras
March 09, 2005 08:55AM
Re: innodb keeps crashing due to out-of-memory errors
2144
Eddie Moojen
March 09, 2005 09:04AM
Re: innodb keeps crashing due to out-of-memory errors
2473
Kostas Pyliouras
March 09, 2005 09:28AM
Re: innodb keeps crashing due to out-of-memory errors
2507
Heikki Tuuri
March 05, 2005 01:47AM
Re: innodb keeps crashing due to out-of-memory errors
2626
Eddie Moojen
April 01, 2005 05:13AM
Re: innodb keeps crashing due to out-of-memory errors
2335
Ken Ellis
June 13, 2005 06:54AM
Re: innodb keeps crashing due to out-of-memory errors
2712
Heikki Tuuri
March 05, 2005 01:54AM
Re: innodb keeps crashing due to out-of-memory errors
1872
Eddie Moojen
March 06, 2005 03:38PM
Re: innodb keeps crashing due to out-of-memory errors
2343
Heikki Tuuri
March 07, 2005 01:58AM
Re: innodb keeps crashing due to out-of-memory errors
2438
Eddie Moojen
March 07, 2005 10:36AM


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.