???????????ü??????????????????ζ??????????????????????г????￡?(????λ????)
????1.?????????
????(????????????????С?????????
????(1).??????????С???????????(mediumint??int??????)??
????(2).??????????????not null???????????????null??
????(3).?????????????ε??????varchar??????ù????С???????????char??
????(4).???????????t????????????????????????????????????Ч??
????(5).??????????????????????????????????????????????????????????????????????????????????????????Щ??????????????????????????????????????Ρ???????????????????Σ?????????????Щ??Σ????????????????
????(6).???????????????浽?????????д????
????(7).??????ζ???????????
????(8).???Щ????￡???????????????????????????????????????????????????????????????С??????????????????????
????2.???????
????(1).??????ó??????
????(2).explain ?????SQL???
????(3).??????????????????????????????α????????????????
????(4).LIMIT??価????? order by ???? distinct??????????????????full table scan??
????(5).??????????????м?????????? truncate table tablename ?????? delete from tablename??
????(6).????? STORE PROCEDURE ???? USER FUNCTION?????
????(7).?????insert????в??????????????????????? load data infile ??????????????????????indert????
????(8).???? OPTIMIZE TABLE ???????????
????(9).?????? date ????????????????????????????????? unsigned int ???????
????3.???????
????(1).????????
??????????????????????????????????У????????????????.
????(2).?????д(IO)
???????????y???в??е????????
????(3).CPU????
??????????????????У???????????CPU?????????????Щ?????
????(4).??????
??????CPU???????????????CPU???????????????????????????.