MySQL5.7新特性之更改索引名字不会锁表MySQL5.7在更改索引名字时候不会锁表,测试过程如下:
点击(此处)折叠或打开mysql> select count(*) from T_USER_INFO;
+----------+
| count(*) |
+----------+
| 7147528 |
MySQL5.7新特性之在线DDL不会锁表MySQL5.7在线修改varchar字段不在锁表,测试过程如下:
点击(此处)折叠或打开mysql> select version();
+------------+
| version() |
+------------+
| 5.7.18-log |
+-------