Timeline for Why Optimize Table does not shrink table size?
Current License: CC BY-SA 4.0
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 |