1
SHOW VARIABLES LIKE 'innodb_file_format';
2
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='file_format';
3
SET GLOBAL innodb_file_format='antelope';
4
SHOW VARIABLES LIKE 'innodb_file_format';
5
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='file_format';
6
SET GLOBAL innodb_file_format='barracuda';
7
SHOW VARIABLES LIKE 'innodb_file_format';
8
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='file_format';
9
--error ER_WRONG_ARGUMENTS
10
SET GLOBAL innodb_file_format='broccolini';
11
SHOW VARIABLES LIKE 'innodb_file_format';
12
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='file_format';