???????MyISAM??InnoDB?к?????
???????????? ???????[ 2012/9/14 10:45:16 ] ????????
????MyISAM??????????????????????????ISAM?????ISAM??Indexed Sequential Access Method (?????????????????) ????д??????洢?????????????????????????洢???????MyISAM???м??????????????????? MyISAM??????????????????????????????????????????????????????????????????????????????????????????????????????д?????SELECT??MyISAM?????????
????MyIASM??IASM????°汾?????????????
?????? ???????ε????????
?????? NULL????????
?????? ????б?ISAM???и?????????
?????? ?????????
?????? ??????????????
?????? ???????????????
?????? ???ú?????auto_increment?????
????InnoDB????????????????????????BDB??????????????????????????????InnoDB???????????б?BDB??????????? ???????????????????洢???棬???????????????????????д?????INSERT??UPDATE????????????????????????InnoDB???????????????InnoDB??????????????????????AUTOCOMMIT??????????????????????????????BEGIN ????????????????????????Commit????????????????????????sql?????begin??????sql?γ????????(???autocommit???????)???????????????
???????????????±??
|
MyISAM |
InnoDB |
?????????? |
???MyISAM???????洢?????????????????????????????????????
.frm ????洢????壻 |
?????????????InnoDB?????????????????????????InnoDB ????С??????????????????С?????? 2GB |
????????? |
MyISAM???????????????????????????InnoDB?????????????????????? |
InnoDB????????????????????????????? |
?? |
????? |
?м??? InnoDB?????????????????????????SQL????MySQL?????????????Χ??InnoDB?????????????????update table set num=1 where name like “%aaa%” |
select??insert??update??delete???? |
?????д????? SELECT??MyISAM ????????? |
1??????????????д?????INSERT??UPDATE????????????????????????InnoDB??? 2??DELETE FROM table???InnoDB???????????????????????е?????? 3??LOAD TABLE FROM MASTER??????InnoDB?????????????????????????InnoDB????MyISAM????????????????InnoDB??????????????????InnoDB?????????????????????á? |
????AUTO_INCREMENT???????? |
?????????и???ε????? |
????????????????????????? |
|
|
InnoDB?????FULLTEXT??????????? |
|
MyISAM???????????????????????????????????? |
|
???????????Щ?????????????
????1??InnoDB?????FULLTEXT???????????
????2??InnoDB ?в?????????????????????????select count(*) from table???InnoDB????????????????????ж????У?????MyISAM??????????????????????ɡ??????????count(*)?????? where????????????????????????
????3??????AUTO_INCREMENT???????Σ?InnoDB?б????????и???ε?????????????MyISAM???У????????????????????????????
????4??DELETE FROM table???InnoDB???????????????????????е??????
????5??LOAD TABLE FROM MASTER??????InnoDB?????????????????????????InnoDB????MyISAM????????????????InnoDB??????????????????InnoDB?????????????????????á?
???????????????κ??????????????????????????????????????????????????????MySQL???????????
??????
???·???
??????????????????
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