Mysql5.6 is closed by default and 5.7 is open by default
show variables like '%innodb_large_prefix%';
set global innodb_large_prefix=on;
show variables like '%innodb_file_format%';
#output:
innodb_file_format Antelope
innodb_file_format_check ON
innodb_file_format_max Antelope
set global innodb_file_format=Barracuda;
Similar Posts:
- [Solved] MYSQL5.6 Error: ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.
- MySQL Error: [Err] 1071 – Specified key was too long; max key length is 767 bytes
- ERROR 2006 (HY000): MySQL server has gone away No
- How to Solve Mysql Error 1206: The total number of locks exceeds the lock table size
- The ‘INFORMATION_SCHEMA.GLOBAL_STATUS’ feature is disabled; see the documentation for …
- MYSQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- Prepared statement needs to be re prepared
- How to Solve MySQL Secure file priv error
- Loading local data is disabled; this must be enabled on both the client and server sides