线上测试 mysql 索引_mysql索引测试

昨天听到说用索引，之前没用过，第一次用，感觉很新奇~~，来测试下是不是有那么牛~~

1.建立的一张表

CREATE TABLE `wh_test` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`name` varchar(32) NOT NULL,

`pwd` varchar(32) NOT NULL,

`tel` varchar(32) NOT NULL,

`age` varchar(32) NOT NULL,

`sex` varchar(32) NOT NULL,

`hight` varchar(32) NOT NULL,

PRIMARY KEY (`id`),

KEY `name` (`name`)

) ENGINE=InnoDB AUTO_INCREMENT=11670 DEFAULT CHARSET=utf8;2，插入数据(总共插入了11669条数据，其中有一条name字段为xxx)

for ($i=0; $i < 1000; $i++) {

$data=array('name'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),

'pwd'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),

'tel'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),

'age'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),

'sex'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),

'hight'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),

);

M('test')->add($data);

}3.查询

SELECT * FROM `wh_test` WHERE `name`='xxx'用时

4.建立索引

ALTER TABLE `wh_test` ADD INDEX `name`(`name`)

5.查询

SELECT * FROM `wh_test` WHERE `name`='xxx'

用计算器算了下，隔了这么多

真的是 很叼~~~

怎么图片上传了没用......

反正就是隔了31倍多的时间，我只测试了一遍