如何提高1600000行的mysql表的性能？

Question

如何提高1600000行的mysql表的性能？我应该通过什么值来更改mysql变量？为了提高性能?哪种mysql性能变量可以帮助我提高性能？

mysql> SHOW CREATE TABLE gps_device_data_demo\G;
*************************** 1. row ***************************
       Table: gps_device_data_demo
Create Table: CREATE TABLE `gps_device_data_demo` (
  `imei_no` bigint(15) NOT NULL DEFAULT '0',
  `ioelementpriority` int(1) DEFAULT NULL,
  `longitude` int(15) DEFAULT NULL,
  `latitude` int(15) DEFAULT NULL,
  `speed` tinyint(3) unsigned DEFAULT NULL,
  `iovalue` varchar(254) CHARACTER SET latin1 DEFAULT NULL,
  `odom` bigint(20) DEFAULT NULL,
  `alarm_category_realtime_id` varchar(70) CHARACTER SET latin1 DEFAULT NULL,
  `angle` int(4) DEFAULT NULL,
  `altitude` int(4) DEFAULT NULL,
  `satellites` int(4) DEFAULT NULL,
  `data_received_time` bigint(20) NOT NULL DEFAULT '0',
  `continue_data_received_time` bigint(20) NOT NULL DEFAULT '0',
  `movement` int(2) DEFAULT NULL,
  `eventsource` int(4) DEFAULT NULL,
  `data_location` varchar(250) CHARACTER SET latin1 DEFAULT NULL,
  `data_poi` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `data_validity` enum('valid','invalid') CHARACTER SET latin1 DEFAULT NULL,
  `createdby` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `createddate` datetime DEFAULT NULL,
  `modifiedby` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `modifieddate` datetime DEFAULT NULL,
  `deletedby` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `deleteddate` datetime DEFAULT NULL,
  PRIMARY KEY (`imei_no`,`data_received_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Answer 1

更改Mysql服务器变量不会对性能产生太大影响。

但是您可以通过创建索引来提高Mysql表的性能。索引用于更快的搜索。当你在正确的字段上给出索引时，它会给你带来巨大的速度差异。