mysql 超大大數(shù)據(jù)庫復(fù)制前可執(zhí)行的加速導(dǎo)入的SQL
use 數(shù)據(jù)庫;
set global innodb_flush_log_at_trx_commit=0;
set global max_allowed_packet=1024*1024*20;
set global bulk_insert_buffer_size=32*1024*1024;
set global innodb_buffer_pool_size=32*1024*1024;

浙公網(wǎng)安備 33010602011771號