ALL_PLUGINS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
PLUGIN_NAME	varchar(64)	Nein
PLUGIN_VERSION	varchar(20)	Nein
PLUGIN_STATUS	varchar(16)	Nein
PLUGIN_TYPE	varchar(80)	Nein
PLUGIN_TYPE_VERSION	varchar(20)	Nein
PLUGIN_LIBRARY	varchar(64)	Ja	NULL
PLUGIN_LIBRARY_VERSION	varchar(20)	Ja	NULL
PLUGIN_AUTHOR	varchar(64)	Ja	NULL
PLUGIN_DESCRIPTION	longtext	Ja	NULL
PLUGIN_LICENSE	varchar(80)	Nein
LOAD_OPTION	varchar(64)	Nein
PLUGIN_MATURITY	varchar(12)	Nein
PLUGIN_AUTH_VERSION	varchar(80)	Ja	NULL

APPLICABLE_ROLES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
GRANTEE	varchar(190)	Nein
ROLE_NAME	varchar(128)	Nein
IS_GRANTABLE	varchar(3)	Nein
IS_DEFAULT	varchar(3)	Ja	NULL

CHARACTER_SETS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
CHARACTER_SET_NAME	varchar(32)	Nein
DEFAULT_COLLATE_NAME	varchar(32)	Nein		COLLATIONS -> COLLATION_NAME
DESCRIPTION	varchar(60)	Nein
MAXLEN	bigint(3)	Nein	0

CHECK_CONSTRAINTS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
CONSTRAINT_CATALOG	varchar(512)	Nein
CONSTRAINT_SCHEMA	varchar(64)	Nein
CONSTRAINT_NAME	varchar(64)	Nein
TABLE_NAME	varchar(64)	Nein
CHECK_CLAUSE	varchar(64)	Nein

CLIENT_STATISTICS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
CLIENT	varchar(64)	Nein
TOTAL_CONNECTIONS	bigint(21)	Nein	0
CONCURRENT_CONNECTIONS	bigint(21)	Nein	0
CONNECTED_TIME	bigint(21)	Nein	0
BUSY_TIME	double	Nein	0
CPU_TIME	double	Nein	0
BYTES_RECEIVED	bigint(21)	Nein	0
BYTES_SENT	bigint(21)	Nein	0
BINLOG_BYTES_WRITTEN	bigint(21)	Nein	0
ROWS_READ	bigint(21)	Nein	0
ROWS_SENT	bigint(21)	Nein	0
ROWS_DELETED	bigint(21)	Nein	0
ROWS_INSERTED	bigint(21)	Nein	0
ROWS_UPDATED	bigint(21)	Nein	0
SELECT_COMMANDS	bigint(21)	Nein	0
UPDATE_COMMANDS	bigint(21)	Nein	0
OTHER_COMMANDS	bigint(21)	Nein	0
COMMIT_TRANSACTIONS	bigint(21)	Nein	0
ROLLBACK_TRANSACTIONS	bigint(21)	Nein	0
DENIED_CONNECTIONS	bigint(21)	Nein	0
LOST_CONNECTIONS	bigint(21)	Nein	0
ACCESS_DENIED	bigint(21)	Nein	0
EMPTY_QUERIES	bigint(21)	Nein	0
TOTAL_SSL_CONNECTIONS	bigint(21)	Nein	0
MAX_STATEMENT_TIME_EXCEEDED	bigint(21)	Nein	0

COLLATIONS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
COLLATION_NAME	varchar(32)	Nein
CHARACTER_SET_NAME	varchar(32)	Nein		CHARACTER_SETS -> CHARACTER_SET_NAME
ID	bigint(11)	Nein	0
IS_DEFAULT	varchar(3)	Nein
IS_COMPILED	varchar(3)	Nein
SORTLEN	bigint(3)	Nein	0

COLLATION_CHARACTER_SET_APPLICABILITY

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
COLLATION_NAME	varchar(32)	Nein		COLLATIONS -> COLLATION_NAME
CHARACTER_SET_NAME	varchar(32)	Nein		CHARACTER_SETS -> CHARACTER_SET_NAME

COLUMNS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_CATALOG	varchar(512)	Nein
TABLE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Nein
COLUMN_NAME	varchar(64)	Nein
ORDINAL_POSITION	bigint(21)	Nein	0
COLUMN_DEFAULT	longtext	Ja	NULL
IS_NULLABLE	varchar(3)	Nein
DATA_TYPE	varchar(64)	Nein
CHARACTER_MAXIMUM_LENGTH	bigint(21)	Ja	NULL
CHARACTER_OCTET_LENGTH	bigint(21)	Ja	NULL
NUMERIC_PRECISION	bigint(21)	Ja	NULL
NUMERIC_SCALE	bigint(21)	Ja	NULL
DATETIME_PRECISION	bigint(21)	Ja	NULL
CHARACTER_SET_NAME	varchar(32)	Ja	NULL	CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAME	varchar(32)	Ja	NULL	COLLATIONS -> COLLATION_NAME
COLUMN_TYPE	longtext	Nein
COLUMN_KEY	varchar(3)	Nein
EXTRA	varchar(30)	Nein
PRIVILEGES	varchar(80)	Nein
COLUMN_COMMENT	varchar(1024)	Nein
IS_GENERATED	varchar(6)	Nein
GENERATION_EXPRESSION	longtext	Ja	NULL

COLUMN_PRIVILEGES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
GRANTEE	varchar(190)	Nein
TABLE_CATALOG	varchar(512)	Nein
TABLE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Nein
COLUMN_NAME	varchar(64)	Nein
PRIVILEGE_TYPE	varchar(64)	Nein
IS_GRANTABLE	varchar(3)	Nein

ENABLED_ROLES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
ROLE_NAME	varchar(128)	Ja	NULL

ENGINES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
ENGINE	varchar(64)	Nein
SUPPORT	varchar(8)	Nein
COMMENT	varchar(160)	Nein
TRANSACTIONS	varchar(3)	Ja	NULL
XA	varchar(3)	Ja	NULL
SAVEPOINTS	varchar(3)	Ja	NULL

