Is there any way to do a bulk/faster delete in mysql? -

I have a table with 10 million records, the fastest way to destroy & amp; Stay in the last 30 days.

I know that this event can be done in the scheduler, but my concern is that it takes a lot of time, it can lock the table for longer periods of time.

It would be nice if you can suggest some optimal way.

Thank you.

I:

1. Rename table
< Li> Create a blank table with the same name as your original table
2. Enter your "Temp" table and return them to the new table
3. Drop a temporary table

This will enable you to continue the table through the whole process (approx) and get data from the last 30 days in your holidays.