Slow logs are not showing full details

Posted on

Question :

I am new to mysql DB.
I have set log_slow_verbosity value to full.

root@localhost/(none)> SELECT @@global.log_slow_verbosity;
| @@global.log_slow_verbosity |
| microtime,query_plan,innodb |

But I am unable to see innodb,query_plan info in the mysqld-slow.log

Answer :

(A possible answer.)

Setting a global variable (anyone, not just this one), does not take effect immediately:

  • If you set it in my.cnf (etc), it would take effect until after a restart
  • If it is set globally (SET GLOBAL @@... ), it won’t take effect until someone logs in — he then gets that setting. (Caveat: Some globals have no “session” counterpart, so they don’t act this way.)
  • If you set it in your session, it does not apply to anyone else.

If this does not answer the question, please show us precisely how you set it. And provide SELECT @@version;

Leave a Reply

Your email address will not be published. Required fields are marked *