This is what we do. So "how long" is a difficult thing to put a number on, since...

mh- on May 23, 2023 | parent | context | favorite | on: Is 20M of rows still a valid soft limit of MySQL t...

This is what we do. So "how long" is a difficult thing to put a number on, since you're intentionally throttling it to avoid impacting the database's performance (or building up slave lag).