I have a MySQL DB and I work with as language: PHP
In this database, two tables are too heavy, because the insertion is made every second.
I want to make sure that I have, in these two tables, the data from the last 2 months. If I do with normal queries and everything, it will crash the server. If I create a new table and I copy the data from the last 2 months, it could crash the server too.
Have you any idea how to deal with this kind of problem?
Thank you very much