Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:

information_schema

CHARACTER_SETS

Column Type Null Default Comments
CHARACTER_SET_NAME varchar(64) No
DEFAULT_COLLATE_NAME varchar(64) No
DESCRIPTION varchar(2048) No
MAXLEN int(10) No

No index defined!

CHECK_CONSTRAINTS

Column Type Null Default Comments
CONSTRAINT_CATALOG varchar(64) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) No
CHECK_CLAUSE longtext No

No index defined!

COLLATIONS

Column Type Null Default Comments
COLLATION_NAME varchar(64) No
CHARACTER_SET_NAME varchar(64) No
ID bigint(20) No 0
IS_DEFAULT varchar(3) No
IS_COMPILED varchar(3) No
SORTLEN int(10) No
PAD_ATTRIBUTE enum('PAD SPACE', 'NO PAD') No

No index defined!

COLLATION_CHARACTER_SET_APPLICABILITY

Column Type Null Default Comments
COLLATION_NAME varchar(64) No
CHARACTER_SET_NAME varchar(64) No

No index defined!

COLUMNS

Column Type Null Default Comments
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
COLUMN_NAME varchar(64) Yes NULL
ORDINAL_POSITION int(10) No
COLUMN_DEFAULT text Yes NULL
IS_NULLABLE varchar(3) No
DATA_TYPE longtext Yes NULL
CHARACTER_MAXIMUM_LENGTH bigint(21) Yes NULL
CHARACTER_OCTET_LENGTH bigint(21) Yes NULL
NUMERIC_PRECISION bigint(10) Yes NULL
NUMERIC_SCALE bigint(10) Yes NULL
DATETIME_PRECISION int(10) Yes NULL
CHARACTER_SET_NAME varchar(64) Yes NULL
COLLATION_NAME varchar(64) Yes NULL
COLUMN_TYPE mediumtext No
COLUMN_KEY enum('', 'PRI', 'UNI', 'MUL') No
EXTRA varchar(256) Yes NULL
PRIVILEGES varchar(154) Yes NULL
COLUMN_COMMENT text No
GENERATION_EXPRESSION longtext No
SRS_ID int(10) Yes NULL

No index defined!

COLUMN_PRIVILEGES

Column Type Null Default Comments
GRANTEE varchar(292) No
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
COLUMN_NAME varchar(64) No
PRIVILEGE_TYPE varchar(64) No
IS_GRANTABLE varchar(3) No

No index defined!

COLUMN_STATISTICS

Column Type Null Default Comments
SCHEMA_NAME varchar(64) No
TABLE_NAME varchar(64) No
COLUMN_NAME varchar(64) No
HISTOGRAM json No

No index defined!

ENGINES

Column Type Null Default Comments
ENGINE varchar(64) No
SUPPORT varchar(8) No
COMMENT varchar(80) No
TRANSACTIONS varchar(3) Yes
XA varchar(3) Yes
SAVEPOINTS varchar(3) Yes

No index defined!

EVENTS

Column Type Null Default Comments
EVENT_CATALOG varchar(64) No
EVENT_SCHEMA varchar(64) No
EVENT_NAME varchar(64) No
DEFINER varchar(288) No
TIME_ZONE varchar(64) No
EVENT_BODY varchar(3) No
EVENT_DEFINITION longtext No
EVENT_TYPE varchar(9) No
EXECUTE_AT datetime Yes NULL
INTERVAL_VALUE varchar(256) Yes NULL
INTERVAL_FIELD enum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND') Yes NULL
SQL_MODE set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'NOT_USED_9', 'NOT_USED_10', 'NOT_USED_11', 'NOT_USED_12', 'NOT_USED_13', 'NOT_USED_14', 'NOT_USED_15', 'NOT_USED_16', 'NOT_USED_17', 'NOT_USED_18', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ALLOW_INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NOT_USED_29', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'TIME_TRUNCATE_FRACTIONAL') No
STARTS datetime Yes NULL
ENDS datetime Yes NULL
STATUS enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED') No
ON_COMPLETION varchar(12) No
CREATED timestamp No
LAST_ALTERED timestamp No
LAST_EXECUTED datetime Yes NULL
EVENT_COMMENT varchar(2048) No
ORIGINATOR int(10) No
CHARACTER_SET_CLIENT varchar(64) No
COLLATION_CONNECTION varchar(64) No
DATABASE_COLLATION varchar(64) No

No index defined!

