Not the answer you need?
Register and ask your own question!

Does percona change slow_query_log automatically?

alopezalopez EntrantCurrent User Role Beginner
Hello everybody, this is my first post so I do not know if I am posting in the right place :o I am a percona's noob and I want to set slow_query_log OFF. So inside my my.conf file is set OFF. I also checked percona's config files but I randomly detect this variable is been set ON. I forced a change with my server up: mysql> set global slow_query_log = 0; Query OK, 0 rows affected (0.00 sec) mysql> show global variables like 'slow_query_log'; +
+
+ | Variable_name | Value | +
+
+ | slow_query_log | OFF | +
+
+ 1 row in set (0.01 sec) But a few hours later I found it ON again. I had logged changes 1 hour and 11 hours later after the last change. mysql> show global variables like 'slow_query_log'; +
+
+ | Variable_name | Value | +
+
+ | slow_query_log | ON | +
+
+ So, I just want to know if pnn is enabling this variable ON or it is changed by any chron process or something similar. I also would thank any help to force slow_query_log to OFF Cheers :)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.