EVENTS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
EVENT_CATALOG	varchar(64)	Nein
EVENT_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
EVENT_NAME	varchar(64)	Nein
DEFINER	varchar(189)	Nein
TIME_ZONE	varchar(64)	Nein
EVENT_BODY	varchar(8)	Nein
EVENT_DEFINITION	longtext	Nein
EVENT_TYPE	varchar(9)	Nein
EXECUTE_AT	datetime	Ja	NULL
INTERVAL_VALUE	varchar(256)	Ja	NULL
INTERVAL_FIELD	varchar(18)	Ja	NULL
SQL_MODE	varchar(8192)	Nein
STARTS	datetime	Ja	NULL
ENDS	datetime	Ja	NULL
STATUS	varchar(18)	Nein
ON_COMPLETION	varchar(12)	Nein
CREATED	datetime	Nein	0000-00-00 00:00:00
LAST_ALTERED	datetime	Nein	0000-00-00 00:00:00
LAST_EXECUTED	datetime	Ja	NULL
EVENT_COMMENT	varchar(64)	Nein
ORIGINATOR	bigint(10)	Nein	0
CHARACTER_SET_CLIENT	varchar(32)	Nein		CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTION	varchar(32)	Nein		COLLATIONS -> COLLATION_NAME
DATABASE_COLLATION	varchar(32)	Nein		COLLATIONS -> COLLATION_NAME

FILES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
FILE_ID	bigint(4)	Nein	0
FILE_NAME	varchar(512)	Ja	NULL
FILE_TYPE	varchar(20)	Nein
TABLESPACE_NAME	varchar(64)	Ja	NULL	TABLESPACES -> TABLESPACE_NAME
TABLE_CATALOG	varchar(64)	Nein
TABLE_SCHEMA	varchar(64)	Ja	NULL	SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Ja	NULL
LOGFILE_GROUP_NAME	varchar(64)	Ja	NULL
LOGFILE_GROUP_NUMBER	bigint(4)	Ja	NULL
ENGINE	varchar(64)	Nein		ENGINES -> ENGINE
FULLTEXT_KEYS	varchar(64)	Ja	NULL
DELETED_ROWS	bigint(4)	Ja	NULL
UPDATE_COUNT	bigint(4)	Ja	NULL
FREE_EXTENTS	bigint(4)	Ja	NULL
TOTAL_EXTENTS	bigint(4)	Ja	NULL
EXTENT_SIZE	bigint(4)	Nein	0
INITIAL_SIZE	bigint(21)	Ja	NULL
MAXIMUM_SIZE	bigint(21)	Ja	NULL
AUTOEXTEND_SIZE	bigint(21)	Ja	NULL
CREATION_TIME	datetime	Ja	NULL
LAST_UPDATE_TIME	datetime	Ja	NULL
LAST_ACCESS_TIME	datetime	Ja	NULL
RECOVER_TIME	bigint(4)	Ja	NULL
TRANSACTION_COUNTER	bigint(4)	Ja	NULL
VERSION	bigint(21)	Ja	NULL
ROW_FORMAT	varchar(10)	Ja	NULL
TABLE_ROWS	bigint(21)	Ja	NULL
AVG_ROW_LENGTH	bigint(21)	Ja	NULL
DATA_LENGTH	bigint(21)	Ja	NULL
MAX_DATA_LENGTH	bigint(21)	Ja	NULL
INDEX_LENGTH	bigint(21)	Ja	NULL
DATA_FREE	bigint(21)	Ja	NULL
CREATE_TIME	datetime	Ja	NULL
UPDATE_TIME	datetime	Ja	NULL
CHECK_TIME	datetime	Ja	NULL
CHECKSUM	bigint(21)	Ja	NULL
STATUS	varchar(20)	Nein
EXTRA	varchar(255)	Ja	NULL

GEOMETRY_COLUMNS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
F_TABLE_CATALOG	varchar(512)	Nein
F_TABLE_SCHEMA	varchar(64)	Nein
F_TABLE_NAME	varchar(64)	Nein
F_GEOMETRY_COLUMN	varchar(64)	Nein
G_TABLE_CATALOG	varchar(512)	Nein
G_TABLE_SCHEMA	varchar(64)	Nein
G_TABLE_NAME	varchar(64)	Nein
G_GEOMETRY_COLUMN	varchar(64)	Nein
STORAGE_TYPE	tinyint(2)	Nein	0
GEOMETRY_TYPE	int(7)	Nein	0
COORD_DIMENSION	tinyint(2)	Nein	0
MAX_PPR	tinyint(2)	Nein	0
SRID	smallint(5)	Nein	0

GLOBAL_STATUS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
VARIABLE_NAME	varchar(64)	Nein
VARIABLE_VALUE	varchar(2048)	Nein

GLOBAL_VARIABLES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
VARIABLE_NAME	varchar(64)	Nein
VARIABLE_VALUE	varchar(2048)	Nein

INDEX_STATISTICS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_SCHEMA	varchar(192)	Nein
TABLE_NAME	varchar(192)	Nein
INDEX_NAME	varchar(192)	Nein
ROWS_READ	bigint(21)	Nein	0

INNODB_BUFFER_PAGE

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
POOL_ID	bigint(21)	Nein	0
BLOCK_ID	bigint(21)	Nein	0
SPACE	bigint(21)	Nein	0
PAGE_NUMBER	bigint(21)	Nein	0
PAGE_TYPE	varchar(64)	Ja	NULL
FLUSH_TYPE	bigint(21)	Nein	0
FIX_COUNT	bigint(21)	Nein	0
IS_HASHED	varchar(3)	Ja	NULL
NEWEST_MODIFICATION	bigint(21)	Nein	0
OLDEST_MODIFICATION	bigint(21)	Nein	0
ACCESS_TIME	bigint(21)	Nein	0
TABLE_NAME	varchar(1024)	Ja	NULL
INDEX_NAME	varchar(1024)	Ja	NULL
NUMBER_RECORDS	bigint(21)	Nein	0
DATA_SIZE	bigint(21)	Nein	0
COMPRESSED_SIZE	bigint(21)	Nein	0
PAGE_STATE	varchar(64)	Ja	NULL
IO_FIX	varchar(64)	Ja	NULL
IS_OLD	varchar(3)	Ja	NULL
FREE_PAGE_CLOCK	bigint(21)	Nein	0

