mysql操作-以及性能记录

//30w条数据 create 耗时0.04s
create table feature_record_hist_200901 like feature_record;

//空表rename 耗时0.039
rename table feature_record_hist_200901 to feature_record_hist_20200901;

//30w的数据 insert select 耗时3.32s
INSERT into feature_record_hist_20200901 SELECT * from feature_record;

//30w的数据 rename table 。。。to 耗时0.052s
RENAME table feature_record_hist_20200901 to feature_record_hist_200901;