Boyd, sorry, only the output of innodb_monitor can be accessed through an SQL statement. The other monitors contain information mostly for special error situations.
But it is in the TODO to implement SHOW LOCKS ... That would be useful for application developers. Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL support from http://www.mysql.com/support/index.html .................. From: "Boyd E. Hemphill" ([EMAIL PROTECTED]) Subject: innodb monitoring This is the only article in this thread View: Original Format Newsgroups: mailing.database.myodbc Date: 2004-10-05 11:29:24 PST I notice the following special tables innodb_monitor, = innodb_lock_monitor, innodb_tablespace_monitor, innodb_table_monitor, and innodb_validate. The information from the first can be accessed from the MySQL client = prompt with show innodb status without creating the table and watch standard = output by issuing "show innodb status."=20 Is it possible to access the others in a similar way? Thanks for your time! Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2278 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
