[deleted]
Is 20M of rows still a valid soft limit of MySQL table in 2023?
31–40 of 86 posts
Re: Is 20M of rows still a valid soft limit of MySQL table in 2023?
#32Haven't had trouble into the low hundreds of millions on a single RDS server with 16GB of ram. YMMV.
Is that web scale?
Re: Is 20M of rows still a valid soft limit of MySQL table in 2023?
#33In my direct experience, with small rows and a carefully optimized workload and schema, 1 to 2 billion rows was totally fine in a single MySQL 5.1 table (InnoDB) on SSDs twelve years ago. Granted, that was on bare metal. But hardware has also improved a fair bit since then...
Re: Is 20M of rows still a valid soft limit of MySQL table in 2023?
#34Re: Is 20M of rows still a valid soft limit of MySQL table in 2023?
#35Re: Is 20M of rows still a valid soft limit of MySQL table in 2023?
#36Re: Is 20M of rows still a valid soft limit of MySQL table in 2023?
#37Re: Is 20M of rows still a valid soft limit of MySQL table in 2023?
#38Earlier quoted context omitted.
My current employer has a single InnoDB table that is 14-15 TB.
I bet queries take minutes.
An indexed read should be no different than on a table with on the order of 100K rows. And that’s even with good ol’ spinning rust.
It’s all about logical I/O operations which, for an indexed read, would only be a handful regardless of size as it’s operating on a btree: https://en.m.wikipedia.org/wiki/B-tree
Now creating that index from scratch might take a while though…
Re: Is 20M of rows still a valid soft limit of MySQL table in 2023?
#39[deleted]