1
SHOW CREATE TABLE DATA_DICTIONARY.INNODB_CONFIGURATION;
2
SELECT COUNT(*) FROM DATA_DICTIONARY.INNODB_CONFIGURATION;
3
SELECT NAME,TYPE FROM DATA_DICTIONARY.INNODB_CONFIGURATION;
4
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION;
5
SELECT NAME,VALUE FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME IN ("data_file_path", "data_home_dir");
6
SELECT NAME,VALUE FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME = "file_per_table";