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...) 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) --------------------------------------------------------------------- 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
