SHOW VARIABLES LIKE ‘%innodb_large_prefix%’;
SET GLOBAL innodb_large_prefix=ON;
SHOW VARIABLES LIKE ‘%innodb_file_format%’;
SET GLOBAL innodb_file_format=Barracuda;
SHOW TABLE STATUS FROM MyDatabaseName WHERE NAME=TableName;
ALTER TABLE TableName ROW_FORMAT=DYNAMIC;