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