MySQL :: MySQL 8.0 Reference Manual :: 15.1.15 CREATE INDEX Statement

SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements

[teppeis]

"a prefix can be up to 1000 bytes long for MyISAM tables, and 767 bytes for InnoDB tables."

[msh514]

mysql table index create lock