??????????????????:
????1????????????????????
????2?????????????????
????4?????????????????????????
????12?????SMP(????????)??????????????????????4??8????(core)???Mysql???????????
????15????л?????(roll-back)???????????????(roll-forward)?????????
????18??????????????????????????????????????????????????????С?
????20?????????????????:??????????(nested-loop)???????????-???????(sort-merge join)?????????(hash join)??
????21?????????????????????????????Щ????￡?????????????????????????????????????????????????????????軹?????
????26??????洢?????????????????????????????????к?????
????28??????洢????(MyISAM)??????????????????????
????30????Щ??м???????????洢???檔????????Count???????????洢????????к???????????洢?????п?????????
????31????м????????????????????????????????????
????33???????????????????δ???????????????????????????????????????沢?????????????????????CPU?????
????45??????(Replication)????????????????к????????????磬?????????(single-threaded)?????????????????????Slave??????????????????????????????Master??
????46??Cluster??????????????????????????????????????????????????????顣
????47?????????(INFORMATION_SCHEMA)???????????????????????(????????????????????????)??
????48????????????Alter Table??????
????50????????ALTER TABLE??CREATE TABLE???????????????????????????δ????????????????????????????????Schame?????????????????????????????洢????????