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 MySQL
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). If
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 memory.
please show us your
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 =
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 =
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.
Heikki Tuuri [EMAIL PROTECTED
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 running?
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