1
SHOW VARIABLES LIKE 'innodb_file_format';
3
innodb_file_format Barracuda
4
SELECT * FROM DATA_DICTIONARY.HAILDB_CONFIGURATION WHERE NAME='file_format';
6
file_format TEXT Barracuda
7
SET GLOBAL innodb_file_format='antelope';
8
SHOW VARIABLES LIKE 'innodb_file_format';
10
innodb_file_format antelope
11
SELECT * FROM DATA_DICTIONARY.HAILDB_CONFIGURATION WHERE NAME='file_format';
13
file_format TEXT Antelope
14
SET GLOBAL innodb_file_format='barracuda';
15
SHOW VARIABLES LIKE 'innodb_file_format';
17
innodb_file_format barracuda
18
SELECT * FROM DATA_DICTIONARY.HAILDB_CONFIGURATION WHERE NAME='file_format';
20
file_format TEXT Barracuda
21
SET GLOBAL innodb_file_format='broccolini';
22
ERROR 42000: Variable 'innodb_file_format' can't be set to the value of 'broccolini'
23
SHOW VARIABLES LIKE 'innodb_file_format';
25
innodb_file_format barracuda
26
SELECT * FROM DATA_DICTIONARY.HAILDB_CONFIGURATION WHERE NAME='file_format';
28
file_format TEXT Barracuda
29
SET GLOBAL innodb_file_format='Barracuda';