将文件拖动至此

SQL upload ( 0 ) x-

服务器: localhost »数据库: information_schema
页面相关设置点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 : 用时 :
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
1
information_schema
{"j_tabs":{"information_schema.ALL_PLUGINS":0,"information_schema.APPLICABLE_ROLES":0,"information_schema.CHANGED_PAGE_BITMAPS":0,"information_schema.CHARACTER_SETS":0,"information_schema.CLIENT_STATISTICS":0,"information_schema.COLLATIONS":0,"information_schema.COLLATION_CHARACTER_SET_APPLICABILITY":0,"information_schema.COLUMNS":0,"information_schema.COLUMN_PRIVILEGES":0,"information_schema.ENABLED_ROLES":0,"information_schema.ENGINES":0,"information_schema.EVENTS":0,"information_schema.FILES":0,"information_schema.GEOMETRY_COLUMNS":0,"information_schema.GLOBAL_STATUS":0,"information_schema.GLOBAL_VARIABLES":0,"information_schema.INDEX_STATISTICS":0,"information_schema.INNODB_BUFFER_PAGE":0,"information_schema.INNODB_BUFFER_PAGE_LRU":0,"information_schema.INNODB_BUFFER_POOL_STATS":0,"information_schema.INNODB_CHANGED_PAGES":0,"information_schema.INNODB_CMP":0,"information_schema.INNODB_CMPMEM":0,"information_schema.INNODB_CMPMEM_RESET":0,"information_schema.INNODB_CMP_PER_INDEX":0,"information_schema.INNODB_CMP_PER_INDEX_RESET":0,"information_schema.INNODB_CMP_RESET":0,"information_schema.INNODB_FT_BEING_DELETED":0,"information_schema.INNODB_FT_CONFIG":0,"information_schema.INNODB_FT_DEFAULT_STOPWORD":0,"information_schema.INNODB_FT_DELETED":0,"information_schema.INNODB_FT_INDEX_CACHE":0,"information_schema.INNODB_FT_INDEX_TABLE":0,"information_schema.INNODB_LOCKS":0,"information_schema.INNODB_LOCK_WAITS":0,"information_schema.INNODB_METRICS":0,"information_schema.INNODB_MUTEXES":0,"information_schema.INNODB_SYS_COLUMNS":0,"information_schema.INNODB_SYS_DATAFILES":0,"information_schema.INNODB_SYS_FIELDS":0,"information_schema.INNODB_SYS_FOREIGN":0,"information_schema.INNODB_SYS_FOREIGN_COLS":0,"information_schema.INNODB_SYS_INDEXES":0,"information_schema.INNODB_SYS_SEMAPHORE_WAITS":0,"information_schema.INNODB_SYS_TABLES":0,"information_schema.INNODB_SYS_TABLESPACES":0,"information_schema.INNODB_SYS_TABLESTATS":0,"information_schema.INNODB_TABLESPACES_ENCRYPTION":0,"information_schema.INNODB_TABLESPACES_SCRUBBING":0,"information_schema.INNODB_TRX":0,"information_schema.KEY_CACHES":0,"information_schema.KEY_COLUMN_USAGE":0,"information_schema.PARAMETERS":0,"information_schema.PARTITIONS":0,"information_schema.PLUGINS":0,"information_schema.PROCESSLIST":0,"information_schema.PROFILING":0,"information_schema.REFERENTIAL_CONSTRAINTS":0,"information_schema.ROUTINES":0,"information_schema.SCHEMATA":0,"information_schema.SCHEMA_PRIVILEGES":0,"information_schema.SESSION_STATUS":0,"information_schema.SESSION_VARIABLES":0,"information_schema.SPATIAL_REF_SYS":0,"information_schema.STATISTICS":0,"information_schema.SYSTEM_VARIABLES":0,"information_schema.TABLES":0,"information_schema.TABLESPACES":0,"information_schema.TABLE_CONSTRAINTS":0,"information_schema.TABLE_PRIVILEGES":0,"information_schema.TABLE_STATISTICS":0,"information_schema.TRIGGERS":0,"information_schema.USER_PRIVILEGES":0,"information_schema.USER_STATISTICS":0,"information_schema.VIEWS":0,"information_schema.XTRADB_INTERNAL_HASH_TABLES":0,"information_schema.XTRADB_READ_VIEW":0,"information_schema.XTRADB_RSEG":0},"h_tabs":{"information_schema.ALL_PLUGINS":1,"information_schema.APPLICABLE_ROLES":1,"information_schema.CHANGED_PAGE_BITMAPS":1,"information_schema.CHARACTER_SETS":1,"information_schema.CLIENT_STATISTICS":1,"information_schema.COLLATIONS":1,"information_schema.COLLATION_CHARACTER_SET_APPLICABILITY":1,"information_schema.COLUMNS":1,"information_schema.COLUMN_PRIVILEGES":1,"information_schema.ENABLED_ROLES":1,"information_schema.ENGINES":1,"information_schema.EVENTS":1,"information_schema.FILES":1,"information_schema.GEOMETRY_COLUMNS":1,"information_schema.GLOBAL_STATUS":1,"information_schema.GLOBAL_VARIABLES":1,"information_schema.INDEX_STATISTICS":1,"information_schema.INNODB_BUFFER_PAGE":1,"information_schema.INNODB_BUFFER_PAGE_LRU":1,"information_schema.INNODB_BUFFER_POOL_STATS":1,"information_schema.INNODB_CHANGED_PAGES":1,"information_schema.INNODB_CMP":1,"information_schema.INNODB_CMPMEM":1,"information_schema.INNODB_CMPMEM_RESET":1,"information_schema.INNODB_CMP_PER_INDEX":1,"information_schema.INNODB_CMP_PER_INDEX_RESET":1,"information_schema.INNODB_CMP_RESET":1,"information_schema.INNODB_FT_BEING_DELETED":1,"information_schema.INNODB_FT_CONFIG":1,"information_schema.INNODB_FT_DEFAULT_STOPWORD":1,"information_schema.INNODB_FT_DELETED":1,"information_schema.INNODB_FT_INDEX_CACHE":1,"information_schema.INNODB_FT_INDEX_TABLE":1,"information_schema.INNODB_LOCKS":1,"information_schema.INNODB_LOCK_WAITS":1,"information_schema.INNODB_METRICS":1,"information_schema.INNODB_MUTEXES":1,"information_schema.INNODB_SYS_COLUMNS":1,"information_schema.INNODB_SYS_DATAFILES":1,"information_schema.INNODB_SYS_FIELDS":1,"information_schema.INNODB_SYS_FOREIGN":1,"information_schema.INNODB_SYS_FOREIGN_COLS":1,"information_schema.INNODB_SYS_INDEXES":1,"information_schema.INNODB_SYS_SEMAPHORE_WAITS":1,"information_schema.INNODB_SYS_TABLES":1,"information_schema.INNODB_SYS_TABLESPACES":1,"information_schema.INNODB_SYS_TABLESTATS":1,"information_schema.INNODB_TABLESPACES_ENCRYPTION":1,"information_schema.INNODB_TABLESPACES_SCRUBBING":1,"information_schema.INNODB_TRX":1,"information_schema.KEY_CACHES":1,"information_schema.KEY_COLUMN_USAGE":1,"information_schema.PARAMETERS":1,"information_schema.PARTITIONS":1,"information_schema.PLUGINS":1,"information_schema.PROCESSLIST":1,"information_schema.PROFILING":1,"information_schema.REFERENTIAL_CONSTRAINTS":1,"information_schema.ROUTINES":1,"information_schema.SCHEMATA":1,"information_schema.SCHEMA_PRIVILEGES":1,"information_schema.SESSION_STATUS":1,"information_schema.SESSION_VARIABLES":1,"information_schema.SPATIAL_REF_SYS":1,"information_schema.STATISTICS":1,"information_schema.SYSTEM_VARIABLES":1,"information_schema.TABLES":1,"information_schema.TABLESPACES":1,"information_schema.TABLE_CONSTRAINTS":1,"information_schema.TABLE_PRIVILEGES":1,"information_schema.TABLE_STATISTICS":1,"information_schema.TRIGGERS":1,"information_schema.USER_PRIVILEGES":1,"information_schema.USER_STATISTICS":1,"information_schema.VIEWS":1,"information_schema.XTRADB_INTERNAL_HASH_TABLES":1,"information_schema.XTRADB_READ_VIEW":1,"information_schema.XTRADB_RSEG":1}}
[{"":{"information_schema.CHARACTER_SETS":{"DEFAULT_COLLATE_NAME":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.COLLATIONS":{"CHARACTER_SET_NAME":["information_schema.CHARACTER_SETS","CHARACTER_SET_NAME"]}}},{"":{"information_schema.COLLATION_CHARACTER_SET_APPLICABILITY":{"CHARACTER_SET_NAME":["information_schema.CHARACTER_SETS","CHARACTER_SET_NAME"]}}},{"":{"information_schema.COLLATION_CHARACTER_SET_APPLICABILITY":{"COLLATION_NAME":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.COLUMNS":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.COLUMNS":{"CHARACTER_SET_NAME":["information_schema.CHARACTER_SETS","CHARACTER_SET_NAME"]}}},{"":{"information_schema.COLUMNS":{"COLLATION_NAME":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.COLUMN_PRIVILEGES":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.EVENTS":{"EVENT_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.EVENTS":{"CHARACTER_SET_CLIENT":["information_schema.CHARACTER_SETS","CHARACTER_SET_NAME"]}}},{"":{"information_schema.EVENTS":{"COLLATION_CONNECTION":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.EVENTS":{"DATABASE_COLLATION":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.FILES":{"TABLESPACE_NAME":["information_schema.TABLESPACES","TABLESPACE_NAME"]}}},{"":{"information_schema.FILES":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.FILES":{"COLLATION_CONNECTION":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.FILES":{"ENGINE":["information_schema.ENGINES","ENGINE"]}}},{"":{"information_schema.KEY_COLUMN_USAGE":{"CONSTRAINT_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.KEY_COLUMN_USAGE":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.KEY_COLUMN_USAGE":{"REFERENCED_TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.PARAMETERS":{"SPECIFIC_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.PARAMETERS":{"CHARACTER_SET_NAME":["information_schema.CHARACTER_SETS","CHARACTER_SET_NAME"]}}},{"":{"information_schema.PARAMETERS":{"COLLATION_NAME":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.PARTITIONS":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.PARTITIONS":{"TABLESPACE_NAME":["information_schema.TABLESPACES","TABLESPACE_NAME"]}}},{"":{"information_schema.PROCESSLIST":{"DB":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.REFERENTIAL_CONSTRAINTS":{"CONSTRAINT_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.REFERENTIAL_CONSTRAINTS":{"UNIQUE_CONSTRAINT_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.ROUTINES":{"ROUTINE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.ROUTINES":{"CHARACTER_SET_NAME":["information_schema.CHARACTER_SETS","CHARACTER_SET_NAME"]}}},{"":{"information_schema.ROUTINES":{"COLLATION_NAME":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.ROUTINES":{"CHARACTER_SET_CLIENT":["information_schema.CHARACTER_SETS","CHARACTER_SET_NAME"]}}},{"":{"information_schema.ROUTINES":{"COLLATION_CONNECTION":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.ROUTINES":{"DATABASE_COLLATION":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.SCHEMATA":{"DEFAULT_CHARACTER_SET_NAME":["information_schema.CHARACTER_SETS","CHARACTER_SET_NAME"]}}},{"":{"information_schema.SCHEMATA":{"DEFAULT_COLLATION_NAME":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.SCHEMA_PRIVILEGES":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.STATISTICS":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.STATISTICS":{"INDEX_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.TABLES":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.TABLES":{"TABLE_COLLATION":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.TABLES":{"ENGINE":["information_schema.ENGINES","ENGINE"]}}},{"":{"information_schema.TABLE_CONSTRAINTS":{"CONSTRAINT_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.TABLE_CONSTRAINTS":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.TABLE_PRIVILEGES":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.TRIGGERS":{"TRIGGER_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.TRIGGERS":{"EVENT_OBJECT_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.TRIGGERS":{"CHARACTER_SET_CLIENT":["information_schema.CHARACTER_SETS","CHARACTER_SET_NAME"]}}},{"":{"information_schema.TRIGGERS":{"COLLATION_CONNECTION":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.TRIGGERS":{"DATABASE_COLLATION":["information_schema.COLLATIONS","COLLATION_NAME"]}}},{"":{"information_schema.VIEWS":{"TABLE_SCHEMA":["information_schema.SCHEMATA","SCHEMA_NAME"]}}},{"":{"information_schema.VIEWS":{"CHARACTER_SET_CLIENT":["information_schema.CHARACTER_SETS","CHARACTER_SET_NAME"]}}},{"":{"information_schema.VIEWS":{"COLLATION_CONNECTION":["information_schema.COLLATIONS","COLLATION_NAME"]}}}]
{"ALL_PLUGINS":"PLUGIN_NAME","APPLICABLE_ROLES":"GRANTEE","CHARACTER_SETS":"DESCRIPTION","CLIENT_STATISTICS":"CLIENT","COLLATIONS":"COLLATION_NAME","COLLATION_CHARACTER_SET_APPLICABILITY":"COLLATION_NAME","COLUMNS":"TABLE_CATALOG","COLUMN_PRIVILEGES":"GRANTEE","ENABLED_ROLES":"ROLE_NAME","ENGINES":"ENGINE","EVENTS":"EVENT_CATALOG","FILES":"FILE_NAME","GEOMETRY_COLUMNS":"F_TABLE_CATALOG","GLOBAL_STATUS":"VARIABLE_NAME","GLOBAL_VARIABLES":"VARIABLE_NAME","INDEX_STATISTICS":"TABLE_SCHEMA","INNODB_BUFFER_PAGE":"PAGE_TYPE","INNODB_BUFFER_PAGE_LRU":"PAGE_TYPE","INNODB_CMP_PER_INDEX":"database_name","INNODB_CMP_PER_INDEX_RESET":"database_name","INNODB_FT_CONFIG":"KEY","INNODB_FT_DEFAULT_STOPWORD":"value","INNODB_FT_INDEX_CACHE":"WORD","INNODB_FT_INDEX_TABLE":"WORD","INNODB_LOCKS":"lock_id","INNODB_LOCK_WAITS":"requesting_trx_id","INNODB_METRICS":"NAME","INNODB_MUTEXES":"NAME","INNODB_SYS_COLUMNS":"NAME","INNODB_SYS_DATAFILES":"PATH","INNODB_SYS_FIELDS":"NAME","INNODB_SYS_FOREIGN":"ID","INNODB_SYS_FOREIGN_COLS":"ID","INNODB_SYS_INDEXES":"NAME","INNODB_SYS_SEMAPHORE_WAITS":"OBJECT_NAME","INNODB_SYS_TABLES":"NAME","INNODB_SYS_TABLESPACES":"NAME","INNODB_SYS_TABLESTATS":"NAME","INNODB_TABLESPACES_ENCRYPTION":"NAME","INNODB_TABLESPACES_SCRUBBING":"NAME","INNODB_TRX":"trx_id","KEY_CACHES":"KEY_CACHE_NAME","KEY_COLUMN_USAGE":"CONSTRAINT_CATALOG","PARAMETERS":"SPECIFIC_CATALOG","PARTITIONS":"TABLE_CATALOG","PLUGINS":"PLUGIN_NAME","PROCESSLIST":"USER","PROFILING":"STATE","REFERENTIAL_CONSTRAINTS":"CONSTRAINT_CATALOG","ROUTINES":"SPECIFIC_NAME","SCHEMATA":"CATALOG_NAME","SCHEMA_PRIVILEGES":"GRANTEE","SESSION_STATUS":"VARIABLE_NAME","SESSION_VARIABLES":"VARIABLE_NAME","SPATIAL_REF_SYS":"AUTH_NAME","STATISTICS":"TABLE_CATALOG","SYSTEM_VARIABLES":"VARIABLE_NAME","TABLES":"TABLE_COMMENT","TABLESPACES":"TABLESPACE_NAME","TABLE_CONSTRAINTS":"CONSTRAINT_CATALOG","TABLE_PRIVILEGES":"GRANTEE","TABLE_STATISTICS":"TABLE_SCHEMA","TRIGGERS":"TRIGGER_CATALOG","USER_PRIVILEGES":"GRANTEE","USER_STATISTICS":"USER","VIEWS":"TABLE_CATALOG","XTRADB_INTERNAL_HASH_TABLES":"INTERNAL_HASH_TABLE_NAME","XTRADB_READ_VIEW":"READ_VIEW_LOW_LIMIT_TRX_NUMBER"}
-1
1
v Show/Hide tables list 全屏查看 规则连接 / 直接连接 对齐网格 v 全部收缩/展开 反向收缩/展开 Toggle relationship lines 生成查询 > 移动菜单 > Pin text
v information_schema ALL_PLUGINS
* PLUGIN_NAME : varchar(64)
* PLUGIN_VERSION : varchar(20)
* PLUGIN_STATUS : varchar(16)
* PLUGIN_TYPE : varchar(80)
* PLUGIN_TYPE_VERSION : varchar(20)
* PLUGIN_LIBRARY : varchar(64)
* PLUGIN_LIBRARY_VERSION : varchar(20)
* PLUGIN_AUTHOR : varchar(64)
* PLUGIN_DESCRIPTION : longtext
* PLUGIN_LICENSE : varchar(80)
* LOAD_OPTION : varchar(64)
* PLUGIN_MATURITY : varchar(12)
* PLUGIN_AUTH_VERSION : varchar(80)
v information_schema APPLICABLE_ROLES
* GRANTEE : varchar(190)
* ROLE_NAME : varchar(128)
* IS_GRANTABLE : varchar(3)
* IS_DEFAULT : varchar(3)
v information_schema CHANGED_PAGE_BITMAPS
* dummy : bigint(21) unsigned
v information_schema CHARACTER_SETS
* CHARACTER_SET_NAME : varchar(32)
* DEFAULT_COLLATE_NAME : varchar(32)
* DESCRIPTION : varchar(60)
* MAXLEN : bigint(3)
v information_schema CLIENT_STATISTICS
* CLIENT : varchar(64)
* TOTAL_CONNECTIONS : bigint(21)
* CONCURRENT_CONNECTIONS : bigint(21)
* CONNECTED_TIME : bigint(21)
* BUSY_TIME : double
* CPU_TIME : double
* BYTES_RECEIVED : bigint(21)
* BYTES_SENT : bigint(21)
* BINLOG_BYTES_WRITTEN : bigint(21)
* ROWS_READ : bigint(21)
* ROWS_SENT : bigint(21)
* ROWS_DELETED : bigint(21)
* ROWS_INSERTED : bigint(21)
* ROWS_UPDATED : bigint(21)
* SELECT_COMMANDS : bigint(21)
* UPDATE_COMMANDS : bigint(21)
* OTHER_COMMANDS : bigint(21)
* COMMIT_TRANSACTIONS : bigint(21)
* ROLLBACK_TRANSACTIONS : bigint(21)
* DENIED_CONNECTIONS : bigint(21)
* LOST_CONNECTIONS : bigint(21)
* ACCESS_DENIED : bigint(21)
* EMPTY_QUERIES : bigint(21)
* TOTAL_SSL_CONNECTIONS : bigint(21) unsigned
* MAX_STATEMENT_TIME_EXCEEDED : bigint(21)
v information_schema COLLATIONS
* COLLATION_NAME : varchar(32)
* CHARACTER_SET_NAME : varchar(32)
* ID : bigint(11)
* IS_DEFAULT : varchar(3)
* IS_COMPILED : varchar(3)
* SORTLEN : bigint(3)
v information_schema COLLATION_CHARACTER_SET_APPLICABILITY
* COLLATION_NAME : varchar(32)
* CHARACTER_SET_NAME : varchar(32)
v information_schema COLUMNS
* TABLE_CATALOG : varchar(512)
* TABLE_SCHEMA : varchar(64)
* TABLE_NAME : varchar(64)
* COLUMN_NAME : varchar(64)
* ORDINAL_POSITION : bigint(21) unsigned
* COLUMN_DEFAULT : longtext
* IS_NULLABLE : varchar(3)
* DATA_TYPE : varchar(64)
* CHARACTER_MAXIMUM_LENGTH : bigint(21) unsigned
* CHARACTER_OCTET_LENGTH : bigint(21) unsigned
* NUMERIC_PRECISION : bigint(21) unsigned
* NUMERIC_SCALE : bigint(21) unsigned
* DATETIME_PRECISION : bigint(21) unsigned
* CHARACTER_SET_NAME : varchar(32)
* COLLATION_NAME : varchar(32)
* COLUMN_TYPE : longtext
* COLUMN_KEY : varchar(3)
* EXTRA : varchar(27)
* PRIVILEGES : varchar(80)
* COLUMN_COMMENT : varchar(1024)
v information_schema COLUMN_PRIVILEGES
* GRANTEE : varchar(190)
* TABLE_CATALOG : varchar(512)
* TABLE_SCHEMA : varchar(64)
* TABLE_NAME : varchar(64)
* COLUMN_NAME : varchar(64)
* PRIVILEGE_TYPE : varchar(64)
* IS_GRANTABLE : varchar(3)
v information_schema ENABLED_ROLES
* ROLE_NAME : varchar(128)
v information_schema ENGINES
* ENGINE : varchar(64)
* SUPPORT : varchar(8)
* COMMENT : varchar(160)
* TRANSACTIONS : varchar(3)
* XA : varchar(3)
* SAVEPOINTS : varchar(3)
v information_schema EVENTS
* EVENT_CATALOG : varchar(64)
* EVENT_SCHEMA : varchar(64)
* EVENT_NAME : varchar(64)
* DEFINER : varchar(189)
* TIME_ZONE : varchar(64)
* EVENT_BODY : varchar(8)
* EVENT_DEFINITION : longtext
* EVENT_TYPE : varchar(9)
* EXECUTE_AT : datetime
* INTERVAL_VALUE : varchar(256)
* INTERVAL_FIELD : varchar(18)
* SQL_MODE : varchar(8192)
* STARTS : datetime
* ENDS : datetime
* STATUS : varchar(18)
* ON_COMPLETION : varchar(12)
* CREATED : datetime
* LAST_ALTERED : datetime
* LAST_EXECUTED : datetime
* EVENT_COMMENT : varchar(64)
* ORIGINATOR : bigint(10)
* CHARACTER_SET_CLIENT : varchar(32)
* COLLATION_CONNECTION : varchar(32)
* DATABASE_COLLATION : varchar(32)
v information_schema FILES
* FILE_ID : bigint(4)
* FILE_NAME : varchar(64)
* FILE_TYPE : varchar(20)
* TABLESPACE_NAME : varchar(64)
* TABLE_CATALOG : varchar(64)
* TABLE_SCHEMA : varchar(64)
* TABLE_NAME : varchar(64)
* LOGFILE_GROUP_NAME : varchar(64)
* LOGFILE_GROUP_NUMBER : bigint(4)
* ENGINE : varchar(64)
* FULLTEXT_KEYS : varchar(64)
* DELETED_ROWS : bigint(4)
* UPDATE_COUNT : bigint(4)
* FREE_EXTENTS : bigint(4)
* TOTAL_EXTENTS : bigint(4)
* EXTENT_SIZE : bigint(4)
* INITIAL_SIZE : bigint(21) unsigned
* MAXIMUM_SIZE : bigint(21) unsigned
* AUTOEXTEND_SIZE : bigint(21) unsigned
* CREATION_TIME : datetime
* LAST_UPDATE_TIME : datetime
* LAST_ACCESS_TIME : datetime
* RECOVER_TIME : bigint(4)
* TRANSACTION_COUNTER : bigint(4)
* VERSION : bigint(21) unsigned
* ROW_FORMAT : varchar(10)
* TABLE_ROWS : bigint(21) unsigned
* AVG_ROW_LENGTH : bigint(21) unsigned
* DATA_LENGTH : bigint(21) unsigned
* MAX_DATA_LENGTH : bigint(21) unsigned
* INDEX_LENGTH : bigint(21) unsigned
* DATA_FREE : bigint(21) unsigned
* CREATE_TIME : datetime
* UPDATE_TIME : datetime
* CHECK_TIME : datetime
* CHECKSUM : bigint(21) unsigned
* STATUS : varchar(20)
* EXTRA : varchar(255)
v information_schema GEOMETRY_COLUMNS
* F_TABLE_CATALOG : varchar(512)
* F_TABLE_SCHEMA : varchar(64)
* F_TABLE_NAME : varchar(64)
* F_GEOMETRY_COLUMN : varchar(64)
* G_TABLE_CATALOG : varchar(512)
* G_TABLE_SCHEMA : varchar(64)
* G_TABLE_NAME : varchar(64)
* G_GEOMETRY_COLUMN : varchar(64)
* STORAGE_TYPE : tinyint(2)
* GEOMETRY_TYPE : int(7)
* COORD_DIMENSION : tinyint(2)
* MAX_PPR : tinyint(2)
* SRID : smallint(5)
v information_schema GLOBAL_STATUS
* VARIABLE_NAME : varchar(64)
* VARIABLE_VALUE : varchar(2048)
v information_schema GLOBAL_VARIABLES
* VARIABLE_NAME : varchar(64)
* VARIABLE_VALUE : varchar(2048)
v information_schema INDEX_STATISTICS
* TABLE_SCHEMA : varchar(192)
* TABLE_NAME : varchar(192)
* INDEX_NAME : varchar(192)
* ROWS_READ : bigint(21)
v information_schema INNODB_BUFFER_PAGE
* POOL_ID : bigint(21) unsigned
* BLOCK_ID : bigint(21) unsigned
* SPACE : bigint(21) unsigned
* PAGE_NUMBER : bigint(21) unsigned
* PAGE_TYPE : varchar(64)
* FLUSH_TYPE : bigint(21) unsigned
* FIX_COUNT : bigint(21) unsigned
* IS_HASHED : varchar(3)
* NEWEST_MODIFICATION : bigint(21) unsigned
* OLDEST_MODIFICATION : bigint(21) unsigned
* ACCESS_TIME : bigint(21) unsigned
* TABLE_NAME : varchar(1024)
* INDEX_NAME : varchar(1024)
* NUMBER_RECORDS : bigint(21) unsigned
* DATA_SIZE : bigint(21) unsigned
* COMPRESSED_SIZE : bigint(21) unsigned
* PAGE_STATE : varchar(64)
* IO_FIX : varchar(64)
* IS_OLD : varchar(3)
* FREE_PAGE_CLOCK : bigint(21) unsigned
v information_schema INNODB_BUFFER_PAGE_LRU
* POOL_ID : bigint(21) unsigned
* LRU_POSITION : bigint(21) unsigned
* SPACE : bigint(21) unsigned
* PAGE_NUMBER : bigint(21) unsigned
* PAGE_TYPE : varchar(64)
* FLUSH_TYPE : bigint(21) unsigned
* FIX_COUNT : bigint(21) unsigned
* IS_HASHED : varchar(3)
* NEWEST_MODIFICATION : bigint(21) unsigned
* OLDEST_MODIFICATION : bigint(21) unsigned
* ACCESS_TIME : bigint(21) unsigned
* TABLE_NAME : varchar(1024)
* INDEX_NAME : varchar(1024)
* NUMBER_RECORDS : bigint(21) unsigned
* DATA_SIZE : bigint(21) unsigned
* COMPRESSED_SIZE : bigint(21) unsigned
* COMPRESSED : varchar(3)
* IO_FIX : varchar(64)
* IS_OLD : varchar(3)
* FREE_PAGE_CLOCK : bigint(21) unsigned
v information_schema INNODB_BUFFER_POOL_STATS
* POOL_ID : bigint(21) unsigned
* POOL_SIZE : bigint(21) unsigned
* FREE_BUFFERS : bigint(21) unsigned
* DATABASE_PAGES : bigint(21) unsigned
* OLD_DATABASE_PAGES : bigint(21) unsigned
* MODIFIED_DATABASE_PAGES : bigint(21) unsigned
* PENDING_DECOMPRESS : bigint(21) unsigned
* PENDING_READS : bigint(21) unsigned
* PENDING_FLUSH_LRU : bigint(21) unsigned
* PENDING_FLUSH_LIST : bigint(21) unsigned
* PAGES_MADE_YOUNG : bigint(21) unsigned
* PAGES_NOT_MADE_YOUNG : bigint(21) unsigned
* PAGES_MADE_YOUNG_RATE : double
* PAGES_MADE_NOT_YOUNG_RATE : double
* NUMBER_PAGES_READ : bigint(21) unsigned
* NUMBER_PAGES_CREATED : bigint(21) unsigned
* NUMBER_PAGES_WRITTEN : bigint(21) unsigned
* PAGES_READ_RATE : double
* PAGES_CREATE_RATE : double
* PAGES_WRITTEN_RATE : double
* NUMBER_PAGES_GET : bigint(21) unsigned
* HIT_RATE : bigint(21) unsigned
* YOUNG_MAKE_PER_THOUSAND_GETS : bigint(21) unsigned
* NOT_YOUNG_MAKE_PER_THOUSAND_GETS : bigint(21) unsigned
* NUMBER_PAGES_READ_AHEAD : bigint(21) unsigned
* NUMBER_READ_AHEAD_EVICTED : bigint(21) unsigned
* READ_AHEAD_RATE : double
* READ_AHEAD_EVICTED_RATE : double
* LRU_IO_TOTAL : bigint(21) unsigned
* LRU_IO_CURRENT : bigint(21) unsigned
* UNCOMPRESS_TOTAL : bigint(21) unsigned
* UNCOMPRESS_CURRENT : bigint(21) unsigned
v information_schema INNODB_CHANGED_PAGES
* space_id : int(11) unsigned
* page_id : int(11) unsigned
* start_lsn : bigint(21) unsigned
* end_lsn : bigint(21) unsigned
v information_schema INNODB_CMP
* page_size : int(5)
* compress_ops : int(11)
* compress_ops_ok : int(11)
* compress_time : int(11)
* uncompress_ops : int(11)
* uncompress_time : int(11)
v information_schema INNODB_CMPMEM
* page_size : int(5)
* buffer_pool_instance : int(11)
* pages_used : int(11)
* pages_free : int(11)
* relocation_ops : bigint(21)
* relocation_time : int(11)
v information_schema INNODB_CMPMEM_RESET
* page_size : int(5)
* buffer_pool_instance : int(11)
* pages_used : int(11)
* pages_free : int(11)
* relocation_ops : bigint(21)
* relocation_time : int(11)
v information_schema INNODB_CMP_PER_INDEX
* database_name : varchar(192)
* table_name : varchar(192)
* index_name : varchar(192)
* compress_ops : int(11)
* compress_ops_ok : int(11)
* compress_time : int(11)
* uncompress_ops : int(11)
* uncompress_time : int(11)
v information_schema INNODB_CMP_PER_INDEX_RESET
* database_name : varchar(192)
* table_name : varchar(192)
* index_name : varchar(192)
* compress_ops : int(11)
* compress_ops_ok : int(11)
* compress_time : int(11)
* uncompress_ops : int(11)
* uncompress_time : int(11)
v information_schema INNODB_CMP_RESET
* page_size : int(5)
* compress_ops : int(11)
* compress_ops_ok : int(11)
* compress_time : int(11)
* uncompress_ops : int(11)
* uncompress_time : int(11)
v information_schema INNODB_FT_BEING_DELETED
* DOC_ID : bigint(21) unsigned
v information_schema INNODB_FT_CONFIG
* KEY : varchar(193)
* VALUE : varchar(193)
v information_schema INNODB_FT_DEFAULT_STOPWORD
* value : varchar(18)
v information_schema INNODB_FT_DELETED
* DOC_ID : bigint(21) unsigned
v information_schema INNODB_FT_INDEX_CACHE
* WORD : varchar(337)
* FIRST_DOC_ID : bigint(21) unsigned
* LAST_DOC_ID : bigint(21) unsigned
* DOC_COUNT : bigint(21) unsigned
* DOC_ID : bigint(21) unsigned
* POSITION : bigint(21) unsigned
v information_schema INNODB_FT_INDEX_TABLE
* WORD : varchar(337)
* FIRST_DOC_ID : bigint(21) unsigned
* LAST_DOC_ID : bigint(21) unsigned
* DOC_COUNT : bigint(21) unsigned
* DOC_ID : bigint(21) unsigned
* POSITION : bigint(21) unsigned
v information_schema INNODB_LOCKS
* lock_id : varchar(81)
* lock_trx_id : varchar(18)
* lock_mode : varchar(32)
* lock_type : varchar(32)
* lock_table : varchar(1024)
* lock_index : varchar(1024)
* lock_space : bigint(21) unsigned
* lock_page : bigint(21) unsigned
* lock_rec : bigint(21) unsigned
* lock_data : varchar(8192)
v information_schema INNODB_LOCK_WAITS
* requesting_trx_id : varchar(18)
* requested_lock_id : varchar(81)
* blocking_trx_id : varchar(18)
* blocking_lock_id : varchar(81)
v information_schema INNODB_METRICS
* NAME : varchar(193)
* SUBSYSTEM : varchar(193)
* COUNT : bigint(21)
* MAX_COUNT : bigint(21)
* MIN_COUNT : bigint(21)
* AVG_COUNT : double
* COUNT_RESET : bigint(21)
* MAX_COUNT_RESET : bigint(21)
* MIN_COUNT_RESET : bigint(21)
* AVG_COUNT_RESET : double
* TIME_ENABLED : datetime
* TIME_DISABLED : datetime
* TIME_ELAPSED : bigint(21)
* TIME_RESET : datetime
* STATUS : varchar(193)
* TYPE : varchar(193)
* COMMENT : varchar(193)
v information_schema INNODB_MUTEXES
* NAME : varchar(4000)
* CREATE_FILE : varchar(4000)
* CREATE_LINE : int(11) unsigned
* OS_WAITS : bigint(21) unsigned
v information_schema INNODB_SYS_COLUMNS
* TABLE_ID : bigint(21) unsigned
* NAME : varchar(193)
* POS : bigint(21) unsigned
* MTYPE : int(11)
* PRTYPE : int(11)
* LEN : int(11)
v information_schema INNODB_SYS_DATAFILES
* SPACE : int(11) unsigned
* PATH : varchar(4000)
v information_schema INNODB_SYS_FIELDS
* INDEX_ID : bigint(21) unsigned
* NAME : varchar(193)
* POS : int(11) unsigned
v information_schema INNODB_SYS_FOREIGN
* ID : varchar(193)
* FOR_NAME : varchar(193)
* REF_NAME : varchar(193)
* N_COLS : int(11) unsigned
* TYPE : int(11) unsigned
v information_schema INNODB_SYS_FOREIGN_COLS
* ID : varchar(193)
* FOR_COL_NAME : varchar(193)
* REF_COL_NAME : varchar(193)
* POS : int(11) unsigned
v information_schema INNODB_SYS_INDEXES
* INDEX_ID : bigint(21) unsigned
* NAME : varchar(193)
* TABLE_ID : bigint(21) unsigned
* TYPE : int(11)
* N_FIELDS : int(11)
* PAGE_NO : int(11)
* SPACE : int(11)
v information_schema INNODB_SYS_SEMAPHORE_WAITS
* THREAD_ID : bigint(21) unsigned
* OBJECT_NAME : varchar(4000)
* FILE : varchar(4000)
* LINE : int(11) unsigned
* WAIT_TIME : bigint(21) unsigned
* WAIT_OBJECT : bigint(21) unsigned
* WAIT_TYPE : varchar(16)
* HOLDER_THREAD_ID : bigint(21) unsigned
* HOLDER_FILE : varchar(4000)
* HOLDER_LINE : int(11) unsigned
* CREATED_FILE : varchar(4000)
* CREATED_LINE : int(11) unsigned
* WRITER_THREAD : bigint(21) unsigned
* RESERVATION_MODE : varchar(16)
* READERS : int(11) unsigned
* WAITERS_FLAG : bigint(21) unsigned
* LOCK_WORD : bigint(21) unsigned
* LAST_READER_FILE : varchar(4000)
* LAST_READER_LINE : int(11) unsigned
* LAST_WRITER_FILE : varchar(4000)
* LAST_WRITER_LINE : int(11) unsigned
* OS_WAIT_COUNT : int(11) unsigned
v information_schema INNODB_SYS_TABLES
* TABLE_ID : bigint(21) unsigned
* NAME : varchar(655)
* FLAG : int(11)
* N_COLS : int(11)
* SPACE : int(11)
* FILE_FORMAT : varchar(10)
* ROW_FORMAT : varchar(12)
* ZIP_PAGE_SIZE : int(11) unsigned
v information_schema INNODB_SYS_TABLESPACES
* SPACE : int(11) unsigned
* NAME : varchar(655)
* FLAG : int(11) unsigned
* FILE_FORMAT : varchar(10)
* ROW_FORMAT : varchar(22)
* PAGE_SIZE : int(11) unsigned
* ZIP_PAGE_SIZE : int(11) unsigned
v information_schema INNODB_SYS_TABLESTATS
* TABLE_ID : bigint(21) unsigned
* NAME : varchar(193)
* STATS_INITIALIZED : varchar(193)
* NUM_ROWS : bigint(21) unsigned
* CLUST_INDEX_SIZE : bigint(21) unsigned
* OTHER_INDEX_SIZE : bigint(21) unsigned
* MODIFIED_COUNTER : bigint(21) unsigned
* AUTOINC : bigint(21) unsigned
* REF_COUNT : int(11)
v information_schema INNODB_TABLESPACES_ENCRYPTION
* SPACE : int(11) unsigned
* NAME : varchar(655)
* ENCRYPTION_SCHEME : int(11) unsigned
* KEYSERVER_REQUESTS : int(11) unsigned
* MIN_KEY_VERSION : int(11) unsigned
* CURRENT_KEY_VERSION : int(11) unsigned
* KEY_ROTATION_PAGE_NUMBER : bigint(21) unsigned
* KEY_ROTATION_MAX_PAGE_NUMBER : bigint(21) unsigned
* CURRENT_KEY_ID : int(11) unsigned
* ROTATING_OR_FLUSHING : int(1) unsigned
v information_schema INNODB_TABLESPACES_SCRUBBING
* SPACE : bigint(21) unsigned
* NAME : varchar(655)
* COMPRESSED : int(11) unsigned
* LAST_SCRUB_COMPLETED : datetime
* CURRENT_SCRUB_STARTED : datetime
* CURRENT_SCRUB_ACTIVE_THREADS : int(11) unsigned
* CURRENT_SCRUB_PAGE_NUMBER : bigint(21) unsigned
* CURRENT_SCRUB_MAX_PAGE_NUMBER : bigint(21) unsigned
v information_schema INNODB_TRX
* trx_id : varchar(18)
* trx_state : varchar(13)
* trx_started : datetime
* trx_requested_lock_id : varchar(81)
* trx_wait_started : datetime
* trx_weight : bigint(21) unsigned
* trx_mysql_thread_id : bigint(21) unsigned
* trx_query : varchar(1024)
* trx_operation_state : varchar(64)
* trx_tables_in_use : bigint(21) unsigned
* trx_tables_locked : bigint(21) unsigned
* trx_lock_structs : bigint(21) unsigned
* trx_lock_memory_bytes : bigint(21) unsigned
* trx_rows_locked : bigint(21) unsigned
* trx_rows_modified : bigint(21) unsigned
* trx_concurrency_tickets : bigint(21) unsigned
* trx_isolation_level : varchar(16)
* trx_unique_checks : int(1)
* trx_foreign_key_checks : int(1)
* trx_last_foreign_key_error : varchar(256)
* trx_adaptive_hash_latched : int(1)
* trx_adaptive_hash_timeout : bigint(21) unsigned
* trx_is_read_only : int(1)
* trx_autocommit_non_locking : int(1)
v information_schema KEY_CACHES
* KEY_CACHE_NAME : varchar(192)
* SEGMENTS : int(3) unsigned
* SEGMENT_NUMBER : int(3) unsigned
* FULL_SIZE : bigint(21) unsigned
* BLOCK_SIZE : bigint(21) unsigned
* USED_BLOCKS : bigint(21) unsigned
* UNUSED_BLOCKS : bigint(21) unsigned
* DIRTY_BLOCKS : bigint(21) unsigned
* READ_REQUESTS : bigint(21) unsigned
* READS : bigint(21) unsigned
* WRITE_REQUESTS : bigint(21) unsigned
* WRITES : bigint(21) unsigned
v information_schema KEY_COLUMN_USAGE
* CONSTRAINT_CATALOG : varchar(512)
* CONSTRAINT_SCHEMA : varchar(64)
* CONSTRAINT_NAME : varchar(64)
* TABLE_CATALOG : varchar(512)
* TABLE_SCHEMA : varchar(64)
* TABLE_NAME : varchar(64)
* COLUMN_NAME : varchar(64)
* ORDINAL_POSITION : bigint(10)
* POSITION_IN_UNIQUE_CONSTRAINT : bigint(10)
* REFERENCED_TABLE_SCHEMA : varchar(64)
* REFERENCED_TABLE_NAME : varchar(64)
* REFERENCED_COLUMN_NAME : varchar(64)
v information_schema PARAMETERS
* SPECIFIC_CATALOG : varchar(512)
* SPECIFIC_SCHEMA : varchar(64)
* SPECIFIC_NAME : varchar(64)
* ORDINAL_POSITION : int(21)
* PARAMETER_MODE : varchar(5)
* PARAMETER_NAME : varchar(64)
* DATA_TYPE : varchar(64)
* CHARACTER_MAXIMUM_LENGTH : int(21)
* CHARACTER_OCTET_LENGTH : int(21)
* NUMERIC_PRECISION : int(21)
* NUMERIC_SCALE : int(21)
* DATETIME_PRECISION : bigint(21) unsigned
* CHARACTER_SET_NAME : varchar(64)
* COLLATION_NAME : varchar(64)
* DTD_IDENTIFIER : longtext
* ROUTINE_TYPE : varchar(9)
v information_schema PARTITIONS
* TABLE_CATALOG : varchar(512)
* TABLE_SCHEMA : varchar(64)
* TABLE_NAME : varchar(64)
* PARTITION_NAME : varchar(64)
* SUBPARTITION_NAME : varchar(64)
* PARTITION_ORDINAL_POSITION : bigint(21) unsigned
* SUBPARTITION_ORDINAL_POSITION : bigint(21) unsigned
* PARTITION_METHOD : varchar(18)
* SUBPARTITION_METHOD : varchar(12)
* PARTITION_EXPRESSION : longtext
* SUBPARTITION_EXPRESSION : longtext
* PARTITION_DESCRIPTION : longtext
* TABLE_ROWS : bigint(21) unsigned
* AVG_ROW_LENGTH : bigint(21) unsigned
* DATA_LENGTH : bigint(21) unsigned
* MAX_DATA_LENGTH : bigint(21) unsigned
* INDEX_LENGTH : bigint(21) unsigned
* DATA_FREE : bigint(21) unsigned
* CREATE_TIME : datetime
* UPDATE_TIME : datetime
* CHECK_TIME : datetime
* CHECKSUM : bigint(21) unsigned
* PARTITION_COMMENT : varchar(80)
* NODEGROUP : varchar(12)
* TABLESPACE_NAME : varchar(64)
v information_schema PLUGINS
* PLUGIN_NAME : varchar(64)
* PLUGIN_VERSION : varchar(20)
* PLUGIN_STATUS : varchar(16)
* PLUGIN_TYPE : varchar(80)
* PLUGIN_TYPE_VERSION : varchar(20)
* PLUGIN_LIBRARY : varchar(64)
* PLUGIN_LIBRARY_VERSION : varchar(20)
* PLUGIN_AUTHOR : varchar(64)
* PLUGIN_DESCRIPTION : longtext
* PLUGIN_LICENSE : varchar(80)
* LOAD_OPTION : varchar(64)
* PLUGIN_MATURITY : varchar(12)
* PLUGIN_AUTH_VERSION : varchar(80)
v information_schema PROCESSLIST
* ID : bigint(4)
* USER : varchar(128)
* HOST : varchar(64)
* DB : varchar(64)
* COMMAND : varchar(16)
* TIME : int(7)
* STATE : varchar(64)
* INFO : longtext
* TIME_MS : decimal(22,3)
* STAGE : tinyint(2)
* MAX_STAGE : tinyint(2)
* PROGRESS : decimal(7,3)
* MEMORY_USED : int(7)
* EXAMINED_ROWS : int(7)
* QUERY_ID : bigint(4)
* INFO_BINARY : blob
* TID : bigint(4)
v information_schema PROFILING
* QUERY_ID : int(20)
* SEQ : int(20)
* STATE : varchar(30)
* DURATION : decimal(9,6)
* CPU_USER : decimal(9,6)
* CPU_SYSTEM : decimal(9,6)
* CONTEXT_VOLUNTARY : int(20)
* CONTEXT_INVOLUNTARY : int(20)
* BLOCK_OPS_IN : int(20)
* BLOCK_OPS_OUT : int(20)
* MESSAGES_SENT : int(20)
* MESSAGES_RECEIVED : int(20)
* PAGE_FAULTS_MAJOR : int(20)
* PAGE_FAULTS_MINOR : int(20)
* SWAPS : int(20)
* SOURCE_FUNCTION : varchar(30)
* SOURCE_FILE : varchar(20)
* SOURCE_LINE : int(20)
v information_schema REFERENTIAL_CONSTRAINTS
* CONSTRAINT_CATALOG : varchar(512)
* CONSTRAINT_SCHEMA : varchar(64)
* CONSTRAINT_NAME : varchar(64)
* UNIQUE_CONSTRAINT_CATALOG : varchar(512)
* UNIQUE_CONSTRAINT_SCHEMA : varchar(64)
* UNIQUE_CONSTRAINT_NAME : varchar(64)
* MATCH_OPTION : varchar(64)
* UPDATE_RULE : varchar(64)
* DELETE_RULE : varchar(64)
* TABLE_NAME : varchar(64)
* REFERENCED_TABLE_NAME : varchar(64)
v information_schema ROUTINES
* SPECIFIC_NAME : varchar(64)
* ROUTINE_CATALOG : varchar(512)
* ROUTINE_SCHEMA : varchar(64)
* ROUTINE_NAME : varchar(64)
* ROUTINE_TYPE : varchar(9)
* DATA_TYPE : varchar(64)
* CHARACTER_MAXIMUM_LENGTH : int(21)
* CHARACTER_OCTET_LENGTH : int(21)
* NUMERIC_PRECISION : int(21)
* NUMERIC_SCALE : int(21)
* DATETIME_PRECISION : bigint(21) unsigned
* CHARACTER_SET_NAME : varchar(64)
* COLLATION_NAME : varchar(64)
* DTD_IDENTIFIER : longtext
* ROUTINE_BODY : varchar(8)
* ROUTINE_DEFINITION : longtext
* EXTERNAL_NAME : varchar(64)
* EXTERNAL_LANGUAGE : varchar(64)
* PARAMETER_STYLE : varchar(8)
* IS_DETERMINISTIC : varchar(3)
* SQL_DATA_ACCESS : varchar(64)
* SQL_PATH : varchar(64)
* SECURITY_TYPE : varchar(7)
* CREATED : datetime
* LAST_ALTERED : datetime
* SQL_MODE : varchar(8192)
* ROUTINE_COMMENT : longtext
* DEFINER : varchar(189)
* CHARACTER_SET_CLIENT : varchar(32)
* COLLATION_CONNECTION : varchar(32)
* DATABASE_COLLATION : varchar(32)
v information_schema SCHEMATA
* CATALOG_NAME : varchar(512)
* SCHEMA_NAME : varchar(64)
* DEFAULT_CHARACTER_SET_NAME : varchar(32)
* DEFAULT_COLLATION_NAME : varchar(32)
* SQL_PATH : varchar(512)
v information_schema SCHEMA_PRIVILEGES
* GRANTEE : varchar(190)
* TABLE_CATALOG : varchar(512)
* TABLE_SCHEMA : varchar(64)
* PRIVILEGE_TYPE : varchar(64)
* IS_GRANTABLE : varchar(3)
v information_schema SESSION_STATUS
* VARIABLE_NAME : varchar(64)
* VARIABLE_VALUE : varchar(2048)
v information_schema SESSION_VARIABLES
* VARIABLE_NAME : varchar(64)
* VARIABLE_VALUE : varchar(2048)
v information_schema SPATIAL_REF_SYS
* SRID : smallint(5)
* AUTH_NAME : varchar(512)
* AUTH_SRID : int(5)
* SRTEXT : varchar(2048)
v information_schema STATISTICS
* TABLE_CATALOG : varchar(512)
* TABLE_SCHEMA : varchar(64)
* TABLE_NAME : varchar(64)
* NON_UNIQUE : bigint(1)
* INDEX_SCHEMA : varchar(64)
* INDEX_NAME : varchar(64)
* SEQ_IN_INDEX : bigint(2)
* COLUMN_NAME : varchar(64)
* COLLATION : varchar(1)
* CARDINALITY : bigint(21)
* SUB_PART : bigint(3)
* PACKED : varchar(10)
* NULLABLE : varchar(3)
* INDEX_TYPE : varchar(16)
* COMMENT : varchar(16)
* INDEX_COMMENT : varchar(1024)
v information_schema SYSTEM_VARIABLES
* VARIABLE_NAME : varchar(64)
* SESSION_VALUE : varchar(2048)
* GLOBAL_VALUE : varchar(2048)
* GLOBAL_VALUE_ORIGIN : varchar(64)
* DEFAULT_VALUE : varchar(2048)
* VARIABLE_SCOPE : varchar(64)
* VARIABLE_TYPE : varchar(64)
* VARIABLE_COMMENT : varchar(2048)
* NUMERIC_MIN_VALUE : varchar(21)
* NUMERIC_MAX_VALUE : varchar(21)
* NUMERIC_BLOCK_SIZE : varchar(21)
* ENUM_VALUE_LIST : longtext
* READ_ONLY : varchar(3)
* COMMAND_LINE_ARGUMENT : varchar(64)
v information_schema TABLES
* TABLE_CATALOG : varchar(512)
* TABLE_SCHEMA : varchar(64)
* TABLE_NAME : varchar(64)
* TABLE_TYPE : varchar(64)
* ENGINE : varchar(64)
* VERSION : bigint(21) unsigned
* ROW_FORMAT : varchar(10)
* TABLE_ROWS : bigint(21) unsigned
* AVG_ROW_LENGTH : bigint(21) unsigned
* DATA_LENGTH : bigint(21) unsigned
* MAX_DATA_LENGTH : bigint(21) unsigned
* INDEX_LENGTH : bigint(21) unsigned
* DATA_FREE : bigint(21) unsigned
* AUTO_INCREMENT : bigint(21) unsigned
* CREATE_TIME : datetime
* UPDATE_TIME : datetime
* CHECK_TIME : datetime
* TABLE_COLLATION : varchar(32)
* CHECKSUM : bigint(21) unsigned
* CREATE_OPTIONS : varchar(2048)
* TABLE_COMMENT : varchar(2048)
v information_schema TABLESPACES
* TABLESPACE_NAME : varchar(64)
* ENGINE : varchar(64)
* TABLESPACE_TYPE : varchar(64)
* LOGFILE_GROUP_NAME : varchar(64)
* EXTENT_SIZE : bigint(21) unsigned
* AUTOEXTEND_SIZE : bigint(21) unsigned
* MAXIMUM_SIZE : bigint(21) unsigned
* NODEGROUP_ID : bigint(21) unsigned
* TABLESPACE_COMMENT : varchar(2048)
v information_schema TABLE_CONSTRAINTS
* CONSTRAINT_CATALOG : varchar(512)
* CONSTRAINT_SCHEMA : varchar(64)
* CONSTRAINT_NAME : varchar(64)
* TABLE_SCHEMA : varchar(64)
* TABLE_NAME : varchar(64)
* CONSTRAINT_TYPE : varchar(64)
v information_schema TABLE_PRIVILEGES
* GRANTEE : varchar(190)
* TABLE_CATALOG : varchar(512)
* TABLE_SCHEMA : varchar(64)
* TABLE_NAME : varchar(64)
* PRIVILEGE_TYPE : varchar(64)
* IS_GRANTABLE : varchar(3)
v information_schema TABLE_STATISTICS
* TABLE_SCHEMA : varchar(192)
* TABLE_NAME : varchar(192)
* ROWS_READ : bigint(21)
* ROWS_CHANGED : bigint(21)
* ROWS_CHANGED_X_INDEXES : bigint(21)
v information_schema TRIGGERS
* TRIGGER_CATALOG : varchar(512)
* TRIGGER_SCHEMA : varchar(64)
* TRIGGER_NAME : varchar(64)
* EVENT_MANIPULATION : varchar(6)
* EVENT_OBJECT_CATALOG : varchar(512)
* EVENT_OBJECT_SCHEMA : varchar(64)
* EVENT_OBJECT_TABLE : varchar(64)
* ACTION_ORDER : bigint(4)
* ACTION_CONDITION : longtext
* ACTION_STATEMENT : longtext
* ACTION_ORIENTATION : varchar(9)
* ACTION_TIMING : varchar(6)
* ACTION_REFERENCE_OLD_TABLE : varchar(64)
* ACTION_REFERENCE_NEW_TABLE : varchar(64)
* ACTION_REFERENCE_OLD_ROW : varchar(3)
* ACTION_REFERENCE_NEW_ROW : varchar(3)
* CREATED : datetime
* SQL_MODE : varchar(8192)
* DEFINER : varchar(189)
* CHARACTER_SET_CLIENT : varchar(32)
* COLLATION_CONNECTION : varchar(32)
* DATABASE_COLLATION : varchar(32)
v information_schema USER_PRIVILEGES
* GRANTEE : varchar(190)
* TABLE_CATALOG : varchar(512)
* PRIVILEGE_TYPE : varchar(64)
* IS_GRANTABLE : varchar(3)
v information_schema USER_STATISTICS
* USER : varchar(128)
* TOTAL_CONNECTIONS : int(11)
* CONCURRENT_CONNECTIONS : int(11)
* CONNECTED_TIME : int(11)
* BUSY_TIME : double
* CPU_TIME : double
* BYTES_RECEIVED : bigint(21)
* BYTES_SENT : bigint(21)
* BINLOG_BYTES_WRITTEN : bigint(21)
* ROWS_READ : bigint(21)
* ROWS_SENT : bigint(21)
* ROWS_DELETED : bigint(21)
* ROWS_INSERTED : bigint(21)
* ROWS_UPDATED : bigint(21)
* SELECT_COMMANDS : bigint(21)
* UPDATE_COMMANDS : bigint(21)
* OTHER_COMMANDS : bigint(21)
* COMMIT_TRANSACTIONS : bigint(21)
* ROLLBACK_TRANSACTIONS : bigint(21)
* DENIED_CONNECTIONS : bigint(21)
* LOST_CONNECTIONS : bigint(21)
* ACCESS_DENIED : bigint(21)
* EMPTY_QUERIES : bigint(21)
* TOTAL_SSL_CONNECTIONS : bigint(21) unsigned
* MAX_STATEMENT_TIME_EXCEEDED : bigint(21)
v information_schema VIEWS
* TABLE_CATALOG : varchar(512)
* TABLE_SCHEMA : varchar(64)
* TABLE_NAME : varchar(64)
* VIEW_DEFINITION : longtext
* CHECK_OPTION : varchar(8)
* IS_UPDATABLE : varchar(3)
* DEFINER : varchar(189)
* SECURITY_TYPE : varchar(7)
* CHARACTER_SET_CLIENT : varchar(32)
* COLLATION_CONNECTION : varchar(32)
* ALGORITHM : varchar(10)
v information_schema XTRADB_INTERNAL_HASH_TABLES
* INTERNAL_HASH_TABLE_NAME : varchar(100)
* TOTAL_MEMORY : bigint(21) unsigned
* CONSTANT_MEMORY : bigint(21) unsigned
* VARIABLE_MEMORY : bigint(21) unsigned
v information_schema XTRADB_READ_VIEW
* READ_VIEW_UNDO_NUMBER : bigint(21) unsigned
* READ_VIEW_LOW_LIMIT_TRX_NUMBER : varchar(18)
* READ_VIEW_UPPER_LIMIT_TRX_ID : varchar(18)
* READ_VIEW_LOW_LIMIT_TRX_ID : varchar(18)
v information_schema XTRADB_RSEG
* rseg_id : bigint(21) unsigned
* space_id : bigint(21) unsigned
* zip_size : bigint(21) unsigned
* page_no : bigint(21) unsigned
* max_size : bigint(21) unsigned
* curr_size : bigint(21) unsigned
当前选项