Hi,
If you want to turn off binlog while analyzing slow logs, you can use --set-vars option + sql_log_bin=0 with pt-query-digest i.e
pt-query-digest --review localhost --user=root --password=root --set-vars sql_log_bin=0 mysql-slow.log
It will insert the record into percona_schema.review table but not write in binlog.
Hi,
If you want to turn off binlog while analyzing slow logs, you can use --set-vars option + sql_log_bin=0 with pt-query-digest i.e
pt-query-digest --review localhost --user=root --password=root --set-vars sql_log_bin=0 mysql-slow.log
It will insert the record into percona_ schema. review table but not write in binlog.