Skip to main content
5 events
when toggle format what by license comment
Mar 5, 2023 at 3:53 comment added Rick James @BrianEstrada - True. No FKs; no Unique indexes (across all partitions). It's the price to pay for nearly instant DROP PARTITION and REORGANIZE PARTITION (if it is empty).
Mar 5, 2023 at 2:35 comment added Brian Estrada As for the partitions, I thought it does not work with tables with foreign keys with delete cascades on them as mentioned here dev.mysql.com/doc/refman/5.7/en/… . Is this not true?
Mar 4, 2023 at 20:19 comment added Rick James Even faster is to have about 32 daily partitions. Partition
Mar 4, 2023 at 17:56 comment added Brian Estrada Thank you! In my case, I only need to maintain 30 days worth of day. So what if I do this? (a) Rename this table to t1_old, (b) Create new table t1 as select * from t1_old where created_at > '2023-01-28 00:00:00'. Would this work and would the CTAS run fast (without dropping the indexes and constraints?
Mar 4, 2023 at 17:34 history answered Rick James CC BY-SA 4.0