INNODB_BUFFER_PAGE_LRU

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
POOL_ID	bigint(21)	Nein	0
LRU_POSITION	bigint(21)	Nein	0
SPACE	bigint(21)	Nein	0
PAGE_NUMBER	bigint(21)	Nein	0
PAGE_TYPE	varchar(64)	Ja	NULL
FLUSH_TYPE	bigint(21)	Nein	0
FIX_COUNT	bigint(21)	Nein	0
IS_HASHED	varchar(3)	Ja	NULL
NEWEST_MODIFICATION	bigint(21)	Nein	0
OLDEST_MODIFICATION	bigint(21)	Nein	0
ACCESS_TIME	bigint(21)	Nein	0
TABLE_NAME	varchar(1024)	Ja	NULL
INDEX_NAME	varchar(1024)	Ja	NULL
NUMBER_RECORDS	bigint(21)	Nein	0
DATA_SIZE	bigint(21)	Nein	0
COMPRESSED_SIZE	bigint(21)	Nein	0
COMPRESSED	varchar(3)	Ja	NULL
IO_FIX	varchar(64)	Ja	NULL
IS_OLD	varchar(3)	Ja	NULL
FREE_PAGE_CLOCK	bigint(21)	Nein	0

INNODB_BUFFER_POOL_STATS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
POOL_ID	bigint(21)	Nein	0
POOL_SIZE	bigint(21)	Nein	0
FREE_BUFFERS	bigint(21)	Nein	0
DATABASE_PAGES	bigint(21)	Nein	0
OLD_DATABASE_PAGES	bigint(21)	Nein	0
MODIFIED_DATABASE_PAGES	bigint(21)	Nein	0
PENDING_DECOMPRESS	bigint(21)	Nein	0
PENDING_READS	bigint(21)	Nein	0
PENDING_FLUSH_LRU	bigint(21)	Nein	0
PENDING_FLUSH_LIST	bigint(21)	Nein	0
PAGES_MADE_YOUNG	bigint(21)	Nein	0
PAGES_NOT_MADE_YOUNG	bigint(21)	Nein	0
PAGES_MADE_YOUNG_RATE	double	Nein	0
PAGES_MADE_NOT_YOUNG_RATE	double	Nein	0
NUMBER_PAGES_READ	bigint(21)	Nein	0
NUMBER_PAGES_CREATED	bigint(21)	Nein	0
NUMBER_PAGES_WRITTEN	bigint(21)	Nein	0
PAGES_READ_RATE	double	Nein	0
PAGES_CREATE_RATE	double	Nein	0
PAGES_WRITTEN_RATE	double	Nein	0
NUMBER_PAGES_GET	bigint(21)	Nein	0
HIT_RATE	bigint(21)	Nein	0
YOUNG_MAKE_PER_THOUSAND_GETS	bigint(21)	Nein	0
NOT_YOUNG_MAKE_PER_THOUSAND_GETS	bigint(21)	Nein	0
NUMBER_PAGES_READ_AHEAD	bigint(21)	Nein	0
NUMBER_READ_AHEAD_EVICTED	bigint(21)	Nein	0
READ_AHEAD_RATE	double	Nein	0
READ_AHEAD_EVICTED_RATE	double	Nein	0
LRU_IO_TOTAL	bigint(21)	Nein	0
LRU_IO_CURRENT	bigint(21)	Nein	0
UNCOMPRESS_TOTAL	bigint(21)	Nein	0
UNCOMPRESS_CURRENT	bigint(21)	Nein	0

INNODB_CMP

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
page_size	int(5)	Nein	0
compress_ops	int(11)	Nein	0
compress_ops_ok	int(11)	Nein	0
compress_time	int(11)	Nein	0
uncompress_ops	int(11)	Nein	0
uncompress_time	int(11)	Nein	0

INNODB_CMPMEM

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
page_size	int(5)	Nein	0
buffer_pool_instance	int(11)	Nein	0
pages_used	int(11)	Nein	0
pages_free	int(11)	Nein	0
relocation_ops	bigint(21)	Nein	0
relocation_time	int(11)	Nein	0

INNODB_CMPMEM_RESET

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
page_size	int(5)	Nein	0
buffer_pool_instance	int(11)	Nein	0
pages_used	int(11)	Nein	0
pages_free	int(11)	Nein	0
relocation_ops	bigint(21)	Nein	0
relocation_time	int(11)	Nein	0

INNODB_CMP_PER_INDEX

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
database_name	varchar(192)	Nein
table_name	varchar(192)	Nein
index_name	varchar(192)	Nein
compress_ops	int(11)	Nein	0
compress_ops_ok	int(11)	Nein	0
compress_time	int(11)	Nein	0
uncompress_ops	int(11)	Nein	0
uncompress_time	int(11)	Nein	0

INNODB_CMP_PER_INDEX_RESET

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
database_name	varchar(192)	Nein
table_name	varchar(192)	Nein
index_name	varchar(192)	Nein
compress_ops	int(11)	Nein	0
compress_ops_ok	int(11)	Nein	0
compress_time	int(11)	Nein	0
uncompress_ops	int(11)	Nein	0
uncompress_time	int(11)	Nein	0

INNODB_CMP_RESET

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
page_size	int(5)	Nein	0
compress_ops	int(11)	Nein	0
compress_ops_ok	int(11)	Nein	0
compress_time	int(11)	Nein	0
uncompress_ops	int(11)	Nein	0
uncompress_time	int(11)	Nein	0

