News for hackers. Stuff that matters.
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...

There are no comments on this comment yet.