FILES

Column Type Null Default Comments
FILE_ID bigint(21) Yes NULL
FILE_NAME text Yes NULL
FILE_TYPE varchar(256) Yes NULL
TABLESPACE_NAME varchar(268) No
TABLE_CATALOG char(0) No
TABLE_SCHEMA binary(0) Yes NULL
TABLE_NAME binary(0) Yes NULL
LOGFILE_GROUP_NAME varchar(256) Yes NULL
LOGFILE_GROUP_NUMBER bigint(21) Yes NULL
ENGINE varchar(64) No
FULLTEXT_KEYS binary(0) Yes NULL
DELETED_ROWS binary(0) Yes NULL
UPDATE_COUNT binary(0) Yes NULL
FREE_EXTENTS bigint(21) Yes NULL
TOTAL_EXTENTS bigint(21) Yes NULL
EXTENT_SIZE bigint(21) Yes NULL
INITIAL_SIZE bigint(21) Yes NULL
MAXIMUM_SIZE bigint(21) Yes NULL
AUTOEXTEND_SIZE bigint(21) Yes NULL
CREATION_TIME binary(0) Yes NULL
LAST_UPDATE_TIME binary(0) Yes NULL
LAST_ACCESS_TIME binary(0) Yes NULL
RECOVER_TIME binary(0) Yes NULL
TRANSACTION_COUNTER binary(0) Yes NULL
VERSION bigint(21) Yes NULL
ROW_FORMAT varchar(256) Yes NULL
TABLE_ROWS binary(0) Yes NULL
AVG_ROW_LENGTH binary(0) Yes NULL
DATA_LENGTH binary(0) Yes NULL
MAX_DATA_LENGTH binary(0) Yes NULL
INDEX_LENGTH binary(0) Yes NULL
DATA_FREE bigint(21) Yes NULL
CREATE_TIME binary(0) Yes NULL
UPDATE_TIME binary(0) Yes NULL
CHECK_TIME binary(0) Yes NULL
CHECKSUM binary(0) Yes NULL
STATUS varchar(256) Yes NULL
EXTRA varchar(256) Yes NULL

No index defined!

INNODB_BUFFER_PAGE

Column Type Null Default Comments
POOL_ID bigint(21) No
BLOCK_ID bigint(21) No
SPACE bigint(21) No
PAGE_NUMBER bigint(21) No
PAGE_TYPE varchar(64) Yes
FLUSH_TYPE bigint(21) No
FIX_COUNT bigint(21) No
IS_HASHED varchar(3) Yes
NEWEST_MODIFICATION bigint(21) No
OLDEST_MODIFICATION bigint(21) No
ACCESS_TIME bigint(21) No
TABLE_NAME varchar(1024) Yes
INDEX_NAME varchar(1024) Yes
NUMBER_RECORDS bigint(21) No
DATA_SIZE bigint(21) No
COMPRESSED_SIZE bigint(21) No
PAGE_STATE varchar(64) Yes
IO_FIX varchar(64) Yes
IS_OLD varchar(3) Yes
FREE_PAGE_CLOCK bigint(21) No

No index defined!

INNODB_BUFFER_PAGE_LRU

Column Type Null Default Comments
POOL_ID bigint(21) No
LRU_POSITION bigint(21) No
SPACE bigint(21) No
PAGE_NUMBER bigint(21) No
PAGE_TYPE varchar(64) Yes
FLUSH_TYPE bigint(21) No
FIX_COUNT bigint(21) No
IS_HASHED varchar(3) Yes
NEWEST_MODIFICATION bigint(21) No
OLDEST_MODIFICATION bigint(21) No
ACCESS_TIME bigint(21) No
TABLE_NAME varchar(1024) Yes
INDEX_NAME varchar(1024) Yes
NUMBER_RECORDS bigint(21) No
DATA_SIZE bigint(21) No
COMPRESSED_SIZE bigint(21) No
COMPRESSED varchar(3) Yes
IO_FIX varchar(64) Yes
IS_OLD varchar(3) Yes
FREE_PAGE_CLOCK bigint(21) No

No index defined!

INNODB_BUFFER_POOL_STATS

