cashapp / spirit

Online Schema Change Tool for MySQL 8.0+
Apache License 2.0
113 stars 20 forks source link

Add relative ETA change to copy estimates #137

Closed morgo closed 4 months ago

morgo commented 1 year ago

It is expected that inserting into a larger table can slow down. This is particularly true if the table has unique indexes or is using Aurora (can't use insert buffer).

It is difficult for the copier to project the rate of which the slow down is occuring, but I wonder if (for multi-day DDLs) it is easier to surface it. i.e.

copier-remaining-time=217h7m22s (+30h from 1d ago).

This makes it very clear that as long as the estimate is going up by a lot, the value itself can't be trusted that much.

jayjanssen commented 5 months ago

sanity check design goals: