?й?MySQL InnoDB????????????????????????
???????????? ???????[ 2013/5/8 9:58:28 ] ????????
????????????
??????????????????????а??????????е???Σ?????????β??????InnoDB???????????С????????????????????????????????????Σ?InnoDB?????μ???????μ???????β??
??????????????
???????????
CREATE TABLE t (
a char(32) not null primary key??
b char(32) not null??
KEY idx1 (a??b)??
KEY idx2 (b??a)
) Engine=InnoDB;
????idx1??idx2?????????????С???????????????
???????????
CREATE TABLE t (
a char(32) not null??
b char(32) not null??
c char(32) not null??
d char(32) not null??
PRIMARY KEY (a??b)
KEY idx1 (c??a)??
KEY idx2 (d??b)
) Engine=InnoDB;
?????????InnoDB???????????????idx1?????????洢?(c??a??b)??idx2?????????洢?(d??b??a)
????????????????????Ρ?Server??????????????? MySQL ?????????????????ε???????????????????????
SELECT * FROM t WHERE d=x1 AND b=x2 ORDER BY a;
???????????洢??idx2(d??b??a)??????????????????????????????? Server ?????????????MySQL????????????idx2(d??b)?????????????a??λ????????PK??????????
??????????????????????????KEY idx2(d??b??a)?????MySQL???(d??b??a)????????????ж??У?????InnoDB?????????????????а????????е???????Σ???????????????????????洢???
??????????????
???????????????????е?MySQL DBA??????????????????????????κ??油????????Ρ???????κ?????????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11