Column Type Null Default Comments
POOL_ID bigint(21) No
POOL_SIZE bigint(21) No
FREE_BUFFERS bigint(21) No
DATABASE_PAGES bigint(21) No
OLD_DATABASE_PAGES bigint(21) No
MODIFIED_DATABASE_PAGES bigint(21) No
PENDING_DECOMPRESS bigint(21) No
PENDING_READS bigint(21) No
PENDING_FLUSH_LRU bigint(21) No
PENDING_FLUSH_LIST bigint(21) No
PAGES_MADE_YOUNG bigint(21) No
PAGES_NOT_MADE_YOUNG bigint(21) No
PAGES_MADE_YOUNG_RATE float(12,0) No
PAGES_MADE_NOT_YOUNG_RATE float(12,0) No
NUMBER_PAGES_READ bigint(21) No
NUMBER_PAGES_CREATED bigint(21) No
NUMBER_PAGES_WRITTEN bigint(21) No
PAGES_READ_RATE float(12,0) No
PAGES_CREATE_RATE float(12,0) No
PAGES_WRITTEN_RATE float(12,0) No
NUMBER_PAGES_GET bigint(21) No
HIT_RATE bigint(21) No
YOUNG_MAKE_PER_THOUSAND_GETS bigint(21) No
NOT_YOUNG_MAKE_PER_THOUSAND_GETS bigint(21) No
NUMBER_PAGES_READ_AHEAD bigint(21) No
NUMBER_READ_AHEAD_EVICTED bigint(21) No
READ_AHEAD_RATE float(12,0) No
READ_AHEAD_EVICTED_RATE float(12,0) No
LRU_IO_TOTAL bigint(21) No
LRU_IO_CURRENT bigint(21) No
UNCOMPRESS_TOTAL bigint(21) No
UNCOMPRESS_CURRENT bigint(21) No

No index defined!

INNODB_CACHED_INDEXES

Column Type Null Default Comments
SPACE_ID int(11) No
INDEX_ID bigint(21) No
N_CACHED_PAGES bigint(21) No

No index defined!

INNODB_CMP

Column Type Null Default Comments
page_size int(5) No
compress_ops int(11) No
compress_ops_ok int(11) No
compress_time int(11) No
uncompress_ops int(11) No
uncompress_time int(11) No

No index defined!

INNODB_CMPMEM

Column Type Null Default Comments
page_size int(5) No
buffer_pool_instance int(11) No
pages_used int(11) No
pages_free int(11) No
relocation_ops bigint(21) No
relocation_time int(11) No

No index defined!

INNODB_CMPMEM_RESET

Column Type Null Default Comments
page_size int(5) No
buffer_pool_instance int(11) No
pages_used int(11) No
pages_free int(11) No
relocation_ops bigint(21) No
relocation_time int(11) No

No index defined!

INNODB_CMP_PER_INDEX

Column Type Null Default Comments
database_name varchar(192) No
table_name varchar(192) No
index_name varchar(192) No
compress_ops int(11) No
compress_ops_ok int(11) No
compress_time int(11) No
uncompress_ops int(11) No
uncompress_time int(11) No

No index defined!

INNODB_CMP_PER_INDEX_RESET

Column Type Null Default Comments
database_name varchar(192) No
table_name varchar(192) No
index_name varchar(192) No
compress_ops int(11) No
compress_ops_ok int(11) No
compress_time int(11) No
uncompress_ops int(11) No
uncompress_time int(11) No

No index defined!

INNODB_CMP_RESET

Column Type Null Default Comments
page_size int(5) No
compress_ops int(11) No
compress_ops_ok int(11) No
compress_time int(11) No
uncompress_ops int(11) No
uncompress_time int(11) No

No index defined!

INNODB_COLUMNS

Column Type Null Default Comments
TABLE_ID bigint(21) No
NAME varchar(193) No
POS bigint(21) No
MTYPE int(11) No
PRTYPE int(11) No
LEN int(11) No
HAS_DEFAULT int(1) No
DEFAULT_VALUE text Yes

No index defined!

INNODB_DATAFILES

Column Type Null Default Comments
SPACE varbinary(256) Yes NULL
PATH varchar(512) No

No index defined!

INNODB_FIELDS

Column Type Null Default Comments
INDEX_ID varbinary(256) Yes NULL
NAME varchar(64) No
POS bigint(11) No 0

No index defined!

INNODB_FOREIGN

Column Type Null Default Comments
ID varchar(129) Yes NULL
FOR_NAME varchar(129) Yes NULL
REF_NAME varchar(129) Yes NULL
N_COLS bigint(21) No 0
TYPE bigint(21) No 0

No index defined!

INNODB_FOREIGN_COLS