INNODB_FT_BEING_DELETED

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
DOC_ID	bigint(21)	Nein	0

INNODB_FT_CONFIG

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
KEY	varchar(193)	Nein
VALUE	varchar(193)	Nein

INNODB_FT_DEFAULT_STOPWORD

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
value	varchar(18)	Nein

INNODB_FT_DELETED

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
DOC_ID	bigint(21)	Nein	0

INNODB_FT_INDEX_CACHE

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
WORD	varchar(337)	Nein
FIRST_DOC_ID	bigint(21)	Nein	0
LAST_DOC_ID	bigint(21)	Nein	0
DOC_COUNT	bigint(21)	Nein	0
DOC_ID	bigint(21)	Nein	0
POSITION	bigint(21)	Nein	0

INNODB_FT_INDEX_TABLE

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
WORD	varchar(337)	Nein
FIRST_DOC_ID	bigint(21)	Nein	0
LAST_DOC_ID	bigint(21)	Nein	0
DOC_COUNT	bigint(21)	Nein	0
DOC_ID	bigint(21)	Nein	0
POSITION	bigint(21)	Nein	0

INNODB_LOCKS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
lock_id	varchar(81)	Nein
lock_trx_id	varchar(18)	Nein
lock_mode	varchar(32)	Nein
lock_type	varchar(32)	Nein
lock_table	varchar(1024)	Nein
lock_index	varchar(1024)	Ja	NULL
lock_space	bigint(21)	Ja	NULL
lock_page	bigint(21)	Ja	NULL
lock_rec	bigint(21)	Ja	NULL
lock_data	varchar(8192)	Ja	NULL

INNODB_LOCK_WAITS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
requesting_trx_id	varchar(18)	Nein
requested_lock_id	varchar(81)	Nein
blocking_trx_id	varchar(18)	Nein
blocking_lock_id	varchar(81)	Nein

INNODB_METRICS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
NAME	varchar(193)	Nein
SUBSYSTEM	varchar(193)	Nein
COUNT	bigint(21)	Nein	0
MAX_COUNT	bigint(21)	Ja	NULL
MIN_COUNT	bigint(21)	Ja	NULL
AVG_COUNT	double	Ja	NULL
COUNT_RESET	bigint(21)	Nein	0
MAX_COUNT_RESET	bigint(21)	Ja	NULL
MIN_COUNT_RESET	bigint(21)	Ja	NULL
AVG_COUNT_RESET	double	Ja	NULL
TIME_ENABLED	datetime	Ja	NULL
TIME_DISABLED	datetime	Ja	NULL
TIME_ELAPSED	bigint(21)	Ja	NULL
TIME_RESET	datetime	Ja	NULL
STATUS	varchar(193)	Nein
TYPE	varchar(193)	Nein
COMMENT	varchar(193)	Nein

INNODB_MUTEXES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
NAME	varchar(4000)	Nein
CREATE_FILE	varchar(4000)	Nein
CREATE_LINE	int(11)	Nein	0
OS_WAITS	bigint(21)	Nein	0

INNODB_SYS_COLUMNS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_ID	bigint(21)	Nein	0
NAME	varchar(193)	Nein
POS	bigint(21)	Nein	0
MTYPE	int(11)	Nein	0
PRTYPE	int(11)	Nein	0
LEN	int(11)	Nein	0

INNODB_SYS_DATAFILES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
SPACE	int(11)	Nein	0
PATH	varchar(4000)	Nein

INNODB_SYS_FIELDS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
INDEX_ID	bigint(21)	Nein	0
NAME	varchar(193)	Nein
POS	int(11)	Nein	0

INNODB_SYS_FOREIGN

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
ID	varchar(193)	Nein
FOR_NAME	varchar(193)	Nein
REF_NAME	varchar(193)	Nein
N_COLS	int(11)	Nein	0
TYPE	int(11)	Nein	0

INNODB_SYS_FOREIGN_COLS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
ID	varchar(193)	Nein
FOR_COL_NAME	varchar(193)	Nein
REF_COL_NAME	varchar(193)	Nein
POS	int(11)	Nein	0

INNODB_SYS_INDEXES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
INDEX_ID	bigint(21)	Nein	0
NAME	varchar(193)	Nein
TABLE_ID	bigint(21)	Nein	0
TYPE	int(11)	Nein	0
N_FIELDS	int(11)	Nein	0
PAGE_NO	int(11)	Nein	0
SPACE	int(11)	Nein	0
MERGE_THRESHOLD	int(11)	Nein	0

INNODB_SYS_SEMAPHORE_WAITS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
THREAD_ID	bigint(21)	Nein	0
OBJECT_NAME	varchar(4000)	Ja	NULL
FILE	varchar(4000)	Ja	NULL
LINE	int(11)	Nein	0
WAIT_TIME	bigint(21)	Nein	0
WAIT_OBJECT	bigint(21)	Nein	0
WAIT_TYPE	varchar(16)	Ja	NULL
HOLDER_THREAD_ID	bigint(21)	Nein	0
HOLDER_FILE	varchar(4000)	Ja	NULL
HOLDER_LINE	int(11)	Nein	0
CREATED_FILE	varchar(4000)	Ja	NULL
CREATED_LINE	int(11)	Nein	0
WRITER_THREAD	bigint(21)	Nein	0
RESERVATION_MODE	varchar(16)	Ja	NULL
READERS	int(11)	Nein	0
WAITERS_FLAG	bigint(21)	Nein	0
LOCK_WORD	bigint(21)	Nein	0
LAST_WRITER_FILE	varchar(4000)	Ja	NULL
LAST_WRITER_LINE	int(11)	Nein	0
OS_WAIT_COUNT	int(11)	Nein	0

INNODB_SYS_TABLES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_ID	bigint(21)	Nein	0
NAME	varchar(655)	Nein
FLAG	int(11)	Nein	0
N_COLS	int(11)	Nein	0
SPACE	int(11)	Nein	0
ROW_FORMAT	varchar(12)	Ja	NULL
ZIP_PAGE_SIZE	int(11)	Nein	0
SPACE_TYPE	varchar(10)	Ja	NULL

