Bug #12130 SHOW WARNINGS improvement for monitoring
Submitted: 23 Jul 2005 12:06 Modified: 23 Jul 2005 15:40
Reporter: Jean-Luc Fontaine Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:4.1 OS:Any
Assigned to: CPU Architecture:Any

[23 Jul 2005 12:06] Jean-Luc Fontaine
Description:
For monitoring purposes, it would be extremely useful to have a timestamp column. This way, one could periodically retrieve the last warnings, that occured after the last poll.
PS: that would allow me to properly design a new mywarnings module for moodss (http://solutions.mysql.com/technology/technology/?item=119)

How to repeat:
show warnings
[23 Jul 2005 15:24] Jim Winstead
I'm not sure this request makes sense -- 'SHOW WARNINGS' does not show all warnings generated on the server, it is specific to the last statement.

A mechanism for getting at the server logs via SQL statements is in the works for a future release.
[23 Jul 2005 15:40] Jean-Luc Fontaine
>I'm not sure this request makes sense -- 'SHOW WARNINGS' does not show all
>warnings generated on the server, it is specific to the last statement.
You are right: I did not realize that.

>A mechanism for getting at the server logs via SQL statements is in the works
>for a future release.
That will do just fine, thanks, provided there is a way to retrieve the last entries from the last time SHOW LOGS was issued.