pt-table-checksum: First chunk takes too long
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned | ||
Bug Description
It would be nice if there were an option to set the initial chunk size. My understanding is that now, setting --chunk-size explicitly completely disables dynamic chunk sizing. I'd like a way to set --chunk-size WITHOUT disabling dynamic chunk sizing.
Background: I have a database with many tables, most of which are "normal" in that the assumption that checksumming the first 1000 rows won't take very long. But I have a couple of tables that contain binary data and have HUGE rows. Blithely checksumming 1000 of these can take a really long time.
I'd like to set an "initial chunk size" of 10 or even 1, and then allow the dynamic chunk sizer to take it from there. Alternatively, the default for --chunk-size could simply be changed from 1000 to 10 or 1. Is there a significant disadvantage to any table for the chunk size to start out small? The dynamic sizer would surely come up with the optimal number pretty quickly anyway.
Thank you!
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #1 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/