Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Did you find a solution ? – zeflex Jan 10 '15 at 20:29
@zeflex I don't remember doing so, as I would have answered my question. – Pentium10 Jan 11 '15 at 16:54

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. :-(

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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