INNODB_SYS_TABLESPACES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
SPACE	int(11)	Nein	0
NAME	varchar(655)	Nein
FLAG	int(11)	Nein	0
ROW_FORMAT	varchar(22)	Ja	NULL
PAGE_SIZE	int(11)	Nein	0
ZIP_PAGE_SIZE	int(11)	Nein	0
SPACE_TYPE	varchar(10)	Ja	NULL
FS_BLOCK_SIZE	int(11)	Nein	0
FILE_SIZE	bigint(21)	Nein	0
ALLOCATED_SIZE	bigint(21)	Nein	0

INNODB_SYS_TABLESTATS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_ID	bigint(21)	Nein	0
NAME	varchar(193)	Nein
STATS_INITIALIZED	varchar(193)	Nein
NUM_ROWS	bigint(21)	Nein	0
CLUST_INDEX_SIZE	bigint(21)	Nein	0
OTHER_INDEX_SIZE	bigint(21)	Nein	0
MODIFIED_COUNTER	bigint(21)	Nein	0
AUTOINC	bigint(21)	Nein	0
REF_COUNT	int(11)	Nein	0

INNODB_SYS_VIRTUAL

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_ID	bigint(21)	Nein	0
POS	int(11)	Nein	0
BASE_POS	int(11)	Nein	0

INNODB_TABLESPACES_ENCRYPTION

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
SPACE	int(11)	Nein	0
NAME	varchar(655)	Ja	NULL
ENCRYPTION_SCHEME	int(11)	Nein	0
KEYSERVER_REQUESTS	int(11)	Nein	0
MIN_KEY_VERSION	int(11)	Nein	0
CURRENT_KEY_VERSION	int(11)	Nein	0
KEY_ROTATION_PAGE_NUMBER	bigint(21)	Ja	NULL
KEY_ROTATION_MAX_PAGE_NUMBER	bigint(21)	Ja	NULL
CURRENT_KEY_ID	int(11)	Nein	0
ROTATING_OR_FLUSHING	int(1)	Nein	0

INNODB_TABLESPACES_SCRUBBING

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
SPACE	bigint(21)	Nein	0
NAME	varchar(655)	Ja	NULL
COMPRESSED	int(1)	Nein	0
LAST_SCRUB_COMPLETED	datetime	Ja	NULL
CURRENT_SCRUB_STARTED	datetime	Ja	NULL
CURRENT_SCRUB_ACTIVE_THREADS	int(11)	Ja	NULL
CURRENT_SCRUB_PAGE_NUMBER	bigint(21)	Nein	0
CURRENT_SCRUB_MAX_PAGE_NUMBER	bigint(21)	Nein	0
ON_SSD	int(1)	Nein	0

INNODB_TRX

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
trx_id	varchar(18)	Nein
trx_state	varchar(13)	Nein
trx_started	datetime	Nein	0000-00-00 00:00:00
trx_requested_lock_id	varchar(81)	Ja	NULL
trx_wait_started	datetime	Ja	NULL
trx_weight	bigint(21)	Nein	0
trx_mysql_thread_id	bigint(21)	Nein	0
trx_query	varchar(1024)	Ja	NULL
trx_operation_state	varchar(64)	Ja	NULL
trx_tables_in_use	bigint(21)	Nein	0
trx_tables_locked	bigint(21)	Nein	0
trx_lock_structs	bigint(21)	Nein	0
trx_lock_memory_bytes	bigint(21)	Nein	0
trx_rows_locked	bigint(21)	Nein	0
trx_rows_modified	bigint(21)	Nein	0
trx_concurrency_tickets	bigint(21)	Nein	0
trx_isolation_level	varchar(16)	Nein
trx_unique_checks	int(1)	Nein	0
trx_foreign_key_checks	int(1)	Nein	0
trx_last_foreign_key_error	varchar(256)	Ja	NULL
trx_is_read_only	int(1)	Nein	0
trx_autocommit_non_locking	int(1)	Nein	0

KEY_CACHES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
KEY_CACHE_NAME	varchar(192)	Nein
SEGMENTS	int(3)	Ja	NULL
SEGMENT_NUMBER	int(3)	Ja	NULL
FULL_SIZE	bigint(21)	Nein	0
BLOCK_SIZE	bigint(21)	Nein	0
USED_BLOCKS	bigint(21)	Nein	0
UNUSED_BLOCKS	bigint(21)	Nein	0
DIRTY_BLOCKS	bigint(21)	Nein	0
READ_REQUESTS	bigint(21)	Nein	0
READS	bigint(21)	Nein	0
WRITE_REQUESTS	bigint(21)	Nein	0
WRITES	bigint(21)	Nein	0

KEY_COLUMN_USAGE

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
CONSTRAINT_CATALOG	varchar(512)	Nein
CONSTRAINT_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAME	varchar(64)	Nein
TABLE_CATALOG	varchar(512)	Nein
TABLE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Nein
COLUMN_NAME	varchar(64)	Nein
ORDINAL_POSITION	bigint(10)	Nein	0
POSITION_IN_UNIQUE_CONSTRAINT	bigint(10)	Ja	NULL
REFERENCED_TABLE_SCHEMA	varchar(64)	Ja	NULL	SCHEMATA -> SCHEMA_NAME
REFERENCED_TABLE_NAME	varchar(64)	Ja	NULL
REFERENCED_COLUMN_NAME	varchar(64)	Ja	NULL

OPTIMIZER_TRACE

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
QUERY	longtext	Nein
TRACE	longtext	Nein
MISSING_BYTES_BEYOND_MAX_MEM_SIZE	int(20)	Nein	0
INSUFFICIENT_PRIVILEGES	tinyint(1)	Nein	0

