MySQL Forums
Forum List  »  InnoDB

Re: innodb keeps crashing due to out-of-memory errors
Posted by: Eddie Moojen
Date: March 04, 2005 07:16AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: innodb keeps crashing due to out-of-memory errors
2935
March 04, 2005 07:16AM


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.