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