show create table trends\G; *************************** 1. row *************************** Table: trends Create Table: CREATE TABLE `trends` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `num` int(11) NOT NULL DEFAULT '0', `value_min` double(16,4) NOT NULL DEFAULT '0.0000', `value_avg` double(16,4) NOT NULL DEFAULT '0.0000', `value_max` double(16,4) NOT NULL DEFAULT '0.0000', PRIMARY KEY (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (clock) (PARTITION p2018w42 VALUES LESS THAN (1540166400) ENGINE = InnoDB, PARTITION p2018w43 VALUES LESS THAN (1540771200) ENGINE = InnoDB, PARTITION p2018w44 VALUES LESS THAN (1541376000) ENGINE = InnoDB, PARTITION p2018w45 VALUES LESS THAN (1541980800) ENGINE = InnoDB, PARTITION p2018w46 VALUES LESS THAN (1542585600) ENGINE = InnoDB, PARTITION p2018w47 VALUES LESS THAN (1543190400) ENGINE = InnoDB, PARTITION p2018w48 VALUES LESS THAN (1543795200) ENGINE = InnoDB, PARTITION p2018w49 VALUES LESS THAN (1544400000) ENGINE = InnoDB, PARTITION p2018w50 VALUES LESS THAN (1545004800) ENGINE = InnoDB, PARTITION p2018w51 VALUES LESS THAN (1545609600) ENGINE = InnoDB, PARTITION p2018w52 VALUES LESS THAN (1546214400) ENGINE = InnoDB, PARTITION p2019w02 VALUES LESS THAN (1547424000) ENGINE = InnoDB, PARTITION p2019w03 VALUES LESS THAN (1548028800) ENGINE = InnoDB, PARTITION p2019w04 VALUES LESS THAN (1548633600) ENGINE = InnoDB, PARTITION p2019w05 VALUES LESS THAN (1549238400) ENGINE = InnoDB, PARTITION p2019w06 VALUES LESS THAN (1549843200) ENGINE = InnoDB, PARTITION p2019w07 VALUES LESS THAN (1550448000) ENGINE = InnoDB, PARTITION p2019w08 VALUES LESS THAN (1551052800) ENGINE = InnoDB, PARTITION p2019w09 VALUES LESS THAN (1551657600) ENGINE = InnoDB, PARTITION p2019w10 VALUES LESS THAN (1552262400) ENGINE = InnoDB, PARTITION p2019w11 VALUES LESS THAN (1552867200) ENGINE = InnoDB, PARTITION p2019w12 VALUES LESS THAN (1553472000) ENGINE = InnoDB, PARTITION p2019w13 VALUES LESS THAN (1554076800) ENGINE = InnoDB, PARTITION p2019w14 VALUES LESS THAN (1554681600) ENGINE = InnoDB, PARTITION p2019w15 VALUES LESS THAN (1555286400) ENGINE = InnoDB, PARTITION p2019w16 VALUES LESS THAN (1555891200) ENGINE = InnoDB, PARTITION p2019w17 VALUES LESS THAN (1556496000) ENGINE = InnoDB, PARTITION p2019w18 VALUES LESS THAN (1557100800) ENGINE = InnoDB, PARTITION p2019w19 VALUES LESS THAN (1557705600) ENGINE = InnoDB, PARTITION p2019w20 VALUES LESS THAN (1558310400) ENGINE = InnoDB, PARTITION p2019w21 VALUES LESS THAN (1558915200) ENGINE = InnoDB, PARTITION p2019w22 VALUES LESS THAN (1559520000) ENGINE = InnoDB, PARTITION p2019w23 VALUES LESS THAN (1560124800) ENGINE = InnoDB, PARTITION p2019w24 VALUES LESS THAN (1560729600) ENGINE = InnoDB, PARTITION p2019w25 VALUES LESS THAN (1561334400) ENGINE = InnoDB, PARTITION p2019w26 VALUES LESS THAN (1561939200) ENGINE = InnoDB, PARTITION p2019w27 VALUES LESS THAN (1562544000) ENGINE = InnoDB, PARTITION p2019w28 VALUES LESS THAN (1563148800) ENGINE = InnoDB, PARTITION p2019w29 VALUES LESS THAN (1563753600) ENGINE = InnoDB, PARTITION p2019w30 VALUES LESS THAN (1564358400) ENGINE = InnoDB, PARTITION p2019w31 VALUES LESS THAN (1564963200) ENGINE = InnoDB, PARTITION p2019w32 VALUES LESS THAN (1565568000) ENGINE = InnoDB, PARTITION p2019w33 VALUES LESS THAN (1566172800) ENGINE = InnoDB, PARTITION p2019w34 VALUES LESS THAN (1566777600) ENGINE = InnoDB, PARTITION p2019w35 VALUES LESS THAN (1567382400) ENGINE = InnoDB, PARTITION p2019w36 VALUES LESS THAN (1567987200) ENGINE = InnoDB, PARTITION p2019w37 VALUES LESS THAN (1568592000) ENGINE = InnoDB, PARTITION p2019w38 VALUES LESS THAN (1569196800) ENGINE = InnoDB, PARTITION p2019w39 VALUES LESS THAN (1569801600) ENGINE = InnoDB, PARTITION p2019w40 VALUES LESS THAN (1570406400) ENGINE = InnoDB, PARTITION p2019w41 VALUES LESS THAN (1571011200) ENGINE = InnoDB, PARTITION p2019w42 VALUES LESS THAN (1571616000) ENGINE = InnoDB, PARTITION p2019w43 VALUES LESS THAN (1572220800) ENGINE = InnoDB, PARTITION p2019w44 VALUES LESS THAN (1572825600) ENGINE = InnoDB, PARTITION p2019w45 VALUES LESS THAN (1573430400) ENGINE = InnoDB, PARTITION p2019w46 VALUES LESS THAN (1574035200) ENGINE = InnoDB, PARTITION p2019w47 VALUES LESS THAN (1574640000) ENGINE = InnoDB, PARTITION p2019w48 VALUES LESS THAN (1575244800) ENGINE = InnoDB, PARTITION p2019w49 VALUES LESS THAN (1575849600) ENGINE = InnoDB, PARTITION p2019w50 VALUES LESS THAN (1576454400) ENGINE = InnoDB, PARTITION p2019w51 VALUES LESS THAN (1577059200) ENGINE = InnoDB, PARTITION p2019w52 VALUES LESS THAN (1577664000) ENGINE = InnoDB, PARTITION p2019w01 VALUES LESS THAN (1578268800) ENGINE = InnoDB, PARTITION p2020w02 VALUES LESS THAN (1578873600) ENGINE = InnoDB) */ 1 row in set (0.01 sec) show create table trends_uint\G; *************************** 1. row *************************** Table: trends_uint Create Table: CREATE TABLE `trends_uint` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `num` int(11) NOT NULL DEFAULT '0', `value_min` bigint(20) unsigned NOT NULL DEFAULT '0', `value_avg` bigint(20) unsigned NOT NULL DEFAULT '0', `value_max` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (clock) (PARTITION p2018w42 VALUES LESS THAN (1540166400) ENGINE = InnoDB, PARTITION p2018w43 VALUES LESS THAN (1540771200) ENGINE = InnoDB, PARTITION p2018w44 VALUES LESS THAN (1541376000) ENGINE = InnoDB, PARTITION p2018w45 VALUES LESS THAN (1541980800) ENGINE = InnoDB, PARTITION p2018w46 VALUES LESS THAN (1542585600) ENGINE = InnoDB, PARTITION p2018w47 VALUES LESS THAN (1543190400) ENGINE = InnoDB, PARTITION p2018w48 VALUES LESS THAN (1543795200) ENGINE = InnoDB, PARTITION p2018w49 VALUES LESS THAN (1544400000) ENGINE = InnoDB, PARTITION p2018w50 VALUES LESS THAN (1545004800) ENGINE = InnoDB, PARTITION p2018w51 VALUES LESS THAN (1545609600) ENGINE = InnoDB, PARTITION p2018w52 VALUES LESS THAN (1546214400) ENGINE = InnoDB, PARTITION p2019w02 VALUES LESS THAN (1547424000) ENGINE = InnoDB, PARTITION p2019w03 VALUES LESS THAN (1548028800) ENGINE = InnoDB, PARTITION p2019w04 VALUES LESS THAN (1548633600) ENGINE = InnoDB, PARTITION p2019w05 VALUES LESS THAN (1549238400) ENGINE = InnoDB, PARTITION p2019w06 VALUES LESS THAN (1549843200) ENGINE = InnoDB, PARTITION p2019w07 VALUES LESS THAN (1550448000) ENGINE = InnoDB, PARTITION p2019w08 VALUES LESS THAN (1551052800) ENGINE = InnoDB, PARTITION p2019w09 VALUES LESS THAN (1551657600) ENGINE = InnoDB, PARTITION p2019w10 VALUES LESS THAN (1552262400) ENGINE = InnoDB, PARTITION p2019w11 VALUES LESS THAN (1552867200) ENGINE = InnoDB, PARTITION p2019w12 VALUES LESS THAN (1553472000) ENGINE = InnoDB, PARTITION p2019w13 VALUES LESS THAN (1554076800) ENGINE = InnoDB, PARTITION p2019w14 VALUES LESS THAN (1554681600) ENGINE = InnoDB, PARTITION p2019w15 VALUES LESS THAN (1555286400) ENGINE = InnoDB, PARTITION p2019w16 VALUES LESS THAN (1555891200) ENGINE = InnoDB, PARTITION p2019w17 VALUES LESS THAN (1556496000) ENGINE = InnoDB, PARTITION p2019w18 VALUES LESS THAN (1557100800) ENGINE = InnoDB, PARTITION p2019w19 VALUES LESS THAN (1557705600) ENGINE = InnoDB, PARTITION p2019w20 VALUES LESS THAN (1558310400) ENGINE = InnoDB, PARTITION p2019w21 VALUES LESS THAN (1558915200) ENGINE = InnoDB, PARTITION p2019w22 VALUES LESS THAN (1559520000) ENGINE = InnoDB, PARTITION p2019w23 VALUES LESS THAN (1560124800) ENGINE = InnoDB, PARTITION p2019w24 VALUES LESS THAN (1560729600) ENGINE = InnoDB, PARTITION p2019w25 VALUES LESS THAN (1561334400) ENGINE = InnoDB, PARTITION p2019w26 VALUES LESS THAN (1561939200) ENGINE = InnoDB, PARTITION p2019w27 VALUES LESS THAN (1562544000) ENGINE = InnoDB, PARTITION p2019w28 VALUES LESS THAN (1563148800) ENGINE = InnoDB, PARTITION p2019w29 VALUES LESS THAN (1563753600) ENGINE = InnoDB, PARTITION p2019w30 VALUES LESS THAN (1564358400) ENGINE = InnoDB, PARTITION p2019w31 VALUES LESS THAN (1564963200) ENGINE = InnoDB, PARTITION p2019w32 VALUES LESS THAN (1565568000) ENGINE = InnoDB, PARTITION p2019w33 VALUES LESS THAN (1566172800) ENGINE = InnoDB, PARTITION p2019w34 VALUES LESS THAN (1566777600) ENGINE = InnoDB, PARTITION p2019w35 VALUES LESS THAN (1567382400) ENGINE = InnoDB, PARTITION p2019w36 VALUES LESS THAN (1567987200) ENGINE = InnoDB, PARTITION p2019w37 VALUES LESS THAN (1568592000) ENGINE = InnoDB, PARTITION p2019w38 VALUES LESS THAN (1569196800) ENGINE = InnoDB, PARTITION p2019w39 VALUES LESS THAN (1569801600) ENGINE = InnoDB, PARTITION p2019w40 VALUES LESS THAN (1570406400) ENGINE = InnoDB, PARTITION p2019w41 VALUES LESS THAN (1571011200) ENGINE = InnoDB, PARTITION p2019w42 VALUES LESS THAN (1571616000) ENGINE = InnoDB, PARTITION p2019w43 VALUES LESS THAN (1572220800) ENGINE = InnoDB, PARTITION p2019w44 VALUES LESS THAN (1572825600) ENGINE = InnoDB, PARTITION p2019w45 VALUES LESS THAN (1573430400) ENGINE = InnoDB, PARTITION p2019w46 VALUES LESS THAN (1574035200) ENGINE = InnoDB, PARTITION p2019w47 VALUES LESS THAN (1574640000) ENGINE = InnoDB, PARTITION p2019w48 VALUES LESS THAN (1575244800) ENGINE = InnoDB, PARTITION p2019w49 VALUES LESS THAN (1575849600) ENGINE = InnoDB, PARTITION p2019w50 VALUES LESS THAN (1576454400) ENGINE = InnoDB, PARTITION p2019w51 VALUES LESS THAN (1577059200) ENGINE = InnoDB, PARTITION p2019w52 VALUES LESS THAN (1577664000) ENGINE = InnoDB, PARTITION p2019w01 VALUES LESS THAN (1578268800) ENGINE = InnoDB, PARTITION p2020w02 VALUES LESS THAN (1578873600) ENGINE = InnoDB) */ 1 row in set (0.01 sec) show create table history\G; *************************** 1. row *************************** Table: history Create Table: CREATE TABLE `history` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` double(16,4) NOT NULL DEFAULT '0.0000', `ns` int(11) NOT NULL DEFAULT '0', KEY `history_1` (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (clock) (PARTITION p2019w37 VALUES LESS THAN (1568592000) ENGINE = InnoDB, PARTITION p2019w38 VALUES LESS THAN (1569196800) ENGINE = InnoDB, PARTITION p2019w39 VALUES LESS THAN (1569801600) ENGINE = InnoDB, PARTITION p2019w40 VALUES LESS THAN (1570406400) ENGINE = InnoDB, PARTITION p2019w41 VALUES LESS THAN (1571011200) ENGINE = InnoDB, PARTITION p2019w42 VALUES LESS THAN (1571616000) ENGINE = InnoDB, PARTITION p2019w43 VALUES LESS THAN (1572220800) ENGINE = InnoDB, PARTITION p2019w44 VALUES LESS THAN (1572825600) ENGINE = InnoDB, PARTITION p2019w45 VALUES LESS THAN (1573430400) ENGINE = InnoDB, PARTITION p2019w46 VALUES LESS THAN (1574035200) ENGINE = InnoDB, PARTITION p2019w47 VALUES LESS THAN (1574640000) ENGINE = InnoDB, PARTITION p2019w48 VALUES LESS THAN (1575244800) ENGINE = InnoDB, PARTITION p2019w49 VALUES LESS THAN (1575849600) ENGINE = InnoDB, PARTITION p2019w50 VALUES LESS THAN (1576454400) ENGINE = InnoDB, PARTITION p2019w51 VALUES LESS THAN (1577059200) ENGINE = InnoDB, PARTITION p2019w52 VALUES LESS THAN (1577664000) ENGINE = InnoDB, PARTITION p2019w01 VALUES LESS THAN (1578268800) ENGINE = InnoDB, PARTITION p2020w02 VALUES LESS THAN (1578873600) ENGINE = InnoDB) */ 1 row in set (0.00 sec) show create table history_log\G; *************************** 1. row *************************** Table: history_log Create Table: CREATE TABLE `history_log` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `timestamp` int(11) NOT NULL DEFAULT '0', `source` varchar(64) NOT NULL DEFAULT '', `severity` int(11) NOT NULL DEFAULT '0', `value` text NOT NULL, `logeventid` int(11) NOT NULL DEFAULT '0', `ns` int(11) NOT NULL DEFAULT '0', KEY `history_log_1` (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 1 row in set (0.00 sec) show create table history_str\G; *************************** 1. row *************************** Table: history_str Create Table: CREATE TABLE `history_str` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', `ns` int(11) NOT NULL DEFAULT '0', KEY `history_str_1` (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (clock) (PARTITION p2019w38 VALUES LESS THAN (1569196800) ENGINE = InnoDB, PARTITION p2019w39 VALUES LESS THAN (1569801600) ENGINE = InnoDB, PARTITION p2019w40 VALUES LESS THAN (1570406400) ENGINE = InnoDB, PARTITION p2019w41 VALUES LESS THAN (1571011200) ENGINE = InnoDB, PARTITION p2019w42 VALUES LESS THAN (1571616000) ENGINE = InnoDB, PARTITION p2019w43 VALUES LESS THAN (1572220800) ENGINE = InnoDB, PARTITION p2019w44 VALUES LESS THAN (1572825600) ENGINE = InnoDB, PARTITION p2019w45 VALUES LESS THAN (1573430400) ENGINE = InnoDB, PARTITION p2019w46 VALUES LESS THAN (1574035200) ENGINE = InnoDB, PARTITION p2019w47 VALUES LESS THAN (1574640000) ENGINE = InnoDB, PARTITION p2019w48 VALUES LESS THAN (1575244800) ENGINE = InnoDB, PARTITION p2019w49 VALUES LESS THAN (1575849600) ENGINE = InnoDB, PARTITION p2019w50 VALUES LESS THAN (1576454400) ENGINE = InnoDB, PARTITION p2019w51 VALUES LESS THAN (1577059200) ENGINE = InnoDB, PARTITION p2019w52 VALUES LESS THAN (1577664000) ENGINE = InnoDB, PARTITION p2019w01 VALUES LESS THAN (1578268800) ENGINE = InnoDB, PARTITION p2020w02 VALUES LESS THAN (1578873600) ENGINE = InnoDB) */ 1 row in set (0.00 sec) show create table history_text\G; *************************** 1. row *************************** Table: history_text Create Table: CREATE TABLE `history_text` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` text NOT NULL, `ns` int(11) NOT NULL DEFAULT '0', KEY `history_text_1` (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 1 row in set (0.00 sec) 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 /*!50100 PARTITION BY RANGE (clock) (PARTITION p2019w33 VALUES LESS THAN (1566172800) ENGINE = InnoDB, PARTITION p2019w34 VALUES LESS THAN (1566777600) ENGINE = InnoDB, PARTITION p2019w35 VALUES LESS THAN (1567382400) ENGINE = InnoDB, PARTITION p2019w36 VALUES LESS THAN (1567987200) ENGINE = InnoDB, PARTITION p2019w37 VALUES LESS THAN (1568592000) ENGINE = InnoDB, PARTITION p2019w38 VALUES LESS THAN (1569196800) ENGINE = InnoDB, PARTITION p2019w39 VALUES LESS THAN (1569801600) ENGINE = InnoDB, PARTITION p2019w40 VALUES LESS THAN (1570406400) ENGINE = InnoDB, PARTITION p2019w41 VALUES LESS THAN (1571011200) ENGINE = InnoDB, PARTITION p2019w42 VALUES LESS THAN (1571616000) ENGINE = InnoDB, PARTITION p2019w43 VALUES LESS THAN (1572220800) ENGINE = InnoDB, PARTITION p2019w44 VALUES LESS THAN (1572825600) ENGINE = InnoDB, PARTITION p2019w45 VALUES LESS THAN (1573430400) ENGINE = InnoDB, PARTITION p2019w46 VALUES LESS THAN (1574035200) ENGINE = InnoDB, PARTITION p2019w47 VALUES LESS THAN (1574640000) ENGINE = InnoDB, PARTITION p2019w48 VALUES LESS THAN (1575244800) ENGINE = InnoDB, PARTITION p2019w49 VALUES LESS THAN (1575849600) ENGINE = InnoDB, PARTITION p2019w50 VALUES LESS THAN (1576454400) ENGINE = InnoDB, PARTITION p2019w51 VALUES LESS THAN (1577059200) ENGINE = InnoDB, PARTITION p2019w52 VALUES LESS THAN (1577664000) ENGINE = InnoDB, PARTITION p2019w01 VALUES LESS THAN (1578268800) ENGINE = InnoDB, PARTITION p2020w02 VALUES LESS THAN (1578873600) ENGINE = InnoDB) */ 1 row in set (0.00 sec) select from_unixtime(min(clock)) from history_str limit 1; +---------------------------+ | from_unixtime(min(clock)) | +---------------------------+ | 2019-10-09 14:59:13 | +---------------------------+ 1 row in set (4.39 sec)