LOCK & UNLOCK

在线修改表结构

lock tables  bus_client_op_real_load_info write  ;

ALTER TABLE `bus_client_op_real_load_info`
MODIFY COLUMN `insertes`  bigint(20) NULL DEFAULT NULL COMMENT '插入操作数量统计' AFTER `loadThread`,
MODIFY COLUMN `updates`  bigint(20) NULL DEFAULT NULL COMMENT '更新操作数量统计' AFTER `insertes`,
MODIFY COLUMN `deletes`  bigint(20) NULL DEFAULT NULL COMMENT '删除操作数量统计' AFTER `updates`,
MODIFY COLUMN `loaddelayseconds`  int(11) NULL DEFAULT 0 AFTER `lastoptime` 

unlock tables ;