????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 ????娲�????澹�
.MYD(MYData) ????????????????
.MYI(MYIndex) ???????????????? 

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