http://www.cnblogs.com/joyber/p/4349604.html
CREATE TABLE `log` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`t11` int(11) NOT NULL ,
`t22` int(11) NOT NULL ,
`logtime` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `gssindex` (`t11`,`t22`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
mysql> explain select * from log where t22=11111 \G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: log
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 110463
Extra: Using where
1 row in set (0.01 sec)
mysql> explain select * from log where t11=11111 \G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: log
type: ref
possible_keys: gssindex
key: gssindex
key_len: 4
ref: const
rows: 1
Extra: NULL
1 row in set (0.00 sec)
mysql>