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 brootstrap on Monday May 22, 2023 @11:12PM (#36039342)
have worked on 20TB+ tables before. proper schema / index / query, shit is still fast as hell when you do it right
[ 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:14PM (#36039356)
Yep, was just sharing this experience in the comments as well. By far the most painful part is schema migrations, and that's well-solved with pt-osc or gh-osc.
[ Parent | on HN ]
Re:Is 20M of rows still a valid soft limit of MySQL table in... by duskwuff on Tuesday May 23, 2023 @12:41AM (#36039900)
With MySQL 8.0+, you might not even need pt-osc. A lot of schema changes can be performed online now.

https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-op...

[ Parent | on HN ]
Re:Is 20M of rows still a valid soft limit of MySQL table in... by SteveNuts on Tuesday May 23, 2023 @12:59AM (#36040023)
And still my coworkers who 20 years ago were burned by some MySQL minor issue will laugh at the mere suggestion that we could probably use MySQL.

People still think it's a toy to this day and they've struggled to shake that perception.

[ Parent | on HN ]