Hi Heikki.
"Heikki Tuuri" <[EMAIL PROTECTED]> writes:
> Why does InnoDB allocate so much memory in your case? If you follow
> the memory allocation with innodb_monitor, does the allocation grow
> steadily over days? Then it could be a memory leak in InnoDB.
This might be the case. I started M
Per,
> set-variable= key_buffer=16M
> set-variable= sort_buffer=1M
> set-variable= record_buffer=1M
> set-variable= max_allowed_packet=16M
> set-variable= thread_stack=256K
> set-variable = innodb_log_file_size=32M
> set-variable = innodb_log_buffer_size=8M
>
> set-variable =
Hi Heikki.
"Heikki Tuuri" <[EMAIL PROTECTED]> writes:
> > Oh, by the way. The error does not occur if I use less memory.
>
> please show us your complete my.cnf.
# This will be passed to all mysql clients
[client]
#password = my_password
port= 3306
socket = /var/ru
Per,
- Original Message -
From: "Per Andreas Buer" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, June 16, 2002 2:10 PM
Subject: Re: innodb keeps crashing due to out-of-memory errors.
> Oh, by the way. The error does not occur if I use less memo
"Heikki Tuuri" <[EMAIL PROTECTED]> writes:
> good. I have also modified 3.23.52 so that it will generate a seg fault when
> it runs out of memory. That way we will get a stack trace on Linux.
The error occered again. Now I se that I only pick 10 frames of the
stack (curse me for cut'n pasteing).
Hi Heikki, thanks for replying so swiftly.
"Heikki Tuuri" <[EMAIL PROTECTED]> writes:
> this is probably a real bug. It is trying to allocate 1.5 GB of memory in
> one shot, which does not make sense. More probably the argument to the
> allocator is garbage.
>
> What MySQL version you are runn
Per,
- Original Message -
From: "Per Andreas Buer" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, June 15, 2002 11:40 PM
Subject: Re: innodb keeps crashing due to out-of-memory errors.
>
> Hi Heikki, thanks for replying so swiftly.
>
Hi.
I have a MySQL-server running Innodb. We have installed ~ 1.7GB of
memory in the server. In spite of this MySQL keeps crashing due to
out-of-memory errors. The server is a dual i686 running kernel Linux
2.4.18 (no patches - 4GB RAM supported).
I've enabled overcommit_memory (/proc/sys/vm/ov