PARAMETERS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
SPECIFIC_CATALOG	varchar(512)	Nein
SPECIFIC_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
SPECIFIC_NAME	varchar(64)	Nein
ORDINAL_POSITION	int(21)	Nein	0
PARAMETER_MODE	varchar(5)	Ja	NULL
PARAMETER_NAME	varchar(64)	Ja	NULL
DATA_TYPE	varchar(64)	Nein
CHARACTER_MAXIMUM_LENGTH	int(21)	Ja	NULL
CHARACTER_OCTET_LENGTH	int(21)	Ja	NULL
NUMERIC_PRECISION	int(21)	Ja	NULL
NUMERIC_SCALE	int(21)	Ja	NULL
DATETIME_PRECISION	bigint(21)	Ja	NULL
CHARACTER_SET_NAME	varchar(64)	Ja	NULL	CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAME	varchar(64)	Ja	NULL	COLLATIONS -> COLLATION_NAME
DTD_IDENTIFIER	longtext	Nein
ROUTINE_TYPE	varchar(9)	Nein

PARTITIONS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_CATALOG	varchar(512)	Nein
TABLE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Nein
PARTITION_NAME	varchar(64)	Ja	NULL
SUBPARTITION_NAME	varchar(64)	Ja	NULL
PARTITION_ORDINAL_POSITION	bigint(21)	Ja	NULL
SUBPARTITION_ORDINAL_POSITION	bigint(21)	Ja	NULL
PARTITION_METHOD	varchar(18)	Ja	NULL
SUBPARTITION_METHOD	varchar(12)	Ja	NULL
PARTITION_EXPRESSION	longtext	Ja	NULL
SUBPARTITION_EXPRESSION	longtext	Ja	NULL
PARTITION_DESCRIPTION	longtext	Ja	NULL
TABLE_ROWS	bigint(21)	Nein	0
AVG_ROW_LENGTH	bigint(21)	Nein	0
DATA_LENGTH	bigint(21)	Nein	0
MAX_DATA_LENGTH	bigint(21)	Ja	NULL
INDEX_LENGTH	bigint(21)	Nein	0
DATA_FREE	bigint(21)	Nein	0
CREATE_TIME	datetime	Ja	NULL
UPDATE_TIME	datetime	Ja	NULL
CHECK_TIME	datetime	Ja	NULL
CHECKSUM	bigint(21)	Ja	NULL
PARTITION_COMMENT	varchar(80)	Nein
NODEGROUP	varchar(12)	Nein
TABLESPACE_NAME	varchar(64)	Ja	NULL	TABLESPACES -> TABLESPACE_NAME

PLUGINS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
PLUGIN_NAME	varchar(64)	Nein
PLUGIN_VERSION	varchar(20)	Nein
PLUGIN_STATUS	varchar(16)	Nein
PLUGIN_TYPE	varchar(80)	Nein
PLUGIN_TYPE_VERSION	varchar(20)	Nein
PLUGIN_LIBRARY	varchar(64)	Ja	NULL
PLUGIN_LIBRARY_VERSION	varchar(20)	Ja	NULL
PLUGIN_AUTHOR	varchar(64)	Ja	NULL
PLUGIN_DESCRIPTION	longtext	Ja	NULL
PLUGIN_LICENSE	varchar(80)	Nein
LOAD_OPTION	varchar(64)	Nein
PLUGIN_MATURITY	varchar(12)	Nein
PLUGIN_AUTH_VERSION	varchar(80)	Ja	NULL

PROCESSLIST

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
ID	bigint(4)	Nein	0
USER	varchar(128)	Nein
HOST	varchar(64)	Nein
DB	varchar(64)	Ja	NULL	SCHEMATA -> SCHEMA_NAME
COMMAND	varchar(16)	Nein
TIME	int(7)	Nein	0
STATE	varchar(64)	Ja	NULL
INFO	longtext	Ja	NULL
TIME_MS	decimal(22,3)	Nein	0.000
STAGE	tinyint(2)	Nein	0
MAX_STAGE	tinyint(2)	Nein	0
PROGRESS	decimal(7,3)	Nein	0.000
MEMORY_USED	bigint(7)	Nein	0
MAX_MEMORY_USED	bigint(7)	Nein	0
EXAMINED_ROWS	int(7)	Nein	0
QUERY_ID	bigint(4)	Nein	0
INFO_BINARY	blob	Ja	NULL
TID	bigint(4)	Nein	0

PROFILING

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
QUERY_ID	int(20)	Nein	0
SEQ	int(20)	Nein	0
STATE	varchar(30)	Nein
DURATION	decimal(9,6)	Nein	0.000000
CPU_USER	decimal(9,6)	Ja	NULL
CPU_SYSTEM	decimal(9,6)	Ja	NULL
CONTEXT_VOLUNTARY	int(20)	Ja	NULL
CONTEXT_INVOLUNTARY	int(20)	Ja	NULL
BLOCK_OPS_IN	int(20)	Ja	NULL
BLOCK_OPS_OUT	int(20)	Ja	NULL
MESSAGES_SENT	int(20)	Ja	NULL
MESSAGES_RECEIVED	int(20)	Ja	NULL
PAGE_FAULTS_MAJOR	int(20)	Ja	NULL
PAGE_FAULTS_MINOR	int(20)	Ja	NULL
SWAPS	int(20)	Ja	NULL
SOURCE_FUNCTION	varchar(30)	Ja	NULL
SOURCE_FILE	varchar(20)	Ja	NULL
SOURCE_LINE	int(20)	Ja	NULL

REFERENTIAL_CONSTRAINTS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
CONSTRAINT_CATALOG	varchar(512)	Nein
CONSTRAINT_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAME	varchar(64)	Nein
UNIQUE_CONSTRAINT_CATALOG	varchar(512)	Nein
UNIQUE_CONSTRAINT_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
UNIQUE_CONSTRAINT_NAME	varchar(64)	Ja	NULL
MATCH_OPTION	varchar(64)	Nein
UPDATE_RULE	varchar(64)	Nein
DELETE_RULE	varchar(64)	Nein
TABLE_NAME	varchar(64)	Nein
REFERENCED_TABLE_NAME	varchar(64)	Nein

