MySQL Forums
Forum List  »  InnoDB

Re: innodb keeps crashing due to out-of-memory errors
Posted by: Eddie Moojen
Date: March 06, 2005 03:38PM

Reposting this from the news group (i will stick to the forum from now on):

Hi Heikki,

...

SHOW PROCESSLIST shows 10~20 connection threads,
_dead_ threads are being removed after 60s. (my.cnf: wait_timeout = 60)

...

Just before writing this (didnt read your response until just now), Ive
changed all HEAP tables (small) to MYISAM tables to see if thats the
problem. I was thinking that maybe some HEAP tables are munching
memory.


If this doesnt work, I will reduce tmp_table_size.


I will post my findings either way.


Thank you,


Eddie


.............


[root@s10 logs]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited


........


And in my.cnf
open_files_limit=65535


......................

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: innodb keeps crashing due to out-of-memory errors
1960
March 06, 2005 03:38PM


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.