PT-ONLINE-SCHEMA-CHANGE - possible time of running

Polyglot Projects Percona Toolkit
1

Hello guys,

I would like to use PT-ONLINE-SCHEMA-CHANGE for reclaiming free space of our production DB. The things is that the DB takes 2.3TB of space, so the question is, do you maybe know how much time the PT-ONLINE-SCHEMA-CHANGE will run in order to ALTER so huge DB?

Thank you in advance,

Denis

2

Hi there le_den, thanks for your question.

The dev team suggested that you could try the --dry-run option to see how long it takes to at least nibble at the table in question, from there you might be able to draw a best case estimate… Here’s a link: https://www.percona.com/doc/percona-toolkit/LATEST/pt-online-schema-change.html#cmdoption-pt-online-schema-change-dry-run

See how you get on?

3

Hi Lorraine,

And thank you for prompt response. I’ll try that.