?????????Щ?????????????????????????????????Ч????￡???????????????????????????????????????????????????????Ｘ??С????????С???á???????????????????????????????
??????????MySQL innodb???Щ??????????????Щ???????insertЧ?????????????ο??ο???
????1. ???SQL???????????????
????????????????磺
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('0'?? 'userid_0'?? 'content_0'?? 0);
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('1'?? 'userid_1'?? 'content_1'?? 1);
?????????
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('0'?? 'userid_0'?? 'content_0'?? 0)?? ('1'?? 'userid_1'?? 'content_1'?? 1);
????????????????????????????Ч???????????SQL???Ч???????????????????????MySQL??binlog??innodb?????????????????????????????????????????????????Ч?????????SQL???????????SQL????????????????????紫???IO??
???????????Щ??????????????????е?????????????????????SQL?????е?????????1???1???1????????????

????2. ???????н??в??????
??????????????
????START TRANSACTION;
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('0'?? 'userid_0'?? 'content_0'?? 0);
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('1'?? 'userid_1'?? 'content_1'?? 1);
????...
????COMMIT;
?????????????????????????Ч?????????????????INSERT???????MySQL?????????????????????????????????????????????????????????????????????????в???????к?????????????
????????????????????????????????????????????????1???1???1????????

????3. ???????????
??????????????????????????????????????????У?????datetime????????????
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('1'?? 'userid_1'?? 'content_1'?? 1);
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('0'?? 'userid_0'?? 'content_0'?? 0);
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('2'?? 'userid_2'?? 'content_2'??2);
?????????
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('0'?? 'userid_0'?? 'content_0'?? 0);
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('1'?? 'userid_1'?? 'content_1'?? 1);
????INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`)
????VALUES ('2'?? 'userid_2'?? 'content_2'??2);
??????????????????????????????????????????????????????????????????????innodb????B+tree???????????β?????????????????棬???????λЧ????????????????????С???????????????????м????B+tree???з?????????????????????????????????????????????λЧ???????????????????????????????????
??????????????????????????????????????????1???1???1??10??100??