can pt-query-digest set a parameter to turn off binlog
Bug #1262553 reported by
wayuki
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Invalid
|
Undecided
|
Unassigned |
Bug Description
[In:Percona Toolkit Documentation]can pt-query-digest set a parameter to turn off binlog?when analyze slow logs,insert into record into review table ,the data will be exist in slave too,would you make a switch to turn it off?
To post a comment you must log in.
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.