What is the limit on records in the database and what is their weight?

Question

MySQL

Must create a custom post on the site.

If we calculate that within six months 10K users will have 15 chats with 50 messages in each, then this turns out to be 10,000x15x50 = 7,500,000 messages/records in the database.

As for me, these are the most minimal numbers, I think there can be 20-50, or even 100 times more records.

The question is how to calculate their weight in the database? What are the limits on the number of entries, and what problems can there be?

Thank you very much in advance.

Answer 1

The question is how to calculate their weight in the database?

You multiply the number by the size of one record (you count by the sum of the sizes of the columns), then you will get the lower limit of the size (usually 10-100% more due to any indexes)

What are the limits on the number of entries, and what problems can there be?

The main limitation is the size of the disk, but at 7.5k you definitely won’t run into this