Bug #34097 With log-slow-admin-statements off do not log I_S queries
Submitted: 27 Jan 2008 22:58
Reporter: Adam Dixon Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D5 (Feature request) / R2 (Low) / E2 (Low)

[27 Jan 2008 22:58] Adam Dixon
When log-slow-admin-statements is set to off, ensure that is also governs queries on information_schema - so that they do not log to slow query log.

How to repeat:
Currently log-slow-admin-statements applies only to;
"Log slow administrative statements such as OPTIMIZE TABLE, ANALYZE TABLE, and ALTER TABLE to the slow query log."

Suggested fix:
with log-slow-admin-statements OFF
Do not log I_S queries.