????????????????????????￡???io/cpu?????????????????????????????????????????????????????????sql??????????????????????????????????￡?
????????????Mybatis??
????INSERT INTO SYS_CITY (CITY_CODE?? CITY_NAME?? PROVINCE_NAME?? ALIAS?? ABBRE_PY) VALUES
????(${cityCode}?? ${cityName}?? ${provinceName}?? ${alias}?? ${abbrePy})
????????????????Mybatis?? ??????????????mysql???????????mytatis???????#????
????INSERT INTO SYS_CITY (CITY_CODE?? CITY_NAME?? PROVINCE_NAME?? ALIAS?? ABBRE_PY) VALUES
????(#{cityCode}?? #{cityName}?? #{provinceName}?? #{alias}?? #{abbrePy})
????????sql??????????? ???????sql???????sql?в???????????????????
????INSERT INTO SYS_CITY (CITY_CODE?? CITY_NAME?? PROVINCE_NAME?? ALIAS?? ABBRE_PY) VALUES
????("cityCode1"?? "cityName1"?? "provinceName1" "alias1"?? "abbrePy1")??("cityCode2"?? "cityName2"?? "provinceName2" "alias2"?? "abbrePy2")
??????????
????????????????MySQL??binlog??innodb?????????????????????????????????????????????????Ч??? ??????SQL??????????紫???IO?? ??????SQL???????SQL?????????????
???????????
?????????sql?????????????sql??????????????? ????????????????innodb_buffer??????????ζ?λ?????漰????????д???????????????? ???????
???????????????????????????????????????????????ɡ?
??????????
???????????INSERT???????MySQL??????????????????????????????????????????????????????????????????????
???????????
?????????????MySQL??innodb_log_buffer_size??????????????????????????????????????? ????????????????innodb_buffer??????????ζ?λ?????漰????????д????????????????
??????????
??????????i5-4200U 1.6GHZ??12G??棬??????
???? :????????: :?????????: :???????????: :???????: 1000 4600???? 3334???? 8???? 704???? 10000 27204???? 26249???? 2959???? 2959???? 100000 240954???? 254716???? 17286???? 20539????
???????
???????ú??sql+???????????Ч????????????????????innodb_buffer??????????ζ?λ?????漰????????д???????????????????????÷??????????