How to store and fetch a large number of messages?

Question

MySQL

How to build a database architecture so that you can safely store users' private messages?
As is usually done in the social. networks? Do splitting into databases and splitting tables by months, quarters, years?
What mechanics are usually used, broken down by users or by time?

Answer 1

correctly, this process is called partitioning.
they do it in such a way as to reduce the maximum requests to one partition