Skip to main content
4 events
when toggle format what by license comment
Nov 30, 2022 at 21:06 comment added Niyaz I implement PARTITION for tables, and it works perfectly. Thanks.
Nov 21, 2022 at 16:17 comment added Rick James @Niyaz - OPTIMIZE took downtime because copied the table. Adding Partitioning needs a similar amount of downtime. (I strongly suggest you test the ALTER separately before running it in Production.) Note two restrictions: No FKs, no UNIQUE indexes.
Nov 21, 2022 at 8:10 comment added Niyaz thanks for your answer. Implementing PARTITION is in my plan but, I should find downtime to prevent losing a huge amount of data. Also, I will monitor the size of the tables for 14 days. I will give you an update about both of them.
Nov 21, 2022 at 4:04 history answered Rick James CC BY-SA 4.0