Changes between Version 18 and Version 19 of Partitioning

Timestamp:

11/05/25 20:06:18 (3 weeks ago)

Author:

222039

Comment:

--

Partitioning

@@ -53 +53 @@
 == Имплементација
 
+Креирање на партициите:
+
+{{{#!div
+{{{#!sql
+ALTER TABLE `weatherdata`
+PARTITION BY RANGE (TO_DAYS(log_date)) (
+  PARTITION p_2024_01 VALUES LESS THAN (TO_DAYS('2024-02-01')),
+  PARTITION p_2024_02 VALUES LESS THAN (TO_DAYS('2024-03-01')),
+  PARTITION p_2024_03 VALUES LESS THAN (TO_DAYS('2024-04-01')),
+  PARTITION p_2024_04 VALUES LESS THAN (TO_DAYS('2024-05-01')),
+  PARTITION p_2024_05 VALUES LESS THAN (TO_DAYS('2024-06-01')),
+  PARTITION p_2024_06 VALUES LESS THAN (TO_DAYS('2024-07-01')),
+  PARTITION p_2024_07 VALUES LESS THAN (TO_DAYS('2024-08-01')),
+  PARTITION p_2024_08 VALUES LESS THAN (TO_DAYS('2024-09-01')),
+  PARTITION p_2024_09 VALUES LESS THAN (TO_DAYS('2024-10-01')),
+  PARTITION p_2024_10 VALUES LESS THAN (TO_DAYS('2024-11-01')),
+  PARTITION p_2024_11 VALUES LESS THAN (TO_DAYS('2024-12-01')),
+  PARTITION p_2024_12 VALUES LESS THAN (TO_DAYS('2025-01-01')),
+  PARTITION p_2025_01 VALUES LESS THAN (TO_DAYS('2025-02-01')),
+  PARTITION p_2025_02 VALUES LESS THAN (TO_DAYS('2025-03-01')),
+  PARTITION p_2025_03 VALUES LESS THAN (TO_DAYS('2025-04-01')),
+  PARTITION p_2025_04 VALUES LESS THAN (TO_DAYS('2025-05-01')),
+  PARTITION p_2025_05 VALUES LESS THAN (TO_DAYS('2025-06-01')),
+  PARTITION p_2025_06 VALUES LESS THAN (TO_DAYS('2025-07-01')),
+  PARTITION p_2025_07 VALUES LESS THAN (TO_DAYS('2025-08-01')),
+  PARTITION p_2025_08 VALUES LESS THAN (TO_DAYS('2025-09-01')),
+  PARTITION p_2025_09 VALUES LESS THAN (TO_DAYS('2025-10-01')),
+  PARTITION p_2025_10 VALUES LESS THAN (TO_DAYS('2025-11-01')),
+  PARTITION p_2025_11 VALUES LESS THAN (TO_DAYS('2025-12-01')),
+  PARTITION p_2025_12 VALUES LESS THAN (TO_DAYS('2026-01-01')),
+  PARTITION p_future VALUES LESS THAN MAXVALUE
+);
+}}}
+}}}
+
+
 == Тестирање и Перформанси