News for hackers. Stuff that matters.

A comment on Is 20M of rows still a valid soft limit of MySQL table in 2023?. Parent comment

Re:Is 20M of rows still a valid soft limit of MySQL table in... by spudlyo on Monday May 22, 2023 @10:27PM (#36039090)
How long does it take you to do a schema change?
[ Parent | on HN ]
Re:Is 20M of rows still a valid soft limit of MySQL table in... by hu3 on Monday May 22, 2023 @10:39PM (#36039157)
Big MySQL deployments typically use pauseless online schema changes tooling like gh-ost:

https://planetscale.com/docs/learn/online-schema-change-tool...

[ Parent | on HN ]
Re:Is 20M of rows still a valid soft limit of MySQL table in... by mh- on Monday May 22, 2023 @11:39PM (#36039518)
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).
[ Parent | on HN ]