Re:Is 20M of rows still a valid soft limit of MySQL table in...
by twelve40 on Monday May 22, 2023 @09:11PM
(#36038644)
yeah i was also under the 20mil impression initially until building a system that worked with a 500mil row table without any problems (just a beefy RDS instance, nothing crazy distributed or anything). Schema changes became a pain at that point, so i would probably split it if I were to do it again, but reads and writes never gave us much trouble.
[ Parent
| on HN ]
Re:Is 20M of rows still a valid soft limit of MySQL table in...
by newtom on Monday May 22, 2023 @09:59PM
(#36038918)
check out gh-ost migrations: https://github.com/github/gh-ost
Re:Is 20M of rows still a valid soft limit of MySQL table in...
by charrondev on Monday May 22, 2023 @10:48PM
(#36039212)
What were you using for schema changes? I’ve been using pt-online-schema-change on InnoDB tables with 200m+ rows for a while, it’s just a bit slow.