???????????insert????ж?????з????
????1???????????У??????
for(){
insert(sql);
}
????2???????????????У????Mysql???????????????????????????????????????
????????begin
for()
{
insert(sql);
}
????????commit
????3??????insert...values value1??value2??????У??????
????insert into table_name values (value1)??(value2)...(valueN);
?????±????????????￡????java api????mysql????????10??100??500??1000?????insert?????????

???????:
????1 ??????Сδ????innodb_buffer_pool_size??
????2 ????????308??????max_allow_packet?????16M??
????3 innodb_flush_log_at_trx_commit=1????????binlog??
????4 ?????е???????????????????????????????????????
?????????
????1?????????????????????3 ??????￡?????insert??????
????2??java api?????addBatch??1?????Ρ?
????????????????????
????1??2??(1) 1?????????insert???mysql???????????????????????2??????mysql??????????
????(2) ????????????????????????
????1??3??(1) ?????????????????(2) ??????sql??????????(3) ??????????????????????????
????2??3????????sql??????????