Column Type Null Default Comments
ID varchar(129) Yes NULL
FOR_COL_NAME varchar(64) No
REF_COL_NAME varchar(64) No
POS int(10) No

No index defined!

INNODB_FT_BEING_DELETED

Column Type Null Default Comments
DOC_ID bigint(21) No

No index defined!

INNODB_FT_CONFIG

Column Type Null Default Comments
KEY varchar(193) No
VALUE varchar(193) No

No index defined!

INNODB_FT_DEFAULT_STOPWORD

Column Type Null Default Comments
value varchar(18) No

No index defined!

INNODB_FT_DELETED

Column Type Null Default Comments
DOC_ID bigint(21) No

No index defined!

INNODB_FT_INDEX_CACHE

Column Type Null Default Comments
WORD varchar(337) No
FIRST_DOC_ID bigint(21) No
LAST_DOC_ID bigint(21) No
DOC_COUNT bigint(21) No
DOC_ID bigint(21) No
POSITION bigint(21) No

No index defined!

INNODB_FT_INDEX_TABLE

Column Type Null Default Comments
WORD varchar(337) No
FIRST_DOC_ID bigint(21) No
LAST_DOC_ID bigint(21) No
DOC_COUNT bigint(21) No
DOC_ID bigint(21) No
POSITION bigint(21) No

No index defined!

INNODB_INDEXES

Column Type Null Default Comments
INDEX_ID bigint(21) No
NAME varchar(193) No
TABLE_ID bigint(21) No
TYPE int(11) No
N_FIELDS int(11) No
PAGE_NO int(11) No
SPACE int(11) No
MERGE_THRESHOLD int(11) No

No index defined!

INNODB_METRICS

Column Type Null Default Comments
NAME varchar(193) No
SUBSYSTEM varchar(193) No
COUNT bigint(21) No
MAX_COUNT bigint(21) Yes
MIN_COUNT bigint(21) Yes
AVG_COUNT float(12,0) Yes
COUNT_RESET bigint(21) No
MAX_COUNT_RESET bigint(21) Yes
MIN_COUNT_RESET bigint(21) Yes
AVG_COUNT_RESET float(12,0) Yes
TIME_ENABLED datetime Yes
TIME_DISABLED datetime Yes
TIME_ELAPSED bigint(21) Yes
TIME_RESET datetime Yes
STATUS varchar(193) No
TYPE varchar(193) No
COMMENT varchar(193) No

No index defined!

INNODB_SESSION_TEMP_TABLESPACES

Column Type Null Default Comments
ID int(11) No
SPACE int(11) No
PATH varchar(4001) No
SIZE bigint(21) No
STATE varchar(192) No
PURPOSE varchar(192) No

No index defined!

INNODB_TABLES

Column Type Null Default Comments
TABLE_ID bigint(21) No
NAME varchar(655) No
FLAG int(11) No
N_COLS int(11) No
SPACE bigint(21) No
ROW_FORMAT varchar(12) Yes
ZIP_PAGE_SIZE int(11) No
SPACE_TYPE varchar(10) Yes
INSTANT_COLS int(11) No

No index defined!

INNODB_TABLESPACES

Column Type Null Default Comments
SPACE int(11) No
NAME varchar(655) No
FLAG int(11) No
ROW_FORMAT varchar(22) Yes
PAGE_SIZE int(11) No
ZIP_PAGE_SIZE int(11) No
SPACE_TYPE varchar(10) Yes
FS_BLOCK_SIZE int(11) No
FILE_SIZE bigint(21) No
ALLOCATED_SIZE bigint(21) No
SERVER_VERSION varchar(10) Yes
SPACE_VERSION int(11) No
ENCRYPTION varchar(1) Yes
STATE varchar(10) Yes

No index defined!

INNODB_TABLESPACES_BRIEF

Column Type Null Default Comments
SPACE varbinary(256) Yes NULL
NAME varchar(268) No
PATH varchar(512) No
FLAG varbinary(256) Yes NULL
SPACE_TYPE varchar(7) No

No index defined!

INNODB_TABLESTATS

Column Type Null Default Comments
TABLE_ID bigint(21) No
NAME varchar(193) No
STATS_INITIALIZED varchar(193) No
NUM_ROWS bigint(21) No
CLUST_INDEX_SIZE bigint(21) No
OTHER_INDEX_SIZE bigint(21) No
MODIFIED_COUNTER bigint(21) No
AUTOINC bigint(21) No
REF_COUNT int(11) No

