Add option to pt-table-checksum to override max execution

Bug #1707018 reported by monty solomon
6
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

Revision history for this message
monty solomon (monty+launchpad) wrote :

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

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1435

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.