[zabbix]> show create table history_uint\G; *************************** 1. row *************************** Table: history_uint Create Table: CREATE TABLE `history_uint` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` bigint(20) unsigned NOT NULL DEFAULT '0', `ns` int(11) NOT NULL DEFAULT '0', KEY `history_uint_1` (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin /*!50100 PARTITION BY RANGE (clock) (PARTITION p2017_11_28 VALUES LESS THAN (1511920800) ENGINE = InnoDB, PARTITION p2017_11_29 VALUES LESS THAN (1512007200) ENGINE = InnoDB, PARTITION p2017_11_30 VALUES LESS THAN (1512093600) ENGINE = InnoDB, PARTITION p2017_12_01 VALUES LESS THAN (1512180000) ENGINE = InnoDB, PARTITION p2017_12_02 VALUES LESS THAN (1512266400) ENGINE = InnoDB, PARTITION p2017_12_03 VALUES LESS THAN (1512352800) ENGINE = InnoDB, PARTITION p2017_12_04 VALUES LESS THAN (1512439200) ENGINE = InnoDB, PARTITION p2017_12_05 VALUES LESS THAN (1512525600) ENGINE = InnoDB, PARTITION p2017_12_06 VALUES LESS THAN (1512612000) ENGINE = InnoDB, PARTITION p2017_12_07 VALUES LESS THAN (1512698400) ENGINE = InnoDB, PARTITION p2017_12_08 VALUES LESS THAN (1512784800) ENGINE = InnoDB, PARTITION p2017_12_09 VALUES LESS THAN (1512871200) ENGINE = InnoDB, PARTITION p2017_12_10 VALUES LESS THAN (1512957600) ENGINE = InnoDB, PARTITION p2017_12_11 VALUES LESS THAN (1513044000) ENGINE = InnoDB, PARTITION p2017_12_12 VALUES LESS THAN (1513130400) ENGINE = InnoDB, PARTITION p2017_12_13 VALUES LESS THAN (1513216800) ENGINE = InnoDB, PARTITION p2017_12_14 VALUES LESS THAN (1513303200) ENGINE = InnoDB, PARTITION p2017_12_15 VALUES LESS THAN (1513389600) ENGINE = InnoDB, PARTITION p2017_12_16 VALUES LESS THAN (1513476000) ENGINE = InnoDB) */