In my mysql database I have a table in which I have to store data for 3 months. The data gets populated in this table continuously through a kafka stream. Because this table has a lot of data I am considering partitioning it based on date of data so that each record gets added to the partition of that specific date. I am wondering how do I setup a spring boot task or a task inside db so that all partitions older than 3 months get truncated/dropped on a regular interval? What would that query look like?
0 Answers
Related