Bug #29244 | log-queries-not-using-indexes logs all UNION SELECTs to slow query log | ||
---|---|---|---|
Submitted: | 20 Jun 2007 16:12 | ||
Reporter: | Axel Schwenke | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Logging | Severity: | S4 (Feature request) |
Version: | 4.1.22, 5.0.44, 5.1.20 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[20 Jun 2007 16:12]
Axel Schwenke
[7 Nov 2010 6:35]
Michael Furdyk
This is severely polluting and growing our slow query log, so just wanted to add a +1 to the usefulness of this!
[21 Jan 2011 7:53]
Michal Kovacik
I have to agree with you. Logging this type of UNION queries is completely useless.
[30 Jan 2012 0:09]
Gavin Stark
+1 the individual queries comprising the UNIONs should be considered for index usage
[19 Apr 2012 4:03]
jacky leung
+1 For this issue, this have cause a lot of false positive alert if using monitoring base on slow queries status