Contents of COLUMNS table:
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | GENERATION_EXPRESSION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| def | ucsevsix_bdmaster | BRUSHFAME | CELEBRITY | 1 | NO | varchar | 30 | 30 | latin1 | latin1_swedish_ci | varchar(30) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | BRUSHFAME | LOCATION | 2 | NO | varchar | 30 | 30 | latin1 | latin1_swedish_ci | varchar(30) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | BRUSHFAME | NOTES | 3 | NO | varchar | 120 | 120 | latin1 | latin1_swedish_ci | varchar(120) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | BRUSHFAME | DECADE | 4 | NO | int | 10 | 0 | int(4) | select,insert,update,references | ||||||||||
| def | ucsevsix_bdmaster | BRUSHFAME | P_id | 5 | NO | int | 10 | 0 | int(11) | PRI | auto_increment | select,insert,update,references | ||||||||
| def | information_schema | CHARACTER_SETS | CHARACTER_SET_NAME | 1 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | CHARACTER_SETS | DEFAULT_COLLATE_NAME | 2 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | CHARACTER_SETS | DESCRIPTION | 3 | NO | varchar | 60 | 180 | utf8 | utf8_general_ci | varchar(60) | select | ||||||||
| def | information_schema | CHARACTER_SETS | MAXLEN | 4 | 0 | NO | bigint | 19 | 0 | bigint(3) | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | CLIENT | 1 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | CLIENT_STATISTICS | TOTAL_CONNECTIONS | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | CONCURRENT_CONNECTIONS | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | CONNECTED_TIME | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | BUSY_TIME | 5 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | CPU_TIME | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | BYTES_RECEIVED | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | BYTES_SENT | 8 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | BINLOG_BYTES_WRITTEN | 9 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | ROWS_FETCHED | 10 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | ROWS_UPDATED | 11 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | TABLE_ROWS_READ | 12 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | SELECT_COMMANDS | 13 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | UPDATE_COMMANDS | 14 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | OTHER_COMMANDS | 15 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | COMMIT_TRANSACTIONS | 16 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | ROLLBACK_TRANSACTIONS | 17 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | DENIED_CONNECTIONS | 18 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | LOST_CONNECTIONS | 19 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | ACCESS_DENIED | 20 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | EMPTY_QUERIES | 21 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | CLIENT_STATISTICS | TOTAL_SSL_CONNECTIONS | 22 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | COLLATIONS | COLLATION_NAME | 1 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | COLLATIONS | CHARACTER_SET_NAME | 2 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | COLLATIONS | ID | 3 | 0 | NO | bigint | 19 | 0 | bigint(11) | select | |||||||||
| def | information_schema | COLLATIONS | IS_DEFAULT | 4 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | COLLATIONS | IS_COMPILED | 5 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | COLLATIONS | SORTLEN | 6 | 0 | NO | bigint | 19 | 0 | bigint(3) | select | |||||||||
| def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | COLLATION_NAME | 1 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | CHARACTER_SET_NAME | 2 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | COLUMNS | TABLE_CATALOG | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | COLUMNS | TABLE_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | COLUMNS | TABLE_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | COLUMNS | COLUMN_NAME | 4 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | COLUMNS | ORDINAL_POSITION | 5 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | COLUMNS | COLUMN_DEFAULT | 6 | YES | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | COLUMNS | IS_NULLABLE | 7 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | COLUMNS | DATA_TYPE | 8 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | COLUMNS | CHARACTER_MAXIMUM_LENGTH | 9 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | COLUMNS | CHARACTER_OCTET_LENGTH | 10 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | COLUMNS | NUMERIC_PRECISION | 11 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | COLUMNS | NUMERIC_SCALE | 12 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | COLUMNS | DATETIME_PRECISION | 13 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | COLUMNS | CHARACTER_SET_NAME | 14 | YES | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | COLUMNS | COLLATION_NAME | 15 | YES | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | COLUMNS | COLUMN_TYPE | 16 | NO | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | COLUMNS | COLUMN_KEY | 17 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | COLUMNS | EXTRA | 18 | NO | varchar | 30 | 90 | utf8 | utf8_general_ci | varchar(30) | select | ||||||||
| def | information_schema | COLUMNS | PRIVILEGES | 19 | NO | varchar | 80 | 240 | utf8 | utf8_general_ci | varchar(80) | select | ||||||||
| def | information_schema | COLUMNS | COLUMN_COMMENT | 20 | NO | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | COLUMNS | GENERATION_EXPRESSION | 21 | NO | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | COLUMN_PRIVILEGES | GRANTEE | 1 | NO | varchar | 81 | 243 | utf8 | utf8_general_ci | varchar(81) | select | ||||||||
| def | information_schema | COLUMN_PRIVILEGES | TABLE_CATALOG | 2 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | COLUMN_PRIVILEGES | TABLE_SCHEMA | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | COLUMN_PRIVILEGES | TABLE_NAME | 4 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | COLUMN_PRIVILEGES | COLUMN_NAME | 5 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | COLUMN_PRIVILEGES | PRIVILEGE_TYPE | 6 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | COLUMN_PRIVILEGES | IS_GRANTABLE | 7 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | ucsevsix_bdmaster | CONCERTS | PERFORMER | 1 | NO | varchar | 30 | 30 | latin1 | latin1_swedish_ci | varchar(30) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | CONCERTS | SHOW_YR | 2 | NO | int | 10 | 0 | int(4) | select,insert,update,references | ||||||||||
| def | ucsevsix_bdmaster | CONCERTS | LOCATION | 3 | NO | varchar | 30 | 30 | latin1 | latin1_swedish_ci | varchar(30) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | CONCERTS | NOTES | 4 | NO | varchar | 80 | 80 | latin1 | latin1_swedish_ci | varchar(80) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | CONCERTS | P_id | 5 | NO | int | 10 | 0 | int(11) | PRI | auto_increment | select,insert,update,references | ||||||||
| def | information_schema | ENGINES | ENGINE | 1 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ENGINES | SUPPORT | 2 | NO | varchar | 8 | 24 | utf8 | utf8_general_ci | varchar(8) | select | ||||||||
| def | information_schema | ENGINES | COMMENT | 3 | NO | varchar | 80 | 240 | utf8 | utf8_general_ci | varchar(80) | select | ||||||||
| def | information_schema | ENGINES | TRANSACTIONS | 4 | YES | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | ENGINES | XA | 5 | YES | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | ENGINES | SAVEPOINTS | 6 | YES | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | EVENTS | EVENT_CATALOG | 1 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | EVENTS | EVENT_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | EVENTS | EVENT_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | EVENTS | DEFINER | 4 | NO | varchar | 93 | 279 | utf8 | utf8_general_ci | varchar(93) | select | ||||||||
| def | information_schema | EVENTS | TIME_ZONE | 5 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | EVENTS | EVENT_BODY | 6 | NO | varchar | 8 | 24 | utf8 | utf8_general_ci | varchar(8) | select | ||||||||
| def | information_schema | EVENTS | EVENT_DEFINITION | 7 | NO | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | EVENTS | EVENT_TYPE | 8 | NO | varchar | 9 | 27 | utf8 | utf8_general_ci | varchar(9) | select | ||||||||
| def | information_schema | EVENTS | EXECUTE_AT | 9 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | EVENTS | INTERVAL_VALUE | 10 | YES | varchar | 256 | 768 | utf8 | utf8_general_ci | varchar(256) | select | ||||||||
| def | information_schema | EVENTS | INTERVAL_FIELD | 11 | YES | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | EVENTS | SQL_MODE | 12 | NO | varchar | 8192 | 24576 | utf8 | utf8_general_ci | varchar(8192) | select | ||||||||
| def | information_schema | EVENTS | STARTS | 13 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | EVENTS | ENDS | 14 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | EVENTS | STATUS | 15 | NO | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | EVENTS | ON_COMPLETION | 16 | NO | varchar | 12 | 36 | utf8 | utf8_general_ci | varchar(12) | select | ||||||||
| def | information_schema | EVENTS | CREATED | 17 | 0000-00-00 00:00:00 | NO | datetime | 0 | datetime | select | ||||||||||
| def | information_schema | EVENTS | LAST_ALTERED | 18 | 0000-00-00 00:00:00 | NO | datetime | 0 | datetime | select | ||||||||||
| def | information_schema | EVENTS | LAST_EXECUTED | 19 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | EVENTS | EVENT_COMMENT | 20 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | EVENTS | ORIGINATOR | 21 | 0 | NO | bigint | 19 | 0 | bigint(10) | select | |||||||||
| def | information_schema | EVENTS | CHARACTER_SET_CLIENT | 22 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | EVENTS | COLLATION_CONNECTION | 23 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | EVENTS | DATABASE_COLLATION | 24 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | FILES | FILE_ID | 1 | 0 | NO | bigint | 19 | 0 | bigint(4) | select | |||||||||
| def | information_schema | FILES | FILE_NAME | 2 | YES | varchar | 4000 | 12000 | utf8 | utf8_general_ci | varchar(4000) | select | ||||||||
| def | information_schema | FILES | FILE_TYPE | 3 | NO | varchar | 20 | 60 | utf8 | utf8_general_ci | varchar(20) | select | ||||||||
| def | information_schema | FILES | TABLESPACE_NAME | 4 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | FILES | TABLE_CATALOG | 5 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | FILES | TABLE_SCHEMA | 6 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | FILES | TABLE_NAME | 7 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | FILES | LOGFILE_GROUP_NAME | 8 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | FILES | LOGFILE_GROUP_NUMBER | 9 | YES | bigint | 19 | 0 | bigint(4) | select | ||||||||||
| def | information_schema | FILES | ENGINE | 10 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | FILES | FULLTEXT_KEYS | 11 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | FILES | DELETED_ROWS | 12 | YES | bigint | 19 | 0 | bigint(4) | select | ||||||||||
| def | information_schema | FILES | UPDATE_COUNT | 13 | YES | bigint | 19 | 0 | bigint(4) | select | ||||||||||
| def | information_schema | FILES | FREE_EXTENTS | 14 | YES | bigint | 19 | 0 | bigint(4) | select | ||||||||||
| def | information_schema | FILES | TOTAL_EXTENTS | 15 | YES | bigint | 19 | 0 | bigint(4) | select | ||||||||||
| def | information_schema | FILES | EXTENT_SIZE | 16 | 0 | NO | bigint | 19 | 0 | bigint(4) | select | |||||||||
| def | information_schema | FILES | INITIAL_SIZE | 17 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | MAXIMUM_SIZE | 18 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | AUTOEXTEND_SIZE | 19 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | CREATION_TIME | 20 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | FILES | LAST_UPDATE_TIME | 21 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | FILES | LAST_ACCESS_TIME | 22 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | FILES | RECOVER_TIME | 23 | YES | bigint | 19 | 0 | bigint(4) | select | ||||||||||
| def | information_schema | FILES | TRANSACTION_COUNTER | 24 | YES | bigint | 19 | 0 | bigint(4) | select | ||||||||||
| def | information_schema | FILES | VERSION | 25 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | ROW_FORMAT | 26 | YES | varchar | 20 | 60 | utf8 | utf8_general_ci | varchar(20) | select | ||||||||
| def | information_schema | FILES | TABLE_ROWS | 27 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | AVG_ROW_LENGTH | 28 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | DATA_LENGTH | 29 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | MAX_DATA_LENGTH | 30 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | INDEX_LENGTH | 31 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | DATA_FREE | 32 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | CREATE_TIME | 33 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | FILES | UPDATE_TIME | 34 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | FILES | CHECK_TIME | 35 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | FILES | CHECKSUM | 36 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | FILES | STATUS | 37 | NO | varchar | 20 | 60 | utf8 | utf8_general_ci | varchar(20) | select | ||||||||
| def | information_schema | FILES | EXTRA | 38 | YES | varchar | 255 | 765 | utf8 | utf8_general_ci | varchar(255) | select | ||||||||
| def | information_schema | GLOBAL_STATUS | VARIABLE_NAME | 1 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | GLOBAL_STATUS | VARIABLE_VALUE | 2 | YES | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | SESSION_ID | 1 | 0 | NO | bigint | 19 | 0 | bigint(4) | select | |||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | TABLE_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | TABLE_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | ENGINE | 4 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | NAME | 5 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | TABLE_ROWS | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | AVG_ROW_LENGTH | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | DATA_LENGTH | 8 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | INDEX_LENGTH | 9 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | CREATE_TIME | 10 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | GLOBAL_TEMPORARY_TABLES | UPDATE_TIME | 11 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | GLOBAL_VARIABLES | VARIABLE_NAME | 1 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | GLOBAL_VARIABLES | VARIABLE_VALUE | 2 | YES | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | INDEX_STATISTICS | TABLE_SCHEMA | 1 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | INDEX_STATISTICS | TABLE_NAME | 2 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | INDEX_STATISTICS | INDEX_NAME | 3 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | INDEX_STATISTICS | ROWS_READ | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | POOL_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | BLOCK_ID | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | SPACE | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | PAGE_NUMBER | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | PAGE_TYPE | 5 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE | FLUSH_TYPE | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | FIX_COUNT | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | IS_HASHED | 8 | YES | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE | NEWEST_MODIFICATION | 9 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | OLDEST_MODIFICATION | 10 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | ACCESS_TIME | 11 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | TABLE_NAME | 12 | YES | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE | INDEX_NAME | 13 | YES | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE | NUMBER_RECORDS | 14 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | DATA_SIZE | 15 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | COMPRESSED_SIZE | 16 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE | PAGE_STATE | 17 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE | IO_FIX | 18 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE | IS_OLD | 19 | YES | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE | FREE_PAGE_CLOCK | 20 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | POOL_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | LRU_POSITION | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | SPACE | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | PAGE_NUMBER | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | PAGE_TYPE | 5 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | FLUSH_TYPE | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | FIX_COUNT | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | IS_HASHED | 8 | YES | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | NEWEST_MODIFICATION | 9 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | OLDEST_MODIFICATION | 10 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | ACCESS_TIME | 11 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | TABLE_NAME | 12 | YES | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | INDEX_NAME | 13 | YES | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | NUMBER_RECORDS | 14 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | DATA_SIZE | 15 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | COMPRESSED_SIZE | 16 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | COMPRESSED | 17 | YES | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | IO_FIX | 18 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | IS_OLD | 19 | YES | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | INNODB_BUFFER_PAGE_LRU | FREE_PAGE_CLOCK | 20 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | POOL_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | POOL_SIZE | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | FREE_BUFFERS | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | DATABASE_PAGES | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | OLD_DATABASE_PAGES | 5 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | MODIFIED_DATABASE_PAGES | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PENDING_DECOMPRESS | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PENDING_READS | 8 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PENDING_FLUSH_LRU | 9 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PENDING_FLUSH_LIST | 10 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PAGES_MADE_YOUNG | 11 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PAGES_NOT_MADE_YOUNG | 12 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PAGES_MADE_YOUNG_RATE | 13 | 0 | NO | double | 12 | double | select | ||||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PAGES_MADE_NOT_YOUNG_RATE | 14 | 0 | NO | double | 12 | double | select | ||||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | NUMBER_PAGES_READ | 15 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | NUMBER_PAGES_CREATED | 16 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | NUMBER_PAGES_WRITTEN | 17 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PAGES_READ_RATE | 18 | 0 | NO | double | 12 | double | select | ||||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PAGES_CREATE_RATE | 19 | 0 | NO | double | 12 | double | select | ||||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | PAGES_WRITTEN_RATE | 20 | 0 | NO | double | 12 | double | select | ||||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | NUMBER_PAGES_GET | 21 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | HIT_RATE | 22 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | YOUNG_MAKE_PER_THOUSAND_GETS | 23 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | NOT_YOUNG_MAKE_PER_THOUSAND_GETS | 24 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | NUMBER_PAGES_READ_AHEAD | 25 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | NUMBER_READ_AHEAD_EVICTED | 26 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | READ_AHEAD_RATE | 27 | 0 | NO | double | 12 | double | select | ||||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | READ_AHEAD_EVICTED_RATE | 28 | 0 | NO | double | 12 | double | select | ||||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | LRU_IO_TOTAL | 29 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | LRU_IO_CURRENT | 30 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | UNCOMPRESS_TOTAL | 31 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_BUFFER_POOL_STATS | UNCOMPRESS_CURRENT | 32 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_CHANGED_PAGES | space_id | 1 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_CHANGED_PAGES | page_id | 2 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_CHANGED_PAGES | start_lsn | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_CHANGED_PAGES | end_lsn | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_CMP | page_size | 1 | 0 | NO | int | 10 | 0 | int(5) | select | |||||||||
| def | information_schema | INNODB_CMP | compress_ops | 2 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP | compress_ops_ok | 3 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP | compress_time | 4 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP | uncompress_ops | 5 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP | uncompress_time | 6 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMPMEM | page_size | 1 | 0 | NO | int | 10 | 0 | int(5) | select | |||||||||
| def | information_schema | INNODB_CMPMEM | buffer_pool_instance | 2 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMPMEM | pages_used | 3 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMPMEM | pages_free | 4 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMPMEM | relocation_ops | 5 | 0 | NO | bigint | 19 | 0 | bigint(21) | select | |||||||||
| def | information_schema | INNODB_CMPMEM | relocation_time | 6 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMPMEM_RESET | page_size | 1 | 0 | NO | int | 10 | 0 | int(5) | select | |||||||||
| def | information_schema | INNODB_CMPMEM_RESET | buffer_pool_instance | 2 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMPMEM_RESET | pages_used | 3 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMPMEM_RESET | pages_free | 4 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMPMEM_RESET | relocation_ops | 5 | 0 | NO | bigint | 19 | 0 | bigint(21) | select | |||||||||
| def | information_schema | INNODB_CMPMEM_RESET | relocation_time | 6 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_PER_INDEX | database_name | 1 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | INNODB_CMP_PER_INDEX | table_name | 2 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | INNODB_CMP_PER_INDEX | index_name | 3 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | INNODB_CMP_PER_INDEX | compress_ops | 4 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_PER_INDEX | compress_ops_ok | 5 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_PER_INDEX | compress_time | 6 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_PER_INDEX | uncompress_ops | 7 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_PER_INDEX | uncompress_time | 8 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_PER_INDEX_RESET | database_name | 1 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | INNODB_CMP_PER_INDEX_RESET | table_name | 2 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | INNODB_CMP_PER_INDEX_RESET | index_name | 3 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | INNODB_CMP_PER_INDEX_RESET | compress_ops | 4 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_PER_INDEX_RESET | compress_ops_ok | 5 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_PER_INDEX_RESET | compress_time | 6 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_PER_INDEX_RESET | uncompress_ops | 7 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_PER_INDEX_RESET | uncompress_time | 8 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_RESET | page_size | 1 | 0 | NO | int | 10 | 0 | int(5) | select | |||||||||
| def | information_schema | INNODB_CMP_RESET | compress_ops | 2 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_RESET | compress_ops_ok | 3 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_RESET | compress_time | 4 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_RESET | uncompress_ops | 5 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_CMP_RESET | uncompress_time | 6 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_FT_BEING_DELETED | DOC_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_CONFIG | KEY | 1 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_FT_CONFIG | VALUE | 2 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_FT_DEFAULT_STOPWORD | value | 1 | NO | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | INNODB_FT_DELETED | DOC_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_INDEX_CACHE | WORD | 1 | NO | varchar | 337 | 1011 | utf8 | utf8_general_ci | varchar(337) | select | ||||||||
| def | information_schema | INNODB_FT_INDEX_CACHE | FIRST_DOC_ID | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_INDEX_CACHE | LAST_DOC_ID | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_INDEX_CACHE | DOC_COUNT | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_INDEX_CACHE | DOC_ID | 5 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_INDEX_CACHE | POSITION | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_INDEX_TABLE | WORD | 1 | NO | varchar | 337 | 1011 | utf8 | utf8_general_ci | varchar(337) | select | ||||||||
| def | information_schema | INNODB_FT_INDEX_TABLE | FIRST_DOC_ID | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_INDEX_TABLE | LAST_DOC_ID | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_INDEX_TABLE | DOC_COUNT | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_INDEX_TABLE | DOC_ID | 5 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_FT_INDEX_TABLE | POSITION | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_LOCKS | lock_id | 1 | NO | varchar | 81 | 243 | utf8 | utf8_general_ci | varchar(81) | select | ||||||||
| def | information_schema | INNODB_LOCKS | lock_trx_id | 2 | NO | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | INNODB_LOCKS | lock_mode | 3 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | INNODB_LOCKS | lock_type | 4 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | INNODB_LOCKS | lock_table | 5 | NO | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | INNODB_LOCKS | lock_index | 6 | YES | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | INNODB_LOCKS | lock_space | 7 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | INNODB_LOCKS | lock_page | 8 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | INNODB_LOCKS | lock_rec | 9 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | INNODB_LOCKS | lock_data | 10 | YES | varchar | 8192 | 24576 | utf8 | utf8_general_ci | varchar(8192) | select | ||||||||
| def | information_schema | INNODB_LOCK_WAITS | requesting_trx_id | 1 | NO | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | INNODB_LOCK_WAITS | requested_lock_id | 2 | NO | varchar | 81 | 243 | utf8 | utf8_general_ci | varchar(81) | select | ||||||||
| def | information_schema | INNODB_LOCK_WAITS | blocking_trx_id | 3 | NO | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | INNODB_LOCK_WAITS | blocking_lock_id | 4 | NO | varchar | 81 | 243 | utf8 | utf8_general_ci | varchar(81) | select | ||||||||
| def | information_schema | INNODB_METRICS | NAME | 1 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_METRICS | SUBSYSTEM | 2 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_METRICS | COUNT | 3 | 0 | NO | bigint | 19 | 0 | bigint(21) | select | |||||||||
| def | information_schema | INNODB_METRICS | MAX_COUNT | 4 | YES | bigint | 19 | 0 | bigint(21) | select | ||||||||||
| def | information_schema | INNODB_METRICS | MIN_COUNT | 5 | YES | bigint | 19 | 0 | bigint(21) | select | ||||||||||
| def | information_schema | INNODB_METRICS | AVG_COUNT | 6 | YES | double | 12 | double | select | |||||||||||
| def | information_schema | INNODB_METRICS | COUNT_RESET | 7 | 0 | NO | bigint | 19 | 0 | bigint(21) | select | |||||||||
| def | information_schema | INNODB_METRICS | MAX_COUNT_RESET | 8 | YES | bigint | 19 | 0 | bigint(21) | select | ||||||||||
| def | information_schema | INNODB_METRICS | MIN_COUNT_RESET | 9 | YES | bigint | 19 | 0 | bigint(21) | select | ||||||||||
| def | information_schema | INNODB_METRICS | AVG_COUNT_RESET | 10 | YES | double | 12 | double | select | |||||||||||
| def | information_schema | INNODB_METRICS | TIME_ENABLED | 11 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | INNODB_METRICS | TIME_DISABLED | 12 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | INNODB_METRICS | TIME_ELAPSED | 13 | YES | bigint | 19 | 0 | bigint(21) | select | ||||||||||
| def | information_schema | INNODB_METRICS | TIME_RESET | 14 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | INNODB_METRICS | STATUS | 15 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_METRICS | TYPE | 16 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_METRICS | COMMENT | 17 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_COLUMNS | TABLE_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_COLUMNS | NAME | 2 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_COLUMNS | POS | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_COLUMNS | MTYPE | 4 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_COLUMNS | PRTYPE | 5 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_COLUMNS | LEN | 6 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_DATAFILES | SPACE | 1 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_DATAFILES | PATH | 2 | NO | varchar | 4000 | 12000 | utf8 | utf8_general_ci | varchar(4000) | select | ||||||||
| def | information_schema | INNODB_SYS_FIELDS | INDEX_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_FIELDS | NAME | 2 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_FIELDS | POS | 3 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_FOREIGN | ID | 1 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_FOREIGN | FOR_NAME | 2 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_FOREIGN | REF_NAME | 3 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_FOREIGN | N_COLS | 4 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_FOREIGN | TYPE | 5 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_FOREIGN_COLS | ID | 1 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_FOREIGN_COLS | FOR_COL_NAME | 2 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_FOREIGN_COLS | REF_COL_NAME | 3 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_FOREIGN_COLS | POS | 4 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_INDEXES | INDEX_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_INDEXES | NAME | 2 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_INDEXES | TABLE_ID | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_INDEXES | TYPE | 4 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_INDEXES | N_FIELDS | 5 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_INDEXES | PAGE_NO | 6 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_INDEXES | SPACE | 7 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_INDEXES | MERGE_THRESHOLD | 8 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_TABLES | TABLE_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLES | NAME | 2 | NO | varchar | 655 | 1965 | utf8 | utf8_general_ci | varchar(655) | select | ||||||||
| def | information_schema | INNODB_SYS_TABLES | FLAG | 3 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_TABLES | N_COLS | 4 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_TABLES | SPACE | 5 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_TABLES | FILE_FORMAT | 6 | YES | varchar | 10 | 30 | utf8 | utf8_general_ci | varchar(10) | select | ||||||||
| def | information_schema | INNODB_SYS_TABLES | ROW_FORMAT | 7 | YES | varchar | 12 | 36 | utf8 | utf8_general_ci | varchar(12) | select | ||||||||
| def | information_schema | INNODB_SYS_TABLES | ZIP_PAGE_SIZE | 8 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLES | SPACE_TYPE | 9 | YES | varchar | 10 | 30 | utf8 | utf8_general_ci | varchar(10) | select | ||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | SPACE | 1 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | NAME | 2 | NO | varchar | 655 | 1965 | utf8 | utf8_general_ci | varchar(655) | select | ||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | FLAG | 3 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | FILE_FORMAT | 4 | YES | varchar | 10 | 30 | utf8 | utf8_general_ci | varchar(10) | select | ||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | ROW_FORMAT | 5 | YES | varchar | 22 | 66 | utf8 | utf8_general_ci | varchar(22) | select | ||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | PAGE_SIZE | 6 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | ZIP_PAGE_SIZE | 7 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | SPACE_TYPE | 8 | YES | varchar | 10 | 30 | utf8 | utf8_general_ci | varchar(10) | select | ||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | FS_BLOCK_SIZE | 9 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | FILE_SIZE | 10 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESPACES | ALLOCATED_SIZE | 11 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESTATS | TABLE_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESTATS | NAME | 2 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_TABLESTATS | STATS_INITIALIZED | 3 | NO | varchar | 193 | 579 | utf8 | utf8_general_ci | varchar(193) | select | ||||||||
| def | information_schema | INNODB_SYS_TABLESTATS | NUM_ROWS | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESTATS | CLUST_INDEX_SIZE | 5 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESTATS | OTHER_INDEX_SIZE | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESTATS | MODIFIED_COUNTER | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESTATS | AUTOINC | 8 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_TABLESTATS | REF_COUNT | 9 | 0 | NO | int | 10 | 0 | int(11) | select | |||||||||
| def | information_schema | INNODB_SYS_VIRTUAL | TABLE_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_VIRTUAL | POS | 2 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_SYS_VIRTUAL | BASE_POS | 3 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_ENCRYPTION | SPACE | 1 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_ENCRYPTION | NAME | 2 | YES | varchar | 655 | 1965 | utf8 | utf8_general_ci | varchar(655) | select | ||||||||
| def | information_schema | INNODB_TABLESPACES_ENCRYPTION | ENCRYPTION_SCHEME | 3 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_ENCRYPTION | KEYSERVER_REQUESTS | 4 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_ENCRYPTION | MIN_KEY_VERSION | 5 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_ENCRYPTION | CURRENT_KEY_VERSION | 6 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_ENCRYPTION | KEY_ROTATION_PAGE_NUMBER | 7 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | INNODB_TABLESPACES_ENCRYPTION | KEY_ROTATION_MAX_PAGE_NUMBER | 8 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | INNODB_TABLESPACES_ENCRYPTION | CURRENT_KEY_ID | 9 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_ENCRYPTION | ROTATING_OR_FLUSHING | 10 | 0 | NO | int | 10 | 0 | int(1) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_SCRUBBING | SPACE | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_SCRUBBING | NAME | 2 | YES | varchar | 655 | 1965 | utf8 | utf8_general_ci | varchar(655) | select | ||||||||
| def | information_schema | INNODB_TABLESPACES_SCRUBBING | COMPRESSED | 3 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_SCRUBBING | LAST_SCRUB_COMPLETED | 4 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | INNODB_TABLESPACES_SCRUBBING | CURRENT_SCRUB_STARTED | 5 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | INNODB_TABLESPACES_SCRUBBING | CURRENT_SCRUB_ACTIVE_THREADS | 6 | YES | int | 10 | 0 | int(11) unsigned | select | ||||||||||
| def | information_schema | INNODB_TABLESPACES_SCRUBBING | CURRENT_SCRUB_PAGE_NUMBER | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_SCRUBBING | CURRENT_SCRUB_MAX_PAGE_NUMBER | 8 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TABLESPACES_SCRUBBING | ROTATING_OR_FLUSHING | 9 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TEMP_TABLE_INFO | TABLE_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TEMP_TABLE_INFO | NAME | 2 | YES | varchar | 202 | 606 | utf8 | utf8_general_ci | varchar(202) | select | ||||||||
| def | information_schema | INNODB_TEMP_TABLE_INFO | N_COLS | 3 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TEMP_TABLE_INFO | SPACE | 4 | 0 | NO | int | 10 | 0 | int(11) unsigned | select | |||||||||
| def | information_schema | INNODB_TEMP_TABLE_INFO | PER_TABLE_TABLESPACE | 5 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | INNODB_TEMP_TABLE_INFO | IS_COMPRESSED | 6 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | INNODB_TRX | trx_id | 1 | NO | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | INNODB_TRX | trx_state | 2 | NO | varchar | 13 | 39 | utf8 | utf8_general_ci | varchar(13) | select | ||||||||
| def | information_schema | INNODB_TRX | trx_started | 3 | 0000-00-00 00:00:00 | NO | datetime | 0 | datetime | select | ||||||||||
| def | information_schema | INNODB_TRX | trx_requested_lock_id | 4 | YES | varchar | 81 | 243 | utf8 | utf8_general_ci | varchar(81) | select | ||||||||
| def | information_schema | INNODB_TRX | trx_wait_started | 5 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | INNODB_TRX | trx_weight | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TRX | trx_mysql_thread_id | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TRX | trx_query | 8 | YES | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | INNODB_TRX | trx_operation_state | 9 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | INNODB_TRX | trx_tables_in_use | 10 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TRX | trx_tables_locked | 11 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TRX | trx_lock_structs | 12 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TRX | trx_lock_memory_bytes | 13 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TRX | trx_rows_locked | 14 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TRX | trx_rows_modified | 15 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TRX | trx_concurrency_tickets | 16 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TRX | trx_isolation_level | 17 | NO | varchar | 16 | 48 | utf8 | utf8_general_ci | varchar(16) | select | ||||||||
| def | information_schema | INNODB_TRX | trx_unique_checks | 18 | 0 | NO | int | 10 | 0 | int(1) | select | |||||||||
| def | information_schema | INNODB_TRX | trx_foreign_key_checks | 19 | 0 | NO | int | 10 | 0 | int(1) | select | |||||||||
| def | information_schema | INNODB_TRX | trx_last_foreign_key_error | 20 | YES | varchar | 256 | 768 | utf8 | utf8_general_ci | varchar(256) | select | ||||||||
| def | information_schema | INNODB_TRX | trx_adaptive_hash_latched | 21 | 0 | NO | int | 10 | 0 | int(1) | select | |||||||||
| def | information_schema | INNODB_TRX | trx_adaptive_hash_timeout | 22 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | INNODB_TRX | trx_is_read_only | 23 | 0 | NO | int | 10 | 0 | int(1) | select | |||||||||
| def | information_schema | INNODB_TRX | trx_autocommit_non_locking | 24 | 0 | NO | int | 10 | 0 | int(1) | select | |||||||||
| def | ucsevsix_bdmaster | KARAOKE | SONG | 1 | NO | varchar | 40 | 40 | latin1 | latin1_swedish_ci | varchar(40) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | KARAOKE | CODE | 2 | NO | int | 10 | 0 | int(5) | select,insert,update,references | KTV Taipei COde | |||||||||
| def | ucsevsix_bdmaster | KARAOKE | P_id | 3 | NO | int | 10 | 0 | int(11) | PRI | auto_increment | select,insert,update,references | ||||||||
| def | information_schema | KEY_COLUMN_USAGE | CONSTRAINT_CATALOG | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | KEY_COLUMN_USAGE | CONSTRAINT_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | KEY_COLUMN_USAGE | CONSTRAINT_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | KEY_COLUMN_USAGE | TABLE_CATALOG | 4 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | KEY_COLUMN_USAGE | TABLE_SCHEMA | 5 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | KEY_COLUMN_USAGE | TABLE_NAME | 6 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | KEY_COLUMN_USAGE | COLUMN_NAME | 7 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | KEY_COLUMN_USAGE | ORDINAL_POSITION | 8 | 0 | NO | bigint | 19 | 0 | bigint(10) | select | |||||||||
| def | information_schema | KEY_COLUMN_USAGE | POSITION_IN_UNIQUE_CONSTRAINT | 9 | YES | bigint | 19 | 0 | bigint(10) | select | ||||||||||
| def | information_schema | KEY_COLUMN_USAGE | REFERENCED_TABLE_SCHEMA | 10 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | KEY_COLUMN_USAGE | REFERENCED_TABLE_NAME | 11 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | KEY_COLUMN_USAGE | REFERENCED_COLUMN_NAME | 12 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | OPTIMIZER_TRACE | QUERY | 1 | NO | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | OPTIMIZER_TRACE | TRACE | 2 | NO | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | OPTIMIZER_TRACE | MISSING_BYTES_BEYOND_MAX_MEM_SIZE | 3 | 0 | NO | int | 10 | 0 | int(20) | select | |||||||||
| def | information_schema | OPTIMIZER_TRACE | INSUFFICIENT_PRIVILEGES | 4 | 0 | NO | tinyint | 3 | 0 | tinyint(1) | select | |||||||||
| def | information_schema | PARAMETERS | SPECIFIC_CATALOG | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | PARAMETERS | SPECIFIC_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PARAMETERS | SPECIFIC_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PARAMETERS | ORDINAL_POSITION | 4 | 0 | NO | int | 10 | 0 | int(21) | select | |||||||||
| def | information_schema | PARAMETERS | PARAMETER_MODE | 5 | YES | varchar | 5 | 15 | utf8 | utf8_general_ci | varchar(5) | select | ||||||||
| def | information_schema | PARAMETERS | PARAMETER_NAME | 6 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PARAMETERS | DATA_TYPE | 7 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PARAMETERS | CHARACTER_MAXIMUM_LENGTH | 8 | YES | int | 10 | 0 | int(21) | select | ||||||||||
| def | information_schema | PARAMETERS | CHARACTER_OCTET_LENGTH | 9 | YES | int | 10 | 0 | int(21) | select | ||||||||||
| def | information_schema | PARAMETERS | NUMERIC_PRECISION | 10 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | PARAMETERS | NUMERIC_SCALE | 11 | YES | int | 10 | 0 | int(21) | select | ||||||||||
| def | information_schema | PARAMETERS | DATETIME_PRECISION | 12 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | PARAMETERS | CHARACTER_SET_NAME | 13 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PARAMETERS | COLLATION_NAME | 14 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PARAMETERS | DTD_IDENTIFIER | 15 | NO | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | PARAMETERS | ROUTINE_TYPE | 16 | NO | varchar | 9 | 27 | utf8 | utf8_general_ci | varchar(9) | select | ||||||||
| def | information_schema | PARTITIONS | TABLE_CATALOG | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | PARTITIONS | TABLE_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PARTITIONS | TABLE_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PARTITIONS | PARTITION_NAME | 4 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PARTITIONS | SUBPARTITION_NAME | 5 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PARTITIONS | PARTITION_ORDINAL_POSITION | 6 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | PARTITIONS | SUBPARTITION_ORDINAL_POSITION | 7 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | PARTITIONS | PARTITION_METHOD | 8 | YES | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | PARTITIONS | SUBPARTITION_METHOD | 9 | YES | varchar | 12 | 36 | utf8 | utf8_general_ci | varchar(12) | select | ||||||||
| def | information_schema | PARTITIONS | PARTITION_EXPRESSION | 10 | YES | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | PARTITIONS | SUBPARTITION_EXPRESSION | 11 | YES | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | PARTITIONS | PARTITION_DESCRIPTION | 12 | YES | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | PARTITIONS | TABLE_ROWS | 13 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | PARTITIONS | AVG_ROW_LENGTH | 14 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | PARTITIONS | DATA_LENGTH | 15 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | PARTITIONS | MAX_DATA_LENGTH | 16 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | PARTITIONS | INDEX_LENGTH | 17 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | PARTITIONS | DATA_FREE | 18 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | PARTITIONS | CREATE_TIME | 19 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | PARTITIONS | UPDATE_TIME | 20 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | PARTITIONS | CHECK_TIME | 21 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | PARTITIONS | CHECKSUM | 22 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | PARTITIONS | PARTITION_COMMENT | 23 | NO | varchar | 80 | 240 | utf8 | utf8_general_ci | varchar(80) | select | ||||||||
| def | information_schema | PARTITIONS | NODEGROUP | 24 | NO | varchar | 12 | 36 | utf8 | utf8_general_ci | varchar(12) | select | ||||||||
| def | information_schema | PARTITIONS | TABLESPACE_NAME | 25 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | ucsevsix_bdmaster | PHONENUMBERS | FIRSTNAME | 1 | NO | varchar | 20 | 20 | latin1 | latin1_swedish_ci | varchar(20) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | PHONENUMBERS | LASTNAME | 2 | NO | varchar | 20 | 20 | latin1 | latin1_swedish_ci | varchar(20) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | PHONENUMBERS | CELLPHONE1 | 3 | NO | varchar | 20 | 20 | latin1 | latin1_swedish_ci | varchar(20) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | PHONENUMBERS | CELLPHONE2 | 4 | NO | varchar | 20 | 20 | latin1 | latin1_swedish_ci | varchar(20) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | PHONENUMBERS | HOMEPHONE1 | 5 | NO | varchar | 20 | 20 | latin1 | latin1_swedish_ci | varchar(20) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | PHONENUMBERS | HOMEPHONE2 | 6 | NO | varchar | 20 | 20 | latin1 | latin1_swedish_ci | varchar(20) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | PHONENUMBERS | WORKPHONE1 | 7 | NO | varchar | 20 | 20 | latin1 | latin1_swedish_ci | varchar(20) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | PHONENUMBERS | EMAIL1 | 8 | NO | varchar | 36 | 36 | latin1 | latin1_swedish_ci | varchar(36) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | PHONENUMBERS | EMAIL2 | 9 | NO | varchar | 30 | 30 | latin1 | latin1_swedish_ci | varchar(30) | select,insert,update,references | ||||||||
| def | ucsevsix_bdmaster | PHONENUMBERS | P_id | 10 | NO | int | 10 | 0 | int(11) | PRI | auto_increment | select,insert,update,references | ||||||||
| def | information_schema | PLUGINS | PLUGIN_NAME | 1 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PLUGINS | PLUGIN_VERSION | 2 | NO | varchar | 20 | 60 | utf8 | utf8_general_ci | varchar(20) | select | ||||||||
| def | information_schema | PLUGINS | PLUGIN_STATUS | 3 | NO | varchar | 10 | 30 | utf8 | utf8_general_ci | varchar(10) | select | ||||||||
| def | information_schema | PLUGINS | PLUGIN_TYPE | 4 | NO | varchar | 80 | 240 | utf8 | utf8_general_ci | varchar(80) | select | ||||||||
| def | information_schema | PLUGINS | PLUGIN_TYPE_VERSION | 5 | NO | varchar | 20 | 60 | utf8 | utf8_general_ci | varchar(20) | select | ||||||||
| def | information_schema | PLUGINS | PLUGIN_LIBRARY | 6 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PLUGINS | PLUGIN_LIBRARY_VERSION | 7 | YES | varchar | 20 | 60 | utf8 | utf8_general_ci | varchar(20) | select | ||||||||
| def | information_schema | PLUGINS | PLUGIN_AUTHOR | 8 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PLUGINS | PLUGIN_DESCRIPTION | 9 | YES | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | PLUGINS | PLUGIN_LICENSE | 10 | YES | varchar | 80 | 240 | utf8 | utf8_general_ci | varchar(80) | select | ||||||||
| def | information_schema | PLUGINS | LOAD_OPTION | 11 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PROCESSLIST | ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | PROCESSLIST | USER | 2 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | PROCESSLIST | HOST | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PROCESSLIST | DB | 4 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PROCESSLIST | COMMAND | 5 | NO | varchar | 16 | 48 | utf8 | utf8_general_ci | varchar(16) | select | ||||||||
| def | information_schema | PROCESSLIST | TIME | 6 | 0 | NO | int | 10 | 0 | int(7) | select | |||||||||
| def | information_schema | PROCESSLIST | STATE | 7 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | PROCESSLIST | INFO | 8 | YES | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | PROCESSLIST | TIME_MS | 9 | 0 | NO | bigint | 19 | 0 | bigint(21) | select | |||||||||
| def | information_schema | PROCESSLIST | ROWS_SENT | 10 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | PROCESSLIST | ROWS_EXAMINED | 11 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | PROFILING | QUERY_ID | 1 | 0 | NO | int | 10 | 0 | int(20) | select | |||||||||
| def | information_schema | PROFILING | SEQ | 2 | 0 | NO | int | 10 | 0 | int(20) | select | |||||||||
| def | information_schema | PROFILING | STATE | 3 | NO | varchar | 30 | 90 | utf8 | utf8_general_ci | varchar(30) | select | ||||||||
| def | information_schema | PROFILING | DURATION | 4 | 0.000000 | NO | decimal | 9 | 6 | decimal(9,6) | select | |||||||||
| def | information_schema | PROFILING | CPU_USER | 5 | YES | decimal | 9 | 6 | decimal(9,6) | select | ||||||||||
| def | information_schema | PROFILING | CPU_SYSTEM | 6 | YES | decimal | 9 | 6 | decimal(9,6) | select | ||||||||||
| def | information_schema | PROFILING | CONTEXT_VOLUNTARY | 7 | YES | int | 10 | 0 | int(20) | select | ||||||||||
| def | information_schema | PROFILING | CONTEXT_INVOLUNTARY | 8 | YES | int | 10 | 0 | int(20) | select | ||||||||||
| def | information_schema | PROFILING | BLOCK_OPS_IN | 9 | YES | int | 10 | 0 | int(20) | select | ||||||||||
| def | information_schema | PROFILING | BLOCK_OPS_OUT | 10 | YES | int | 10 | 0 | int(20) | select | ||||||||||
| def | information_schema | PROFILING | MESSAGES_SENT | 11 | YES | int | 10 | 0 | int(20) | select | ||||||||||
| def | information_schema | PROFILING | MESSAGES_RECEIVED | 12 | YES | int | 10 | 0 | int(20) | select | ||||||||||
| def | information_schema | PROFILING | PAGE_FAULTS_MAJOR | 13 | YES | int | 10 | 0 | int(20) | select | ||||||||||
| def | information_schema | PROFILING | PAGE_FAULTS_MINOR | 14 | YES | int | 10 | 0 | int(20) | select | ||||||||||
| def | information_schema | PROFILING | SWAPS | 15 | YES | int | 10 | 0 | int(20) | select | ||||||||||
| def | information_schema | PROFILING | SOURCE_FUNCTION | 16 | YES | varchar | 30 | 90 | utf8 | utf8_general_ci | varchar(30) | select | ||||||||
| def | information_schema | PROFILING | SOURCE_FILE | 17 | YES | varchar | 20 | 60 | utf8 | utf8_general_ci | varchar(20) | select | ||||||||
| def | information_schema | PROFILING | SOURCE_LINE | 18 | YES | int | 10 | 0 | int(20) | select | ||||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | CONSTRAINT_CATALOG | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | CONSTRAINT_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | CONSTRAINT_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | UNIQUE_CONSTRAINT_CATALOG | 4 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | UNIQUE_CONSTRAINT_SCHEMA | 5 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | UNIQUE_CONSTRAINT_NAME | 6 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | MATCH_OPTION | 7 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | UPDATE_RULE | 8 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | DELETE_RULE | 9 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | TABLE_NAME | 10 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | REFERENTIAL_CONSTRAINTS | REFERENCED_TABLE_NAME | 11 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | SPECIFIC_NAME | 1 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | ROUTINE_CATALOG | 2 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | ROUTINES | ROUTINE_SCHEMA | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | ROUTINE_NAME | 4 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | ROUTINE_TYPE | 5 | NO | varchar | 9 | 27 | utf8 | utf8_general_ci | varchar(9) | select | ||||||||
| def | information_schema | ROUTINES | DATA_TYPE | 6 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | CHARACTER_MAXIMUM_LENGTH | 7 | YES | int | 10 | 0 | int(21) | select | ||||||||||
| def | information_schema | ROUTINES | CHARACTER_OCTET_LENGTH | 8 | YES | int | 10 | 0 | int(21) | select | ||||||||||
| def | information_schema | ROUTINES | NUMERIC_PRECISION | 9 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | ROUTINES | NUMERIC_SCALE | 10 | YES | int | 10 | 0 | int(21) | select | ||||||||||
| def | information_schema | ROUTINES | DATETIME_PRECISION | 11 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | ROUTINES | CHARACTER_SET_NAME | 12 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | COLLATION_NAME | 13 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | DTD_IDENTIFIER | 14 | YES | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | ROUTINES | ROUTINE_BODY | 15 | NO | varchar | 8 | 24 | utf8 | utf8_general_ci | varchar(8) | select | ||||||||
| def | information_schema | ROUTINES | ROUTINE_DEFINITION | 16 | YES | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | ROUTINES | EXTERNAL_NAME | 17 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | EXTERNAL_LANGUAGE | 18 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | PARAMETER_STYLE | 19 | NO | varchar | 8 | 24 | utf8 | utf8_general_ci | varchar(8) | select | ||||||||
| def | information_schema | ROUTINES | IS_DETERMINISTIC | 20 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | ROUTINES | SQL_DATA_ACCESS | 21 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | SQL_PATH | 22 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | ROUTINES | SECURITY_TYPE | 23 | NO | varchar | 7 | 21 | utf8 | utf8_general_ci | varchar(7) | select | ||||||||
| def | information_schema | ROUTINES | CREATED | 24 | 0000-00-00 00:00:00 | NO | datetime | 0 | datetime | select | ||||||||||
| def | information_schema | ROUTINES | LAST_ALTERED | 25 | 0000-00-00 00:00:00 | NO | datetime | 0 | datetime | select | ||||||||||
| def | information_schema | ROUTINES | SQL_MODE | 26 | NO | varchar | 8192 | 24576 | utf8 | utf8_general_ci | varchar(8192) | select | ||||||||
| def | information_schema | ROUTINES | ROUTINE_COMMENT | 27 | NO | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | ROUTINES | DEFINER | 28 | NO | varchar | 93 | 279 | utf8 | utf8_general_ci | varchar(93) | select | ||||||||
| def | information_schema | ROUTINES | CHARACTER_SET_CLIENT | 29 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | ROUTINES | COLLATION_CONNECTION | 30 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | ROUTINES | DATABASE_COLLATION | 31 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | SCHEMATA | CATALOG_NAME | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | SCHEMATA | SCHEMA_NAME | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | SCHEMATA | DEFAULT_CHARACTER_SET_NAME | 3 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | SCHEMATA | DEFAULT_COLLATION_NAME | 4 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | SCHEMATA | SQL_PATH | 5 | YES | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | SCHEMA_PRIVILEGES | GRANTEE | 1 | NO | varchar | 81 | 243 | utf8 | utf8_general_ci | varchar(81) | select | ||||||||
| def | information_schema | SCHEMA_PRIVILEGES | TABLE_CATALOG | 2 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | SCHEMA_PRIVILEGES | TABLE_SCHEMA | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | SCHEMA_PRIVILEGES | PRIVILEGE_TYPE | 4 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | SCHEMA_PRIVILEGES | IS_GRANTABLE | 5 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | SESSION_STATUS | VARIABLE_NAME | 1 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | SESSION_STATUS | VARIABLE_VALUE | 2 | YES | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | SESSION_VARIABLES | VARIABLE_NAME | 1 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | SESSION_VARIABLES | VARIABLE_VALUE | 2 | YES | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | STATISTICS | TABLE_CATALOG | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | STATISTICS | TABLE_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | STATISTICS | TABLE_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | STATISTICS | NON_UNIQUE | 4 | 0 | NO | bigint | 19 | 0 | bigint(1) | select | |||||||||
| def | information_schema | STATISTICS | INDEX_SCHEMA | 5 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | STATISTICS | INDEX_NAME | 6 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | STATISTICS | SEQ_IN_INDEX | 7 | 0 | NO | bigint | 19 | 0 | bigint(2) | select | |||||||||
| def | information_schema | STATISTICS | COLUMN_NAME | 8 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | STATISTICS | COLLATION | 9 | YES | varchar | 1 | 3 | utf8 | utf8_general_ci | varchar(1) | select | ||||||||
| def | information_schema | STATISTICS | CARDINALITY | 10 | YES | bigint | 19 | 0 | bigint(21) | select | ||||||||||
| def | information_schema | STATISTICS | SUB_PART | 11 | YES | bigint | 19 | 0 | bigint(3) | select | ||||||||||
| def | information_schema | STATISTICS | PACKED | 12 | YES | varchar | 10 | 30 | utf8 | utf8_general_ci | varchar(10) | select | ||||||||
| def | information_schema | STATISTICS | NULLABLE | 13 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | STATISTICS | INDEX_TYPE | 14 | NO | varchar | 16 | 48 | utf8 | utf8_general_ci | varchar(16) | select | ||||||||
| def | information_schema | STATISTICS | COMMENT | 15 | YES | varchar | 16 | 48 | utf8 | utf8_general_ci | varchar(16) | select | ||||||||
| def | information_schema | STATISTICS | INDEX_COMMENT | 16 | NO | varchar | 1024 | 3072 | utf8 | utf8_general_ci | varchar(1024) | select | ||||||||
| def | information_schema | TABLES | TABLE_CATALOG | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | TABLES | TABLE_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLES | TABLE_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLES | TABLE_TYPE | 4 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLES | ENGINE | 5 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLES | VERSION | 6 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLES | ROW_FORMAT | 7 | YES | varchar | 20 | 60 | utf8 | utf8_general_ci | varchar(20) | select | ||||||||
| def | information_schema | TABLES | TABLE_ROWS | 8 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLES | AVG_ROW_LENGTH | 9 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLES | DATA_LENGTH | 10 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLES | MAX_DATA_LENGTH | 11 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLES | INDEX_LENGTH | 12 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLES | DATA_FREE | 13 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLES | AUTO_INCREMENT | 14 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLES | CREATE_TIME | 15 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | TABLES | UPDATE_TIME | 16 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | TABLES | CHECK_TIME | 17 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | TABLES | TABLE_COLLATION | 18 | YES | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | TABLES | CHECKSUM | 19 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLES | CREATE_OPTIONS | 20 | YES | varchar | 255 | 765 | utf8 | utf8_general_ci | varchar(255) | select | ||||||||
| def | information_schema | TABLES | TABLE_COMMENT | 21 | NO | varchar | 2048 | 6144 | utf8 | utf8_general_ci | varchar(2048) | select | ||||||||
| def | information_schema | TABLESPACES | TABLESPACE_NAME | 1 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLESPACES | ENGINE | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLESPACES | TABLESPACE_TYPE | 3 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLESPACES | LOGFILE_GROUP_NAME | 4 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLESPACES | EXTENT_SIZE | 5 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLESPACES | AUTOEXTEND_SIZE | 6 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLESPACES | MAXIMUM_SIZE | 7 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLESPACES | NODEGROUP_ID | 8 | YES | bigint | 20 | 0 | bigint(21) unsigned | select | ||||||||||
| def | information_schema | TABLESPACES | TABLESPACE_COMMENT | 9 | YES | varchar | 2048 | 6144 | utf8 | utf8_general_ci | varchar(2048) | select | ||||||||
| def | information_schema | TABLE_CONSTRAINTS | CONSTRAINT_CATALOG | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | TABLE_CONSTRAINTS | CONSTRAINT_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLE_CONSTRAINTS | CONSTRAINT_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLE_CONSTRAINTS | TABLE_SCHEMA | 4 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLE_CONSTRAINTS | TABLE_NAME | 5 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLE_CONSTRAINTS | CONSTRAINT_TYPE | 6 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLE_PRIVILEGES | GRANTEE | 1 | NO | varchar | 81 | 243 | utf8 | utf8_general_ci | varchar(81) | select | ||||||||
| def | information_schema | TABLE_PRIVILEGES | TABLE_CATALOG | 2 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | TABLE_PRIVILEGES | TABLE_SCHEMA | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLE_PRIVILEGES | TABLE_NAME | 4 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLE_PRIVILEGES | PRIVILEGE_TYPE | 5 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TABLE_PRIVILEGES | IS_GRANTABLE | 6 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | TABLE_STATISTICS | TABLE_SCHEMA | 1 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | TABLE_STATISTICS | TABLE_NAME | 2 | NO | varchar | 192 | 576 | utf8 | utf8_general_ci | varchar(192) | select | ||||||||
| def | information_schema | TABLE_STATISTICS | ROWS_READ | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | TABLE_STATISTICS | ROWS_CHANGED | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | TABLE_STATISTICS | ROWS_CHANGED_X_INDEXES | 5 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | TEMPORARY_TABLES | SESSION_ID | 1 | 0 | NO | bigint | 19 | 0 | bigint(4) | select | |||||||||
| def | information_schema | TEMPORARY_TABLES | TABLE_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TEMPORARY_TABLES | TABLE_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TEMPORARY_TABLES | ENGINE | 4 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TEMPORARY_TABLES | NAME | 5 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | TEMPORARY_TABLES | TABLE_ROWS | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | TEMPORARY_TABLES | AVG_ROW_LENGTH | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | TEMPORARY_TABLES | DATA_LENGTH | 8 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | TEMPORARY_TABLES | INDEX_LENGTH | 9 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | TEMPORARY_TABLES | CREATE_TIME | 10 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | TEMPORARY_TABLES | UPDATE_TIME | 11 | YES | datetime | 0 | datetime | select | |||||||||||
| def | information_schema | THREAD_STATISTICS | THREAD_ID | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | TOTAL_CONNECTIONS | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | CONCURRENT_CONNECTIONS | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | CONNECTED_TIME | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | BUSY_TIME | 5 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | CPU_TIME | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | BYTES_RECEIVED | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | BYTES_SENT | 8 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | BINLOG_BYTES_WRITTEN | 9 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | ROWS_FETCHED | 10 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | ROWS_UPDATED | 11 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | TABLE_ROWS_READ | 12 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | SELECT_COMMANDS | 13 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | UPDATE_COMMANDS | 14 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | OTHER_COMMANDS | 15 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | COMMIT_TRANSACTIONS | 16 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | ROLLBACK_TRANSACTIONS | 17 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | DENIED_CONNECTIONS | 18 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | LOST_CONNECTIONS | 19 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | ACCESS_DENIED | 20 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | EMPTY_QUERIES | 21 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | THREAD_STATISTICS | TOTAL_SSL_CONNECTIONS | 22 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | TRIGGERS | TRIGGER_CATALOG | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | TRIGGERS | TRIGGER_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TRIGGERS | TRIGGER_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TRIGGERS | EVENT_MANIPULATION | 4 | NO | varchar | 6 | 18 | utf8 | utf8_general_ci | varchar(6) | select | ||||||||
| def | information_schema | TRIGGERS | EVENT_OBJECT_CATALOG | 5 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | TRIGGERS | EVENT_OBJECT_SCHEMA | 6 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TRIGGERS | EVENT_OBJECT_TABLE | 7 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TRIGGERS | ACTION_ORDER | 8 | 0 | NO | bigint | 19 | 0 | bigint(4) | select | |||||||||
| def | information_schema | TRIGGERS | ACTION_CONDITION | 9 | YES | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | TRIGGERS | ACTION_STATEMENT | 10 | NO | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | TRIGGERS | ACTION_ORIENTATION | 11 | NO | varchar | 9 | 27 | utf8 | utf8_general_ci | varchar(9) | select | ||||||||
| def | information_schema | TRIGGERS | ACTION_TIMING | 12 | NO | varchar | 6 | 18 | utf8 | utf8_general_ci | varchar(6) | select | ||||||||
| def | information_schema | TRIGGERS | ACTION_REFERENCE_OLD_TABLE | 13 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TRIGGERS | ACTION_REFERENCE_NEW_TABLE | 14 | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | TRIGGERS | ACTION_REFERENCE_OLD_ROW | 15 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | TRIGGERS | ACTION_REFERENCE_NEW_ROW | 16 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | TRIGGERS | CREATED | 17 | YES | datetime | 2 | datetime(2) | select | |||||||||||
| def | information_schema | TRIGGERS | SQL_MODE | 18 | NO | varchar | 8192 | 24576 | utf8 | utf8_general_ci | varchar(8192) | select | ||||||||
| def | information_schema | TRIGGERS | DEFINER | 19 | NO | varchar | 93 | 279 | utf8 | utf8_general_ci | varchar(93) | select | ||||||||
| def | information_schema | TRIGGERS | CHARACTER_SET_CLIENT | 20 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | TRIGGERS | COLLATION_CONNECTION | 21 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | TRIGGERS | DATABASE_COLLATION | 22 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | USER_PRIVILEGES | GRANTEE | 1 | NO | varchar | 81 | 243 | utf8 | utf8_general_ci | varchar(81) | select | ||||||||
| def | information_schema | USER_PRIVILEGES | TABLE_CATALOG | 2 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | USER_PRIVILEGES | PRIVILEGE_TYPE | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | USER_PRIVILEGES | IS_GRANTABLE | 4 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | USER_STATISTICS | USER | 1 | NO | varchar | 96 | 288 | utf8 | utf8_general_ci | varchar(96) | select | ||||||||
| def | information_schema | USER_STATISTICS | TOTAL_CONNECTIONS | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | CONCURRENT_CONNECTIONS | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | CONNECTED_TIME | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | BUSY_TIME | 5 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | CPU_TIME | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | BYTES_RECEIVED | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | BYTES_SENT | 8 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | BINLOG_BYTES_WRITTEN | 9 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | ROWS_FETCHED | 10 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | ROWS_UPDATED | 11 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | TABLE_ROWS_READ | 12 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | SELECT_COMMANDS | 13 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | UPDATE_COMMANDS | 14 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | OTHER_COMMANDS | 15 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | COMMIT_TRANSACTIONS | 16 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | ROLLBACK_TRANSACTIONS | 17 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | DENIED_CONNECTIONS | 18 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | LOST_CONNECTIONS | 19 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | ACCESS_DENIED | 20 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | EMPTY_QUERIES | 21 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | USER_STATISTICS | TOTAL_SSL_CONNECTIONS | 22 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | VIEWS | TABLE_CATALOG | 1 | NO | varchar | 512 | 1536 | utf8 | utf8_general_ci | varchar(512) | select | ||||||||
| def | information_schema | VIEWS | TABLE_SCHEMA | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | VIEWS | TABLE_NAME | 3 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | VIEWS | VIEW_DEFINITION | 4 | NO | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | select | ||||||||
| def | information_schema | VIEWS | CHECK_OPTION | 5 | NO | varchar | 8 | 24 | utf8 | utf8_general_ci | varchar(8) | select | ||||||||
| def | information_schema | VIEWS | IS_UPDATABLE | 6 | NO | varchar | 3 | 9 | utf8 | utf8_general_ci | varchar(3) | select | ||||||||
| def | information_schema | VIEWS | DEFINER | 7 | NO | varchar | 93 | 279 | utf8 | utf8_general_ci | varchar(93) | select | ||||||||
| def | information_schema | VIEWS | SECURITY_TYPE | 8 | NO | varchar | 7 | 21 | utf8 | utf8_general_ci | varchar(7) | select | ||||||||
| def | information_schema | VIEWS | CHARACTER_SET_CLIENT | 9 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | VIEWS | COLLATION_CONNECTION | 10 | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | select | ||||||||
| def | information_schema | XTRADB_INTERNAL_HASH_TABLES | INTERNAL_HASH_TABLE_NAME | 1 | NO | varchar | 100 | 300 | utf8 | utf8_general_ci | varchar(100) | select | ||||||||
| def | information_schema | XTRADB_INTERNAL_HASH_TABLES | TOTAL_MEMORY | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_INTERNAL_HASH_TABLES | CONSTANT_MEMORY | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_INTERNAL_HASH_TABLES | VARIABLE_MEMORY | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_READ_VIEW | READ_VIEW_LOW_LIMIT_TRX_NUMBER | 1 | NO | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | XTRADB_READ_VIEW | READ_VIEW_UPPER_LIMIT_TRX_ID | 2 | NO | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | XTRADB_READ_VIEW | READ_VIEW_LOW_LIMIT_TRX_ID | 3 | NO | varchar | 18 | 54 | utf8 | utf8_general_ci | varchar(18) | select | ||||||||
| def | information_schema | XTRADB_RSEG | rseg_id | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_RSEG | space_id | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_RSEG | physical_page_size | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_RSEG | logical_page_size | 4 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_RSEG | is_compressed | 5 | 0 | NO | tinyint | 3 | 0 | tinyint(1) unsigned | select | |||||||||
| def | information_schema | XTRADB_RSEG | page_no | 6 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_RSEG | max_size | 7 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_RSEG | curr_size | 8 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_ZIP_DICT | id | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_ZIP_DICT | name | 2 | NO | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | select | ||||||||
| def | information_schema | XTRADB_ZIP_DICT | zip_dict | 3 | NO | blob | 65535 | 65535 | blob | select | ||||||||||
| def | information_schema | XTRADB_ZIP_DICT_COLS | table_id | 1 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_ZIP_DICT_COLS | column_pos | 2 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select | |||||||||
| def | information_schema | XTRADB_ZIP_DICT_COLS | dict_id | 3 | 0 | NO | bigint | 20 | 0 | bigint(21) unsigned | select |