I am working on a MariaDb database, in which there is a table called event that can calmly store 6-8 million monthly records. Although the data that is stored does not have much information, since it is simple records of events that occur, composed of 3 columns.
So I would like to prevent possible corruption of the table and my initial idea is, at the end of each month, to create a new historical table with the name in the format event_month_year, and dump the data of the corresponding date. Example:
- event_jan_2022
- event_feb_2022
- event_mar_2022
In this way, if I want to access the information of the current month, I will just query to the table event, but if I want information of previous dates, then I will query to the table by its name in the format that I just explained (event_month_year).
I don't know if this way is the most correct, the most optimal or elegant or not. Surely there are other, better ways to do it, so I'd like to hear opinions.
Thanks in advance.