Re:Is 20M of rows still a valid soft limit of MySQL table in...
by mensetmanusman on Monday May 22, 2023 @09:31PM
(#36038769)
What types of data with over two billion rows?
[ Parent
| on HN ]
Re:Is 20M of rows still a valid soft limit of MySQL table in...
by Guest9081239812 on Monday May 22, 2023 @09:44PM
(#36038837)
It's related to user activity, along the lines of products a user views. The other large tables in the billions of rows are about analyzing how products are performing on other websites over time to view historical data along with past and current trends.
Re:Is 20M of rows still a valid soft limit of MySQL table in...
by grumple on Tuesday May 23, 2023 @09:04AM
(#36043662)
We have two tables at nearly 2 billion rows for line items on invoices (we aggregate data for a substantial portion of a major industry). We have ~20 tables that are over 100 million rows but less than 1 billion. Looks like another ~20 tables over 20 million.
To get this info on your own mysql db: `select * from information_schema.TABLES;`. As previously disclaimed, the TABLE_ROWS here are an estimate generally, see https://dev.mysql.com/doc/mysql-infoschema-excerpt/5.7/en/in...