How-Much-Data-Is-Too-Big-for-Table.md

Conclusion

Limit about 200 million rows for recommendation,

the actual number of rows depends on the size of the data.

Reason

Due to the B+ tree,

the more rows,

the more layers b+ tree has,

and it means more I/O reading.