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?
Revision history for this message
| Nilnandan Joshi (nilnandan-joshi) wrote | #1 |
| Changed in percona-toolkit: | |
| status: | New → Invalid |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #2 |
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_