: Friday, May 05, 2006 10:50 PM
Subject: Re: InnoDB Memory Problem causing mysql to crash
Well, according to my calculations:
innodb_buffer_pool_size + key_buffer_size
+ max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size)
+ max_connections*2MB
(I used the default
- Original Message -
From: sheeri kritzer [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, May 05, 2006 10:50 PM
Subject: Re: InnoDB Memory Problem causing mysql to crash
Well, according to my calculations:
innodb_buffer_pool_size + key_buffer_size
+ max_connections
Well, according to my calculations:
innodb_buffer_pool_size + key_buffer_size
+ max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size)
+ max_connections*2MB
(I used the default binlog_cache_size value of 32K plus your settings)
MySQL could use up to 4.991913 G of memory.
: mailing.database.myodbc
Sent: Friday, May 05, 2006 10:50 PM
Subject: Re: InnoDB Memory Problem causing mysql to crash
Well, according to my calculations:
innodb_buffer_pool_size + key_buffer_size
+ max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size)
+ max_connections*2MB
(I used
Hi,
I'm trying to resolve why InnoDB is crashing. It happened twice for the last
month without obvoius reason
Any help will be appreciated.
Dobromir Velev
My Server is
Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELsmp
Dual 3.2 GHz Intel Xeon
8 GB RAM
with 3 x 146GB
Hi all,
I have a problem about the innodb memory usage. The following is my
config file for mysql and the version I am using is 4.0.12 in FreeBSD
4.7 stable.
my.cnf
[mysqld]
port=3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = thread_cache_size=700
set-variable =
, and a hot backup tool for MySQL
.
Subject: Innodb memory problem
From: Kaming
Date: Mon, 31 Mar 2003 17:48:46 +0800
Hi all,
I have a problem about the innodb memory usage. The following is my
config file for mysql and the version I am using is 4.0.12 in FreeBSD
4.7 stable