Re: innodb rollbacks

2002-05-31 Thread Heikki Tuuri
Jeremy, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 8:43 PM Subject: Re: innodb rollbacks On Thu, May 30, 2002 at 12:16:28PM +0300, Heikki Tuuri wrote: However, if there are lots

Re: innodb rollbacks

2002-05-30 Thread Heikki Tuuri
technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, May 30, 2002 6:31 AM Subject: Re: innodb

Re: innodb rollbacks

2002-05-30 Thread Jeremy Zawodny
On Thu, May 30, 2002 at 12:16:28PM +0300, Heikki Tuuri wrote: However, if there are lots of updates, and the user has a dangling uncommitted consistent read to the database for a long time, then the size of the undo logs may become significant also in InnoDB. I have to consider adding the

Re: innodb rollbacks

2002-05-30 Thread Philip Molter
On Thu, May 30, 2002 at 10:43:58AM -0700, Jeremy Zawodny wrote: : Heikki, : : That reminds me of an InnoDB wish-list item I have. I like the level : of detail provided in the InnoDB monitor output. However, I'd really : like to be available via MySQL rather than just in the logs. That : will

Re: innodb rollbacks

2002-05-30 Thread Jeremy Zawodny
On Thu, May 30, 2002 at 02:30:07PM -0500, Philip Molter wrote: On Thu, May 30, 2002 at 10:43:58AM -0700, Jeremy Zawodny wrote: : Heikki, : : That reminds me of an InnoDB wish-list item I have. I like the level : of detail provided in the InnoDB monitor output. However, I'd really : like

Re: innodb rollbacks

2002-05-29 Thread Jeremy Zawodny
On Tue, May 21, 2002 at 10:41:51AM -0400, walt wrote: Thanks for your reply Jeremy! I'm an Oracle person, so I tend to think of things being in multiple files/tablespaces. Right. Do you know if there is a way to view the rollback stats? I checked the InnoDB monitor (details in the

Re: innodb rollbacks

2002-05-21 Thread Jeremy Zawodny
On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote: Does anyone know where rollbacks are stored for innodb tables? I assume memory since I keep getting a table full error when trying to drop an index. sql,query I'm not exactly sure what you're asking, but the rollback information needs

Re: innodb rollbacks

2002-05-21 Thread walt
On Tuesday 21 May 2002 12:24 am, Jeremy Zawodny wrote: On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote: Does anyone know where rollbacks are stored for innodb tables? I assume memory since I keep getting a table full error when trying to drop an index. sql,query I'm not exactly

innodb rollbacks

2002-05-20 Thread walt
Does anyone know where rollbacks are stored for innodb tables? I assume memory since I keep getting a table full error when trying to drop an index. sql,query Thanks for your help! -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608