2020 十一月 24 , 星期二
Home / 2019 / 十一月

Monthly Archives: 十一月 2019

Mysql 大表加索引

create table new_table like old_table; –增加新索引 insert into new_table select * from old_table where id < 3; lock tables old_table write, new_table write; insert into new_table select * from old_table where id >= 3; alter table foo new_table renam ...

Read More »