No index defined!

INNODB_TEMP_TABLE_INFO

Column Type Null Default Comments
TABLE_ID bigint(21) No
NAME varchar(64) Yes
N_COLS int(11) No
SPACE int(11) No

No index defined!

INNODB_TRX

Column Type Null Default Comments
trx_id varchar(18) No
trx_state varchar(13) No
trx_started datetime No
trx_requested_lock_id varchar(105) Yes
trx_wait_started datetime Yes
trx_weight bigint(21) No
trx_mysql_thread_id bigint(21) No
trx_query varchar(1024) Yes
trx_operation_state varchar(64) Yes
trx_tables_in_use bigint(21) No
trx_tables_locked bigint(21) No
trx_lock_structs bigint(21) No
trx_lock_memory_bytes bigint(21) No
trx_rows_locked bigint(21) No
trx_rows_modified bigint(21) No
trx_concurrency_tickets bigint(21) No
trx_isolation_level varchar(16) No
trx_unique_checks int(1) No
trx_foreign_key_checks int(1) No
trx_last_foreign_key_error varchar(256) Yes
trx_adaptive_hash_latched int(1) No
trx_adaptive_hash_timeout bigint(21) No
trx_is_read_only int(1) No
trx_autocommit_non_locking int(1) No

No index defined!

INNODB_VIRTUAL

Column Type Null Default Comments
TABLE_ID bigint(21) No
POS int(11) No
BASE_POS int(11) No

No index defined!

KEYWORDS

Column Type Null Default Comments
WORD varchar(29) Yes NULL
RESERVED int(11) Yes NULL

No index defined!

KEY_COLUMN_USAGE

Column Type Null Default Comments
CONSTRAINT_CATALOG varchar(64) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) Yes NULL
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
COLUMN_NAME varchar(64) Yes NULL
ORDINAL_POSITION int(10) No 0
POSITION_IN_UNIQUE_CONSTRAINT int(10) Yes NULL
REFERENCED_TABLE_SCHEMA varchar(64) Yes NULL
REFERENCED_TABLE_NAME varchar(64) Yes NULL
REFERENCED_COLUMN_NAME varchar(64) Yes NULL

No index defined!

OPTIMIZER_TRACE

Column Type Null Default Comments
QUERY varchar(65535) No
TRACE varchar(65535) No
MISSING_BYTES_BEYOND_MAX_MEM_SIZE int(20) No
INSUFFICIENT_PRIVILEGES tinyint(1) No

No index defined!

PARAMETERS

Column Type Null Default Comments
SPECIFIC_CATALOG varchar(64) No
SPECIFIC_SCHEMA varchar(64) No
SPECIFIC_NAME varchar(64) No
ORDINAL_POSITION bigint(11) No 0
PARAMETER_MODE varchar(5) Yes NULL
PARAMETER_NAME varchar(64) Yes NULL
DATA_TYPE longtext Yes NULL
CHARACTER_MAXIMUM_LENGTH bigint(21) Yes NULL
CHARACTER_OCTET_LENGTH bigint(21) Yes NULL
NUMERIC_PRECISION int(10) Yes NULL
NUMERIC_SCALE bigint(10) Yes NULL
DATETIME_PRECISION int(10) Yes NULL
CHARACTER_SET_NAME varchar(64) Yes NULL
COLLATION_NAME varchar(64) Yes NULL
DTD_IDENTIFIER mediumtext No
ROUTINE_TYPE enum('FUNCTION', 'PROCEDURE') No

No index defined!

PARTITIONS

Column Type Null Default Comments
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
PARTITION_NAME varchar(64) Yes NULL
SUBPARTITION_NAME varchar(64) Yes NULL
PARTITION_ORDINAL_POSITION int(6) Yes NULL
SUBPARTITION_ORDINAL_POSITION int(6) Yes NULL
PARTITION_METHOD varchar(13) Yes NULL
SUBPARTITION_METHOD varchar(13) Yes NULL
PARTITION_EXPRESSION varchar(2048) Yes NULL
SUBPARTITION_EXPRESSION varchar(2048) Yes NULL
PARTITION_DESCRIPTION text Yes NULL
TABLE_ROWS bigint(21) Yes NULL
AVG_ROW_LENGTH bigint(21) Yes NULL
DATA_LENGTH bigint(21) Yes NULL
MAX_DATA_LENGTH bigint(21) Yes NULL
INDEX_LENGTH bigint(21) Yes NULL
DATA_FREE bigint(21) Yes NULL
CREATE_TIME timestamp No
UPDATE_TIME datetime Yes NULL
CHECK_TIME datetime Yes NULL
CHECKSUM bigint(21) Yes NULL
PARTITION_COMMENT text No
NODEGROUP varchar(256) Yes NULL
TABLESPACE_NAME varchar(268) Yes NULL

