Hey all,
When using the suggested MySQL partitioning procedure (with script), are there any obvious downsides to partitioning by day vs. by month?
Right now we're having discussions about whether we need to store history for 3 months or 12 months. If storing for 3 months then daily partitioning is a no-brainer. But if storing for 12 months then daily partitioning means having MySQL manage ~365 partitions (per data type). I just want to be sure I won't break anything or run into any obvious bottleneck if we do daily partitioning and keep partitions for 365 days.
Thanks all!
When using the suggested MySQL partitioning procedure (with script), are there any obvious downsides to partitioning by day vs. by month?
Right now we're having discussions about whether we need to store history for 3 months or 12 months. If storing for 3 months then daily partitioning is a no-brainer. But if storing for 12 months then daily partitioning means having MySQL manage ~365 partitions (per data type). I just want to be sure I won't break anything or run into any obvious bottleneck if we do daily partitioning and keep partitions for 365 days.
Thanks all!