1
SHOW CREATE TABLE DATA_DICTIONARY.INNODB_CONFIGURATION;
3
INNODB_CONFIGURATION CREATE TABLE `innodb_configuration` (
4
`NAME` varchar(64) NOT NULL DEFAULT '',
5
`TYPE` varchar(64) NOT NULL DEFAULT '',
6
`VALUE` varchar(64) DEFAULT NULL
7
) ENGINE=FunctionEngine
8
SELECT COUNT(*) FROM DATA_DICTIONARY.INNODB_CONFIGURATION;
11
SELECT NAME,TYPE FROM DATA_DICTIONARY.INNODB_CONFIGURATION;
13
adaptive_hash_index BOOL
14
adaptive_flushing BOOL
15
additional_mem_pool_size ULINT
16
autoextend_increment ULONG
17
buffer_pool_size ULINT
25
flush_log_at_trx_commit ULONG
29
lock_wait_timeout ULINT
32
log_files_in_group ULINT
33
log_group_home_dir TEXT
34
max_dirty_pages_pct ULONG
36
lru_old_blocks_pct ULINT
37
lru_block_access_recency ULINT
40
write_io_threads ULINT
41
pre_rollback_hook CALLBACK
42
print_verbose_log BOOL
43
rollback_on_timeout BOOL
44
stats_sample_pages ULINT
49
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION;
51
adaptive_hash_index BOOL false
52
adaptive_flushing BOOL true
53
additional_mem_pool_size ULINT 4194304
54
autoextend_increment ULONG 8
55
buffer_pool_size ULINT 8388608
57
data_file_path TEXT NULL
60
file_format TEXT Barracuda
61
file_io_threads ULINT 10
62
file_per_table BOOL true
63
flush_log_at_trx_commit ULONG 1
64
flush_method TEXT fsync
65
force_recovery ULINT 0
67
lock_wait_timeout ULINT 60
68
log_buffer_size ULINT 24
69
log_file_size ULINT 320
70
log_files_in_group ULINT 2
71
log_group_home_dir TEXT NULL
72
max_dirty_pages_pct ULONG 75
74
lru_old_blocks_pct ULINT 37
75
lru_block_access_recency ULINT 0
77
read_io_threads ULINT 4
78
write_io_threads ULINT 4
79
pre_rollback_hook CALLBACK NULL
80
print_verbose_log BOOL true
81
rollback_on_timeout BOOL true
82
stats_sample_pages ULINT 8
83
status_file BOOL false
84
sync_spin_loops ULONG 30
85
use_sys_malloc BOOL false
86
version TEXT 1.0.6.6750
87
SELECT NAME,VALUE FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME IN ("data_file_path", "data_home_dir");
91
SELECT NAME,VALUE FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME = "file_per_table";