ROUTINES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
SPECIFIC_NAME	varchar(64)	Nein
ROUTINE_CATALOG	varchar(512)	Nein
ROUTINE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
ROUTINE_NAME	varchar(64)	Nein
ROUTINE_TYPE	varchar(13)	Nein
DATA_TYPE	varchar(64)	Nein
CHARACTER_MAXIMUM_LENGTH	int(21)	Ja	NULL
CHARACTER_OCTET_LENGTH	int(21)	Ja	NULL
NUMERIC_PRECISION	int(21)	Ja	NULL
NUMERIC_SCALE	int(21)	Ja	NULL
DATETIME_PRECISION	bigint(21)	Ja	NULL
CHARACTER_SET_NAME	varchar(64)	Ja	NULL	CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAME	varchar(64)	Ja	NULL	COLLATIONS -> COLLATION_NAME
DTD_IDENTIFIER	longtext	Ja	NULL
ROUTINE_BODY	varchar(8)	Nein
ROUTINE_DEFINITION	longtext	Ja	NULL
EXTERNAL_NAME	varchar(64)	Ja	NULL
EXTERNAL_LANGUAGE	varchar(64)	Ja	NULL
PARAMETER_STYLE	varchar(8)	Nein
IS_DETERMINISTIC	varchar(3)	Nein
SQL_DATA_ACCESS	varchar(64)	Nein
SQL_PATH	varchar(64)	Ja	NULL
SECURITY_TYPE	varchar(7)	Nein
CREATED	datetime	Nein	0000-00-00 00:00:00
LAST_ALTERED	datetime	Nein	0000-00-00 00:00:00
SQL_MODE	varchar(8192)	Nein
ROUTINE_COMMENT	longtext	Nein
DEFINER	varchar(189)	Nein
CHARACTER_SET_CLIENT	varchar(32)	Nein		CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTION	varchar(32)	Nein		COLLATIONS -> COLLATION_NAME
DATABASE_COLLATION	varchar(32)	Nein		COLLATIONS -> COLLATION_NAME

SCHEMATA

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
CATALOG_NAME	varchar(512)	Nein
SCHEMA_NAME	varchar(64)	Nein
DEFAULT_CHARACTER_SET_NAME	varchar(32)	Nein		CHARACTER_SETS -> CHARACTER_SET_NAME
DEFAULT_COLLATION_NAME	varchar(32)	Nein		COLLATIONS -> COLLATION_NAME
SQL_PATH	varchar(512)	Ja	NULL

SCHEMA_PRIVILEGES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
GRANTEE	varchar(190)	Nein
TABLE_CATALOG	varchar(512)	Nein
TABLE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
PRIVILEGE_TYPE	varchar(64)	Nein
IS_GRANTABLE	varchar(3)	Nein

SESSION_STATUS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
VARIABLE_NAME	varchar(64)	Nein
VARIABLE_VALUE	varchar(2048)	Nein

SESSION_VARIABLES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
VARIABLE_NAME	varchar(64)	Nein
VARIABLE_VALUE	varchar(2048)	Nein

SPATIAL_REF_SYS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
SRID	smallint(5)	Nein	0
AUTH_NAME	varchar(512)	Nein
AUTH_SRID	int(5)	Nein	0
SRTEXT	varchar(2048)	Nein

STATISTICS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_CATALOG	varchar(512)	Nein
TABLE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Nein
NON_UNIQUE	bigint(1)	Nein	0
INDEX_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
INDEX_NAME	varchar(64)	Nein
SEQ_IN_INDEX	bigint(2)	Nein	0
COLUMN_NAME	varchar(64)	Nein
COLLATION	varchar(1)	Ja	NULL
CARDINALITY	bigint(21)	Ja	NULL
SUB_PART	bigint(3)	Ja	NULL
PACKED	varchar(10)	Ja	NULL
NULLABLE	varchar(3)	Nein
INDEX_TYPE	varchar(16)	Nein
COMMENT	varchar(16)	Ja	NULL
INDEX_COMMENT	varchar(1024)	Nein

SYSTEM_VARIABLES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
VARIABLE_NAME	varchar(64)	Nein
SESSION_VALUE	varchar(2048)	Ja	NULL
GLOBAL_VALUE	varchar(2048)	Ja	NULL
GLOBAL_VALUE_ORIGIN	varchar(64)	Nein
DEFAULT_VALUE	varchar(2048)	Ja	NULL
VARIABLE_SCOPE	varchar(64)	Nein
VARIABLE_TYPE	varchar(64)	Nein
VARIABLE_COMMENT	varchar(2048)	Nein
NUMERIC_MIN_VALUE	varchar(21)	Ja	NULL
NUMERIC_MAX_VALUE	varchar(21)	Ja	NULL
NUMERIC_BLOCK_SIZE	varchar(21)	Ja	NULL
ENUM_VALUE_LIST	longtext	Ja	NULL
READ_ONLY	varchar(3)	Nein
COMMAND_LINE_ARGUMENT	varchar(64)	Ja	NULL

TABLES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_CATALOG	varchar(512)	Nein
TABLE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Nein
TABLE_TYPE	varchar(64)	Nein
ENGINE	varchar(64)	Ja	NULL	ENGINES -> ENGINE
VERSION	bigint(21)	Ja	NULL
ROW_FORMAT	varchar(10)	Ja	NULL
TABLE_ROWS	bigint(21)	Ja	NULL
AVG_ROW_LENGTH	bigint(21)	Ja	NULL
DATA_LENGTH	bigint(21)	Ja	NULL
MAX_DATA_LENGTH	bigint(21)	Ja	NULL
INDEX_LENGTH	bigint(21)	Ja	NULL
DATA_FREE	bigint(21)	Ja	NULL
AUTO_INCREMENT	bigint(21)	Ja	NULL
CREATE_TIME	datetime	Ja	NULL
UPDATE_TIME	datetime	Ja	NULL
CHECK_TIME	datetime	Ja	NULL
TABLE_COLLATION	varchar(32)	Ja	NULL	COLLATIONS -> COLLATION_NAME
CHECKSUM	bigint(21)	Ja	NULL
CREATE_OPTIONS	varchar(2048)	Ja	NULL
TABLE_COMMENT	varchar(2048)	Nein
MAX_INDEX_LENGTH	bigint(21)	Ja	NULL
TEMPORARY	varchar(1)	Ja	NULL

