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 »