Timeline for Why Optimize Table does not shrink table size?
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 16, 2022 at 20:00 | answer | added | Niyaz | timeline score: 1 | |
| Nov 21, 2022 at 4:04 | answer | added | Rick James | timeline score: 2 | |
| Nov 21, 2022 at 3:59 | comment | added | Rick James |
Does the size stay approximately the same for a full 14 days? Please provide the ll output for 14 days (if we can't provide an answer before then).
|
|
| Nov 21, 2022 at 2:41 | history | edited | RolandoMySQLDBA |
edited tags
|
|
| Nov 20, 2022 at 21:36 | answer | added | RolandoMySQLDBA | timeline score: 1 | |
| Nov 20, 2022 at 15:02 | comment | added | Niyaz |
When I run optimize TABLE table1; (Also, for table2 and table3), The table size should shrink dramatically because in previous days I delete multi-million rows. My question is, why the size of the tables do not decrease?
|
|
| Nov 20, 2022 at 14:49 | comment | added | Marcello Miorelli | Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. | |
| S Nov 20, 2022 at 13:05 | review | First questions | |||
| Nov 20, 2022 at 14:49 | |||||
| S Nov 20, 2022 at 13:05 | history | asked | Niyaz | CC BY-SA 4.0 |