I’m new to mysql, moving from oracle to mysql. I wonder what is the is identical step to tablespace extend in mysql / percona ?. In oracle, I usually have automated cron job at weekend to compute the projected tablespace space for the next week period and then extend the tablespace at night based on the computed result. I want to do the same / identical thing with mysql since tablespace extend will be IO intensive and doing so automatically during busy day is not an option (it will slow thing down). Any insight, docs, howto, etc to achieve those identical step in mysql ?. I prefer to extend the tablespace in advance for the next week rather than using the auto extend performed at the busy day.
thanks in advance for your help