The manual indicates that you can specify a specific level to control
what types of warnings are logged:

http://dev.mysql.com/doc/refman/5.0/...r-options.html

(See section on log-warnings.)

But all I really get from this reading is 0 turns it off, 1 prints some
warnings, and 2 prints level 1 warnings plus aborted connections
warnings. I have not been able to find any additional information in my
search. Am I missing something, or is this all the documentation there
is on this?


Thanks,

Kristen G. Thorson
Programmer
(804) 553-1130, Ext. 204
www.AllegroConsultants.com

Kristen G. Thorson wrote:

Hi!

> But all I really get from this reading is 0 turns it off, 1 prints some
> warnings, and 2 prints level 1 warnings plus aborted connections
> warnings. I have not been able to find any additional information in my
> search. Am I missing something, or is this all the documentation there
> is on this?

What kind of additional information are you looking about the --W (or
--log-warnings=N) option?

I'd pay attention to aborted connections, as MySQL Network's monitoring
service actually does do so

kind regards
--
Colin Charles, Community Engineer
MySQL AB, Melbourne, Australia, www.mysql.com
Mobile: +614 12 593 292 / Skype: colincharles
Web: http://www.bytebot.net/blog/

MySQL Forge: http://forge.mysql.com/

> -----Original Message-----
> From: Colin Charles [mailto:colin@mysql.com]
> Sent: Wednesday, January 17, 2007 9:08 PM
> To: Kristen G. Thorson
> Cc: mysql@lists.mysql.com
> Subject: Re: Log Warnings Level
>
> Kristen G. Thorson wrote:
>
> Hi!
>
> > But all I really get from this reading is 0 turns it off, 1 prints
some
> > warnings, and 2 prints level 1 warnings plus aborted connections
> > warnings. I have not been able to find any additional information
in my
> > search. Am I missing something, or is this all the documentation
there
> > is on this?
>
> What kind of additional information are you looking about the --W (or
> --log-warnings=N) option?


Thank you for the response.

I was looking for information on how high the level can go - 2? 5? 200?
- and what types of warnings are logged for a given level?


> I'd pay attention to aborted connections, as MySQL Network's
monitoring
> service actually does do so


I'm not sure what you mean by this. Could you clarify?

Thanks!

Kristen G. Thorson wrote:

>>> But all I really get from this reading is 0 turns it off, 1 prints
> some
>>> warnings, and 2 prints level 1 warnings plus aborted connections
>>> warnings. I have not been able to find any additional information
> in my
>>> search. Am I missing something, or is this all the documentation
> there
>>> is on this?
>> What kind of additional information are you looking about the --W (or
>> --log-warnings=N) option?
>
>
> Thank you for the response.
>
> I was looking for information on how high the level can go - 2? 5? 200?
> - and what types of warnings are logged for a given level?

AFAIK, 2 is the highest. Anything beyond that, is equivalent to it

>> I'd pay attention to aborted connections, as MySQL Network's
> monitoring
>> service actually does do so
>
>
> I'm not sure what you mean by this. Could you clarify?

With a log level of 2 here, you actually get to see aborted connections

--
Colin Charles, Community Engineer
MySQL AB, Melbourne, Australia, www.mysql.com
Mobile: +614 12 593 292 / Skype: colincharles
Web: http://www.bytebot.net/blog/

MySQL Forge: http://forge.mysql.com/