TABLESPACES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLESPACE_NAME	varchar(64)	Nein
ENGINE	varchar(64)	Nein
TABLESPACE_TYPE	varchar(64)	Ja	NULL
LOGFILE_GROUP_NAME	varchar(64)	Ja	NULL
EXTENT_SIZE	bigint(21)	Ja	NULL
AUTOEXTEND_SIZE	bigint(21)	Ja	NULL
MAXIMUM_SIZE	bigint(21)	Ja	NULL
NODEGROUP_ID	bigint(21)	Ja	NULL
TABLESPACE_COMMENT	varchar(2048)	Ja	NULL

TABLE_CONSTRAINTS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
CONSTRAINT_CATALOG	varchar(512)	Nein
CONSTRAINT_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAME	varchar(64)	Nein
TABLE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Nein
CONSTRAINT_TYPE	varchar(64)	Nein

TABLE_PRIVILEGES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
GRANTEE	varchar(190)	Nein
TABLE_CATALOG	varchar(512)	Nein
TABLE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Nein
PRIVILEGE_TYPE	varchar(64)	Nein
IS_GRANTABLE	varchar(3)	Nein

TABLE_STATISTICS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_SCHEMA	varchar(192)	Nein
TABLE_NAME	varchar(192)	Nein
ROWS_READ	bigint(21)	Nein	0
ROWS_CHANGED	bigint(21)	Nein	0
ROWS_CHANGED_X_INDEXES	bigint(21)	Nein	0

TRIGGERS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TRIGGER_CATALOG	varchar(512)	Nein
TRIGGER_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
TRIGGER_NAME	varchar(64)	Nein
EVENT_MANIPULATION	varchar(6)	Nein
EVENT_OBJECT_CATALOG	varchar(512)	Nein
EVENT_OBJECT_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
EVENT_OBJECT_TABLE	varchar(64)	Nein
ACTION_ORDER	bigint(4)	Nein	0
ACTION_CONDITION	longtext	Ja	NULL
ACTION_STATEMENT	longtext	Nein
ACTION_ORIENTATION	varchar(9)	Nein
ACTION_TIMING	varchar(6)	Nein
ACTION_REFERENCE_OLD_TABLE	varchar(64)	Ja	NULL
ACTION_REFERENCE_NEW_TABLE	varchar(64)	Ja	NULL
ACTION_REFERENCE_OLD_ROW	varchar(3)	Nein
ACTION_REFERENCE_NEW_ROW	varchar(3)	Nein
CREATED	datetime(2)	Ja	NULL
SQL_MODE	varchar(8192)	Nein
DEFINER	varchar(189)	Nein
CHARACTER_SET_CLIENT	varchar(32)	Nein		CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTION	varchar(32)	Nein		COLLATIONS -> COLLATION_NAME
DATABASE_COLLATION	varchar(32)	Nein		COLLATIONS -> COLLATION_NAME

USER_PRIVILEGES

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
GRANTEE	varchar(190)	Nein
TABLE_CATALOG	varchar(512)	Nein
PRIVILEGE_TYPE	varchar(64)	Nein
IS_GRANTABLE	varchar(3)	Nein

USER_STATISTICS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
USER	varchar(128)	Nein
TOTAL_CONNECTIONS	int(11)	Nein	0
CONCURRENT_CONNECTIONS	int(11)	Nein	0
CONNECTED_TIME	int(11)	Nein	0
BUSY_TIME	double	Nein	0
CPU_TIME	double	Nein	0
BYTES_RECEIVED	bigint(21)	Nein	0
BYTES_SENT	bigint(21)	Nein	0
BINLOG_BYTES_WRITTEN	bigint(21)	Nein	0
ROWS_READ	bigint(21)	Nein	0
ROWS_SENT	bigint(21)	Nein	0
ROWS_DELETED	bigint(21)	Nein	0
ROWS_INSERTED	bigint(21)	Nein	0
ROWS_UPDATED	bigint(21)	Nein	0
SELECT_COMMANDS	bigint(21)	Nein	0
UPDATE_COMMANDS	bigint(21)	Nein	0
OTHER_COMMANDS	bigint(21)	Nein	0
COMMIT_TRANSACTIONS	bigint(21)	Nein	0
ROLLBACK_TRANSACTIONS	bigint(21)	Nein	0
DENIED_CONNECTIONS	bigint(21)	Nein	0
LOST_CONNECTIONS	bigint(21)	Nein	0
ACCESS_DENIED	bigint(21)	Nein	0
EMPTY_QUERIES	bigint(21)	Nein	0
TOTAL_SSL_CONNECTIONS	bigint(21)	Nein	0
MAX_STATEMENT_TIME_EXCEEDED	bigint(21)	Nein	0

user_variables

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
VARIABLE_NAME	varchar(64)	Nein
VARIABLE_VALUE	varchar(2048)	Ja	NULL
VARIABLE_TYPE	varchar(64)	Nein
CHARACTER_SET_NAME	varchar(32)	Ja	NULL

VIEWS

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
TABLE_CATALOG	varchar(512)	Nein
TABLE_SCHEMA	varchar(64)	Nein		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Nein
VIEW_DEFINITION	longtext	Nein
CHECK_OPTION	varchar(8)	Nein
IS_UPDATABLE	varchar(3)	Nein
DEFINER	varchar(189)	Nein
SECURITY_TYPE	varchar(7)	Nein
CHARACTER_SET_CLIENT	varchar(32)	Nein		CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTION	varchar(32)	Nein		COLLATIONS -> COLLATION_NAME
ALGORITHM	varchar(10)	Nein