????3??50???????????????????SQL 80??Σ?

????insert into test(INT_A?? INT_B?? INT_C?? STRING_A?? STRING_B?? STRING_C) values(CEIL(RAND()*100000)?? CEIL(RAND()*100000)?? CEIL(RAND()*100000)?? random_string(CEIL(50*RAND()))?? random_string(CEIL(250*RAND()))?? random_string(CEIL(700*RAND())))

????????????У??????????????????????!??????????????750?????????????????????!?????????????????????buffer???????????????????????????????!

????1??truncate table test

????2??????my.cnf????????￡?

????innodb_file_per_table = 0

????innodb_flush_log_at_trx_commit = 2

????innodb_flush_method = O_DIRECT

????innodb_buffer_pool_size = 2G

????innodb_file_io_threads = 4

??????????????????mysqld

????3??50???????????????????SQL 80??Σ?

????insert into test(INT_A?? INT_B?? INT_C?? STRING_A?? STRING_B?? STRING_C) values(CEIL(RAND()*100000)?? CEIL(RAND()*100000)?? CEIL(RAND()*100000)?? random_string(CEIL(50*RAND()))?? random_string(CEIL(250*RAND()))?? random_string(CEIL(700*RAND())))

??????????????????????!??????????ó??????????????????????4000??????????????insert???????????????????δ???????????????С??buffer?????????????????????????????????????????????select???????????????Innodb?????????????ν???????????????????????????????????棬??????????????????????????MySQL????????????????????????????????????????????????????????????????????á?