Re: innodb keeps crashing due to out-of-memory errors

[Eddie Moojen]

Thanx for your reply,

maybe it's also good to know we use multiple large databases with alot of small querries. (25 p/s)

Kostas Pyliouras wrote:
> - If you are not using myisam tables heavily you
> can descrease the key_buffer as Innodb does not
> use the keybuffer.

We use a mix Innodb and myisam, but 95 % of the inserts are directed to innodb with batches filling myisam summary pages. so not sure if it wise to descrease it.

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

I have decreased the myisam_sort_buffer_size to 16M


> - 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

ulimit output:

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

any sugestions?

also note that the open files in my.cnf is set to 65000


> - 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

stack size (kbytes, -s) 8192

is this ok ?



Any other suggestions would be highly appreciated