I’m working on a MySQL database that has a few thousand records added to it every day. I need to partition date, by month/year. The issue I’m running into is that I want to avoid having to physically update the database when new data is added. For example, there are records from June 13, July 13 etc, now that August has started I would like Aug 13 to automatically partition. Is this possible?