insert into some table show status like 'foo'

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

RE: insert into some table show status like 'foo'

-Original Message- From: Chris Comparini [mailto:[EMAIL PROTECTED] Sent: Friday, December 15, 2006 2:12 PM To: mysql@lists.mysql.com Subject: insert into some table show status like 'foo' Hello, Say I wanted to log some various server status variables to a table. What I'd like to do, ideally

Re: insert into some table show status like 'foo'

On Friday 15 December 2006 11:23, Mikhail Berman wrote: Hi Chris, If you are running on *Nix you could write a script generally structured like: do - show status | grep 'what_ever_string_you_want_to_see' - insert into table - sleep [seconds] done Yes, we are, and

Re: insert into some table show status like 'foo'

At 11:12 AM -0800 12/15/06, Chris Comparini wrote: 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.

Re: insert into some table show status like 'foo'

On Friday 15 December 2006 11:53, Steve Edberg wrote: At 11:12 AM -0800 12/15/06, Chris Comparini wrote: 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