???????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