5 ms·
Agreed. I have a handful of tables with over 2 billion rows and have experienced no issues. One database is 2.5TB in size. I feel like 20 million rows is a rela
by Guest9081239812 3y ago
Agreed. I have a handful of tables with over 2 billion rows and have experienced no issues. One database is 2.5TB in size. I feel like 20 million rows is a relatively small MySQL table.
- mensetmanusman 3y agoWhat types of data with over two billion rows?
- Guest9081239812 3y agoIt'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, helping to determine past and current trends for businesses.
- grumple 3y agoWe 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/information-schema-tables-table.html https://dev.mysql.com/doc/mysql-infoschema-excerpt/5.7/en/in... (same in MySQL 8; we use both 5.7 and 8)
- pollux1997 3y agoCould you provide some details, like MySQL version, IOPS and read/write performance?
- grumple 3y agoNice! We're at 9TB... I agree that 20M is small enough that I'm not concerned about performance at all.