????????????????????????У????????????????????????????????????????????????????????????????涼??????????????????????????????????????????????з???????????????????в??????????
???????????
????MySQL?в??????????????????????????????????е????????????????
???????????3??
??????????????????????2??
???????????????2??
??????????????1x?????С??
????????????????1x??????
??????????1??
???????????????????????????SQL???????????????г?????????????????в???N?Σ???????????????????????????????
?????????insert?????д????У?????????
?????????в?????д????????
????????Load Data????????
???????????е??????????
????Innodb????
????InnoDB ?? MySQL ???????????(commit)?????(rollback)????????????(crash recovery capabilities)???????(transaction-safe (ACID compliant))????InnoDB ????????(locking on row level)?????????(FOREIGN KEY constraints)??
????InnoDB ??????????????????????????????? CPU ????????????????????????????????????????????????InnoDB ???????? MySQL ??????????????????InnoDB ????????н??????????????????????????????????
???????????
????Macbook Air 12mid apache2.2.26 php5.5.10 mysql5.6.16
????????100W??????
?????????????????С38.6MB????????????46.8??????????
?????????????????? ??????229s ?????棺246KB
?????????????????? ??????242s ?????棺246KB
?????????????????? ??????10s ?????棺8643KB
?????????????????? ??????16s ?????棺8643KB
????????????????? ??????78s ?????棺246KB
????????????????? ??????82s ?????棺246KB
??????????Load Data???? ??????12s ?????棺246KB
??????????Load Data???? ??????11s ?????棺246KB
????MyIASM????
????MyISAM ??MySQL?????????檔??????????????????
???????????
????Macbook Air 12mid apache2.2.26 php5.5.10 mysql5.6.16
????????100W??????
?????????????????С19.1MB????????????38.6??????????
?????????????????? ??????82s ?????棺246KB
?????????????????? ??????86s ?????棺246KB
?????????????????? ??????3s ?????棺8643KB
?????????????????? ??????7s ?????棺8643KB
??????????Load Data???? ??????6s ?????棺246KB
??????????Load Data???? ??????8s ?????棺246KB