Add option to pt-table-checksum to override max execution
Bug #1707018 reported by
monty solomon
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
We configure our servers with a max execution time.
It would be useful to override that via an optimizer hint in the queries when running utilities like pt-table-checksum
To post a comment you must log in.
pt-table-checksum --no-check- binlog- format --function murmur_hash -h monty --recursion-method hosts --ignore-tables mysql.gtid_ executed, mysql.engine_ cost,mysql. server_ cost --tables foo.bar
07-27T16:42:50 Skipping chunk 1 foo.bar because MySQL used only 4 bytes of the PRIMARY index instead of 13. See the --[no]check-plan documentation for more information.
pt-table-checksum --no-check- binlog- format --function murmur_hash -h monty --recursion-method hosts --ignore-tables mysql.gtid_ executed, mysql.engine_ cost,mysql. server_ cost --tables foo.bar --no-check-plan
07-27T16:44:37 Error checksumming table foo.bar: DBD::mysql::st execute failed: Query execution was interrupted, maximum statement execution time exceeded