Re: speed up query
CREATE TABLE `dsl_data_1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`port_id` int(11) DEFAULT NULL,
`snrup` decimal(5,2) DEFAULT NULL,
`snrdown` decimal(5,2) DEFAULT NULL,
`attnup` decimal(5,2) DEFAULT NULL,
`attndown` decimal(5,2) DEFAULT NULL,
`uprate` int(3) DEFAULT NULL,
`downrate` int(3) DEFAULT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`,`time`),
KEY `idx_dsl_data_time_portid1` (`time`,`port_id`),
KEY `idx_dsl_data_port_id1` (`port_id`)
) ENGINE=InnoDB AUTO_INCREMENT=108653793 DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (UNIX_TIMESTAMP(time))
(PARTITION p001 VALUES LESS THAN (1264982400) ENGINE = InnoDB,
PARTITION p002 VALUES LESS THAN (1267401600) ENGINE = InnoDB,
PARTITION p003 VALUES LESS THAN (1270080000) ENGINE = InnoDB,
PARTITION p004 VALUES LESS THAN (1272672000) ENGINE = InnoDB,
PARTITION p005 VALUES LESS THAN (1275350400) ENGINE = InnoDB,
PARTITION p006 VALUES LESS THAN (1277942400) ENGINE = InnoDB,
PARTITION p007 VALUES LESS THAN (1280620800) ENGINE = InnoDB,
PARTITION p008 VALUES LESS THAN (1283299200) ENGINE = InnoDB,
PARTITION p009 VALUES LESS THAN (1285891200) ENGINE = InnoDB,
PARTITION p010 VALUES LESS THAN (1288569600) ENGINE = InnoDB,
PARTITION p011 VALUES LESS THAN (1291161600) ENGINE = InnoDB,
PARTITION p012 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */