| Author |
How NOT to log SHOW INNODB STATUS in the query log.
|
|
|
|
|
|
| Nathan Gross 2006-01-26, 4:56 pm |
| Aye. -v. thanks!
-nat
On 1/26/06, Pooly <pooly7@gmail.com> wrote:[color=darkred
]
> 2006/1/25, Nathan Gross <nat101sql@gmail.com>:
>
>
> If you have a linux box (or any acceptable shell)
> cat query.log | grep -i -v 'show innodb status' > query_clean.log
>
> grep -i : case insensitive
> grep -v : everything but the patterm given
> cat : well a cat is a cat...
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Imran Chaudhry 2006-01-27, 3:23 am |
| > Hi;
> My query.log is full of 'show innodb status' queries.
> How do I get this ascii log file not to log these. OR some help with a
> grep script to copy the file without these lines.
I noticed the same in the logs of a 4.1 test server. I put it down to
MySQL Administrator which was monitoring the server at the time. I
believe MYSQL Admin issues these SHOW STATUS commands periodically to
refresh it's status info screen.
Out of curiosity were/are you using MySQL Administrator or something
like a monitoring app with your MySQL servers?
Im
--
http://www.ImranChaudhry.info
MySQL Database Management & Design Services
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Nathan Gross 2006-01-27, 1:23 pm |
| On 1/27/06, Imran Chaudhry <ichaudhry@gmail.com> wrote:
>
> I noticed the same in the logs of a 4.1 test server. I put it down to
> MySQL Administrator which was monitoring the server at the time. I
> believe MYSQL Admin issues these SHOW STATUS commands periodically to
> refresh it's status info screen.
>
> Out of curiosity were/are you using MySQL Administrator or something
> like a monitoring app with your MySQL servers?
Yep! It's a test environment, and MySQL-Administrator is often open
for long periods in the background.
Thanks;
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|