Re: InnoDB Memory Problem causing mysql to crash

2006-05-12 Thread sheeri kritzer
t; - 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

Re: InnoDB Memory Problem causing mysql to crash

2006-05-08 Thread Dobromir Velev
oDB which also backs up MyISAM > tables > http://www.innodb.com/order.php > > - Original Message - > From: ""sheeri kritzer"" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Friday, May 05, 2006 10:50 PM > Subject: Re: I

Re: InnoDB Memory Problem causing mysql to crash

2006-05-05 Thread Heikki Tuuri
t; <[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*(sort_buffer_size+read_buffer_size+binlog_cache_s

Re: InnoDB Memory Problem causing mysql to crash

2006-05-05 Thread sheeri kritzer
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. Shouldn'