pt-archiver should autolearn txn-size from limit if txn-size is not implied
Bug #1152559 reported by
David Busby
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
As the summary suggests, if --limit=100 is specified at runtime and --txn-size is not, then --txn-size should default to the --limit value, instead of defaulting to 1.
tags: | added: pt-archiver |
Changed in percona-toolkit: | |
status: | New → Triaged |
To post a comment you must log in.
On second look/thought, I'm not sure that --limit and --txn-size should be linked like this. --limit is "how many rows to select to archive", but --txn-size is "how many rows to commit for each txn", i.e. they do very different things. If one only wants to select the first 10,000 rows to archive, that doesn't imply they want them all in a 10k row txn; maybe they want 100 rows per txn.