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 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. > > 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 make it a lot easier to collect the data remotely and write apps > that can monitor and make use of the data. > > Have you given any thought to that? (I have no idea what the effort > would be like, but it's can't hurt to ask...) it will take me 5 hours effective work time to add something like SHOW INNODB STATUS; I have to add it soon (June 2002), because the upcoming BMC Patrol Knowledge Module for InnoDB needs these stats to draw nice graphs. > Thanks, > > 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 18,745,524 queries (295/sec. avg) Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com --------------------------------------------------------------------- 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