How many records can be stored in the table at most?

Question

MySQL

There is a mysql table with the following structure:

How many records can be stored in such a table? What to do if you need to store more than 1 million. such records?

Answer 1

I have not heard that MySQL has some kind of limit on the number of records at the kernel level. It all depends on how much storage you have. As for 1 million records, this is not much, the average table size on a more or less highload project is 10-30 million. My project has tables with 300+ million records and everything is ok. If you have a question about how difficult it will be to make selections on such tables, then you need to properly design the table structure, think about indexes and optimize queries, the topic is quite extensive, you can find a lot of information on this subject on the Internet.