问题(一):修改表结构是否会锁定表
一、在sakila数据库下准备一个表。
create table filmtest like film
insert into filmtest(title,description,release_year,language_id,original_language_id,rental_duration,rental_rate,length,replacement_cost,rating,special_features,last_update) select title,description,release_year,language_id,original_language_id,rental_duration,rental_rate,length,replacement_cost,rating,special_features,last_update from film;
多次执行以上insert语句,制造很多数据
二、修改表结构
alter table filmtest change title title2 varchar(255);
alter table filmtest add index idx(title2);
三、此时插入一条语句
insert into filmtest(title2,description,release_year,language_id,original_language_id,rental_duration,rental_rate,length,replacement_cost,rating,special_features,last_update) select title,description,release_year,language_id,original_language_id,rental_duration,rental_rate,length,replacement_cost,rating,special_features,last_update from film limit 1;
四、查看语句state
show full processlist;
ps:这个时候插入语句确实在等待修改表结构的语句释放锁
问题(二):怎么把代码上线到多个服务器?
jenkins
http://walle-web.io/
travis ci