Walt, Jeremy, the undo logs (= rollback segments) in the tablespace generally take much less space than the inserted rows. Thus it is best just to look with SHOW TABLE STATUS what is the available free space. I think in Oracle rollback segments use a lot more space than in InnoDB.
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 size info to the InnoDB Monitor. Best regards, Heikki Tuuri Innobase Oy --- Order 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 rollbacks > 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 InnoDB docs here > http://www.innodb.com/ibman.html) but don't see anything. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.51: up 0 days, processed 3,071,354 queries (252/sec. avg) > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
