MySQL 5.6 information_schema Tables and Columns

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