I do want to enable log-queries-not-using-indexes of MySQL 5.0 but I do not want to have all the system queries there like SHOW TABLES, GRANTS and etc... which are indeed not using indexes.

How can I get a sanitized output or is there a different configuration available?

link|improve this question

50% accept rate
feedback

1 Answer

I haven't tried this, but setting --log-slow-admin-statements to false might help? It certainly would be nice if it did.

If it doesn't work, you may want to try your luck with Oracle to implement it. :-(

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.