Is 20M of rows still a valid soft limit of MySQL table in 2023?

Re:Is 20M of rows still a valid soft limit of MySQL table in... by qeternity on Tuesday May 23, 2023 @03:18AM (#36041003)

Many DB systems have some sort of HLL function to provide a similar approximation (although I think you’re overestimating the costs that MVCC impose on large datasets).

[ Parent | on HN ]

Re:Is 20M of rows still a valid soft limit of MySQL table in... by ddorian43 on Tuesday May 23, 2023 @07:48AM (#36042972)

Note that HLL is used for counting `unique` things. You don't need HLL for counting the rows of the table.

[ Parent | on HN ]