|
Table |
Column |
Ordinal Position |
Default |
Type |
Max Len |
Octet Len |
Precision |
Numeric Scale |
Null |
Char Set |
Collation |
|
character_sets |
character_set_name |
1 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
character_sets |
default_collate_name |
2 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
character_sets |
description |
3 |
|
VARCHAR |
60 |
180 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
character_sets |
maxlen |
4 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
collations |
collation_name |
1 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
collations |
character_set_name |
2 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
collations |
id |
3 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
collations |
is_default |
4 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
collations |
is_compiled |
5 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
collations |
sortlen |
6 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
collation_character_set_applicability |
collation_name |
1 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
collation_character_set_applicability |
character_set_name |
2 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
table_catalog |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
table_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
table_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
column_name |
4 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
ordinal_position |
5 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
columns |
column_default |
6 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
columns |
is_nullable |
7 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
data_type |
8 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
character_maximum_length |
9 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
columns |
character_octet_length |
10 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
columns |
numeric_precision |
11 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
columns |
numeric_scale |
12 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
columns |
datetime_precision |
13 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
columns |
character_set_name |
14 |
NULL |
VARCHAR |
32 |
96 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
columns |
collation_name |
15 |
NULL |
VARCHAR |
32 |
96 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
columns |
column_type |
16 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
column_key |
17 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
extra |
18 |
|
VARCHAR |
30 |
90 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
privileges |
19 |
|
VARCHAR |
80 |
240 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
columns |
column_comment |
20 |
|
VARCHAR |
1024 |
3072 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
column_privileges |
grantee |
1 |
|
VARCHAR |
81 |
243 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
column_privileges |
table_catalog |
2 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
column_privileges |
table_schema |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
column_privileges |
table_name |
4 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
column_privileges |
column_name |
5 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
column_privileges |
privilege_type |
6 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
column_privileges |
is_grantable |
7 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
engines |
engine |
1 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
engines |
support |
2 |
|
VARCHAR |
8 |
24 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
engines |
comment |
3 |
|
VARCHAR |
80 |
240 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
engines |
transactions |
4 |
NULL |
VARCHAR |
3 |
9 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
engines |
xa |
5 |
NULL |
VARCHAR |
3 |
9 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
engines |
savepoints |
6 |
NULL |
VARCHAR |
3 |
9 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
events |
event_catalog |
1 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
event_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
event_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
definer |
4 |
|
VARCHAR |
77 |
231 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
time_zone |
5 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
event_body |
6 |
|
VARCHAR |
8 |
24 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
event_definition |
7 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
event_type |
8 |
|
VARCHAR |
9 |
27 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
execute_at |
9 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
events |
interval_value |
10 |
NULL |
VARCHAR |
256 |
768 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
events |
interval_field |
11 |
NULL |
VARCHAR |
18 |
54 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
events |
sql_mode |
12 |
|
VARCHAR |
8192 |
24576 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
starts |
13 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
events |
ends |
14 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
events |
status |
15 |
|
VARCHAR |
18 |
54 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
on_completion |
16 |
|
VARCHAR |
12 |
36 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
created |
17 |
0000-00-00 00:00:00 |
DATETIME |
NULL |
NULL |
NULL |
NULL |
NO |
NULL |
NULL |
|
events |
last_altered |
18 |
0000-00-00 00:00:00 |
DATETIME |
NULL |
NULL |
NULL |
NULL |
NO |
NULL |
NULL |
|
events |
last_executed |
19 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
events |
event_comment |
20 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
originator |
21 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
events |
character_set_client |
22 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
collation_connection |
23 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
events |
database_collation |
24 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
files |
file_id |
1 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
files |
file_name |
2 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
files |
file_type |
3 |
|
VARCHAR |
20 |
60 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
files |
tablespace_name |
4 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
files |
table_catalog |
5 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
files |
table_schema |
6 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
files |
table_name |
7 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
files |
logfile_group_name |
8 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
files |
logfile_group_number |
9 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
files |
engine |
10 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
files |
fulltext_keys |
11 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
files |
deleted_rows |
12 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
files |
update_count |
13 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
files |
free_extents |
14 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
files |
total_extents |
15 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
files |
extent_size |
16 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
files |
initial_size |
17 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
maximum_size |
18 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
autoextend_size |
19 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
creation_time |
20 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
files |
last_update_time |
21 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
files |
last_access_time |
22 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
files |
recover_time |
23 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
files |
transaction_counter |
24 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
files |
version |
25 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
row_format |
26 |
NULL |
VARCHAR |
10 |
30 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
files |
table_rows |
27 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
avg_row_length |
28 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
data_length |
29 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
max_data_length |
30 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
index_length |
31 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
data_free |
32 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
create_time |
33 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
files |
update_time |
34 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
files |
check_time |
35 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
files |
checksum |
36 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
files |
status |
37 |
|
VARCHAR |
20 |
60 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
files |
extra |
38 |
NULL |
VARCHAR |
255 |
765 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
global_status |
variable_name |
1 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
global_status |
variable_value |
2 |
NULL |
VARCHAR |
1024 |
3072 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
global_variables |
variable_name |
1 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
global_variables |
variable_value |
2 |
NULL |
VARCHAR |
1024 |
3072 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page |
pool_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
block_id |
2 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
space |
3 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
page_number |
4 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
page_type |
5 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page |
flush_type |
6 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
fix_count |
7 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
is_hashed |
8 |
NULL |
VARCHAR |
3 |
9 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page |
newest_modification |
9 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
oldest_modification |
10 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
access_time |
11 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
table_name |
12 |
NULL |
VARCHAR |
1024 |
3072 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page |
index_name |
13 |
NULL |
VARCHAR |
1024 |
3072 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page |
number_records |
14 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
data_size |
15 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
compressed_size |
16 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page |
page_state |
17 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page |
io_fix |
18 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page |
is_old |
19 |
NULL |
VARCHAR |
3 |
9 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page |
free_page_clock |
20 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
pool_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
lru_position |
2 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
space |
3 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
page_number |
4 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
page_type |
5 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page_lru |
flush_type |
6 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
fix_count |
7 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
is_hashed |
8 |
NULL |
VARCHAR |
3 |
9 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page_lru |
newest_modification |
9 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
oldest_modification |
10 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
access_time |
11 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
table_name |
12 |
NULL |
VARCHAR |
1024 |
3072 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page_lru |
index_name |
13 |
NULL |
VARCHAR |
1024 |
3072 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page_lru |
number_records |
14 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
data_size |
15 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
compressed_size |
16 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_page_lru |
compressed |
17 |
NULL |
VARCHAR |
3 |
9 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page_lru |
io_fix |
18 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page_lru |
is_old |
19 |
NULL |
VARCHAR |
3 |
9 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_buffer_page_lru |
free_page_clock |
20 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pool_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pool_size |
2 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
free_buffers |
3 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
database_pages |
4 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
old_database_pages |
5 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
modified_database_pages |
6 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pending_decompress |
7 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pending_reads |
8 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pending_flush_lru |
9 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pending_flush_list |
10 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pages_made_young |
11 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pages_not_made_young |
12 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pages_made_young_rate |
13 |
0 |
DOUBLE |
NULL |
NULL |
0 |
NULL |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pages_made_not_young_rate |
14 |
0 |
DOUBLE |
NULL |
NULL |
0 |
NULL |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
number_pages_read |
15 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
number_pages_created |
16 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
number_pages_written |
17 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pages_read_rate |
18 |
0 |
DOUBLE |
NULL |
NULL |
0 |
NULL |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pages_create_rate |
19 |
0 |
DOUBLE |
NULL |
NULL |
0 |
NULL |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
pages_written_rate |
20 |
0 |
DOUBLE |
NULL |
NULL |
0 |
NULL |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
number_pages_get |
21 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
hit_rate |
22 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
young_make_per_thousand_gets |
23 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
not_young_make_per_thousand_gets |
24 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
number_pages_read_ahead |
25 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
number_read_ahead_evicted |
26 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
read_ahead_rate |
27 |
0 |
DOUBLE |
NULL |
NULL |
0 |
NULL |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
read_ahead_evicted_rate |
28 |
0 |
DOUBLE |
NULL |
NULL |
0 |
NULL |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
lru_io_total |
29 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
lru_io_current |
30 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
uncompress_total |
31 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_buffer_pool_stats |
uncompress_current |
32 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp |
page_size |
1 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp |
compress_ops |
2 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp |
compress_ops_ok |
3 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp |
compress_time |
4 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp |
uncompress_ops |
5 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp |
uncompress_time |
6 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem |
page_size |
1 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem |
buffer_pool_instance |
2 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem |
pages_used |
3 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem |
pages_free |
4 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem |
relocation_ops |
5 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem |
relocation_time |
6 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem_reset |
page_size |
1 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem_reset |
buffer_pool_instance |
2 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem_reset |
pages_used |
3 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem_reset |
pages_free |
4 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem_reset |
relocation_ops |
5 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
innodb_cmpmem_reset |
relocation_time |
6 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp_reset |
page_size |
1 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp_reset |
compress_ops |
2 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp_reset |
compress_ops_ok |
3 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp_reset |
compress_time |
4 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp_reset |
uncompress_ops |
5 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_cmp_reset |
uncompress_time |
6 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_being_deleted |
doc_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_config |
key |
1 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_ft_config |
value |
2 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_ft_default_stopword |
value |
1 |
|
VARCHAR |
18 |
54 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_ft_deleted |
doc_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_index_cache |
word |
1 |
|
VARCHAR |
253 |
759 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_ft_index_cache |
first_doc_id |
2 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_index_cache |
last_doc_id |
3 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_index_cache |
doc_count |
4 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_index_cache |
doc_id |
5 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_index_cache |
position |
6 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_index_table |
word |
1 |
|
VARCHAR |
253 |
759 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_ft_index_table |
first_doc_id |
2 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_index_table |
last_doc_id |
3 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_index_table |
doc_count |
4 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_index_table |
doc_id |
5 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_index_table |
position |
6 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_ft_inserted |
doc_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_locks |
lock_id |
1 |
|
VARCHAR |
81 |
243 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_locks |
lock_trx_id |
2 |
|
VARCHAR |
18 |
54 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_locks |
lock_mode |
3 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_locks |
lock_type |
4 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_locks |
lock_table |
5 |
|
VARCHAR |
1024 |
3072 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_locks |
lock_index |
6 |
NULL |
VARCHAR |
1024 |
3072 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_locks |
lock_space |
7 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
innodb_locks |
lock_page |
8 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
innodb_locks |
lock_rec |
9 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
innodb_locks |
lock_data |
10 |
NULL |
VARCHAR |
8192 |
24576 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_lock_waits |
requesting_trx_id |
1 |
|
VARCHAR |
18 |
54 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_lock_waits |
requested_lock_id |
2 |
|
VARCHAR |
81 |
243 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_lock_waits |
blocking_trx_id |
3 |
|
VARCHAR |
18 |
54 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_lock_waits |
blocking_lock_id |
4 |
|
VARCHAR |
81 |
243 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_metrics |
name |
1 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_metrics |
subsystem |
2 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_metrics |
count |
3 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
innodb_metrics |
max_count |
4 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
innodb_metrics |
min_count |
5 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
innodb_metrics |
avg_count |
6 |
NULL |
DOUBLE |
NULL |
NULL |
0 |
NULL |
YES |
NULL |
NULL |
|
innodb_metrics |
count_reset |
7 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
innodb_metrics |
max_count_reset |
8 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
innodb_metrics |
min_count_reset |
9 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
innodb_metrics |
avg_count_reset |
10 |
NULL |
DOUBLE |
NULL |
NULL |
0 |
NULL |
YES |
NULL |
NULL |
|
innodb_metrics |
time_enabled |
11 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
innodb_metrics |
time_disabled |
12 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
innodb_metrics |
time_elapsed |
13 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
innodb_metrics |
time_reset |
14 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
innodb_metrics |
status |
15 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_metrics |
type |
16 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_metrics |
comment |
17 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_columns |
table_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_columns |
name |
2 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_columns |
pos |
3 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_columns |
mtype |
4 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_columns |
prtype |
5 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_columns |
len |
6 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_fields |
index_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_fields |
name |
2 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_fields |
pos |
3 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_foreign |
id |
1 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_foreign |
for_name |
2 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_foreign |
ref_name |
3 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_foreign |
n_cols |
4 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_foreign |
type |
5 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_foreign_cols |
id |
1 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_foreign_cols |
for_col_name |
2 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_foreign_cols |
ref_col_name |
3 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_foreign_cols |
pos |
4 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_indexes |
index_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_indexes |
name |
2 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_indexes |
table_id |
3 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_indexes |
type |
4 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_indexes |
n_fields |
5 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_indexes |
page_no |
6 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_indexes |
space |
7 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tables |
table_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tables |
name |
2 |
|
VARCHAR |
399 |
1197 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_tables |
flag |
3 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tables |
n_cols |
4 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tables |
space |
5 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tablestats |
table_id |
1 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tablestats |
name |
2 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_tablestats |
stats_initialized |
3 |
|
VARCHAR |
193 |
579 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_sys_tablestats |
num_rows |
4 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tablestats |
clust_index_size |
5 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tablestats |
other_index_size |
6 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tablestats |
modified_counter |
7 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tablestats |
autoinc |
8 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_sys_tablestats |
ref_count |
9 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_id |
1 |
|
VARCHAR |
18 |
54 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_trx |
trx_state |
2 |
|
VARCHAR |
13 |
39 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_trx |
trx_started |
3 |
0000-00-00 00:00:00 |
DATETIME |
NULL |
NULL |
NULL |
NULL |
NO |
NULL |
NULL |
|
innodb_trx |
trx_requested_lock_id |
4 |
NULL |
VARCHAR |
81 |
243 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_trx |
trx_wait_started |
5 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
innodb_trx |
trx_weight |
6 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_mysql_thread_id |
7 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_query |
8 |
NULL |
VARCHAR |
1024 |
3072 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_trx |
trx_operation_state |
9 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_trx |
trx_tables_in_use |
10 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_tables_locked |
11 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_lock_structs |
12 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_lock_memory_bytes |
13 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_rows_locked |
14 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_rows_modified |
15 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_concurrency_tickets |
16 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_isolation_level |
17 |
|
VARCHAR |
16 |
48 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
innodb_trx |
trx_unique_checks |
18 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_foreign_key_checks |
19 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_last_foreign_key_error |
20 |
NULL |
VARCHAR |
256 |
768 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
innodb_trx |
trx_adaptive_hash_latched |
21 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_adaptive_hash_timeout |
22 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_is_read_only |
23 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
innodb_trx |
trx_autocommit_non_locking |
24 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
key_column_usage |
constraint_catalog |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
key_column_usage |
constraint_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
key_column_usage |
constraint_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
key_column_usage |
table_catalog |
4 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
key_column_usage |
table_schema |
5 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
key_column_usage |
table_name |
6 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
key_column_usage |
column_name |
7 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
key_column_usage |
ordinal_position |
8 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
key_column_usage |
position_in_unique_constraint |
9 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
key_column_usage |
referenced_table_schema |
10 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
key_column_usage |
referenced_table_name |
11 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
key_column_usage |
referenced_column_name |
12 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
optimizer_trace |
query |
1 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
optimizer_trace |
trace |
2 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
optimizer_trace |
missing_bytes_beyond_max_mem_size |
3 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
optimizer_trace |
insufficient_privileges |
4 |
0 |
TINYINT |
NULL |
NULL |
3 |
0 |
NO |
NULL |
NULL |
|
parameters |
specific_catalog |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
parameters |
specific_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
parameters |
specific_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
parameters |
ordinal_position |
4 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
parameters |
parameter_mode |
5 |
NULL |
VARCHAR |
5 |
15 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
parameters |
parameter_name |
6 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
parameters |
data_type |
7 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
parameters |
character_maximum_length |
8 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
parameters |
character_octet_length |
9 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
parameters |
numeric_precision |
10 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
parameters |
numeric_scale |
11 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
parameters |
datetime_precision |
12 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
parameters |
character_set_name |
13 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
parameters |
collation_name |
14 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
parameters |
dtd_identifier |
15 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
parameters |
routine_type |
16 |
|
VARCHAR |
9 |
27 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
partitions |
table_catalog |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
partitions |
table_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
partitions |
table_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
partitions |
partition_name |
4 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
partitions |
subpartition_name |
5 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
partitions |
partition_ordinal_position |
6 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
partitions |
subpartition_ordinal_position |
7 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
partitions |
partition_method |
8 |
NULL |
VARCHAR |
18 |
54 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
partitions |
subpartition_method |
9 |
NULL |
VARCHAR |
12 |
36 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
partitions |
partition_expression |
10 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
partitions |
subpartition_expression |
11 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
partitions |
partition_description |
12 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
partitions |
table_rows |
13 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
partitions |
avg_row_length |
14 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
partitions |
data_length |
15 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
partitions |
max_data_length |
16 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
partitions |
index_length |
17 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
partitions |
data_free |
18 |
0 |
BIGINT |
NULL |
NULL |
20 |
0 |
NO |
NULL |
NULL |
|
partitions |
create_time |
19 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
partitions |
update_time |
20 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
partitions |
check_time |
21 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
partitions |
checksum |
22 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
partitions |
partition_comment |
23 |
|
VARCHAR |
80 |
240 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
partitions |
nodegroup |
24 |
|
VARCHAR |
12 |
36 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
partitions |
tablespace_name |
25 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
plugins |
plugin_name |
1 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
plugins |
plugin_version |
2 |
|
VARCHAR |
20 |
60 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
plugins |
plugin_status |
3 |
|
VARCHAR |
10 |
30 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
plugins |
plugin_type |
4 |
|
VARCHAR |
80 |
240 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
plugins |
plugin_type_version |
5 |
|
VARCHAR |
20 |
60 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
plugins |
plugin_library |
6 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
plugins |
plugin_library_version |
7 |
NULL |
VARCHAR |
20 |
60 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
plugins |
plugin_author |
8 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
plugins |
plugin_description |
9 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
plugins |
plugin_license |
10 |
NULL |
VARCHAR |
80 |
240 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
plugins |
load_option |
11 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
processlist |
id |
1 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
processlist |
user |
2 |
|
VARCHAR |
16 |
48 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
processlist |
host |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
processlist |
db |
4 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
processlist |
command |
5 |
|
VARCHAR |
16 |
48 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
processlist |
time |
6 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
processlist |
state |
7 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
processlist |
info |
8 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
profiling |
query_id |
1 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
profiling |
seq |
2 |
0 |
INT |
NULL |
NULL |
10 |
0 |
NO |
NULL |
NULL |
|
profiling |
state |
3 |
|
VARCHAR |
30 |
90 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
profiling |
duration |
4 |
0.000000 |
DECIMAL |
NULL |
NULL |
9 |
6 |
NO |
NULL |
NULL |
|
profiling |
cpu_user |
5 |
NULL |
DECIMAL |
NULL |
NULL |
9 |
6 |
YES |
NULL |
NULL |
|
profiling |
cpu_system |
6 |
NULL |
DECIMAL |
NULL |
NULL |
9 |
6 |
YES |
NULL |
NULL |
|
profiling |
context_voluntary |
7 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
profiling |
context_involuntary |
8 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
profiling |
block_ops_in |
9 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
profiling |
block_ops_out |
10 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
profiling |
messages_sent |
11 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
profiling |
messages_received |
12 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
profiling |
page_faults_major |
13 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
profiling |
page_faults_minor |
14 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
profiling |
swaps |
15 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
profiling |
source_function |
16 |
NULL |
VARCHAR |
30 |
90 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
profiling |
source_file |
17 |
NULL |
VARCHAR |
20 |
60 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
profiling |
source_line |
18 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
referential_constraints |
constraint_catalog |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
referential_constraints |
constraint_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
referential_constraints |
constraint_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
referential_constraints |
unique_constraint_catalog |
4 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
referential_constraints |
unique_constraint_schema |
5 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
referential_constraints |
unique_constraint_name |
6 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
referential_constraints |
match_option |
7 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
referential_constraints |
update_rule |
8 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
referential_constraints |
delete_rule |
9 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
referential_constraints |
table_name |
10 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
referential_constraints |
referenced_table_name |
11 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
specific_name |
1 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
routine_catalog |
2 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
routine_schema |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
routine_name |
4 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
routine_type |
5 |
|
VARCHAR |
9 |
27 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
data_type |
6 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
character_maximum_length |
7 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
routines |
character_octet_length |
8 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
routines |
numeric_precision |
9 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
routines |
numeric_scale |
10 |
NULL |
INT |
NULL |
NULL |
10 |
0 |
YES |
NULL |
NULL |
|
routines |
datetime_precision |
11 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
routines |
character_set_name |
12 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
routines |
collation_name |
13 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
routines |
dtd_identifier |
14 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
routines |
routine_body |
15 |
|
VARCHAR |
8 |
24 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
routine_definition |
16 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
routines |
external_name |
17 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
routines |
external_language |
18 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
routines |
parameter_style |
19 |
|
VARCHAR |
8 |
24 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
is_deterministic |
20 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
sql_data_access |
21 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
sql_path |
22 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
routines |
security_type |
23 |
|
VARCHAR |
7 |
21 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
created |
24 |
0000-00-00 00:00:00 |
DATETIME |
NULL |
NULL |
NULL |
NULL |
NO |
NULL |
NULL |
|
routines |
last_altered |
25 |
0000-00-00 00:00:00 |
DATETIME |
NULL |
NULL |
NULL |
NULL |
NO |
NULL |
NULL |
|
routines |
sql_mode |
26 |
|
VARCHAR |
8192 |
24576 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
routine_comment |
27 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
definer |
28 |
|
VARCHAR |
77 |
231 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
character_set_client |
29 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
collation_connection |
30 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
routines |
database_collation |
31 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
schemata |
catalog_name |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
schemata |
schema_name |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
schemata |
default_character_set_name |
3 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
schemata |
default_collation_name |
4 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
schemata |
sql_path |
5 |
NULL |
VARCHAR |
512 |
1536 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
schema_privileges |
grantee |
1 |
|
VARCHAR |
81 |
243 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
schema_privileges |
table_catalog |
2 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
schema_privileges |
table_schema |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
schema_privileges |
privilege_type |
4 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
schema_privileges |
is_grantable |
5 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
session_status |
variable_name |
1 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
session_status |
variable_value |
2 |
NULL |
VARCHAR |
1024 |
3072 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
session_variables |
variable_name |
1 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
session_variables |
variable_value |
2 |
NULL |
VARCHAR |
1024 |
3072 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
statistics |
table_catalog |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
statistics |
table_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
statistics |
table_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
statistics |
non_unique |
4 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
statistics |
index_schema |
5 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
statistics |
index_name |
6 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
statistics |
seq_in_index |
7 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
statistics |
column_name |
8 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
statistics |
collation |
9 |
NULL |
VARCHAR |
1 |
3 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
statistics |
cardinality |
10 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
statistics |
sub_part |
11 |
NULL |
BIGINT |
NULL |
NULL |
19 |
0 |
YES |
NULL |
NULL |
|
statistics |
packed |
12 |
NULL |
VARCHAR |
10 |
30 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
statistics |
nullable |
13 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
statistics |
index_type |
14 |
|
VARCHAR |
16 |
48 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
statistics |
comment |
15 |
NULL |
VARCHAR |
16 |
48 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
statistics |
index_comment |
16 |
|
VARCHAR |
1024 |
3072 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
tables |
table_catalog |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
tables |
table_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
tables |
table_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
tables |
table_type |
4 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
tables |
engine |
5 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
tables |
version |
6 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tables |
row_format |
7 |
NULL |
VARCHAR |
10 |
30 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
tables |
table_rows |
8 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tables |
avg_row_length |
9 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tables |
data_length |
10 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tables |
max_data_length |
11 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tables |
index_length |
12 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tables |
data_free |
13 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tables |
auto_increment |
14 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tables |
create_time |
15 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
tables |
update_time |
16 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
tables |
check_time |
17 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
tables |
table_collation |
18 |
NULL |
VARCHAR |
32 |
96 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
tables |
checksum |
19 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tables |
create_options |
20 |
NULL |
VARCHAR |
255 |
765 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
tables |
table_comment |
21 |
|
VARCHAR |
2048 |
6144 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
tablespaces |
tablespace_name |
1 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
tablespaces |
engine |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
tablespaces |
tablespace_type |
3 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
tablespaces |
logfile_group_name |
4 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
tablespaces |
extent_size |
5 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tablespaces |
autoextend_size |
6 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tablespaces |
maximum_size |
7 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tablespaces |
nodegroup_id |
8 |
NULL |
BIGINT |
NULL |
NULL |
20 |
0 |
YES |
NULL |
NULL |
|
tablespaces |
tablespace_comment |
9 |
NULL |
VARCHAR |
2048 |
6144 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
table_constraints |
constraint_catalog |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_constraints |
constraint_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_constraints |
constraint_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_constraints |
table_schema |
4 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_constraints |
table_name |
5 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_constraints |
constraint_type |
6 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_privileges |
grantee |
1 |
|
VARCHAR |
81 |
243 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_privileges |
table_catalog |
2 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_privileges |
table_schema |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_privileges |
table_name |
4 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_privileges |
privilege_type |
5 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
table_privileges |
is_grantable |
6 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
trigger_catalog |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
trigger_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
trigger_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
event_manipulation |
4 |
|
VARCHAR |
6 |
18 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
event_object_catalog |
5 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
event_object_schema |
6 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
event_object_table |
7 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
action_order |
8 |
0 |
BIGINT |
NULL |
NULL |
19 |
0 |
NO |
NULL |
NULL |
|
triggers |
action_condition |
9 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
triggers |
action_statement |
10 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
action_orientation |
11 |
|
VARCHAR |
9 |
27 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
action_timing |
12 |
|
VARCHAR |
6 |
18 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
action_reference_old_table |
13 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
triggers |
action_reference_new_table |
14 |
NULL |
VARCHAR |
64 |
192 |
NULL |
NULL |
YES |
utf8 |
utf8_general_ci |
|
triggers |
action_reference_old_row |
15 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
action_reference_new_row |
16 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
created |
17 |
NULL |
DATETIME |
NULL |
NULL |
NULL |
NULL |
YES |
NULL |
NULL |
|
triggers |
sql_mode |
18 |
|
VARCHAR |
8192 |
24576 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
definer |
19 |
|
VARCHAR |
77 |
231 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
character_set_client |
20 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
collation_connection |
21 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
triggers |
database_collation |
22 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
user_privileges |
grantee |
1 |
|
VARCHAR |
81 |
243 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
user_privileges |
table_catalog |
2 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
user_privileges |
privilege_type |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
user_privileges |
is_grantable |
4 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
views |
table_catalog |
1 |
|
VARCHAR |
512 |
1536 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
views |
table_schema |
2 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
views |
table_name |
3 |
|
VARCHAR |
64 |
192 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
views |
view_definition |
4 |
NULL |
LONGTEXT |
4294967295 |
4294967295 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
views |
check_option |
5 |
|
VARCHAR |
8 |
24 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
views |
is_updatable |
6 |
|
VARCHAR |
3 |
9 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
views |
definer |
7 |
|
VARCHAR |
77 |
231 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
views |
security_type |
8 |
|
VARCHAR |
7 |
21 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
views |
character_set_client |
9 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |
|
views |
collation_connection |
10 |
|
VARCHAR |
32 |
96 |
NULL |
NULL |
NO |
utf8 |
utf8_general_ci |