MySQL Forums
Forum List  »  Partitioning

how we can delete old data from hash partition ??
Posted by: sabbirali kadiwala
Date: June 19, 2018 04:07AM

I want to keep 2 years old data into below table, older data I want to move to archival tables...


I have one table with autoincrement id and daily 1 lakh records would be added into it.
but its huge table so it will take more time with help of delete query.

I have created a HASH partition on it with 24 partitions.

now daily or monthly I need to remove older than 2 years data from it, but its huge table so it will take more time with help of delete query.

can we delete partition like range or list so we can delete old partition and old data will be deleted from the table?

Please suggest how we can delete data ??

Options: ReplyQuote


Subject
Views
Written By
Posted
how we can delete old data from hash partition ??
134
June 19, 2018 04:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.