Please confirm in real!
log_slow_slave_statements is global dynamic variable already!
mysql> show variables like 'log_slow_slave_statements';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| log_slow_slave_statements | OFF |
+---------------------------+-------+
1 row in set (0.00 sec)
mysql> set global log_slow_slave_statements=ON;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like 'log_slow_slave_statements';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| log_slow_slave_statements | ON |
+---------------------------+-------+
1 row in set (0.00 sec)
Please confirm in real! slave_statement s is global dynamic variable already!
log_slow_
mysql> show variables like 'log_slow_ slave_statement s'; ------- ------- ------- +------ -+ ------- ------- ------- +------ -+ slave_statement s | OFF | ------- ------- ------- +------ -+
+------
| Variable_name | Value |
+------
| log_slow_
+------
1 row in set (0.00 sec)
mysql> set global log_slow_ slave_statement s=ON;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like 'log_slow_ slave_statement s'; ------- ------- ------- +------ -+ ------- ------- ------- +------ -+ slave_statement s | ON | ------- ------- ------- +------ -+
+------
| Variable_name | Value |
+------
| log_slow_
+------
1 row in set (0.00 sec)