No index defined!

PLUGINS

Column Type Null Default Comments
PLUGIN_NAME varchar(64) No
PLUGIN_VERSION varchar(20) No
PLUGIN_STATUS varchar(10) No
PLUGIN_TYPE varchar(80) No
PLUGIN_TYPE_VERSION varchar(20) No
PLUGIN_LIBRARY varchar(64) Yes
PLUGIN_LIBRARY_VERSION varchar(20) Yes
PLUGIN_AUTHOR varchar(64) Yes
PLUGIN_DESCRIPTION varchar(65535) Yes
PLUGIN_LICENSE varchar(80) Yes
LOAD_OPTION varchar(64) No

No index defined!

PROCESSLIST

Column Type Null Default Comments
ID bigint(21) No
USER varchar(32) No
HOST varchar(261) No
DB varchar(64) Yes
COMMAND varchar(16) No
TIME int(7) No
STATE varchar(64) Yes
INFO varchar(65535) Yes

No index defined!

PROFILING

Column Type Null Default Comments
QUERY_ID int(20) No
SEQ int(20) No
STATE varchar(30) No
DURATION decimal(905,0) No
CPU_USER decimal(905,0) Yes
CPU_SYSTEM decimal(905,0) Yes
CONTEXT_VOLUNTARY int(20) Yes
CONTEXT_INVOLUNTARY int(20) Yes
BLOCK_OPS_IN int(20) Yes
BLOCK_OPS_OUT int(20) Yes
MESSAGES_SENT int(20) Yes
MESSAGES_RECEIVED int(20) Yes
PAGE_FAULTS_MAJOR int(20) Yes
PAGE_FAULTS_MINOR int(20) Yes
SWAPS int(20) Yes
SOURCE_FUNCTION varchar(30) Yes
SOURCE_FILE varchar(20) Yes
SOURCE_LINE int(20) Yes

No index defined!

REFERENTIAL_CONSTRAINTS

Column Type Null Default Comments
CONSTRAINT_CATALOG varchar(64) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) Yes NULL
UNIQUE_CONSTRAINT_CATALOG varchar(64) No
UNIQUE_CONSTRAINT_SCHEMA varchar(64) No
UNIQUE_CONSTRAINT_NAME varchar(64) Yes NULL
MATCH_OPTION enum('NONE', 'PARTIAL', 'FULL') No
UPDATE_RULE enum('NO ACTION', 'RESTRICT', 'CASCADE', 'SET NULL', 'SET DEFAULT') No
DELETE_RULE enum('NO ACTION', 'RESTRICT', 'CASCADE', 'SET NULL', 'SET DEFAULT') No
TABLE_NAME varchar(64) No
REFERENCED_TABLE_NAME varchar(64) No

No index defined!

RESOURCE_GROUPS

Column Type Null Default Comments
RESOURCE_GROUP_NAME varchar(64) No
RESOURCE_GROUP_TYPE enum('SYSTEM', 'USER') No
RESOURCE_GROUP_ENABLED tinyint(1) No
VCPU_IDS blob Yes NULL
THREAD_PRIORITY int(11) No

No index defined!

ROUTINES

