Skip to content

Instantly share code, notes, and snippets.

@pawlos
Last active October 28, 2016 19:48
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save pawlos/a520762d6f0e65156dabda06b05478ed to your computer and use it in GitHub Desktop.
All the columns in all the tables - rosa_meltroso'/**/union/**/SELECT/**/table_name,COLUMN_NAME/**/FROM/**/INFORMATION_SCHEMA.COLUMNS#
CHARACTER_SETS CHARACTER_SET_NAME
CHARACTER_SETS DEFAULT_COLLATE_NAME
CHARACTER_SETS DESCRIPTION
CHARACTER_SETS MAXLEN
COLLATIONS COLLATION_NAME
COLLATIONS CHARACTER_SET_NAME
COLLATIONS ID
COLLATIONS IS_DEFAULT
COLLATIONS IS_COMPILED
COLLATIONS SORTLEN
COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME
COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME
COLUMNS TABLE_CATALOG
COLUMNS TABLE_SCHEMA
COLUMNS TABLE_NAME
COLUMNS COLUMN_NAME
COLUMNS ORDINAL_POSITION
COLUMNS COLUMN_DEFAULT
COLUMNS IS_NULLABLE
COLUMNS DATA_TYPE
COLUMNS CHARACTER_MAXIMUM_LENGTH
COLUMNS CHARACTER_OCTET_LENGTH
COLUMNS NUMERIC_PRECISION
COLUMNS NUMERIC_SCALE
COLUMNS DATETIME_PRECISION
COLUMNS CHARACTER_SET_NAME
COLUMNS COLLATION_NAME
COLUMNS COLUMN_TYPE
COLUMNS COLUMN_KEY
COLUMNS EXTRA
COLUMNS PRIVILEGES
COLUMNS COLUMN_COMMENT
COLUMNS GENERATION_EXPRESSION
COLUMN_PRIVILEGES GRANTEE
COLUMN_PRIVILEGES TABLE_CATALOG
COLUMN_PRIVILEGES TABLE_SCHEMA
COLUMN_PRIVILEGES TABLE_NAME
COLUMN_PRIVILEGES COLUMN_NAME
COLUMN_PRIVILEGES PRIVILEGE_TYPE
COLUMN_PRIVILEGES IS_GRANTABLE
ENGINES ENGINE
ENGINES SUPPORT
ENGINES COMMENT
ENGINES TRANSACTIONS
ENGINES XA
ENGINES SAVEPOINTS
EVENTS EVENT_CATALOG
EVENTS EVENT_SCHEMA
EVENTS EVENT_NAME
EVENTS DEFINER
EVENTS TIME_ZONE
EVENTS EVENT_BODY
EVENTS EVENT_DEFINITION
EVENTS EVENT_TYPE
EVENTS EXECUTE_AT
EVENTS INTERVAL_VALUE
EVENTS INTERVAL_FIELD
EVENTS SQL_MODE
EVENTS STARTS
EVENTS ENDS
EVENTS STATUS
EVENTS ON_COMPLETION
EVENTS CREATED
EVENTS LAST_ALTERED
EVENTS LAST_EXECUTED
EVENTS EVENT_COMMENT
EVENTS ORIGINATOR
EVENTS CHARACTER_SET_CLIENT
EVENTS COLLATION_CONNECTION
EVENTS DATABASE_COLLATION
FILES FILE_ID
FILES FILE_NAME
FILES FILE_TYPE
FILES TABLESPACE_NAME
FILES TABLE_CATALOG
FILES TABLE_SCHEMA
FILES TABLE_NAME
FILES LOGFILE_GROUP_NAME
FILES LOGFILE_GROUP_NUMBER
FILES ENGINE
FILES FULLTEXT_KEYS
FILES DELETED_ROWS
FILES UPDATE_COUNT
FILES FREE_EXTENTS
FILES TOTAL_EXTENTS
FILES EXTENT_SIZE
FILES INITIAL_SIZE
FILES MAXIMUM_SIZE
FILES AUTOEXTEND_SIZE
FILES CREATION_TIME
FILES LAST_UPDATE_TIME
FILES LAST_ACCESS_TIME
FILES RECOVER_TIME
FILES TRANSACTION_COUNTER
FILES VERSION
FILES ROW_FORMAT
FILES TABLE_ROWS
FILES AVG_ROW_LENGTH
FILES DATA_LENGTH
FILES MAX_DATA_LENGTH
FILES INDEX_LENGTH
FILES DATA_FREE
FILES CREATE_TIME
FILES UPDATE_TIME
FILES CHECK_TIME
FILES CHECKSUM
FILES STATUS
FILES EXTRA
GLOBAL_STATUS VARIABLE_NAME
GLOBAL_STATUS VARIABLE_VALUE
GLOBAL_VARIABLES VARIABLE_NAME
GLOBAL_VARIABLES VARIABLE_VALUE
KEY_COLUMN_USAGE CONSTRAINT_CATALOG
KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
KEY_COLUMN_USAGE CONSTRAINT_NAME
KEY_COLUMN_USAGE TABLE_CATALOG
KEY_COLUMN_USAGE TABLE_SCHEMA
KEY_COLUMN_USAGE TABLE_NAME
KEY_COLUMN_USAGE COLUMN_NAME
KEY_COLUMN_USAGE ORDINAL_POSITION
KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT
KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA
KEY_COLUMN_USAGE REFERENCED_TABLE_NAME
KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME
OPTIMIZER_TRACE QUERY
OPTIMIZER_TRACE TRACE
OPTIMIZER_TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE
OPTIMIZER_TRACE INSUFFICIENT_PRIVILEGES
PARAMETERS SPECIFIC_CATALOG
PARAMETERS SPECIFIC_SCHEMA
PARAMETERS SPECIFIC_NAME
PARAMETERS ORDINAL_POSITION
PARAMETERS PARAMETER_MODE
PARAMETERS PARAMETER_NAME
PARAMETERS DATA_TYPE
PARAMETERS CHARACTER_MAXIMUM_LENGTH
PARAMETERS CHARACTER_OCTET_LENGTH
PARAMETERS NUMERIC_PRECISION
PARAMETERS NUMERIC_SCALE
PARAMETERS DATETIME_PRECISION
PARAMETERS CHARACTER_SET_NAME
PARAMETERS COLLATION_NAME
PARAMETERS DTD_IDENTIFIER
PARAMETERS ROUTINE_TYPE
PARTITIONS TABLE_CATALOG
PARTITIONS TABLE_SCHEMA
PARTITIONS TABLE_NAME
PARTITIONS PARTITION_NAME
PARTITIONS SUBPARTITION_NAME
PARTITIONS PARTITION_ORDINAL_POSITION
PARTITIONS SUBPARTITION_ORDINAL_POSITION
PARTITIONS PARTITION_METHOD
PARTITIONS SUBPARTITION_METHOD
PARTITIONS PARTITION_EXPRESSION
PARTITIONS SUBPARTITION_EXPRESSION
PARTITIONS PARTITION_DESCRIPTION
PARTITIONS TABLE_ROWS
PARTITIONS AVG_ROW_LENGTH
PARTITIONS DATA_LENGTH
PARTITIONS MAX_DATA_LENGTH
PARTITIONS INDEX_LENGTH
PARTITIONS DATA_FREE
PARTITIONS CREATE_TIME
PARTITIONS UPDATE_TIME
PARTITIONS CHECK_TIME
PARTITIONS CHECKSUM
PARTITIONS PARTITION_COMMENT
PARTITIONS NODEGROUP
PARTITIONS TABLESPACE_NAME
PLUGINS PLUGIN_NAME
PLUGINS PLUGIN_VERSION
PLUGINS PLUGIN_STATUS
PLUGINS PLUGIN_TYPE
PLUGINS PLUGIN_TYPE_VERSION
PLUGINS PLUGIN_LIBRARY
PLUGINS PLUGIN_LIBRARY_VERSION
PLUGINS PLUGIN_AUTHOR
PLUGINS PLUGIN_DESCRIPTION
PLUGINS PLUGIN_LICENSE
PLUGINS LOAD_OPTION
PROCESSLIST ID
PROCESSLIST USER
PROCESSLIST HOST
PROCESSLIST DB
PROCESSLIST COMMAND
PROCESSLIST TIME
PROCESSLIST STATE
PROCESSLIST INFO
PROFILING QUERY_ID
PROFILING SEQ
PROFILING STATE
PROFILING DURATION
PROFILING CPU_USER
PROFILING CPU_SYSTEM
PROFILING CONTEXT_VOLUNTARY
PROFILING CONTEXT_INVOLUNTARY
PROFILING BLOCK_OPS_IN
PROFILING BLOCK_OPS_OUT
PROFILING MESSAGES_SENT
PROFILING MESSAGES_RECEIVED
PROFILING PAGE_FAULTS_MAJOR
PROFILING PAGE_FAULTS_MINOR
PROFILING SWAPS
PROFILING SOURCE_FUNCTION
PROFILING SOURCE_FILE
PROFILING SOURCE_LINE
REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME
REFERENTIAL_CONSTRAINTS MATCH_OPTION
REFERENTIAL_CONSTRAINTS UPDATE_RULE
REFERENTIAL_CONSTRAINTS DELETE_RULE
REFERENTIAL_CONSTRAINTS TABLE_NAME
REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME
ROUTINES SPECIFIC_NAME
ROUTINES ROUTINE_CATALOG
ROUTINES ROUTINE_SCHEMA
ROUTINES ROUTINE_NAME
ROUTINES ROUTINE_TYPE
ROUTINES DATA_TYPE
ROUTINES CHARACTER_MAXIMUM_LENGTH
ROUTINES CHARACTER_OCTET_LENGTH
ROUTINES NUMERIC_PRECISION
ROUTINES NUMERIC_SCALE
ROUTINES DATETIME_PRECISION
ROUTINES CHARACTER_SET_NAME
ROUTINES COLLATION_NAME
ROUTINES DTD_IDENTIFIER
ROUTINES ROUTINE_BODY
ROUTINES ROUTINE_DEFINITION
ROUTINES EXTERNAL_NAME
ROUTINES EXTERNAL_LANGUAGE
ROUTINES PARAMETER_STYLE
ROUTINES IS_DETERMINISTIC
ROUTINES SQL_DATA_ACCESS
ROUTINES SQL_PATH
ROUTINES SECURITY_TYPE
ROUTINES CREATED
ROUTINES LAST_ALTERED
ROUTINES SQL_MODE
ROUTINES ROUTINE_COMMENT
ROUTINES DEFINER
ROUTINES CHARACTER_SET_CLIENT
ROUTINES COLLATION_CONNECTION
ROUTINES DATABASE_COLLATION
SCHEMATA CATALOG_NAME
SCHEMATA SCHEMA_NAME
SCHEMATA DEFAULT_CHARACTER_SET_NAME
SCHEMATA DEFAULT_COLLATION_NAME
SCHEMATA SQL_PATH
SCHEMA_PRIVILEGES GRANTEE
SCHEMA_PRIVILEGES TABLE_CATALOG
SCHEMA_PRIVILEGES TABLE_SCHEMA
SCHEMA_PRIVILEGES PRIVILEGE_TYPE
SCHEMA_PRIVILEGES IS_GRANTABLE
SESSION_STATUS VARIABLE_NAME
SESSION_STATUS VARIABLE_VALUE
SESSION_VARIABLES VARIABLE_NAME
SESSION_VARIABLES VARIABLE_VALUE
STATISTICS TABLE_CATALOG
STATISTICS TABLE_SCHEMA
STATISTICS TABLE_NAME
STATISTICS NON_UNIQUE
STATISTICS INDEX_SCHEMA
STATISTICS INDEX_NAME
STATISTICS SEQ_IN_INDEX
STATISTICS COLUMN_NAME
STATISTICS COLLATION
STATISTICS CARDINALITY
STATISTICS SUB_PART
STATISTICS PACKED
STATISTICS NULLABLE
STATISTICS INDEX_TYPE
STATISTICS COMMENT
STATISTICS INDEX_COMMENT
TABLES TABLE_CATALOG
TABLES TABLE_SCHEMA
TABLES TABLE_NAME
TABLES TABLE_TYPE
TABLES ENGINE
TABLES VERSION
TABLES ROW_FORMAT
TABLES TABLE_ROWS
TABLES AVG_ROW_LENGTH
TABLES DATA_LENGTH
TABLES MAX_DATA_LENGTH
TABLES INDEX_LENGTH
TABLES DATA_FREE
TABLES AUTO_INCREMENT
TABLES CREATE_TIME
TABLES UPDATE_TIME
TABLES CHECK_TIME
TABLES TABLE_COLLATION
TABLES CHECKSUM
TABLES CREATE_OPTIONS
TABLES TABLE_COMMENT
TABLESPACES TABLESPACE_NAME
TABLESPACES ENGINE
TABLESPACES TABLESPACE_TYPE
TABLESPACES LOGFILE_GROUP_NAME
TABLESPACES EXTENT_SIZE
TABLESPACES AUTOEXTEND_SIZE
TABLESPACES MAXIMUM_SIZE
TABLESPACES NODEGROUP_ID
TABLESPACES TABLESPACE_COMMENT
TABLE_CONSTRAINTS CONSTRAINT_CATALOG
TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
TABLE_CONSTRAINTS CONSTRAINT_NAME
TABLE_CONSTRAINTS TABLE_SCHEMA
TABLE_CONSTRAINTS TABLE_NAME
TABLE_CONSTRAINTS CONSTRAINT_TYPE
TABLE_PRIVILEGES GRANTEE
TABLE_PRIVILEGES TABLE_CATALOG
TABLE_PRIVILEGES TABLE_SCHEMA
TABLE_PRIVILEGES TABLE_NAME
TABLE_PRIVILEGES PRIVILEGE_TYPE
TABLE_PRIVILEGES IS_GRANTABLE
TRIGGERS TRIGGER_CATALOG
TRIGGERS TRIGGER_SCHEMA
TRIGGERS TRIGGER_NAME
TRIGGERS EVENT_MANIPULATION
TRIGGERS EVENT_OBJECT_CATALOG
TRIGGERS EVENT_OBJECT_SCHEMA
TRIGGERS EVENT_OBJECT_TABLE
TRIGGERS ACTION_ORDER
TRIGGERS ACTION_CONDITION
TRIGGERS ACTION_STATEMENT
TRIGGERS ACTION_ORIENTATION
TRIGGERS ACTION_TIMING
TRIGGERS ACTION_REFERENCE_OLD_TABLE
TRIGGERS ACTION_REFERENCE_NEW_TABLE
TRIGGERS ACTION_REFERENCE_OLD_ROW
TRIGGERS ACTION_REFERENCE_NEW_ROW
TRIGGERS CREATED
TRIGGERS SQL_MODE
TRIGGERS DEFINER
TRIGGERS CHARACTER_SET_CLIENT
TRIGGERS COLLATION_CONNECTION
TRIGGERS DATABASE_COLLATION
USER_PRIVILEGES GRANTEE
USER_PRIVILEGES TABLE_CATALOG
USER_PRIVILEGES PRIVILEGE_TYPE
USER_PRIVILEGES IS_GRANTABLE
VIEWS TABLE_CATALOG
VIEWS TABLE_SCHEMA
VIEWS TABLE_NAME
VIEWS VIEW_DEFINITION
VIEWS CHECK_OPTION
VIEWS IS_UPDATABLE
VIEWS DEFINER
VIEWS SECURITY_TYPE
VIEWS CHARACTER_SET_CLIENT
VIEWS COLLATION_CONNECTION
INNODB_LOCKS lock_id
INNODB_LOCKS lock_trx_id
INNODB_LOCKS lock_mode
INNODB_LOCKS lock_type
INNODB_LOCKS lock_table
INNODB_LOCKS lock_index
INNODB_LOCKS lock_space
INNODB_LOCKS lock_page
INNODB_LOCKS lock_rec
INNODB_LOCKS lock_data
INNODB_TRX trx_id
INNODB_TRX trx_state
INNODB_TRX trx_started
INNODB_TRX trx_requested_lock_id
INNODB_TRX trx_wait_started
INNODB_TRX trx_weight
INNODB_TRX trx_mysql_thread_id
INNODB_TRX trx_query
INNODB_TRX trx_operation_state
INNODB_TRX trx_tables_in_use
INNODB_TRX trx_tables_locked
INNODB_TRX trx_lock_structs
INNODB_TRX trx_lock_memory_bytes
INNODB_TRX trx_rows_locked
INNODB_TRX trx_rows_modified
INNODB_TRX trx_concurrency_tickets
INNODB_TRX trx_isolation_level
INNODB_TRX trx_unique_checks
INNODB_TRX trx_foreign_key_checks
INNODB_TRX trx_last_foreign_key_error
INNODB_TRX trx_adaptive_hash_latched
INNODB_TRX trx_adaptive_hash_timeout
INNODB_TRX trx_is_read_only
INNODB_TRX trx_autocommit_non_locking
INNODB_SYS_DATAFILES SPACE
INNODB_SYS_DATAFILES PATH
INNODB_FT_CONFIG KEY
INNODB_FT_CONFIG VALUE
INNODB_SYS_VIRTUAL TABLE_ID
INNODB_SYS_VIRTUAL POS
INNODB_SYS_VIRTUAL BASE_POS
INNODB_CMP page_size
INNODB_CMP compress_ops
INNODB_CMP compress_ops_ok
INNODB_CMP compress_time
INNODB_CMP uncompress_ops
INNODB_CMP uncompress_time
INNODB_FT_BEING_DELETED DOC_ID
INNODB_CMP_RESET page_size
INNODB_CMP_RESET compress_ops
INNODB_CMP_RESET compress_ops_ok
INNODB_CMP_RESET compress_time
INNODB_CMP_RESET uncompress_ops
INNODB_CMP_RESET uncompress_time
INNODB_CMP_PER_INDEX database_name
INNODB_CMP_PER_INDEX table_name
INNODB_CMP_PER_INDEX index_name
INNODB_CMP_PER_INDEX compress_ops
INNODB_CMP_PER_INDEX compress_ops_ok
INNODB_CMP_PER_INDEX compress_time
INNODB_CMP_PER_INDEX uncompress_ops
INNODB_CMP_PER_INDEX uncompress_time
INNODB_CMPMEM_RESET page_size
INNODB_CMPMEM_RESET buffer_pool_instance
INNODB_CMPMEM_RESET pages_used
INNODB_CMPMEM_RESET pages_free
INNODB_CMPMEM_RESET relocation_ops
INNODB_CMPMEM_RESET relocation_time
INNODB_FT_DELETED DOC_ID
INNODB_BUFFER_PAGE_LRU POOL_ID
INNODB_BUFFER_PAGE_LRU LRU_POSITION
INNODB_BUFFER_PAGE_LRU SPACE
INNODB_BUFFER_PAGE_LRU PAGE_NUMBER
INNODB_BUFFER_PAGE_LRU PAGE_TYPE
INNODB_BUFFER_PAGE_LRU FLUSH_TYPE
INNODB_BUFFER_PAGE_LRU FIX_COUNT
INNODB_BUFFER_PAGE_LRU IS_HASHED
INNODB_BUFFER_PAGE_LRU NEWEST_MODIFICATION
INNODB_BUFFER_PAGE_LRU OLDEST_MODIFICATION
INNODB_BUFFER_PAGE_LRU ACCESS_TIME
INNODB_BUFFER_PAGE_LRU TABLE_NAME
INNODB_BUFFER_PAGE_LRU INDEX_NAME
INNODB_BUFFER_PAGE_LRU NUMBER_RECORDS
INNODB_BUFFER_PAGE_LRU DATA_SIZE
INNODB_BUFFER_PAGE_LRU COMPRESSED_SIZE
INNODB_BUFFER_PAGE_LRU COMPRESSED
INNODB_BUFFER_PAGE_LRU IO_FIX
INNODB_BUFFER_PAGE_LRU IS_OLD
INNODB_BUFFER_PAGE_LRU FREE_PAGE_CLOCK
INNODB_LOCK_WAITS requesting_trx_id
INNODB_LOCK_WAITS requested_lock_id
INNODB_LOCK_WAITS blocking_trx_id
INNODB_LOCK_WAITS blocking_lock_id
INNODB_TEMP_TABLE_INFO TABLE_ID
INNODB_TEMP_TABLE_INFO NAME
INNODB_TEMP_TABLE_INFO N_COLS
INNODB_TEMP_TABLE_INFO SPACE
INNODB_TEMP_TABLE_INFO PER_TABLE_TABLESPACE
INNODB_TEMP_TABLE_INFO IS_COMPRESSED
INNODB_SYS_INDEXES INDEX_ID
INNODB_SYS_INDEXES NAME
INNODB_SYS_INDEXES TABLE_ID
INNODB_SYS_INDEXES TYPE
INNODB_SYS_INDEXES N_FIELDS
INNODB_SYS_INDEXES PAGE_NO
INNODB_SYS_INDEXES SPACE
INNODB_SYS_INDEXES MERGE_THRESHOLD
INNODB_SYS_TABLES TABLE_ID
INNODB_SYS_TABLES NAME
INNODB_SYS_TABLES FLAG
INNODB_SYS_TABLES N_COLS
INNODB_SYS_TABLES SPACE
INNODB_SYS_TABLES FILE_FORMAT
INNODB_SYS_TABLES ROW_FORMAT
INNODB_SYS_TABLES ZIP_PAGE_SIZE
INNODB_SYS_TABLES SPACE_TYPE
INNODB_SYS_FIELDS INDEX_ID
INNODB_SYS_FIELDS NAME
INNODB_SYS_FIELDS POS
INNODB_CMP_PER_INDEX_RESET database_name
INNODB_CMP_PER_INDEX_RESET table_name
INNODB_CMP_PER_INDEX_RESET index_name
INNODB_CMP_PER_INDEX_RESET compress_ops
INNODB_CMP_PER_INDEX_RESET compress_ops_ok
INNODB_CMP_PER_INDEX_RESET compress_time
INNODB_CMP_PER_INDEX_RESET uncompress_ops
INNODB_CMP_PER_INDEX_RESET uncompress_time
INNODB_BUFFER_PAGE POOL_ID
INNODB_BUFFER_PAGE BLOCK_ID
INNODB_BUFFER_PAGE SPACE
INNODB_BUFFER_PAGE PAGE_NUMBER
INNODB_BUFFER_PAGE PAGE_TYPE
INNODB_BUFFER_PAGE FLUSH_TYPE
INNODB_BUFFER_PAGE FIX_COUNT
INNODB_BUFFER_PAGE IS_HASHED
INNODB_BUFFER_PAGE NEWEST_MODIFICATION
INNODB_BUFFER_PAGE OLDEST_MODIFICATION
INNODB_BUFFER_PAGE ACCESS_TIME
INNODB_BUFFER_PAGE TABLE_NAME
INNODB_BUFFER_PAGE INDEX_NAME
INNODB_BUFFER_PAGE NUMBER_RECORDS
INNODB_BUFFER_PAGE DATA_SIZE
INNODB_BUFFER_PAGE COMPRESSED_SIZE
INNODB_BUFFER_PAGE PAGE_STATE
INNODB_BUFFER_PAGE IO_FIX
INNODB_BUFFER_PAGE IS_OLD
INNODB_BUFFER_PAGE FREE_PAGE_CLOCK
INNODB_FT_DEFAULT_STOPWORD value
INNODB_FT_INDEX_TABLE WORD
INNODB_FT_INDEX_TABLE FIRST_DOC_ID
INNODB_FT_INDEX_TABLE LAST_DOC_ID
INNODB_FT_INDEX_TABLE DOC_COUNT
INNODB_FT_INDEX_TABLE DOC_ID
INNODB_FT_INDEX_TABLE POSITION
INNODB_FT_INDEX_CACHE WORD
INNODB_FT_INDEX_CACHE FIRST_DOC_ID
INNODB_FT_INDEX_CACHE LAST_DOC_ID
INNODB_FT_INDEX_CACHE DOC_COUNT
INNODB_FT_INDEX_CACHE DOC_ID
INNODB_FT_INDEX_CACHE POSITION
INNODB_SYS_TABLESPACES SPACE
INNODB_SYS_TABLESPACES NAME
INNODB_SYS_TABLESPACES FLAG
INNODB_SYS_TABLESPACES FILE_FORMAT
INNODB_SYS_TABLESPACES ROW_FORMAT
INNODB_SYS_TABLESPACES PAGE_SIZE
INNODB_SYS_TABLESPACES ZIP_PAGE_SIZE
INNODB_SYS_TABLESPACES SPACE_TYPE
INNODB_SYS_TABLESPACES FS_BLOCK_SIZE
INNODB_SYS_TABLESPACES FILE_SIZE
INNODB_SYS_TABLESPACES ALLOCATED_SIZE
INNODB_METRICS NAME
INNODB_METRICS SUBSYSTEM
INNODB_METRICS COUNT
INNODB_METRICS MAX_COUNT
INNODB_METRICS MIN_COUNT
INNODB_METRICS AVG_COUNT
INNODB_METRICS COUNT_RESET
INNODB_METRICS MAX_COUNT_RESET
INNODB_METRICS MIN_COUNT_RESET
INNODB_METRICS AVG_COUNT_RESET
INNODB_METRICS TIME_ENABLED
INNODB_METRICS TIME_DISABLED
INNODB_METRICS TIME_ELAPSED
INNODB_METRICS TIME_RESET
INNODB_METRICS STATUS
INNODB_METRICS TYPE
INNODB_METRICS COMMENT
INNODB_SYS_FOREIGN_COLS ID
INNODB_SYS_FOREIGN_COLS FOR_COL_NAME
INNODB_SYS_FOREIGN_COLS REF_COL_NAME
INNODB_SYS_FOREIGN_COLS POS
INNODB_CMPMEM page_size
INNODB_CMPMEM buffer_pool_instance
INNODB_CMPMEM pages_used
INNODB_CMPMEM pages_free
INNODB_CMPMEM relocation_ops
INNODB_CMPMEM relocation_time
INNODB_BUFFER_POOL_STATS POOL_ID
INNODB_BUFFER_POOL_STATS POOL_SIZE
INNODB_BUFFER_POOL_STATS FREE_BUFFERS
INNODB_BUFFER_POOL_STATS DATABASE_PAGES
INNODB_BUFFER_POOL_STATS OLD_DATABASE_PAGES
INNODB_BUFFER_POOL_STATS MODIFIED_DATABASE_PAGES
INNODB_BUFFER_POOL_STATS PENDING_DECOMPRESS
INNODB_BUFFER_POOL_STATS PENDING_READS
INNODB_BUFFER_POOL_STATS PENDING_FLUSH_LRU
INNODB_BUFFER_POOL_STATS PENDING_FLUSH_LIST
INNODB_BUFFER_POOL_STATS PAGES_MADE_YOUNG
INNODB_BUFFER_POOL_STATS PAGES_NOT_MADE_YOUNG
INNODB_BUFFER_POOL_STATS PAGES_MADE_YOUNG_RATE
INNODB_BUFFER_POOL_STATS PAGES_MADE_NOT_YOUNG_RATE
INNODB_BUFFER_POOL_STATS NUMBER_PAGES_READ
INNODB_BUFFER_POOL_STATS NUMBER_PAGES_CREATED
INNODB_BUFFER_POOL_STATS NUMBER_PAGES_WRITTEN
INNODB_BUFFER_POOL_STATS PAGES_READ_RATE
INNODB_BUFFER_POOL_STATS PAGES_CREATE_RATE
INNODB_BUFFER_POOL_STATS PAGES_WRITTEN_RATE
INNODB_BUFFER_POOL_STATS NUMBER_PAGES_GET
INNODB_BUFFER_POOL_STATS HIT_RATE
INNODB_BUFFER_POOL_STATS YOUNG_MAKE_PER_THOUSAND_GETS
INNODB_BUFFER_POOL_STATS NOT_YOUNG_MAKE_PER_THOUSAND_GETS
INNODB_BUFFER_POOL_STATS NUMBER_PAGES_READ_AHEAD
INNODB_BUFFER_POOL_STATS NUMBER_READ_AHEAD_EVICTED
INNODB_BUFFER_POOL_STATS READ_AHEAD_RATE
INNODB_BUFFER_POOL_STATS READ_AHEAD_EVICTED_RATE
INNODB_BUFFER_POOL_STATS LRU_IO_TOTAL
INNODB_BUFFER_POOL_STATS LRU_IO_CURRENT
INNODB_BUFFER_POOL_STATS UNCOMPRESS_TOTAL
INNODB_BUFFER_POOL_STATS UNCOMPRESS_CURRENT
INNODB_SYS_COLUMNS TABLE_ID
INNODB_SYS_COLUMNS NAME
INNODB_SYS_COLUMNS POS
INNODB_SYS_COLUMNS MTYPE
INNODB_SYS_COLUMNS PRTYPE
INNODB_SYS_COLUMNS LEN
INNODB_SYS_FOREIGN ID
INNODB_SYS_FOREIGN FOR_NAME
INNODB_SYS_FOREIGN REF_NAME
INNODB_SYS_FOREIGN N_COLS
INNODB_SYS_FOREIGN TYPE
INNODB_SYS_TABLESTATS TABLE_ID
INNODB_SYS_TABLESTATS NAME
INNODB_SYS_TABLESTATS STATS_INITIALIZED
INNODB_SYS_TABLESTATS NUM_ROWS
INNODB_SYS_TABLESTATS CLUST_INDEX_SIZE
INNODB_SYS_TABLESTATS OTHER_INDEX_SIZE
INNODB_SYS_TABLESTATS MODIFIED_COUNTER
INNODB_SYS_TABLESTATS AUTOINC
INNODB_SYS_TABLESTATS REF_COUNT
users id
users username
users password
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment