Re: innodb keeps crashing due to out-of-memory errors
- 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
Subject
Views
Written By
Posted
7568
March 03, 2005 06:55PM
Re: innodb keeps crashing due to out-of-memory errors
3069
March 03, 2005 07:30PM
3138
March 04, 2005 07:16AM
2540
March 04, 2005 09:02AM
2793
March 07, 2005 03:38AM
2605
March 08, 2005 06:35PM
2448
March 09, 2005 08:51AM
2450
March 09, 2005 08:55AM
2306
March 09, 2005 09:04AM
2608
March 09, 2005 09:28AM
2715
March 05, 2005 01:47AM
2897
April 01, 2005 05:13AM
2489
June 13, 2005 06:54AM
2883
March 05, 2005 01:54AM
2086
March 06, 2005 03:38PM
2525
March 07, 2005 01:58AM
2624
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.