Ad Widget

**fsousa** · 20-11-2018, 13:36

I'm doing this in test environment. I dumped my database on 2018-11-05

**fsousa** · 20-11-2018, 14:22

I've changed the ALTER TABLE like you suggested and now I've another error:

ERROR 1566 (HY000): Not allowed to use NULL value in VALUES LESS THAN

Code:

ALTER TABLE `history` PARTITION BY RANGE ( clock)
(PARTITION p2018_01_01 VALUES LESS THAN (UNIX_TIMESTAMP("p2018-01-02 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_02 VALUES LESS THAN (UNIX_TIMESTAMP("p2018-01-03 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_03 VALUES LESS THAN (UNIX_TIMESTAMP("p2018-01-04 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_04 VALUES LESS THAN (UNIX_TIMESTAMP("p2018-01-05 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_05 VALUES LESS THAN (UNIX_TIMESTAMP("p2018-01-06 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_06 VALUES LESS THAN (UNIX_TIMESTAMP("p2018-01-07 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_07 VALUES LESS THAN (UNIX_TIMESTAMP("p2018-01-08 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_08 VALUES LESS THAN (UNIX_TIMESTAMP("p2018-01-09 00:00:00") div 1) ENGINE = InnoDB,
(...)

My ALTER TABLE have 311 lines.

What I'm missing?

Thank you.

**ingus.vilnis** · 20-11-2018, 15:58

Remove the letter "p" from the date.

Code:

(PARTITION p2018_01_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-02 00:00:00")

**fsousa** · 20-11-2018, 16:43

Done. Now I've the following error:

Code:

ERROR 1479 (HY000): Syntax error: RANGE PARTITIONING requires definition of VALUES LESS THAN for each partition

Code:

ALTER TABLE `history` PARTITION BY RANGE ( clock) 
(PARTITION p2018_01_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-02 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-03 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-04 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-05 00:00:00") div 1) ENGINE = InnoDB,
PARTITION p2018_01_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-06 00:00:00") div 1) ENGINE = InnoDB,
(...)

Thank you.

**ingus.vilnis** · 20-11-2018, 19:35

Dates could be off for one of the days. Some typo or misconfiguration

**fsousa** · 21-11-2018, 14:09

I can't find the misconfiguration, the size of my ALTER TABLE isn't the problem?

Thank you.

**ingus.vilnis** · 21-11-2018, 14:39

Should not be size related.

Also should not matter but remove the "div 1" then, although I don't believe it makes a significance.

Well what else can you do - post the full command and it's output here.

**fsousa** · 21-11-2018, 14:51

I've removed the "div 1" and the error now are:

ERROR 1697 (HY000): VALUES value for partition 'p2018_04_30' must have type INT

Code:

ALTER TABLE `history` PARTITION BY RANGE ( clock) 
(PARTITION p2018_01_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_12 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_13 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_14 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_15 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_16 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_17 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_18 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_19 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_20 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_21 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_22 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_23 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_24 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_25 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_26 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_27 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_28 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_29 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_30 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-31 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_01_31 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_12 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_13 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_14 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_15 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_16 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_17 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_18 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_19 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_20 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_21 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_22 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_23 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_24 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_25 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_26 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_27 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_02_28 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_12 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_13 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_14 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_15 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_16 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_17 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_18 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_19 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_20 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_21 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_22 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_23 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_24 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_25 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_26 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_27 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_28 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_29 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_30 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-31 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_03_31 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_12 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_13 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_14 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_15 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_16 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_17 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_18 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_19 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_20 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_21 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_22 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_23 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_24 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_25 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_26 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_27 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_28 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_29 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_30 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-31 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_04_31 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_12 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_13 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_14 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_15 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_16 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_17 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_18 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_19 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_20 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_21 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_22 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_23 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_24 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_25 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_26 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_27 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_28 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_29 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_30 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-31 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_05_31 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_12 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_13 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_14 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_15 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_16 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_17 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_18 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_19 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_20 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_21 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_22 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_23 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_24 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_25 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_26 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_27 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_28 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_29 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_30 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-31 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_06_31 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_12 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_13 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_14 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_15 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_16 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_17 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_18 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_19 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_20 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_21 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_22 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_23 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_24 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_25 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_26 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_27 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_28 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_29 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_07_30 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_12 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_13 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_14 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_15 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_16 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_17 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_18 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_19 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_20 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_21 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_22 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_23 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_24 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_25 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_26 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_27 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_28 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_29 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_30 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-31 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_08_31 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_12 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_13 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_14 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_15 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_16 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_17 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_18 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_19 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_20 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_21 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_22 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_23 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_24 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_25 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_26 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_27 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_28 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_29 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_09_30 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_12 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_13 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_14 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_15 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_16 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_17 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_18 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_19 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_20 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_21 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_22 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_23 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_24 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_25 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_26 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_27 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_28 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_29 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_30 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-31 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_10_31 VALUES LESS THAN (UNIX_TIMESTAMP("2018-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_11_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-11-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_11_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-11-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_11_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-11-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_11_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-11-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2018_11_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-11-06 00:00:00")) ENGINE = InnoDB);

**ingus.vilnis** · 21-11-2018, 14:54

April has 30 days.
Same for June.

**fsousa** · 21-11-2018, 18:21

Hi Ingus,

Yeah, I miss that

Now I've another error:

ERROR 1526 (HY000): Table has no partition for value 1542708758

I've converted this time stamp and I've this result Tuesday, November 20, 2018 10:12:38 AM. I don't understand because my last PARTITION value are

PARTITION p2018_11_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-11-06 00:00:00")) ENGINE = InnoDB)

**ingus.vilnis** · 21-11-2018, 18:27

Code:

 [h=3]Timestamp Converter[/h]  [h=3]1542708758[/h]  [h=5]Is equivalent to:[/h]  [h=3]11/20/2018 @ 10:12am (UTC)[/h]

Believe or not, you have data up to at least yesterday, so please create partitions for all the dates up to today included.

**fsousa** · 21-11-2018, 18:45

I will try that.

So I've to do the partition until yesterday because my database was been created yesterday?

**ingus.vilnis** · 21-11-2018, 18:47

In one post you say you have the data as old as from 2018-01-01 and it is a backup taken 2018-11-05. Now you have a yesterday created DB? Does not add up to me.

**fsousa** · 21-11-2018, 19:43

Let met explain what I've done.

To test the partitioning table I've one environment test(one virtual machine with the same setup that my production environment).

Then I 've dump my production database on 2018-11-05 and import this dump to my environment test yesterday

My oldest entry on history table is:

Code:

mysql> SELECT FROM_UNIXTIME(MIN(clock)) FROM `history`;
+---------------------------+
| FROM_UNIXTIME(MIN(clock)) |
+---------------------------+
| 2017-11-21 18:28:36       |
+---------------------------+
1 row in set (4 min 48,01 sec)

I think I don't understand in the right way what you have explained to me. I started my partition with 2018-01-01 , but I realize it should be started with 2017-11-21, right?

**ingus.vilnis** · 22-11-2018, 13:23

Ok, back to some theory and decision making.

History - every single item value collected by Zabbix server. Separated into five tables per each data type. Good for viewing data in highest detail. However, takes up lots of disk space.

Trends - aggregated hourly averages per each numeric item. You lose the details in the graphs when you zoom in to short intervals but in the long run they are great to show graphs over several months and even years.

Now there are questions you got to answer yourself. Do you care what were your exact collected values one year ago? Or do you usually look back at them for a week and then just use the graphs to see the overall system growth?
In normal circumstances the time to keep full detailed history varies from 3 days up to 90 days. Trends then are stored for a year or two, depending on the requirements.

So when implementing partitioning you first have to make this decision for how long are you going to store the data. Once done that, you partition the tables with the time interval you want to keep. So if you now decide that you are really interested only in keeping last 30 days of history, there is no point of partitioning the tables further than that. All data which is older will be put in the oldest partition and deleted the next time the nightly partition cleanup is run.

Ad Widget

Database seems to be growing too quick

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment