mysql online ddl still lock
Posted by:
hua kai
Date: February 19, 2016 02:35AM
Hi,
My mysql is 5.6.22. It should support online DDL.
But I found some strange problem.
For some table, it supports online DDL.
ALTER TABLE `table_xxx` FORCE, ALGORITHM=INPLACE, LOCK=NONE, will work.
But for some table, this will report not support error. The table has no FULLTEXT index, and after I drop one index on the table, it still not work, then I readd the index, after readd, the online DDL worked.
I don't know why this happens. My index has column datetime, varchar, longint type field.
Subject
Views
Written By
Posted
mysql online ddl still lock
2708
February 19, 2016 02:35AM
1609
February 19, 2016 03:09AM
1559
February 19, 2016 06:53AM
1507
February 20, 2016 01:38AM
1244
August 24, 2016 03:48AM
1106
August 25, 2016 07:40PM
1267
August 30, 2016 09:33PM
1218
September 01, 2016 04:55PM
1163
September 01, 2016 11:40PM
1160
September 03, 2016 05:05PM
1162
September 05, 2016 01:20AM
1297
September 05, 2016 03:54PM
1059
September 08, 2016 04:04AM
1128
September 10, 2016 12:19AM
1428
February 23, 2016 11:29PM
1893
February 29, 2016 11:32PM
1602
March 05, 2016 12:19AM
1541
March 07, 2016 03:34AM
1513
March 31, 2016 02:32AM
1467
April 02, 2016 12:39AM
1488
May 13, 2016 02:44AM
1507
May 24, 2016 09:53AM