MySQL and 2 heavy tables

MySQL & MariaDB Other MySQL® Questions
1

Hello everyone

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

2

because the insertion is made every second.

are you kidding me?

3

I am not kidding. I am very serious about this.
Have you any idea to help me?

4

A server should not crash from 1 insert per second.

What’s your table lay-out and what is your query?