Column Type Null Default Comments
SPECIFIC_NAME varchar(64) No
ROUTINE_CATALOG varchar(64) No
ROUTINE_SCHEMA varchar(64) No
ROUTINE_NAME varchar(64) No
ROUTINE_TYPE enum('FUNCTION', 'PROCEDURE') No
DATA_TYPE longtext Yes NULL
CHARACTER_MAXIMUM_LENGTH bigint(21) Yes NULL
CHARACTER_OCTET_LENGTH bigint(21) Yes NULL
NUMERIC_PRECISION int(10) Yes NULL
NUMERIC_SCALE int(10) Yes NULL
DATETIME_PRECISION int(10) Yes NULL
CHARACTER_SET_NAME varchar(64) Yes NULL
COLLATION_NAME varchar(64) Yes NULL
DTD_IDENTIFIER longtext Yes NULL
ROUTINE_BODY varchar(3) No
ROUTINE_DEFINITION longtext Yes NULL
EXTERNAL_NAME binary(0) Yes NULL
EXTERNAL_LANGUAGE varchar(64) No SQL
PARAMETER_STYLE varchar(3) No
IS_DETERMINISTIC varchar(3) No
SQL_DATA_ACCESS enum('CONTAINS SQL', 'NO SQL', 'READS SQL DATA', 'MODIFIES SQL DATA') No
SQL_PATH binary(0) Yes NULL
SECURITY_TYPE enum('DEFAULT', 'INVOKER', 'DEFINER') No
CREATED timestamp No
LAST_ALTERED timestamp No
SQL_MODE set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'NOT_USED_9', 'NOT_USED_10', 'NOT_USED_11', 'NOT_USED_12', 'NOT_USED_13', 'NOT_USED_14', 'NOT_USED_15', 'NOT_USED_16', 'NOT_USED_17', 'NOT_USED_18', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ALLOW_INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NOT_USED_29', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'TIME_TRUNCATE_FRACTIONAL') No
ROUTINE_COMMENT text No
DEFINER varchar(288) No
CHARACTER_SET_CLIENT varchar(64) No
COLLATION_CONNECTION varchar(64) No
DATABASE_COLLATION varchar(64) No

No index defined!

SCHEMATA

Column Type Null Default Comments
CATALOG_NAME varchar(64) No
SCHEMA_NAME varchar(64) No
DEFAULT_CHARACTER_SET_NAME varchar(64) No
DEFAULT_COLLATION_NAME varchar(64) No
SQL_PATH binary(0) Yes NULL
DEFAULT_ENCRYPTION enum('NO', 'YES') No

No index defined!

SCHEMA_PRIVILEGES

Column Type Null Default Comments
GRANTEE varchar(292) No
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
PRIVILEGE_TYPE varchar(64) No
IS_GRANTABLE varchar(3) No

No index defined!

STATISTICS

Column Type Null Default Comments
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
NON_UNIQUE int(1) No 0
INDEX_SCHEMA varchar(64) No
INDEX_NAME varchar(64) Yes NULL
SEQ_IN_INDEX int(10) No
COLUMN_NAME varchar(64) Yes NULL
COLLATION varchar(1) Yes NULL
CARDINALITY bigint(21) Yes NULL
SUB_PART bigint(21) Yes NULL
PACKED binary(0) Yes NULL
NULLABLE varchar(3) No
INDEX_TYPE varchar(11) No
COMMENT varchar(8) No
INDEX_COMMENT varchar(2048) No
IS_VISIBLE varchar(3) No
EXPRESSION longtext Yes NULL

No index defined!

ST_GEOMETRY_COLUMNS

Column Type Null Default Comments
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
COLUMN_NAME varchar(64) Yes NULL
SRS_NAME varchar(80) Yes NULL
SRS_ID int(10) Yes NULL
GEOMETRY_TYPE_NAME longtext Yes NULL

No index defined!

ST_SPATIAL_REFERENCE_SYSTEMS

Column Type Null Default Comments
SRS_NAME varchar(80) No
SRS_ID int(10) No
ORGANIZATION varchar(256) Yes NULL
ORGANIZATION_COORDSYS_ID int(10) Yes NULL
DEFINITION varchar(4096) No
DESCRIPTION varchar(2048) Yes NULL

No index defined!

ST_UNITS_OF_MEASURE

Column Type Null Default Comments
UNIT_NAME varchar(255) Yes NULL
UNIT_TYPE varchar(7) Yes NULL
CONVERSION_FACTOR double Yes NULL
DESCRIPTION varchar(255) Yes NULL

No index defined!

TABLES

Column Type Null Default Comments
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
TABLE_TYPE enum('BASE TABLE', 'VIEW', 'SYSTEM VIEW') No
ENGINE varchar(64) Yes NULL
VERSION int(2) Yes NULL
ROW_FORMAT enum('Fixed', 'Dynamic', 'Compressed', 'Redundant', 'Compact', 'Paged') Yes NULL
TABLE_ROWS bigint(21) Yes NULL
AVG_ROW_LENGTH bigint(21) Yes NULL
DATA_LENGTH bigint(21) Yes NULL
MAX_DATA_LENGTH bigint(21) Yes NULL
INDEX_LENGTH bigint(21) Yes NULL
DATA_FREE bigint(21) Yes NULL
AUTO_INCREMENT bigint(21) Yes NULL
CREATE_TIME timestamp No
UPDATE_TIME datetime Yes NULL
CHECK_TIME datetime Yes NULL
TABLE_COLLATION varchar(64) Yes NULL
CHECKSUM bigint(21) Yes NULL
CREATE_OPTIONS varchar(256) Yes NULL
TABLE_COMMENT text Yes NULL

