看了姜老师的视频,介绍这个参数对性能的影响,自己实际测试了一下。
表结构
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int | NO | PRI | NULL | auto_increment |
| k | int | NO | MUL | 0 | |
| c | char(120) | NO | | | |
| pad | char(60) | NO | | | |
| k1 | int | YES | | NULL | |
| k2 | int | YES | | NULL | |
| c2 | char(120) | YES | | NULL | |
| c3 | char(120) | YES | | NULL | |
| c4 | char(120) | YES | | NULL | |
| c5