All tables of my database are InnoDB except the language table, which is MyISAM. I tried converting it to InnoDB using the following:
After running I get the following error:
My host informed me that innodb_strict_mode is not enabled and the innodb_log_file_size is on 512MB. Is there any way I can convert the table or can I leave it just as is? Not sure if there would be any increase in performance when changing this table.
Code:
ALTER TABLE language ENGINE=InnoDB
Code:
#1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
Comment