Hello, Say I wanted to log some various server status variables to a table. What I'd like to do, ideally, is something like this:
insert into SomeLogTable (Threads) show status like 'Threads_running'; MySQL does not allow this, of course. But, is there some other way to see the "Threads_running" (or other status variables) such that this would be possible? Incidentally, one of the things I'd like to log thus is the slave status "Seconds_Behind_Master". It's a little disappointing that you cannot do this: show slave status like 'Seconds_Behind_Master'; .. but rather have to get the entire slave status back in order to see this one thing. Anyway... If anyone has any ideas on this, I'd love to hear them. Thanks, - Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