No index defined!

TABLESPACES

Column Type Null Default Comments
TABLESPACE_NAME varchar(64) No
ENGINE varchar(64) No
TABLESPACE_TYPE varchar(64) Yes
LOGFILE_GROUP_NAME varchar(64) Yes
EXTENT_SIZE bigint(21) Yes
AUTOEXTEND_SIZE bigint(21) Yes
MAXIMUM_SIZE bigint(21) Yes
NODEGROUP_ID bigint(21) Yes
TABLESPACE_COMMENT varchar(2048) Yes

No index defined!

TABLE_CONSTRAINTS

Column Type Null Default Comments
CONSTRAINT_CATALOG varchar(64) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) Yes NULL
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
CONSTRAINT_TYPE varchar(11) No
ENFORCED varchar(3) No

No index defined!

TABLE_PRIVILEGES

Column Type Null Default Comments
GRANTEE varchar(292) No
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
PRIVILEGE_TYPE varchar(64) No
IS_GRANTABLE varchar(3) No

No index defined!

TRIGGERS

Column Type Null Default Comments
TRIGGER_CATALOG varchar(64) No
TRIGGER_SCHEMA varchar(64) No
TRIGGER_NAME varchar(64) No
EVENT_MANIPULATION enum('INSERT', 'UPDATE', 'DELETE') No
EVENT_OBJECT_CATALOG varchar(64) No
EVENT_OBJECT_SCHEMA varchar(64) No
EVENT_OBJECT_TABLE varchar(64) No
ACTION_ORDER int(10) No
ACTION_CONDITION binary(0) Yes NULL
ACTION_STATEMENT longtext No
ACTION_ORIENTATION varchar(3) No
ACTION_TIMING enum('BEFORE', 'AFTER') No
ACTION_REFERENCE_OLD_TABLE binary(0) Yes NULL
ACTION_REFERENCE_NEW_TABLE binary(0) Yes NULL
ACTION_REFERENCE_OLD_ROW varchar(3) No
ACTION_REFERENCE_NEW_ROW varchar(3) No
CREATED timestamp(2) No
SQL_MODE set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'NOT_USED_9', 'NOT_USED_10', 'NOT_USED_11', 'NOT_USED_12', 'NOT_USED_13', 'NOT_USED_14', 'NOT_USED_15', 'NOT_USED_16', 'NOT_USED_17', 'NOT_USED_18', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ALLOW_INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NOT_USED_29', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'TIME_TRUNCATE_FRACTIONAL') No
DEFINER varchar(288) No
CHARACTER_SET_CLIENT varchar(64) No
COLLATION_CONNECTION varchar(64) No
DATABASE_COLLATION varchar(64) No

No index defined!

USER_PRIVILEGES

Column Type Null Default Comments
GRANTEE varchar(292) No
TABLE_CATALOG varchar(512) No
PRIVILEGE_TYPE varchar(64) No
IS_GRANTABLE varchar(3) No

No index defined!

VIEWS

Column Type Null Default Comments
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
VIEW_DEFINITION longtext Yes NULL
CHECK_OPTION enum('NONE', 'LOCAL', 'CASCADED') Yes NULL
IS_UPDATABLE enum('NO', 'YES') Yes NULL
DEFINER varchar(288) Yes NULL
SECURITY_TYPE varchar(7) Yes NULL
CHARACTER_SET_CLIENT varchar(64) No
COLLATION_CONNECTION varchar(64) No

No index defined!

VIEW_ROUTINE_USAGE

Column Type Null Default Comments
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
SPECIFIC_CATALOG varchar(64) No
SPECIFIC_SCHEMA varchar(64) No
SPECIFIC_NAME varchar(64) No

No index defined!

VIEW_TABLE_USAGE

Column Type Null Default Comments
VIEW_CATALOG varchar(64) No
VIEW_SCHEMA varchar(64) No
VIEW_NAME varchar(64) No
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No

No index defined!