September 21, 2014

MySQL 5.7: 新增的online DDL操作

(这是个汇总文章,后续有新的Online DDL操作 会不断更新…) 1. 支持ALTER TABLE t1 RENAME INDEX idx1 to idx2; (Server层)语法支持的worklog: http://dev.mysql.com/worklog/task/?id=6555 (Innodb层)Online DDL的worklog: http://dev.mysql.com/worklog/task/?id=6752 新增了语法支持RENAME INDEX操作: mysql> create table t1 (a int, b int, index x1(a)); Query OK, 0 rows affected (0.00 sec) mysql> alter table t1 rename index x1 to x2; Query OK, 0 rows affected (0.00 sec) Records: 0 Duplicates: […]