InnoDB INFORMATION SCHEMA tables interface to MySQL. More...

#include "storage/innobase/handler/i_s.h"
#include <field.h>
#include <sql_acl.h>
#include <sql_show.h>
#include <sql_time.h>
#include <sys/types.h>
#include <time.h>
#include "auth_acls.h"
#include "btr0btr.h"
#include "btr0pcur.h"
#include "btr0types.h"
#include "buf0buddy.h"
#include "buf0buf.h"
#include "buf0stats.h"
#include "dict0crea.h"
#include "dict0dd.h"
#include "dict0dict.h"
#include "dict0load.h"
#include "dict0mem.h"
#include "dict0types.h"
#include "fsp0sysspace.h"
#include "fts0opt.h"
#include "fts0priv.h"
#include "fts0types.h"
#include "fut0fut.h"
#include "ha_prototypes.h"
#include "ibuf0ibuf.h"
#include "mysql/plugin.h"
#include "page0zip.h"
#include "pars0pars.h"
#include "sql/sql_class.h"
#include "srv0mon.h"
#include "srv0start.h"
#include "srv0tmp.h"
#include "trx0i_s.h"
#include "trx0trx.h"
#include "ut0new.h"
#include "my_dbug.h"

Classes
struct	buf_page_desc_t
	structure associates a name string with a file page type and/or buffer page state. More...

struct	buf_page_info_t
	This structure defines information we will fetch from pages currently cached in the buffer pool. More...

struct	temp_table_info_t

Macros
#define	OK(expr)

#define	STRUCT_FLD(name, value) value

#define	END_OF_ST_FIELD_INFO

#define	IDX_TRX_ID 0

#define	IDX_TRX_STATE 1

#define	IDX_TRX_STARTED 2

#define	IDX_TRX_REQUESTED_LOCK_ID 3

#define	IDX_TRX_WAIT_STARTED 4

#define	IDX_TRX_WEIGHT 5

#define	IDX_TRX_MYSQL_THREAD_ID 6

#define	IDX_TRX_QUERY 7

#define	IDX_TRX_OPERATION_STATE 8

#define	IDX_TRX_TABLES_IN_USE 9

#define	IDX_TRX_TABLES_LOCKED 10

#define	IDX_TRX_LOCK_STRUCTS 11

#define	IDX_TRX_LOCK_MEMORY_BYTES 12

#define	IDX_TRX_ROWS_LOCKED 13

#define	IDX_TRX_ROWS_MODIFIED 14

#define	IDX_TRX_CONNCURRENCY_TICKETS 15

#define	IDX_TRX_ISOLATION_LEVEL 16

#define	IDX_TRX_UNIQUE_CHECKS 17

#define	IDX_TRX_FOREIGN_KEY_CHECKS 18

#define	IDX_TRX_LAST_FOREIGN_KEY_ERROR 19

#define	IDX_TRX_ADAPTIVE_HASH_LATCHED 20

#define	IDX_TRX_ADAPTIVE_HASH_TIMEOUT 21

#define	IDX_TRX_READ_ONLY 22

#define	IDX_TRX_AUTOCOMMIT_NON_LOCKING 23

#define	IDX_TRX_SCHEDULE_WEIGHT 24

#define	IDX_DATABASE_NAME 0

#define	IDX_TABLE_NAME 1

#define	IDX_INDEX_NAME 2

#define	IDX_COMPRESS_OPS 3

#define	IDX_COMPRESS_OPS_OK 4

#define	IDX_COMPRESS_TIME 5

#define	IDX_UNCOMPRESS_OPS 6

#define	IDX_UNCOMPRESS_TIME 7

#define	METRIC_NAME 0

#define	METRIC_SUBSYS 1

#define	METRIC_VALUE_START 2

#define	METRIC_MAX_VALUE_START 3

#define	METRIC_MIN_VALUE_START 4

#define	METRIC_AVG_VALUE_START 5

#define	METRIC_VALUE_RESET 6

#define	METRIC_MAX_VALUE_RESET 7

#define	METRIC_MIN_VALUE_RESET 8

#define	METRIC_AVG_VALUE_RESET 9

#define	METRIC_START_TIME 10

#define	METRIC_STOP_TIME 11

#define	METRIC_TIME_ELAPSED 12

#define	METRIC_RESET_TIME 13

#define	METRIC_STATUS 14

#define	METRIC_TYPE 15

#define	METRIC_DESC 16

#define	STOPWORD_VALUE 0

#define	I_S_FTS_DOC_ID 0

#define	I_S_FTS_WORD 0

#define	I_S_FTS_FIRST_DOC_ID 1

#define	I_S_FTS_LAST_DOC_ID 2

#define	I_S_FTS_DOC_COUNT 3

#define	I_S_FTS_ILIST_DOC_ID 4

#define	I_S_FTS_ILIST_DOC_POS 5

#define	FTS_CONFIG_KEY 0

#define	FTS_CONFIG_VALUE 1

#define	IDX_TEMP_TABLE_ID 0

#define	IDX_TEMP_TABLE_NAME 1

#define	IDX_TEMP_TABLE_N_COLS 2

#define	IDX_TEMP_TABLE_SPACE_ID 3

#define	IDX_BUF_STATS_POOL_ID 0

#define	IDX_BUF_STATS_POOL_SIZE 1

#define	IDX_BUF_STATS_FREE_BUFFERS 2

#define	IDX_BUF_STATS_LRU_LEN 3

#define	IDX_BUF_STATS_OLD_LRU_LEN 4

#define	IDX_BUF_STATS_FLUSH_LIST_LEN 5

#define	IDX_BUF_STATS_PENDING_ZIP 6

#define	IDX_BUF_STATS_PENDING_READ 7

#define	IDX_BUF_STATS_FLUSH_LRU 8

#define	IDX_BUF_STATS_FLUSH_LIST 9

#define	IDX_BUF_STATS_PAGE_YOUNG 10

#define	IDX_BUF_STATS_PAGE_NOT_YOUNG 11

#define	IDX_BUF_STATS_PAGE_YOUNG_RATE 12

#define	IDX_BUF_STATS_PAGE_NOT_YOUNG_RATE 13

#define	IDX_BUF_STATS_PAGE_READ 14

#define	IDX_BUF_STATS_PAGE_CREATED 15

#define	IDX_BUF_STATS_PAGE_WRITTEN 16

#define	IDX_BUF_STATS_PAGE_READ_RATE 17

#define	IDX_BUF_STATS_PAGE_CREATE_RATE 18

#define	IDX_BUF_STATS_PAGE_WRITTEN_RATE 19

#define	IDX_BUF_STATS_GET 20

#define	IDX_BUF_STATS_HIT_RATE 21

#define	IDX_BUF_STATS_MADE_YOUNG_PCT 22

#define	IDX_BUF_STATS_NOT_MADE_YOUNG_PCT 23

#define	IDX_BUF_STATS_READ_AHREAD 24

#define	IDX_BUF_STATS_READ_AHEAD_EVICTED 25

#define	IDX_BUF_STATS_READ_AHEAD_RATE 26

#define	IDX_BUF_STATS_READ_AHEAD_EVICT_RATE 27

#define	IDX_BUF_STATS_LRU_IO_SUM 28

#define	IDX_BUF_STATS_LRU_IO_CUR 29

#define	IDX_BUF_STATS_UNZIP_SUM 30

#define	IDX_BUF_STATS_UNZIP_CUR 31

#define	IDX_BUFFER_POOL_ID 0

#define	IDX_BUFFER_BLOCK_ID 1

#define	IDX_BUFFER_PAGE_SPACE 2

#define	IDX_BUFFER_PAGE_NUM 3

#define	IDX_BUFFER_PAGE_TYPE 4

#define	IDX_BUFFER_PAGE_FLUSH_TYPE 5

#define	IDX_BUFFER_PAGE_FIX_COUNT 6

#define	IDX_BUFFER_PAGE_HASHED 7

#define	IDX_BUFFER_PAGE_NEWEST_MOD 8

#define	IDX_BUFFER_PAGE_OLDEST_MOD 9

#define	IDX_BUFFER_PAGE_ACCESS_TIME 10

#define	IDX_BUFFER_PAGE_TABLE_NAME 11

#define	IDX_BUFFER_PAGE_INDEX_NAME 12

#define	IDX_BUFFER_PAGE_NUM_RECS 13

#define	IDX_BUFFER_PAGE_DATA_SIZE 14

#define	IDX_BUFFER_PAGE_ZIP_SIZE 15

#define	IDX_BUFFER_PAGE_STATE 16

#define	IDX_BUFFER_PAGE_IO_FIX 17

#define	IDX_BUFFER_PAGE_IS_OLD 18

#define	IDX_BUFFER_PAGE_FREE_CLOCK 19

#define	IDX_BUFFER_PAGE_IS_STALE 20

#define	IDX_BUF_LRU_POOL_ID 0

#define	IDX_BUF_LRU_POS 1

#define	IDX_BUF_LRU_PAGE_SPACE 2

#define	IDX_BUF_LRU_PAGE_NUM 3

#define	IDX_BUF_LRU_PAGE_TYPE 4

#define	IDX_BUF_LRU_PAGE_FLUSH_TYPE 5

#define	IDX_BUF_LRU_PAGE_FIX_COUNT 6

#define	IDX_BUF_LRU_PAGE_HASHED 7

#define	IDX_BUF_LRU_PAGE_NEWEST_MOD 8

#define	IDX_BUF_LRU_PAGE_OLDEST_MOD 9

#define	IDX_BUF_LRU_PAGE_ACCESS_TIME 10

#define	IDX_BUF_LRU_PAGE_TABLE_NAME 11

#define	IDX_BUF_LRU_PAGE_INDEX_NAME 12

#define	IDX_BUF_LRU_PAGE_NUM_RECS 13

#define	IDX_BUF_LRU_PAGE_DATA_SIZE 14

#define	IDX_BUF_LRU_PAGE_ZIP_SIZE 15

#define	IDX_BUF_LRU_PAGE_STATE 16

#define	IDX_BUF_LRU_PAGE_IO_FIX 17

#define	IDX_BUF_LRU_PAGE_IS_OLD 18

#define	IDX_BUF_LRU_PAGE_FREE_CLOCK 19

#define	INNODB_TABLES_ID 0

#define	INNODB_TABLES_NAME 1

#define	INNODB_TABLES_FLAG 2

#define	INNODB_TABLES_NUM_COLUMN 3

#define	INNODB_TABLES_SPACE 4

#define	INNODB_TABLES_ROW_FORMAT 5

#define	INNODB_TABLES_ZIP_PAGE_SIZE 6

#define	INNODB_TABLES_SPACE_TYPE 7

#define	INNODB_TABLES_INSTANT_COLS 8

#define	INNODB_TABLES_TOTAL_ROW_VERSIONS 9

#define	INNODB_TABLES_INITIAL_COLUMN_COUNTS 10

#define	INNODB_TABLES_CURRENT_COLUMN_COUNTS 11

#define	INNODB_TABLES_TOTAL_COLUMN_COUNTS 12

#define	INNODB_TABLESTATS_ID 0

#define	INNODB_TABLESTATS_NAME 1

#define	INNODB_TABLESTATS_INIT 2

#define	INNODB_TABLESTATS_NROW 3

#define	INNODB_TABLESTATS_CLUST_SIZE 4

#define	INNODB_TABLESTATS_INDEX_SIZE 5

#define	INNODB_TABLESTATS_MODIFIED 6

#define	INNODB_TABLESTATS_AUTONINC 7

#define	INNODB_TABLESTATS_TABLE_REF_COUNT 8

#define	SYS_INDEX_ID 0

#define	SYS_INDEX_NAME 1

#define	SYS_INDEX_TABLE_ID 2

#define	SYS_INDEX_TYPE 3

#define	SYS_INDEX_NUM_FIELDS 4

#define	SYS_INDEX_PAGE_NO 5

#define	SYS_INDEX_SPACE 6

#define	SYS_INDEX_MERGE_THRESHOLD 7

#define	SYS_COLUMN_TABLE_ID 0

#define	SYS_COLUMN_NAME 1

#define	SYS_COLUMN_POSITION 2

#define	SYS_COLUMN_MTYPE 3

#define	SYS_COLUMN__PRTYPE 4

#define	SYS_COLUMN_COLUMN_LEN 5

#define	SYS_COLUMN_HAS_DEFAULT 6

#define	SYS_COLUMN_DEFAULT_VALUE 7

#define	SYS_COLUMN_VERSION_ADDED 8

#define	SYS_COLUMN_VERSION_DROPPED 9

#define	SYS_COLUMN_PHYSICAL_POS 10

#define	INNODB_VIRTUAL_TABLE_ID 0

#define	INNODB_VIRTUAL_POS 1

#define	INNODB_VIRTUAL_BASE_POS 2

#define	INNODB_TABLESPACES_SPACE 0

#define	INNODB_TABLESPACES_NAME 1

#define	INNODB_TABLESPACES_FLAGS 2

#define	INNODB_TABLESPACES_ROW_FORMAT 3

#define	INNODB_TABLESPACES_PAGE_SIZE 4

#define	INNODB_TABLESPACES_ZIP_PAGE_SIZE 5

#define	INNODB_TABLESPACES_SPACE_TYPE 6

#define	INNODB_TABLESPACES_FS_BLOCK_SIZE 7

#define	INNODB_TABLESPACES_FILE_SIZE 8

#define	INNODB_TABLESPACES_ALLOC_SIZE 9

#define	INNODB_TABLESPACES_AUTOEXTEND_SIZE 10

#define	INNODB_TABLESPACES_SERVER_VERSION 11

#define	INNODB_TABLESPACES_SPACE_VERSION 12

#define	INNODB_TABLESPACES_ENCRYPTION 13

#define	INNODB_TABLESPACES_STATE 14

#define	CACHED_INDEXES_SPACE_ID 0

#define	CACHED_INDEXES_INDEX_ID 1

#define	CACHED_INDEXES_N_CACHED_PAGES 2

#define	INNODB_SESSION_TEMP_TABLESPACES_ID 0

#define	INNODB_SESSION_TEMP_TABLESPACES_SPACE 1

#define	INNODB_SESSION_TEMP_TABLESPACES_PATH 2

#define	INNODB_SESSION_TEMP_TABLESPACES_SIZE 3

#define	INNODB_SESSION_TEMP_TABLESPACES_STATE 4

#define	INNODB_SESSION_TEMP_TABLESPACES_PURPOSE 5

Typedefs
typedef std::vector< temp_table_info_t, ut::allocator< temp_table_info_t > >	temp_table_info_cache_t

Functions
static int	trx_i_s_common_fill_table (THD thd, Table_ref tables, Item *)
	Common function to fill any of the dynamic tables: INFORMATION_SCHEMA.innodb_trx. More...

static int	i_s_common_deinit (void *p)
	Unbind a dynamic INFORMATION_SCHEMA table. More...

static int	field_store_time_t (Field *field, time_t time)
	Auxiliary function to store time_t value in MYSQL_TYPE_DATETIME field. More...

static int	field_store_string (Field field, const char str)
	Auxiliary function to store char* value in MYSQL_TYPE_STRING field. More...

static int	field_store_index_name (Field field, const char index_name)
	Store the name of an index in a MYSQL_TYPE_VARCHAR field. More...

static int	fill_innodb_trx_from_cache (trx_i_s_cache_t cache, THD thd, TABLE *table)
	Read data from cache buffer and fill the INFORMATION_SCHEMA.innodb_trx table with it. More...

static int	innodb_trx_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.innodb_trx. More...

static int	i_s_cmp_fill_low (THD thd, Table_ref tables, Item *, bool reset)
	Fill the dynamic table information_schema.innodb_cmp or innodb_cmp_reset. More...

static int	i_s_cmp_fill (THD thd, Table_ref tables, Item *cond)
	Fill the dynamic table information_schema.innodb_cmp. More...

static int	i_s_cmp_reset_fill (THD thd, Table_ref tables, Item *cond)
	Fill the dynamic table information_schema.innodb_cmp_reset. More...

static int	i_s_cmp_init (void *p)
	Bind the dynamic table information_schema.innodb_cmp. More...

static int	i_s_cmp_reset_init (void *p)
	Bind the dynamic table information_schema.innodb_cmp_reset. More...

static int	i_s_cmp_per_index_fill_low (THD thd, Table_ref tables, Item *, bool reset)
	Fill the dynamic table information_schema.innodb_cmp_per_index or information_schema.innodb_cmp_per_index_reset. More...

static int	i_s_cmp_per_index_fill (THD thd, Table_ref tables, Item *cond)
	Fill the dynamic table information_schema.innodb_cmp_per_index. More...

static int	i_s_cmp_per_index_reset_fill (THD thd, Table_ref tables, Item *cond)
	Fill the dynamic table information_schema.innodb_cmp_per_index_reset. More...

static int	i_s_cmp_per_index_init (void *p)
	Bind the dynamic table information_schema.innodb_cmp_per_index. More...

static int	i_s_cmp_per_index_reset_init (void *p)
	Bind the dynamic table information_schema.innodb_cmp_per_index_reset. More...

static int	i_s_cmpmem_fill_low (THD thd, Table_ref tables, bool reset)
	Fill the dynamic table information_schema.innodb_cmpmem or innodb_cmpmem_reset. More...

static int	i_s_cmpmem_fill (THD thd, Table_ref tables, Item *)
	Fill the dynamic table information_schema.innodb_cmpmem. More...

static int	i_s_cmpmem_reset_fill (THD thd, Table_ref tables, Item *)
	Fill the dynamic table information_schema.innodb_cmpmem_reset. More...

static int	i_s_cmpmem_init (void *p)
	Bind the dynamic table information_schema.innodb_cmpmem. More...

static int	i_s_cmpmem_reset_init (void *p)
	Bind the dynamic table information_schema.innodb_cmpmem_reset. More...

static int	i_s_metrics_fill (THD thd, TABLE table_to_fill)
	Fill the information schema metrics table. More...

static int	i_s_metrics_fill_table (THD thd, Table_ref tables, Item *)
	Function to fill information schema metrics tables. More...

static int	innodb_metrics_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.innodb_metrics. More...

static int	i_s_stopword_fill (THD thd, Table_ref tables, Item *)
	Fill the dynamic table information_schema.innodb_ft_default_stopword. More...

static int	i_s_stopword_init (void *p)
	Bind the dynamic table information_schema.innodb_ft_default_stopword. More...

static int	i_s_fts_deleted_generic_fill (THD thd, Table_ref tables, bool being_deleted)
	Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_DELETED or INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED. More...

static int	i_s_fts_deleted_fill (THD thd, Table_ref tables, Item *)
	Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_DELETED. More...

static int	i_s_fts_deleted_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_FT_DELETED. More...

static int	i_s_fts_being_deleted_fill (THD thd, Table_ref tables, Item *)
	Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED. More...

static int	i_s_fts_being_deleted_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED. More...

static int	i_s_fts_index_cache_fill_one_index (fts_index_cache_t index_cache, THD thd, Table_ref *tables)
	Go through the Doc Node and its ilist, fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHED for one FTS index on the table. More...

static int	i_s_fts_index_cache_fill (THD thd, Table_ref tables, Item *)
	Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHED. More...

static int	i_s_fts_index_cache_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE. More...

static dberr_t	i_s_fts_index_table_fill_selected (dict_index_t index, ib_vector_t words, ulint selected, fts_string_t *word)
	Go through a FTS index auxiliary table, fetch its rows and fill FTS word cache structure. More...

static void	i_s_fts_index_table_free_one_fetch (ib_vector_t *words)
	Free words. More...

static int	i_s_fts_index_table_fill_one_fetch (CHARSET_INFO index_charset, THD thd, Table_ref tables, ib_vector_t words, fts_string_t *conv_str, bool has_more)
	Go through words, fill INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE. More...

static int	i_s_fts_index_table_fill_one_index (dict_index_t index, THD thd, Table_ref *tables)
	Go through a FTS index and its auxiliary tables, fetch rows in each table and fill INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE. More...

static int	i_s_fts_index_table_fill (THD thd, Table_ref tables, Item *)
	Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE. More...

static int	i_s_fts_index_table_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE. More...

static int	i_s_fts_config_fill (THD thd, Table_ref tables, Item *)
	Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_CONFIG. More...

static int	i_s_fts_config_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_FT_CONFIG. More...

static int	i_s_innodb_temp_table_info_fill (THD thd, Table_ref tables, const temp_table_info_t *info)
	Fill Information Schema table INNODB_TEMP_TABLE_INFO for a particular temp-table. More...

static void	innodb_temp_table_populate_cache (const dict_table_t table, temp_table_info_t cache)
	Populate current table information to cache. More...

static int	i_s_innodb_temp_table_info_fill_table (THD thd, Table_ref tables, Item *)
	This function will iterate over all available table and will fill stats for temp-tables to INNODB_TEMP_TABLE_INFO. More...

static int	i_s_innodb_temp_table_info_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO. More...

static int	i_s_innodb_stats_fill (THD thd, Table_ref tables, const buf_pool_info_t *info)
	Fill Information Schema table INNODB_BUFFER_POOL_STATS for a particular buffer pool. More...

static int	i_s_innodb_buffer_stats_fill_table (THD thd, Table_ref tables, Item *)
	This is the function that loops through each buffer pool and fetch buffer pool stats to information schema table: I_S_INNODB_BUFFER_POOL_STATS. More...

static int	i_s_innodb_buffer_pool_stats_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS. More...

static int	i_s_innodb_buffer_page_fill (THD thd, Table_ref tables, const buf_page_info_t *info_array, ulint num_page)
	Fill Information Schema table INNODB_BUFFER_PAGE with information cached in the buf_page_info_t array. More...

static void	i_s_innodb_set_page_type (buf_page_info_t page_info, ulint page_type, const byte frame)
	Set appropriate page type to a buf_page_info_t structure. More...

static void	i_s_innodb_buffer_page_get_info (const buf_page_t bpage, ulint pool_id, ulint pos, buf_page_info_t page_info)
	Scans pages in the buffer cache, and collect their general information into the buf_page_info_t array which is zero-filled. More...

static int	i_s_innodb_fill_buffer_pool (THD thd, Table_ref tables, buf_pool_t *buf_pool, const ulint pool_id)
	This is the function that goes through each block of the buffer pool and fetch information to information schema tables: INNODB_BUFFER_PAGE. More...

static int	i_s_innodb_buffer_page_fill_table (THD thd, Table_ref tables, Item *)
	Fill page information for pages in InnoDB buffer pool to the dynamic table INFORMATION_SCHEMA.INNODB_BUFFER_PAGE. More...

static int	i_s_innodb_buffer_page_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_BUFFER_PAGE. More...

static int	i_s_innodb_buf_page_lru_fill (THD thd, Table_ref tables, const buf_page_info_t *info_array, ulint num_page)
	Fill Information Schema table INNODB_BUFFER_PAGE_LRU with information cached in the buf_page_info_t array. More...

static int	i_s_innodb_fill_buffer_lru (THD thd, Table_ref tables, buf_pool_t *buf_pool, const ulint pool_id)
	This is the function that goes through buffer pool's LRU list and fetch information to INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU. More...

static int	i_s_innodb_buf_page_lru_fill_table (THD thd, Table_ref tables, Item *)
	Fill page information for pages in InnoDB buffer pool to the dynamic table INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU. More...

static int	i_s_innodb_buffer_page_lru_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU. More...

static int	i_s_dict_fill_innodb_tables (THD thd, dict_table_t table, TABLE *table_to_fill)
	Populate information_schema.innodb_tables table with information from INNODB_TABLES. More...

static int	i_s_innodb_tables_fill_table (THD thd, Table_ref tables, Item *)
	Function to go through each record in INNODB_TABLES table, and fill the information_schema.innodb_tables table with related table information. More...

static int	innodb_tables_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.innodb_tables. More...

static int	i_s_dict_fill_innodb_tablestats (THD thd, dict_table_t table, ulint ref_count, TABLE *table_to_fill)
	Populate information_schema.innodb_tablestats table with information from INNODB_TABLES. More...

static int	i_s_innodb_tables_fill_table_stats (THD thd, Table_ref tables, Item *)
	Function to go through each record in INNODB_TABLES table, and fill the information_schema.innodb_tablestats table with table statistics related information. More...

static int	innodb_tablestats_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.innodb_tablestats. More...

static int	i_s_dict_fill_innodb_indexes (THD thd, const dict_index_t index, TABLE *table_to_fill)
	Function to populate the information_schema.innodb_indexes table with collected index information. More...

static int	i_s_innodb_indexes_fill_table (THD thd, Table_ref tables, Item *)
	Function to go through each record in INNODB_INDEXES table, and fill the information_schema.innodb_indexes table with related index information. More...

static int	innodb_indexes_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.innodb_indexes. More...

static int	field_blob_store (Field field, dict_col_default_t default_val)
	Function to fill the BLOB value for column default value. More...

static int	i_s_dict_fill_innodb_columns (THD thd, table_id_t table_id, const char col_name, dict_col_t column, ulint nth_v_col, TABLE table_to_fill)
	Function to populate the information_schema.innodb_columns with related column information. More...

static void	process_rows (THD thd, Table_ref tables, const rec_t rec, dict_table_t dd_table, btr_pcur_t &pcur, mtr_t &mtr, mem_heap_t *heap, bool is_partition)

static int	i_s_innodb_columns_fill_table (THD thd, Table_ref tables, Item *)
	Function to fill information_schema.innodb_columns with information collected by scanning INNODB_COLUMNS table. More...

static int	innodb_columns_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.innodb_columns. More...

static int	i_s_dict_fill_innodb_virtual (THD thd, table_id_t table_id, ulint pos, ulint base_pos, TABLE table_to_fill)
	Function to populate the information_schema.innodb_virtual with related information param[in] thd thread param[in] table_id table ID param[in] pos virtual column position param[in] base_pos base column position param[in,out] table_to_fill fill this table. More...

static int	i_s_innodb_virtual_fill_table (THD thd, Table_ref tables, Item *)
	Function to fill information_schema.innodb_virtual with information collected by scanning INNODB_VIRTUAL table. More...

static int	innodb_virtual_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.innodb_virtual param[in,out] p table schema object. More...

static int	i_s_dict_fill_innodb_tablespaces (THD thd, space_id_t space_id, const char name, uint32_t flags, uint32_t server_version, uint32_t space_version, bool is_encrypted, uint64_t autoextend_size, const char state, TABLE table_to_fill)
	Function to fill INFORMATION_SCHEMA.INNODB_TABLESPACES with information collected by scanning INNODB_TABLESPACESS table. More...

static int	i_s_innodb_tablespaces_fill_table (THD thd, Table_ref tables, Item *)
	Function to populate INFORMATION_SCHEMA.INNODB_TABLESPACES table. More...

static int	innodb_tablespaces_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_TABLESPACES. More...

static int	i_s_fill_innodb_cached_indexes_row (THD thd, space_id_t space_id, ulint index_id, TABLE table_to_fill)
	Populate INFORMATION_SCHEMA.INNODB_CACHED_INDEXES. More...

static int	i_s_innodb_cached_indexes_fill_table (THD thd, Table_ref tables, Item *)
	Go through each record in INNODB_INDEXES, and fill INFORMATION_SCHEMA.INNODB_CACHED_INDEXES. More...

static int	innodb_cached_indexes_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_CACHED_INDEXES. More...

static int	i_s_innodb_session_temp_tablespaces_fill_one (THD thd, const ibt::Tablespace ts, TABLE *table_to_fill)
	Function to fill INFORMATION_SCHEMA.INNODB_SESSION_TEMPORARY_TABLESPACES. More...

static int	i_s_innodb_session_temp_tablespaces_fill (THD thd, Table_ref tables, Item *)
	Function to populate INFORMATION_SCHEMA.INNODB_SESSION_TEMPORARY_TABLESPACES table. More...

static int	innodb_session_temp_tablespaces_init (void *p)
	Bind the dynamic table INFORMATION_SCHEMA.INNODB_SESSION_TEMPORARY_TABLESPACES. More...

Variables
mysql_mutex_t	LOCK_global_system_variables

constexpr char	plugin_author [] = PLUGIN_AUTHOR_ORACLE

constexpr size_t	I_S_PAGE_TYPE_INDEX = 1
	We also define I_S_PAGE_TYPE_INDEX as the Index Page's position in i_s_page_type[] array. More...

constexpr auto	I_S_PAGE_TYPE_UNKNOWN = FIL_PAGE_TYPE_UNKNOWN
	Any unassigned FIL_PAGE_TYPE will be treated as unknown. More...

constexpr auto	I_S_PAGE_TYPE_RTREE = (FIL_PAGE_TYPE_LAST + 1)
	R-tree index page. More...

constexpr auto	I_S_PAGE_TYPE_IBUF = (FIL_PAGE_TYPE_LAST + 2)
	Change buffer B-tree page. More...

constexpr auto	I_S_PAGE_TYPE_SDI = (FIL_PAGE_TYPE_LAST + 3)
	SDI B-tree page. More...

constexpr auto	I_S_PAGE_TYPE_LAST = I_S_PAGE_TYPE_SDI

constexpr auto	I_S_PAGE_TYPE_BITS = 6

constexpr uint8_t	i_s_innodb_plugin_version_postfix = 2
	I_S.innodb_* views version postfix. More...

constexpr uint64_t	i_s_innodb_plugin_version
	I_S.innodb_* views version. More...

static buf_page_desc_t	i_s_page_type []
	Name string for File Page Types. More...

const ulint	MAX_BUF_INFO_CACHED = 10000
	Maximum number of buffer page info we would cache. More...

static ST_FIELD_INFO	innodb_trx_fields_info []

static struct st_mysql_information_schema	i_s_info

struct st_mysql_plugin	i_s_innodb_trx

static ST_FIELD_INFO	i_s_cmp_fields_info []

struct st_mysql_plugin	i_s_innodb_cmp

struct st_mysql_plugin	i_s_innodb_cmp_reset

static ST_FIELD_INFO	i_s_cmp_per_index_fields_info []

struct st_mysql_plugin	i_s_innodb_cmp_per_index

struct st_mysql_plugin	i_s_innodb_cmp_per_index_reset

static ST_FIELD_INFO	i_s_cmpmem_fields_info []

struct st_mysql_plugin	i_s_innodb_cmpmem

struct st_mysql_plugin	i_s_innodb_cmpmem_reset

static ST_FIELD_INFO	innodb_metrics_fields_info []

struct st_mysql_plugin	i_s_innodb_metrics

static ST_FIELD_INFO	i_s_stopword_fields_info []

struct st_mysql_plugin	i_s_innodb_ft_default_stopword

static ST_FIELD_INFO	i_s_fts_doc_fields_info []

struct st_mysql_plugin	i_s_innodb_ft_deleted

struct st_mysql_plugin	i_s_innodb_ft_being_deleted

static ST_FIELD_INFO	i_s_fts_index_fields_info []

struct st_mysql_plugin	i_s_innodb_ft_index_cache

struct st_mysql_plugin	i_s_innodb_ft_index_table

static ST_FIELD_INFO	i_s_fts_config_fields_info []

static const char *	fts_config_key []

struct st_mysql_plugin	i_s_innodb_ft_config

static ST_FIELD_INFO	i_s_innodb_temp_table_info_fields_info []

struct st_mysql_plugin	i_s_innodb_temp_table_info

static ST_FIELD_INFO	i_s_innodb_buffer_stats_fields_info []

struct st_mysql_plugin	i_s_innodb_buffer_stats

static ST_FIELD_INFO	i_s_innodb_buffer_page_fields_info []

struct st_mysql_plugin	i_s_innodb_buffer_page

static ST_FIELD_INFO	i_s_innodb_buf_page_lru_fields_info []

struct st_mysql_plugin	i_s_innodb_buffer_page_lru

static ST_FIELD_INFO	innodb_tables_fields_info []
	INNODB_TABLES More...

struct st_mysql_plugin	i_s_innodb_tables

static ST_FIELD_INFO	innodb_tablestats_fields_info []
	INNODB_TABLESTATS More...

struct st_mysql_plugin	i_s_innodb_tablestats

static ST_FIELD_INFO	innodb_sysindex_fields_info []
	INNODB_INDEXES More...

struct st_mysql_plugin	i_s_innodb_indexes

static ST_FIELD_INFO	innodb_columns_fields_info []
	INNODB_COLUMNS More...

struct st_mysql_plugin	i_s_innodb_columns

static ST_FIELD_INFO	innodb_virtual_fields_info []
	INNODB_VIRTUAL. More...

struct st_mysql_plugin	i_s_innodb_virtual

static ST_FIELD_INFO	innodb_tablespaces_fields_info []
	INNODB_TABLESPACES More...

struct st_mysql_plugin	i_s_innodb_tablespaces

static ST_FIELD_INFO	innodb_cached_indexes_fields_info []
	INFORMATION_SCHEMA.INNODB_CACHED_INDEXES. More...

struct st_mysql_plugin	i_s_innodb_cached_indexes

static ST_FIELD_INFO	innodb_session_temp_tablespaces_fields_info []
	INNODB_SESSION_TEMPORARY TABLESPACES More...

struct st_mysql_plugin	i_s_innodb_session_temp_tablespaces

Detailed Description

InnoDB INFORMATION SCHEMA tables interface to MySQL.

Created July 18, 2007 Vasil Dimov

Macro Definition Documentation

◆ CACHED_INDEXES_INDEX_ID

#define CACHED_INDEXES_INDEX_ID 1

◆ CACHED_INDEXES_N_CACHED_PAGES

#define CACHED_INDEXES_N_CACHED_PAGES 2

◆ CACHED_INDEXES_SPACE_ID

#define CACHED_INDEXES_SPACE_ID 0

◆ END_OF_ST_FIELD_INFO

#define END_OF_ST_FIELD_INFO

Value:

  {                                                                    \
    STRUCT_FLD(field_name, NULL), STRUCT_FLD(field_length, 0),         \
        STRUCT_FLD(field_type, MYSQL_TYPE_NULL), STRUCT_FLD(value, 0), \
        STRUCT_FLD(field_flags, 0), STRUCT_FLD(old_name, ""),          \
        STRUCT_FLD(open_method, 0)                                     \
  }

◆ FTS_CONFIG_KEY

#define FTS_CONFIG_KEY 0

◆ FTS_CONFIG_VALUE

#define FTS_CONFIG_VALUE 1

◆ I_S_FTS_DOC_COUNT

#define I_S_FTS_DOC_COUNT 3

◆ I_S_FTS_DOC_ID

#define I_S_FTS_DOC_ID 0

◆ I_S_FTS_FIRST_DOC_ID

#define I_S_FTS_FIRST_DOC_ID 1

◆ I_S_FTS_ILIST_DOC_ID

#define I_S_FTS_ILIST_DOC_ID 4

◆ I_S_FTS_ILIST_DOC_POS

#define I_S_FTS_ILIST_DOC_POS 5

◆ I_S_FTS_LAST_DOC_ID

#define I_S_FTS_LAST_DOC_ID 2

◆ I_S_FTS_WORD

#define I_S_FTS_WORD 0

◆ IDX_BUF_LRU_PAGE_ACCESS_TIME

#define IDX_BUF_LRU_PAGE_ACCESS_TIME 10

◆ IDX_BUF_LRU_PAGE_DATA_SIZE

#define IDX_BUF_LRU_PAGE_DATA_SIZE 14

◆ IDX_BUF_LRU_PAGE_FIX_COUNT

#define IDX_BUF_LRU_PAGE_FIX_COUNT 6

◆ IDX_BUF_LRU_PAGE_FLUSH_TYPE

#define IDX_BUF_LRU_PAGE_FLUSH_TYPE 5

◆ IDX_BUF_LRU_PAGE_FREE_CLOCK

#define IDX_BUF_LRU_PAGE_FREE_CLOCK 19

◆ IDX_BUF_LRU_PAGE_HASHED

#define IDX_BUF_LRU_PAGE_HASHED 7

◆ IDX_BUF_LRU_PAGE_INDEX_NAME

#define IDX_BUF_LRU_PAGE_INDEX_NAME 12

◆ IDX_BUF_LRU_PAGE_IO_FIX

#define IDX_BUF_LRU_PAGE_IO_FIX 17

◆ IDX_BUF_LRU_PAGE_IS_OLD

#define IDX_BUF_LRU_PAGE_IS_OLD 18

◆ IDX_BUF_LRU_PAGE_NEWEST_MOD

#define IDX_BUF_LRU_PAGE_NEWEST_MOD 8

◆ IDX_BUF_LRU_PAGE_NUM

#define IDX_BUF_LRU_PAGE_NUM 3

◆ IDX_BUF_LRU_PAGE_NUM_RECS

#define IDX_BUF_LRU_PAGE_NUM_RECS 13

◆ IDX_BUF_LRU_PAGE_OLDEST_MOD

#define IDX_BUF_LRU_PAGE_OLDEST_MOD 9

◆ IDX_BUF_LRU_PAGE_SPACE

#define IDX_BUF_LRU_PAGE_SPACE 2

◆ IDX_BUF_LRU_PAGE_STATE

#define IDX_BUF_LRU_PAGE_STATE 16

◆ IDX_BUF_LRU_PAGE_TABLE_NAME

#define IDX_BUF_LRU_PAGE_TABLE_NAME 11

◆ IDX_BUF_LRU_PAGE_TYPE

#define IDX_BUF_LRU_PAGE_TYPE 4

◆ IDX_BUF_LRU_PAGE_ZIP_SIZE

#define IDX_BUF_LRU_PAGE_ZIP_SIZE 15

◆ IDX_BUF_LRU_POOL_ID

#define IDX_BUF_LRU_POOL_ID 0

◆ IDX_BUF_LRU_POS

#define IDX_BUF_LRU_POS 1

◆ IDX_BUF_STATS_FLUSH_LIST

#define IDX_BUF_STATS_FLUSH_LIST 9

◆ IDX_BUF_STATS_FLUSH_LIST_LEN

#define IDX_BUF_STATS_FLUSH_LIST_LEN 5

◆ IDX_BUF_STATS_FLUSH_LRU

#define IDX_BUF_STATS_FLUSH_LRU 8

◆ IDX_BUF_STATS_FREE_BUFFERS

#define IDX_BUF_STATS_FREE_BUFFERS 2

◆ IDX_BUF_STATS_GET

#define IDX_BUF_STATS_GET 20

◆ IDX_BUF_STATS_HIT_RATE

#define IDX_BUF_STATS_HIT_RATE 21

◆ IDX_BUF_STATS_LRU_IO_CUR

#define IDX_BUF_STATS_LRU_IO_CUR 29

◆ IDX_BUF_STATS_LRU_IO_SUM

#define IDX_BUF_STATS_LRU_IO_SUM 28

◆ IDX_BUF_STATS_LRU_LEN

#define IDX_BUF_STATS_LRU_LEN 3

◆ IDX_BUF_STATS_MADE_YOUNG_PCT

#define IDX_BUF_STATS_MADE_YOUNG_PCT 22

◆ IDX_BUF_STATS_NOT_MADE_YOUNG_PCT

#define IDX_BUF_STATS_NOT_MADE_YOUNG_PCT 23

◆ IDX_BUF_STATS_OLD_LRU_LEN

#define IDX_BUF_STATS_OLD_LRU_LEN 4

◆ IDX_BUF_STATS_PAGE_CREATE_RATE

#define IDX_BUF_STATS_PAGE_CREATE_RATE 18

◆ IDX_BUF_STATS_PAGE_CREATED

#define IDX_BUF_STATS_PAGE_CREATED 15

◆ IDX_BUF_STATS_PAGE_NOT_YOUNG

#define IDX_BUF_STATS_PAGE_NOT_YOUNG 11

◆ IDX_BUF_STATS_PAGE_NOT_YOUNG_RATE

#define IDX_BUF_STATS_PAGE_NOT_YOUNG_RATE 13

◆ IDX_BUF_STATS_PAGE_READ

#define IDX_BUF_STATS_PAGE_READ 14

◆ IDX_BUF_STATS_PAGE_READ_RATE

#define IDX_BUF_STATS_PAGE_READ_RATE 17

◆ IDX_BUF_STATS_PAGE_WRITTEN

#define IDX_BUF_STATS_PAGE_WRITTEN 16

◆ IDX_BUF_STATS_PAGE_WRITTEN_RATE

#define IDX_BUF_STATS_PAGE_WRITTEN_RATE 19

◆ IDX_BUF_STATS_PAGE_YOUNG

#define IDX_BUF_STATS_PAGE_YOUNG 10

◆ IDX_BUF_STATS_PAGE_YOUNG_RATE

#define IDX_BUF_STATS_PAGE_YOUNG_RATE 12

◆ IDX_BUF_STATS_PENDING_READ

#define IDX_BUF_STATS_PENDING_READ 7

◆ IDX_BUF_STATS_PENDING_ZIP

#define IDX_BUF_STATS_PENDING_ZIP 6

◆ IDX_BUF_STATS_POOL_ID

#define IDX_BUF_STATS_POOL_ID 0

◆ IDX_BUF_STATS_POOL_SIZE

#define IDX_BUF_STATS_POOL_SIZE 1

◆ IDX_BUF_STATS_READ_AHEAD_EVICT_RATE

#define IDX_BUF_STATS_READ_AHEAD_EVICT_RATE 27

◆ IDX_BUF_STATS_READ_AHEAD_EVICTED

#define IDX_BUF_STATS_READ_AHEAD_EVICTED 25

◆ IDX_BUF_STATS_READ_AHEAD_RATE

#define IDX_BUF_STATS_READ_AHEAD_RATE 26

◆ IDX_BUF_STATS_READ_AHREAD

#define IDX_BUF_STATS_READ_AHREAD 24

◆ IDX_BUF_STATS_UNZIP_CUR

#define IDX_BUF_STATS_UNZIP_CUR 31

◆ IDX_BUF_STATS_UNZIP_SUM

#define IDX_BUF_STATS_UNZIP_SUM 30

◆ IDX_BUFFER_BLOCK_ID

#define IDX_BUFFER_BLOCK_ID 1

◆ IDX_BUFFER_PAGE_ACCESS_TIME

#define IDX_BUFFER_PAGE_ACCESS_TIME 10

◆ IDX_BUFFER_PAGE_DATA_SIZE

#define IDX_BUFFER_PAGE_DATA_SIZE 14

◆ IDX_BUFFER_PAGE_FIX_COUNT

#define IDX_BUFFER_PAGE_FIX_COUNT 6

◆ IDX_BUFFER_PAGE_FLUSH_TYPE

#define IDX_BUFFER_PAGE_FLUSH_TYPE 5

◆ IDX_BUFFER_PAGE_FREE_CLOCK

#define IDX_BUFFER_PAGE_FREE_CLOCK 19

◆ IDX_BUFFER_PAGE_HASHED

#define IDX_BUFFER_PAGE_HASHED 7

◆ IDX_BUFFER_PAGE_INDEX_NAME

#define IDX_BUFFER_PAGE_INDEX_NAME 12

◆ IDX_BUFFER_PAGE_IO_FIX

#define IDX_BUFFER_PAGE_IO_FIX 17

◆ IDX_BUFFER_PAGE_IS_OLD

#define IDX_BUFFER_PAGE_IS_OLD 18

◆ IDX_BUFFER_PAGE_IS_STALE

#define IDX_BUFFER_PAGE_IS_STALE 20

◆ IDX_BUFFER_PAGE_NEWEST_MOD

#define IDX_BUFFER_PAGE_NEWEST_MOD 8

◆ IDX_BUFFER_PAGE_NUM

#define IDX_BUFFER_PAGE_NUM 3

◆ IDX_BUFFER_PAGE_NUM_RECS

#define IDX_BUFFER_PAGE_NUM_RECS 13

◆ IDX_BUFFER_PAGE_OLDEST_MOD

#define IDX_BUFFER_PAGE_OLDEST_MOD 9

◆ IDX_BUFFER_PAGE_SPACE

#define IDX_BUFFER_PAGE_SPACE 2

◆ IDX_BUFFER_PAGE_STATE

#define IDX_BUFFER_PAGE_STATE 16

◆ IDX_BUFFER_PAGE_TABLE_NAME

#define IDX_BUFFER_PAGE_TABLE_NAME 11

◆ IDX_BUFFER_PAGE_TYPE

#define IDX_BUFFER_PAGE_TYPE 4

◆ IDX_BUFFER_PAGE_ZIP_SIZE

#define IDX_BUFFER_PAGE_ZIP_SIZE 15

◆ IDX_BUFFER_POOL_ID

#define IDX_BUFFER_POOL_ID 0

◆ IDX_COMPRESS_OPS

#define IDX_COMPRESS_OPS 3

◆ IDX_COMPRESS_OPS_OK

#define IDX_COMPRESS_OPS_OK 4

◆ IDX_COMPRESS_TIME

#define IDX_COMPRESS_TIME 5

◆ IDX_DATABASE_NAME

#define IDX_DATABASE_NAME 0

◆ IDX_INDEX_NAME

#define IDX_INDEX_NAME 2

◆ IDX_TABLE_NAME

#define IDX_TABLE_NAME 1

◆ IDX_TEMP_TABLE_ID

#define IDX_TEMP_TABLE_ID 0

◆ IDX_TEMP_TABLE_N_COLS

#define IDX_TEMP_TABLE_N_COLS 2

◆ IDX_TEMP_TABLE_NAME

#define IDX_TEMP_TABLE_NAME 1

◆ IDX_TEMP_TABLE_SPACE_ID

#define IDX_TEMP_TABLE_SPACE_ID 3

◆ IDX_TRX_ADAPTIVE_HASH_LATCHED

#define IDX_TRX_ADAPTIVE_HASH_LATCHED 20

◆ IDX_TRX_ADAPTIVE_HASH_TIMEOUT

#define IDX_TRX_ADAPTIVE_HASH_TIMEOUT 21

◆ IDX_TRX_AUTOCOMMIT_NON_LOCKING

#define IDX_TRX_AUTOCOMMIT_NON_LOCKING 23

◆ IDX_TRX_CONNCURRENCY_TICKETS

#define IDX_TRX_CONNCURRENCY_TICKETS 15

◆ IDX_TRX_FOREIGN_KEY_CHECKS

#define IDX_TRX_FOREIGN_KEY_CHECKS 18

◆ IDX_TRX_ID

#define IDX_TRX_ID 0

◆ IDX_TRX_ISOLATION_LEVEL

#define IDX_TRX_ISOLATION_LEVEL 16

◆ IDX_TRX_LAST_FOREIGN_KEY_ERROR

#define IDX_TRX_LAST_FOREIGN_KEY_ERROR 19

◆ IDX_TRX_LOCK_MEMORY_BYTES

#define IDX_TRX_LOCK_MEMORY_BYTES 12

◆ IDX_TRX_LOCK_STRUCTS

#define IDX_TRX_LOCK_STRUCTS 11

◆ IDX_TRX_MYSQL_THREAD_ID

#define IDX_TRX_MYSQL_THREAD_ID 6

◆ IDX_TRX_OPERATION_STATE

#define IDX_TRX_OPERATION_STATE 8

◆ IDX_TRX_QUERY

#define IDX_TRX_QUERY 7

◆ IDX_TRX_READ_ONLY

#define IDX_TRX_READ_ONLY 22

◆ IDX_TRX_REQUESTED_LOCK_ID

#define IDX_TRX_REQUESTED_LOCK_ID 3

◆ IDX_TRX_ROWS_LOCKED

#define IDX_TRX_ROWS_LOCKED 13

◆ IDX_TRX_ROWS_MODIFIED

#define IDX_TRX_ROWS_MODIFIED 14

◆ IDX_TRX_SCHEDULE_WEIGHT

#define IDX_TRX_SCHEDULE_WEIGHT 24

◆ IDX_TRX_STARTED

#define IDX_TRX_STARTED 2

◆ IDX_TRX_STATE

#define IDX_TRX_STATE 1

◆ IDX_TRX_TABLES_IN_USE

#define IDX_TRX_TABLES_IN_USE 9

◆ IDX_TRX_TABLES_LOCKED

#define IDX_TRX_TABLES_LOCKED 10

◆ IDX_TRX_UNIQUE_CHECKS

#define IDX_TRX_UNIQUE_CHECKS 17

◆ IDX_TRX_WAIT_STARTED

#define IDX_TRX_WAIT_STARTED 4

◆ IDX_TRX_WEIGHT

#define IDX_TRX_WEIGHT 5

◆ IDX_UNCOMPRESS_OPS

#define IDX_UNCOMPRESS_OPS 6

◆ IDX_UNCOMPRESS_TIME

#define IDX_UNCOMPRESS_TIME 7

◆ INNODB_SESSION_TEMP_TABLESPACES_ID

#define INNODB_SESSION_TEMP_TABLESPACES_ID 0

◆ INNODB_SESSION_TEMP_TABLESPACES_PATH

#define INNODB_SESSION_TEMP_TABLESPACES_PATH 2

◆ INNODB_SESSION_TEMP_TABLESPACES_PURPOSE

#define INNODB_SESSION_TEMP_TABLESPACES_PURPOSE 5

◆ INNODB_SESSION_TEMP_TABLESPACES_SIZE

#define INNODB_SESSION_TEMP_TABLESPACES_SIZE 3

◆ INNODB_SESSION_TEMP_TABLESPACES_SPACE

#define INNODB_SESSION_TEMP_TABLESPACES_SPACE 1

◆ INNODB_SESSION_TEMP_TABLESPACES_STATE

#define INNODB_SESSION_TEMP_TABLESPACES_STATE 4

◆ INNODB_TABLES_CURRENT_COLUMN_COUNTS

#define INNODB_TABLES_CURRENT_COLUMN_COUNTS 11

◆ INNODB_TABLES_FLAG

#define INNODB_TABLES_FLAG 2

◆ INNODB_TABLES_ID

#define INNODB_TABLES_ID 0

◆ INNODB_TABLES_INITIAL_COLUMN_COUNTS

#define INNODB_TABLES_INITIAL_COLUMN_COUNTS 10

◆ INNODB_TABLES_INSTANT_COLS

#define INNODB_TABLES_INSTANT_COLS 8

◆ INNODB_TABLES_NAME

#define INNODB_TABLES_NAME 1

◆ INNODB_TABLES_NUM_COLUMN

#define INNODB_TABLES_NUM_COLUMN 3

◆ INNODB_TABLES_ROW_FORMAT

#define INNODB_TABLES_ROW_FORMAT 5

◆ INNODB_TABLES_SPACE

#define INNODB_TABLES_SPACE 4

◆ INNODB_TABLES_SPACE_TYPE

#define INNODB_TABLES_SPACE_TYPE 7

◆ INNODB_TABLES_TOTAL_COLUMN_COUNTS

#define INNODB_TABLES_TOTAL_COLUMN_COUNTS 12

◆ INNODB_TABLES_TOTAL_ROW_VERSIONS

#define INNODB_TABLES_TOTAL_ROW_VERSIONS 9

◆ INNODB_TABLES_ZIP_PAGE_SIZE

#define INNODB_TABLES_ZIP_PAGE_SIZE 6

◆ INNODB_TABLESPACES_ALLOC_SIZE

#define INNODB_TABLESPACES_ALLOC_SIZE 9

◆ INNODB_TABLESPACES_AUTOEXTEND_SIZE

#define INNODB_TABLESPACES_AUTOEXTEND_SIZE 10

◆ INNODB_TABLESPACES_ENCRYPTION

#define INNODB_TABLESPACES_ENCRYPTION 13

◆ INNODB_TABLESPACES_FILE_SIZE

#define INNODB_TABLESPACES_FILE_SIZE 8

◆ INNODB_TABLESPACES_FLAGS

#define INNODB_TABLESPACES_FLAGS 2

◆ INNODB_TABLESPACES_FS_BLOCK_SIZE

#define INNODB_TABLESPACES_FS_BLOCK_SIZE 7

◆ INNODB_TABLESPACES_NAME

#define INNODB_TABLESPACES_NAME 1

◆ INNODB_TABLESPACES_PAGE_SIZE

#define INNODB_TABLESPACES_PAGE_SIZE 4

◆ INNODB_TABLESPACES_ROW_FORMAT

#define INNODB_TABLESPACES_ROW_FORMAT 3

◆ INNODB_TABLESPACES_SERVER_VERSION

#define INNODB_TABLESPACES_SERVER_VERSION 11

◆ INNODB_TABLESPACES_SPACE

#define INNODB_TABLESPACES_SPACE 0

◆ INNODB_TABLESPACES_SPACE_TYPE

#define INNODB_TABLESPACES_SPACE_TYPE 6

◆ INNODB_TABLESPACES_SPACE_VERSION

#define INNODB_TABLESPACES_SPACE_VERSION 12

◆ INNODB_TABLESPACES_STATE

#define INNODB_TABLESPACES_STATE 14

◆ INNODB_TABLESPACES_ZIP_PAGE_SIZE

#define INNODB_TABLESPACES_ZIP_PAGE_SIZE 5

◆ INNODB_TABLESTATS_AUTONINC

#define INNODB_TABLESTATS_AUTONINC 7

◆ INNODB_TABLESTATS_CLUST_SIZE

#define INNODB_TABLESTATS_CLUST_SIZE 4

◆ INNODB_TABLESTATS_ID

#define INNODB_TABLESTATS_ID 0

◆ INNODB_TABLESTATS_INDEX_SIZE

#define INNODB_TABLESTATS_INDEX_SIZE 5

◆ INNODB_TABLESTATS_INIT

#define INNODB_TABLESTATS_INIT 2

◆ INNODB_TABLESTATS_MODIFIED

#define INNODB_TABLESTATS_MODIFIED 6

◆ INNODB_TABLESTATS_NAME

#define INNODB_TABLESTATS_NAME 1

◆ INNODB_TABLESTATS_NROW

#define INNODB_TABLESTATS_NROW 3

◆ INNODB_TABLESTATS_TABLE_REF_COUNT

#define INNODB_TABLESTATS_TABLE_REF_COUNT 8

◆ INNODB_VIRTUAL_BASE_POS

#define INNODB_VIRTUAL_BASE_POS 2

◆ INNODB_VIRTUAL_POS

#define INNODB_VIRTUAL_POS 1

◆ INNODB_VIRTUAL_TABLE_ID

#define INNODB_VIRTUAL_TABLE_ID 0

◆ METRIC_AVG_VALUE_RESET

#define METRIC_AVG_VALUE_RESET 9

◆ METRIC_AVG_VALUE_START

#define METRIC_AVG_VALUE_START 5

◆ METRIC_DESC

#define METRIC_DESC 16

◆ METRIC_MAX_VALUE_RESET

#define METRIC_MAX_VALUE_RESET 7

◆ METRIC_MAX_VALUE_START

#define METRIC_MAX_VALUE_START 3

◆ METRIC_MIN_VALUE_RESET

#define METRIC_MIN_VALUE_RESET 8

◆ METRIC_MIN_VALUE_START

#define METRIC_MIN_VALUE_START 4

◆ METRIC_NAME

#define METRIC_NAME 0

◆ METRIC_RESET_TIME

#define METRIC_RESET_TIME 13

◆ METRIC_START_TIME

#define METRIC_START_TIME 10

◆ METRIC_STATUS

#define METRIC_STATUS 14

◆ METRIC_STOP_TIME

#define METRIC_STOP_TIME 11

◆ METRIC_SUBSYS

#define METRIC_SUBSYS 1

◆ METRIC_TIME_ELAPSED

#define METRIC_TIME_ELAPSED 12

◆ METRIC_TYPE

#define METRIC_TYPE 15

◆ METRIC_VALUE_RESET

#define METRIC_VALUE_RESET 6

◆ METRIC_VALUE_START

#define METRIC_VALUE_START 2

◆ OK

#define OK ( expr )

Value:

  if ((expr) != 0) { \
    return 1;        \
  }

◆ STOPWORD_VALUE

#define STOPWORD_VALUE 0

◆ STRUCT_FLD

#define STRUCT_FLD	(	name,
		value
	)	value

◆ SYS_COLUMN__PRTYPE

#define SYS_COLUMN__PRTYPE 4

◆ SYS_COLUMN_COLUMN_LEN

#define SYS_COLUMN_COLUMN_LEN 5

◆ SYS_COLUMN_DEFAULT_VALUE

#define SYS_COLUMN_DEFAULT_VALUE 7

◆ SYS_COLUMN_HAS_DEFAULT

#define SYS_COLUMN_HAS_DEFAULT 6

◆ SYS_COLUMN_MTYPE

#define SYS_COLUMN_MTYPE 3

◆ SYS_COLUMN_NAME

#define SYS_COLUMN_NAME 1

◆ SYS_COLUMN_PHYSICAL_POS

#define SYS_COLUMN_PHYSICAL_POS 10

◆ SYS_COLUMN_POSITION

#define SYS_COLUMN_POSITION 2

◆ SYS_COLUMN_TABLE_ID

#define SYS_COLUMN_TABLE_ID 0

◆ SYS_COLUMN_VERSION_ADDED

#define SYS_COLUMN_VERSION_ADDED 8

◆ SYS_COLUMN_VERSION_DROPPED

#define SYS_COLUMN_VERSION_DROPPED 9

◆ SYS_INDEX_ID

#define SYS_INDEX_ID 0

◆ SYS_INDEX_MERGE_THRESHOLD

#define SYS_INDEX_MERGE_THRESHOLD 7

◆ SYS_INDEX_NAME

#define SYS_INDEX_NAME 1

◆ SYS_INDEX_NUM_FIELDS

#define SYS_INDEX_NUM_FIELDS 4

◆ SYS_INDEX_PAGE_NO

#define SYS_INDEX_PAGE_NO 5

◆ SYS_INDEX_SPACE

#define SYS_INDEX_SPACE 6

◆ SYS_INDEX_TABLE_ID

#define SYS_INDEX_TABLE_ID 2

◆ SYS_INDEX_TYPE

#define SYS_INDEX_TYPE 3

Typedef Documentation

◆ temp_table_info_cache_t

typedef std::vector<temp_table_info_t, ut::allocator<temp_table_info_t> > temp_table_info_cache_t

Function Documentation

◆ field_blob_store()

static int field_blob_store	(	Field *	field,
		dict_col_default_t *	default_val
	)

static

Function to fill the BLOB value for column default value.

Parameters

[in,out]	field	field to store default value
[in]	default_val	default value to fill

Returns: 0 on success

◆ field_store_index_name()

static int field_store_index_name	(	Field *	field,
		const char *	index_name
	)

static

Store the name of an index in a MYSQL_TYPE_VARCHAR field.

Handles the names of incomplete secondary indexes.

Returns: 0 on success

Parameters

field	in/out: target field for storage
index_name	in: NUL-terminated utf-8 index name, possibly starting with TEMP_INDEX_PREFIX

◆ field_store_string()

static int field_store_string	(	Field *	field,
		const char *	str
	)

static

Auxiliary function to store char* value in MYSQL_TYPE_STRING field.

Returns: 0 on success

Parameters

field	in/out: target field for storage
str	in: NUL-terminated utf-8 string, or NULL

◆ field_store_time_t()

static int field_store_time_t	(	Field *	field,
		time_t	time
	)

static

Auxiliary function to store time_t value in MYSQL_TYPE_DATETIME field.

Returns: 0 on success

Parameters

field	in/out: target field for storage
time	in: value to store

◆ fill_innodb_trx_from_cache()

static int fill_innodb_trx_from_cache	(	trx_i_s_cache_t *	cache,
		THD *	thd,
		TABLE *	table
	)

static

Read data from cache buffer and fill the INFORMATION_SCHEMA.innodb_trx table with it.

Returns: 0 on success

Parameters

cache	in: cache to read from
thd	in: used to call schema_table_store_record()
table	in/out: fill this table

◆ i_s_cmp_fill()

static int i_s_cmp_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *	cond
	)

static

Fill the dynamic table information_schema.innodb_cmp.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
cond	in: condition (ignored)

◆ i_s_cmp_fill_low()

static int i_s_cmp_fill_low	(	THD *	thd,
		Table_ref *	tables,
		Item *	,
		bool	reset
	)

static

Fill the dynamic table information_schema.innodb_cmp or innodb_cmp_reset.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
reset	in: true=reset cumulated counts

◆ i_s_cmp_init()

static int i_s_cmp_init ( void * p )

static

Bind the dynamic table information_schema.innodb_cmp.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_cmp_per_index_fill()

static int i_s_cmp_per_index_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *	cond
	)

static

Fill the dynamic table information_schema.innodb_cmp_per_index.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
cond	in: condition (ignored)

◆ i_s_cmp_per_index_fill_low()

static int i_s_cmp_per_index_fill_low	(	THD *	thd,
		Table_ref *	tables,
		Item *	,
		bool	reset
	)

static

Fill the dynamic table information_schema.innodb_cmp_per_index or information_schema.innodb_cmp_per_index_reset.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
reset	in: true=reset cumulated counts

◆ i_s_cmp_per_index_init()

static int i_s_cmp_per_index_init ( void * p )

static

Bind the dynamic table information_schema.innodb_cmp_per_index.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_cmp_per_index_reset_fill()

static int i_s_cmp_per_index_reset_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *	cond
	)

static

Fill the dynamic table information_schema.innodb_cmp_per_index_reset.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
cond	in: condition (ignored)

◆ i_s_cmp_per_index_reset_init()

static int i_s_cmp_per_index_reset_init ( void * p )

static

Bind the dynamic table information_schema.innodb_cmp_per_index_reset.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_cmp_reset_fill()

static int i_s_cmp_reset_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *	cond
	)

static

Fill the dynamic table information_schema.innodb_cmp_reset.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
cond	in: condition (ignored)

◆ i_s_cmp_reset_init()

static int i_s_cmp_reset_init ( void * p )

static

Bind the dynamic table information_schema.innodb_cmp_reset.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_cmpmem_fill()

static int i_s_cmpmem_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Fill the dynamic table information_schema.innodb_cmpmem.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_cmpmem_fill_low()

static int i_s_cmpmem_fill_low	(	THD *	thd,
		Table_ref *	tables,
		bool	reset
	)

static

Fill the dynamic table information_schema.innodb_cmpmem or innodb_cmpmem_reset.

Parameters

[in]	thd	thread
[in,out]	tables	tables to fill
[in]	reset	true=reset cumulated counts

Returns: 0 on success, 1 on failure

◆ i_s_cmpmem_init()

static int i_s_cmpmem_init ( void * p )

static

Bind the dynamic table information_schema.innodb_cmpmem.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_cmpmem_reset_fill()

static int i_s_cmpmem_reset_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Fill the dynamic table information_schema.innodb_cmpmem_reset.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_cmpmem_reset_init()

static int i_s_cmpmem_reset_init ( void * p )

static

Bind the dynamic table information_schema.innodb_cmpmem_reset.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_common_deinit()

static int i_s_common_deinit ( void * p )

static

Unbind a dynamic INFORMATION_SCHEMA table.

Returns: 0 on success in/out: table schema object; 0 on success

Parameters

p	in/out: table schema object

◆ i_s_dict_fill_innodb_columns()

static int i_s_dict_fill_innodb_columns	(	THD *	thd,
		table_id_t	table_id,
		const char *	col_name,
		dict_col_t *	column,
		ulint	nth_v_col,
		TABLE *	table_to_fill
	)

static

Function to populate the information_schema.innodb_columns with related column information.

Parameters

[in]	thd	thread
[in]	table_id	table id
[in]	col_name	column name
[in]	column	dict_col_t obj
[in]	nth_v_col	virtual column, its sequence number
[in,out]	table_to_fill	fill this table

Returns: 0 on success

◆ i_s_dict_fill_innodb_indexes()

static int i_s_dict_fill_innodb_indexes	(	THD *	thd,
		const dict_index_t *	index,
		TABLE *	table_to_fill
	)

static

Function to populate the information_schema.innodb_indexes table with collected index information.

Parameters

[in]	thd	thread
[in]	index	dict_index_t obj
[in,out]	table_to_fill	fill this table

Returns: 0 on success

◆ i_s_dict_fill_innodb_tables()

static int i_s_dict_fill_innodb_tables	(	THD *	thd,
		dict_table_t *	table,
		TABLE *	table_to_fill
	)

static

Populate information_schema.innodb_tables table with information from INNODB_TABLES.

Parameters

[in]	thd	thread
[in]	table	table obj
[in,out]	table_to_fill	fill this table

Returns: 0 on success

◆ i_s_dict_fill_innodb_tablespaces()

static int i_s_dict_fill_innodb_tablespaces	(	THD *	thd,
		space_id_t	space_id,
		const char *	name,
		uint32_t	flags,
		uint32_t	server_version,
		uint32_t	space_version,
		bool	is_encrypted,
		uint64_t	autoextend_size,
		const char *	state,
		TABLE *	table_to_fill
	)

static

Function to fill INFORMATION_SCHEMA.INNODB_TABLESPACES with information collected by scanning INNODB_TABLESPACESS table.

Parameters

[in]	thd	thread
[in]	space_id	space ID
[in]	name	tablespace name
[in]	flags	tablespace flags
[in]	server_version	server version
[in]	space_version	tablespace version
[in]	is_encrypted	true if tablespace is encrypted
[in]	autoextend_size	autoextend_size attribute value
[in]	state	tablespace state
[in,out]	table_to_fill	fill this table

Returns: 0 on success

◆ i_s_dict_fill_innodb_tablestats()

static int i_s_dict_fill_innodb_tablestats	(	THD *	thd,
		dict_table_t *	table,
		ulint	ref_count,
		TABLE *	table_to_fill
	)

static

Populate information_schema.innodb_tablestats table with information from INNODB_TABLES.

Parameters

[in]	thd	thread ID
[in,out]	table	table
[in]	ref_count	table reference count
[in,out]	table_to_fill	fill this table

Returns: 0 on success

◆ i_s_dict_fill_innodb_virtual()

static int i_s_dict_fill_innodb_virtual	(	THD *	thd,
		table_id_t	table_id,
		ulint	pos,
		ulint	base_pos,
		TABLE *	table_to_fill
	)

static

Function to populate the information_schema.innodb_virtual with related information param[in] thd thread param[in] table_id table ID param[in] pos virtual column position param[in] base_pos base column position param[in,out] table_to_fill fill this table.

Returns: 0 on success

◆ i_s_fill_innodb_cached_indexes_row()

static int i_s_fill_innodb_cached_indexes_row	(	THD *	thd,
		space_id_t	space_id,
		ulint	index_id,
		TABLE *	table_to_fill
	)

static

Populate INFORMATION_SCHEMA.INNODB_CACHED_INDEXES.

Parameters

[in]	thd	user thread
[in]	space_id	space id
[in]	index_id	index id
[in,out]	table_to_fill	fill this table

Returns: 0 on success

◆ i_s_fts_being_deleted_fill()

static int i_s_fts_being_deleted_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_fts_being_deleted_init()

static int i_s_fts_being_deleted_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_fts_config_fill()

static int i_s_fts_config_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_CONFIG.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_fts_config_init()

static int i_s_fts_config_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_FT_CONFIG.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_fts_deleted_fill()

static int i_s_fts_deleted_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_DELETED.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_fts_deleted_generic_fill()

static int i_s_fts_deleted_generic_fill	(	THD *	thd,
		Table_ref *	tables,
		bool	being_deleted
	)

static

Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_DELETED or INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
being_deleted	in: BEING_DELTED table

◆ i_s_fts_deleted_init()

static int i_s_fts_deleted_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_FT_DELETED.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_fts_index_cache_fill()

static int i_s_fts_index_cache_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHED.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_fts_index_cache_fill_one_index()

static int i_s_fts_index_cache_fill_one_index	(	fts_index_cache_t *	index_cache,
		THD *	thd,
		Table_ref *	tables
	)

static

Go through the Doc Node and its ilist, fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHED for one FTS index on the table.

Returns: 0 on success, 1 on failure

Parameters

index_cache	in: FTS index cache
thd	in: thread
tables	in/out: tables to fill

◆ i_s_fts_index_cache_init()

static int i_s_fts_index_cache_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_fts_index_table_fill()

static int i_s_fts_index_table_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Fill the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_fts_index_table_fill_one_fetch()

static int i_s_fts_index_table_fill_one_fetch	(	CHARSET_INFO *	index_charset,
		THD *	thd,
		Table_ref *	tables,
		ib_vector_t *	words,
		fts_string_t *	conv_str,
		bool	has_more
	)

static

Go through words, fill INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE.

Returns: 0 on success, 1 on failure

Parameters

index_charset	in: FTS index charset
thd	in: thread
tables	in/out: tables to fill
words	in: words fetched
conv_str	in: string for conversion
has_more	in: has more to fetch

◆ i_s_fts_index_table_fill_one_index()

static int i_s_fts_index_table_fill_one_index	(	dict_index_t *	index,
		THD *	thd,
		Table_ref *	tables
	)

static

Go through a FTS index and its auxiliary tables, fetch rows in each table and fill INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE.

Returns: 0 on success, 1 on failure

Parameters

index	in: FTS index
thd	in: thread
tables	in/out: tables to fill

◆ i_s_fts_index_table_fill_selected()

static dberr_t i_s_fts_index_table_fill_selected	(	dict_index_t *	index,
		ib_vector_t *	words,
		ulint	selected,
		fts_string_t *	word
	)

static

Go through a FTS index auxiliary table, fetch its rows and fill FTS word cache structure.

Returns: DB_SUCCESS on success, otherwise error code

Parameters

index	in: FTS index
words	in/out: vector to hold fetched words
selected	in: selected FTS index
word	in: word to select

◆ i_s_fts_index_table_free_one_fetch()

static void i_s_fts_index_table_free_one_fetch ( ib_vector_t * words )

static

Free words.

Parameters

words in: words fetched

◆ i_s_fts_index_table_init()

static int i_s_fts_index_table_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ i_s_innodb_buf_page_lru_fill()

static int i_s_innodb_buf_page_lru_fill	(	THD *	thd,
		Table_ref *	tables,
		const buf_page_info_t *	info_array,
		ulint	num_page
	)

static

Fill Information Schema table INNODB_BUFFER_PAGE_LRU with information cached in the buf_page_info_t array.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
info_array	in: array cached page info
num_page	in: number of page info cached

◆ i_s_innodb_buf_page_lru_fill_table()

static int i_s_innodb_buf_page_lru_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Fill page information for pages in InnoDB buffer pool to the dynamic table INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_innodb_buffer_page_fill()

static int i_s_innodb_buffer_page_fill	(	THD *	thd,
		Table_ref *	tables,
		const buf_page_info_t *	info_array,
		ulint	num_page
	)

static

Fill Information Schema table INNODB_BUFFER_PAGE with information cached in the buf_page_info_t array.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
info_array	in: array cached page info
num_page	in: number of page info cached

◆ i_s_innodb_buffer_page_fill_table()

static int i_s_innodb_buffer_page_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Fill page information for pages in InnoDB buffer pool to the dynamic table INFORMATION_SCHEMA.INNODB_BUFFER_PAGE.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_innodb_buffer_page_get_info()

static void i_s_innodb_buffer_page_get_info	(	const buf_page_t *	bpage,
		ulint	pool_id,
		ulint	pos,
		buf_page_info_t *	page_info
	)

static

Scans pages in the buffer cache, and collect their general information into the buf_page_info_t array which is zero-filled.

So any fields that are not initialized in the function will default to 0

Parameters

bpage	in: buffer pool page to scan
pool_id	in: buffer pool id
pos	in: buffer block position in buffer pool or in the LRU list
page_info	in: zero filled info structure; out: structure filled with scanned info

◆ i_s_innodb_buffer_page_init()

static int i_s_innodb_buffer_page_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_BUFFER_PAGE.

Returns: 0 on success, 1 on failure

Parameters

p	in/out: table schema object

◆ i_s_innodb_buffer_page_lru_init()

static int i_s_innodb_buffer_page_lru_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU.

Returns: 0 on success, 1 on failure

Parameters

p	in/out: table schema object

◆ i_s_innodb_buffer_pool_stats_init()

static int i_s_innodb_buffer_pool_stats_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS.

Returns: 0 on success, 1 on failure

Parameters

p	in/out: table schema object

◆ i_s_innodb_buffer_stats_fill_table()

static int i_s_innodb_buffer_stats_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

This is the function that loops through each buffer pool and fetch buffer pool stats to information schema table: I_S_INNODB_BUFFER_POOL_STATS.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_innodb_cached_indexes_fill_table()

static int i_s_innodb_cached_indexes_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Go through each record in INNODB_INDEXES, and fill INFORMATION_SCHEMA.INNODB_CACHED_INDEXES.

Parameters

[in]	thd	thread
[in,out]	tables	tables to fill

Returns: 0 on success

◆ i_s_innodb_columns_fill_table()

static int i_s_innodb_columns_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Function to fill information_schema.innodb_columns with information collected by scanning INNODB_COLUMNS table.

Parameters

[in]	thd	thread
[in,out]	tables	tables to fill

Returns: 0 on success

◆ i_s_innodb_fill_buffer_lru()

static int i_s_innodb_fill_buffer_lru	(	THD *	thd,
		Table_ref *	tables,
		buf_pool_t *	buf_pool,
		const ulint	pool_id
	)

static

This is the function that goes through buffer pool's LRU list and fetch information to INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU.

Parameters

[in]	thd	thread
[in,out]	tables	tables to fill
[in]	buf_pool	buffer pool to scan
[in]	pool_id	buffer pool id

Returns: 0 on success, 1 on failure

◆ i_s_innodb_fill_buffer_pool()

static int i_s_innodb_fill_buffer_pool	(	THD *	thd,
		Table_ref *	tables,
		buf_pool_t *	buf_pool,
		const ulint	pool_id
	)

static

This is the function that goes through each block of the buffer pool and fetch information to information schema tables: INNODB_BUFFER_PAGE.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
buf_pool	in: buffer pool to scan
pool_id	in: buffer pool id

◆ i_s_innodb_indexes_fill_table()

static int i_s_innodb_indexes_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Function to go through each record in INNODB_INDEXES table, and fill the information_schema.innodb_indexes table with related index information.

Parameters

[in]	thd	thread
[in,out]	tables	tables to fill

Returns: 0 on success

◆ i_s_innodb_session_temp_tablespaces_fill()

static int i_s_innodb_session_temp_tablespaces_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Function to populate INFORMATION_SCHEMA.INNODB_SESSION_TEMPORARY_TABLESPACES table.

Iterate over the in-memory structure and fill the table

Parameters

[in]	thd	thread
[in,out]	tables	tables to fill

Returns: 0 on success

◆ i_s_innodb_session_temp_tablespaces_fill_one()

static int i_s_innodb_session_temp_tablespaces_fill_one	(	THD *	thd,
		const ibt::Tablespace *	ts,
		TABLE *	table_to_fill
	)

static

Function to fill INFORMATION_SCHEMA.INNODB_SESSION_TEMPORARY_TABLESPACES.

Parameters

[in]	thd	thread
[in]	ts	temp tablespace object
[in,out]	table_to_fill	fill this table

Returns: 0 on success

◆ i_s_innodb_set_page_type()

static void i_s_innodb_set_page_type	(	buf_page_info_t *	page_info,
		ulint	page_type,
		const byte *	frame
	)

static

Set appropriate page type to a buf_page_info_t structure.

Parameters

page_info	in/out: structure to fill with scanned info
page_type	in: page type
frame	in: buffer frame

◆ i_s_innodb_stats_fill()

static int i_s_innodb_stats_fill	(	THD *	thd,
		Table_ref *	tables,
		const buf_pool_info_t *	info
	)

static

Fill Information Schema table INNODB_BUFFER_POOL_STATS for a particular buffer pool.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
info	in: buffer pool information

◆ i_s_innodb_tables_fill_table()

static int i_s_innodb_tables_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Function to go through each record in INNODB_TABLES table, and fill the information_schema.innodb_tables table with related table information.

Parameters

[in]	thd	thread
[in,out]	tables	tables to fill

Returns: 0 on success

◆ i_s_innodb_tables_fill_table_stats()

static int i_s_innodb_tables_fill_table_stats	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Function to go through each record in INNODB_TABLES table, and fill the information_schema.innodb_tablestats table with table statistics related information.

Parameters

[in]	thd	thread
[in,out]	tables	tables to fill

Returns: 0 on success

◆ i_s_innodb_tablespaces_fill_table()

static int i_s_innodb_tablespaces_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Function to populate INFORMATION_SCHEMA.INNODB_TABLESPACES table.

Loop through each record in INNODB_TABLESPACES, and extract the column information and fill the INFORMATION_SCHEMA.INNODB_TABLESPACES table.

Parameters

[in]	thd	thread
[in,out]	tables	tables to fill

Returns: 0 on success

◆ i_s_innodb_temp_table_info_fill()

static int i_s_innodb_temp_table_info_fill	(	THD *	thd,
		Table_ref *	tables,
		const temp_table_info_t *	info
	)

static

Fill Information Schema table INNODB_TEMP_TABLE_INFO for a particular temp-table.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill
info	in: temp-table information

◆ i_s_innodb_temp_table_info_fill_table()

static int i_s_innodb_temp_table_info_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

This function will iterate over all available table and will fill stats for temp-tables to INNODB_TEMP_TABLE_INFO.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_innodb_temp_table_info_init()

static int i_s_innodb_temp_table_info_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO.

Returns: 0 on success, 1 on failure

Parameters

p	in/out: table schema object

◆ i_s_innodb_virtual_fill_table()

static int i_s_innodb_virtual_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Function to fill information_schema.innodb_virtual with information collected by scanning INNODB_VIRTUAL table.

param[in] thd thread param[in,out] tables tables to fill param[in] item condition (not used)

Returns: 0 on success

◆ i_s_metrics_fill()

static int i_s_metrics_fill	(	THD *	thd,
		TABLE *	table_to_fill
	)

static

Fill the information schema metrics table.

Returns: 0 on success

Parameters

thd	in: thread
table_to_fill	in/out: fill this table

◆ i_s_metrics_fill_table()

static int i_s_metrics_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Function to fill information schema metrics tables.

Returns: 0 on success

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_stopword_fill()

static int i_s_stopword_fill	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Fill the dynamic table information_schema.innodb_ft_default_stopword.

Returns: 0 on success, 1 on failure

Parameters

thd	in: thread
tables	in/out: tables to fill

◆ i_s_stopword_init()

static int i_s_stopword_init ( void * p )

static

Bind the dynamic table information_schema.innodb_ft_default_stopword.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ innodb_cached_indexes_init()

static int innodb_cached_indexes_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_CACHED_INDEXES.

Parameters

[in,out] p table schema object

Returns: 0 on success

◆ innodb_columns_init()

static int innodb_columns_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.innodb_columns.

Parameters

[in,out] p table schema object

Returns: 0 on success

◆ innodb_indexes_init()

static int innodb_indexes_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.innodb_indexes.

Parameters

[in,out] p table schema object

Returns: 0 on success

◆ innodb_metrics_init()

static int innodb_metrics_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.innodb_metrics.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ innodb_session_temp_tablespaces_init()

static int innodb_session_temp_tablespaces_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_SESSION_TEMPORARY_TABLESPACES.

Parameters

[in,out] p table schema object

Returns: 0 on success

◆ innodb_tables_init()

static int innodb_tables_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.innodb_tables.

Parameters

[in,out] p table schema object

Returns: 0 on success

◆ innodb_tablespaces_init()

static int innodb_tablespaces_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.INNODB_TABLESPACES.

Parameters

[in,out] p table schema object

Returns: 0 on success

◆ innodb_tablestats_init()

static int innodb_tablestats_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.innodb_tablestats.

Parameters

[in,out] p table schema object

Returns: 0 on success

◆ innodb_temp_table_populate_cache()

static void innodb_temp_table_populate_cache	(	const dict_table_t *	table,
		temp_table_info_t *	cache
	)

static

Populate current table information to cache.

Parameters

[in]	table	table
[in,out]	cache	populate data in this cache

◆ innodb_trx_init()

static int innodb_trx_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.innodb_trx.

Returns: 0 on success

Parameters

p	in/out: table schema object

◆ innodb_virtual_init()

static int innodb_virtual_init ( void * p )

static

Bind the dynamic table INFORMATION_SCHEMA.innodb_virtual param[in,out] p table schema object.

Returns: 0 on success

◆ process_rows()

static void process_rows	(	THD *	thd,
		Table_ref *	tables,
		const rec_t *	rec,
		dict_table_t *	dd_table,
		btr_pcur_t &	pcur,
		mtr_t &	mtr,
		mem_heap_t *	heap,
		bool	is_partition
	)

static

◆ trx_i_s_common_fill_table()

static int trx_i_s_common_fill_table	(	THD *	thd,
		Table_ref *	tables,
		Item *
	)

static

Common function to fill any of the dynamic tables: INFORMATION_SCHEMA.innodb_trx.

Returns: 0 on success in: condition (not used); 0 on success

Parameters

thd	in: thread
tables	in/out: tables to fill

Variable Documentation

◆ fts_config_key

const char* fts_config_key[]

static

Initial value:

= {
    FTS_OPTIMIZE_LIMIT_IN_SECS, FTS_SYNCED_DOC_ID, FTS_STOPWORD_TABLE_NAME,
    FTS_USE_STOPWORD, nullptr}

◆ i_s_cmp_fields_info

ST_FIELD_INFO i_s_cmp_fields_info[]

static

◆ i_s_cmp_per_index_fields_info

ST_FIELD_INFO i_s_cmp_per_index_fields_info[]

static

◆ i_s_cmpmem_fields_info

ST_FIELD_INFO i_s_cmpmem_fields_info[]

static

◆ i_s_fts_config_fields_info

ST_FIELD_INFO i_s_fts_config_fields_info[]

static

Initial value:

= {
#define FTS_CONFIG_KEY  
    {STRUCT_FLD(field_name, "KEY"), STRUCT_FLD(field_length, NAME_LEN + 1),
     STRUCT_FLD(field_type, MYSQL_TYPE_STRING), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, 0), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
#define FTS_CONFIG_VALUE  
    {STRUCT_FLD(field_name, "VALUE"), STRUCT_FLD(field_length, NAME_LEN + 1),
     STRUCT_FLD(field_type, MYSQL_TYPE_STRING), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, 0), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
    END_OF_ST_FIELD_INFO}

◆ i_s_fts_doc_fields_info

ST_FIELD_INFO i_s_fts_doc_fields_info[]

static

Initial value:

= {
#define I_S_FTS_DOC_ID  
    {STRUCT_FLD(field_name, "DOC_ID"),
     STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
     STRUCT_FLD(field_type, MYSQL_TYPE_LONGLONG), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_UNSIGNED), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
    END_OF_ST_FIELD_INFO}

◆ i_s_fts_index_fields_info

ST_FIELD_INFO i_s_fts_index_fields_info[]

static

◆ i_s_info

struct st_mysql_information_schema i_s_info

static

Initial value:

= {

MYSQL_INFORMATION_SCHEMA_INTERFACE_VERSION}

MYSQL_INFORMATION_SCHEMA_INTERFACE_VERSION

#define MYSQL_INFORMATION_SCHEMA_INTERFACE_VERSION

Definition: plugin.h:685

◆ i_s_innodb_buf_page_lru_fields_info

ST_FIELD_INFO i_s_innodb_buf_page_lru_fields_info[]

static

◆ i_s_innodb_buffer_page

struct st_mysql_plugin i_s_innodb_buffer_page

◆ i_s_innodb_buffer_page_fields_info

ST_FIELD_INFO i_s_innodb_buffer_page_fields_info[]

static

◆ i_s_innodb_buffer_page_lru

struct st_mysql_plugin i_s_innodb_buffer_page_lru

◆ i_s_innodb_buffer_stats

struct st_mysql_plugin i_s_innodb_buffer_stats

◆ i_s_innodb_buffer_stats_fields_info

ST_FIELD_INFO i_s_innodb_buffer_stats_fields_info[]

static

◆ i_s_innodb_cached_indexes

struct st_mysql_plugin i_s_innodb_cached_indexes

◆ i_s_innodb_cmp

struct st_mysql_plugin i_s_innodb_cmp

◆ i_s_innodb_cmp_per_index

struct st_mysql_plugin i_s_innodb_cmp_per_index

◆ i_s_innodb_cmp_per_index_reset

struct st_mysql_plugin i_s_innodb_cmp_per_index_reset

◆ i_s_innodb_cmp_reset

struct st_mysql_plugin i_s_innodb_cmp_reset

◆ i_s_innodb_cmpmem

struct st_mysql_plugin i_s_innodb_cmpmem

◆ i_s_innodb_cmpmem_reset

struct st_mysql_plugin i_s_innodb_cmpmem_reset

◆ i_s_innodb_columns

struct st_mysql_plugin i_s_innodb_columns

◆ i_s_innodb_ft_being_deleted

struct st_mysql_plugin i_s_innodb_ft_being_deleted

◆ i_s_innodb_ft_config

struct st_mysql_plugin i_s_innodb_ft_config

◆ i_s_innodb_ft_default_stopword

struct st_mysql_plugin i_s_innodb_ft_default_stopword

◆ i_s_innodb_ft_deleted

struct st_mysql_plugin i_s_innodb_ft_deleted

◆ i_s_innodb_ft_index_cache

struct st_mysql_plugin i_s_innodb_ft_index_cache

◆ i_s_innodb_ft_index_table

struct st_mysql_plugin i_s_innodb_ft_index_table

◆ i_s_innodb_indexes

struct st_mysql_plugin i_s_innodb_indexes

◆ i_s_innodb_metrics

struct st_mysql_plugin i_s_innodb_metrics

◆ i_s_innodb_plugin_version

constexpr uint64_t i_s_innodb_plugin_version

constexpr

Initial value:

=

(INNODB_VERSION_MAJOR << 8 | i_s_innodb_plugin_version_postfix)

i_s_innodb_plugin_version_postfix

constexpr uint8_t i_s_innodb_plugin_version_postfix

I_S.innodb_* views version postfix.

Definition: i_s.cc:110

INNODB_VERSION_MAJOR

#define INNODB_VERSION_MAJOR

Definition: univ.i:54

I_S.innodb_* views version.

It would be X.Y and X should be the server major version while Y is the InnoDB I_S views version, starting from 1

◆ i_s_innodb_plugin_version_postfix

constexpr uint8_t i_s_innodb_plugin_version_postfix = 2

constexpr

I_S.innodb_* views version postfix.

Every time the define of any InnoDB I_S table is changed, this value has to be increased accordingly

◆ i_s_innodb_session_temp_tablespaces

struct st_mysql_plugin i_s_innodb_session_temp_tablespaces

◆ i_s_innodb_tables

struct st_mysql_plugin i_s_innodb_tables

◆ i_s_innodb_tablespaces

struct st_mysql_plugin i_s_innodb_tablespaces

◆ i_s_innodb_tablestats

struct st_mysql_plugin i_s_innodb_tablestats

◆ i_s_innodb_temp_table_info

struct st_mysql_plugin i_s_innodb_temp_table_info

◆ i_s_innodb_temp_table_info_fields_info

ST_FIELD_INFO i_s_innodb_temp_table_info_fields_info[]

static

Initial value:

= {
#define IDX_TEMP_TABLE_ID  
    {STRUCT_FLD(field_name, "TABLE_ID"),
     STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
     STRUCT_FLD(field_type, MYSQL_TYPE_LONGLONG), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_UNSIGNED), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
#define IDX_TEMP_TABLE_NAME  
    {STRUCT_FLD(field_name, "NAME"), STRUCT_FLD(field_length, NAME_CHAR_LEN),
     STRUCT_FLD(field_type, MYSQL_TYPE_STRING), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_MAYBE_NULL), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
#define IDX_TEMP_TABLE_N_COLS  
    {STRUCT_FLD(field_name, "N_COLS"),
     STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
     STRUCT_FLD(field_type, MYSQL_TYPE_LONG), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_UNSIGNED), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
#define IDX_TEMP_TABLE_SPACE_ID  
    {STRUCT_FLD(field_name, "SPACE"),
     STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
     STRUCT_FLD(field_type, MYSQL_TYPE_LONG), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_UNSIGNED), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
    END_OF_ST_FIELD_INFO}

◆ i_s_innodb_trx

struct st_mysql_plugin i_s_innodb_trx

◆ i_s_innodb_virtual

struct st_mysql_plugin i_s_innodb_virtual

◆ i_s_page_type

buf_page_desc_t i_s_page_type[]

static

Name string for File Page Types.

◆ I_S_PAGE_TYPE_BITS

constexpr auto I_S_PAGE_TYPE_BITS = 6

constexpr

◆ I_S_PAGE_TYPE_IBUF

constexpr auto I_S_PAGE_TYPE_IBUF = (FIL_PAGE_TYPE_LAST + 2)

constexpr

Change buffer B-tree page.

◆ I_S_PAGE_TYPE_INDEX

constexpr size_t I_S_PAGE_TYPE_INDEX = 1

constexpr

We also define I_S_PAGE_TYPE_INDEX as the Index Page's position in i_s_page_type[] array.

◆ I_S_PAGE_TYPE_LAST

constexpr auto I_S_PAGE_TYPE_LAST = I_S_PAGE_TYPE_SDI

constexpr

◆ I_S_PAGE_TYPE_RTREE

constexpr auto I_S_PAGE_TYPE_RTREE = (FIL_PAGE_TYPE_LAST + 1)

constexpr

R-tree index page.

◆ I_S_PAGE_TYPE_SDI

constexpr auto I_S_PAGE_TYPE_SDI = (FIL_PAGE_TYPE_LAST + 3)

constexpr

SDI B-tree page.

◆ I_S_PAGE_TYPE_UNKNOWN

constexpr auto I_S_PAGE_TYPE_UNKNOWN = FIL_PAGE_TYPE_UNKNOWN

constexpr

Any unassigned FIL_PAGE_TYPE will be treated as unknown.

◆ i_s_stopword_fields_info

ST_FIELD_INFO i_s_stopword_fields_info[]

static

Initial value:

= {
#define STOPWORD_VALUE  
    {STRUCT_FLD(field_name, "value"), STRUCT_FLD(field_length, 18),
     STRUCT_FLD(field_type, MYSQL_TYPE_STRING), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, 0), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
    END_OF_ST_FIELD_INFO}

◆ innodb_cached_indexes_fields_info

ST_FIELD_INFO innodb_cached_indexes_fields_info[]

static

Initial value:

= {
#define CACHED_INDEXES_SPACE_ID  
    {STRUCT_FLD(field_name, "SPACE_ID"),
     STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
     STRUCT_FLD(field_type, MYSQL_TYPE_LONG), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_UNSIGNED), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
#define CACHED_INDEXES_INDEX_ID  
    {STRUCT_FLD(field_name, "INDEX_ID"),
     STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
     STRUCT_FLD(field_type, MYSQL_TYPE_LONGLONG), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_UNSIGNED), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
#define CACHED_INDEXES_N_CACHED_PAGES  
    {STRUCT_FLD(field_name, "N_CACHED_PAGES"),
     STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
     STRUCT_FLD(field_type, MYSQL_TYPE_LONGLONG), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_UNSIGNED), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
    END_OF_ST_FIELD_INFO}

INFORMATION_SCHEMA.INNODB_CACHED_INDEXES.

◆ innodb_columns_fields_info

ST_FIELD_INFO innodb_columns_fields_info[]

static

INNODB_COLUMNS

◆ innodb_metrics_fields_info

ST_FIELD_INFO innodb_metrics_fields_info[]

static

◆ innodb_session_temp_tablespaces_fields_info

ST_FIELD_INFO innodb_session_temp_tablespaces_fields_info[]

static

INNODB_SESSION_TEMPORARY TABLESPACES

◆ innodb_sysindex_fields_info

ST_FIELD_INFO innodb_sysindex_fields_info[]

static

INNODB_INDEXES

◆ innodb_tables_fields_info

ST_FIELD_INFO innodb_tables_fields_info[]

static

INNODB_TABLES

◆ innodb_tablespaces_fields_info

ST_FIELD_INFO innodb_tablespaces_fields_info[]

static

INNODB_TABLESPACES

◆ innodb_tablestats_fields_info

ST_FIELD_INFO innodb_tablestats_fields_info[]

static

INNODB_TABLESTATS

◆ innodb_trx_fields_info

ST_FIELD_INFO innodb_trx_fields_info[]

static

◆ innodb_virtual_fields_info

ST_FIELD_INFO innodb_virtual_fields_info[]

static

Initial value:

= {
#define INNODB_VIRTUAL_TABLE_ID  
    {STRUCT_FLD(field_name, "TABLE_ID"),
     STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
     STRUCT_FLD(field_type, MYSQL_TYPE_LONGLONG), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_UNSIGNED), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
#define INNODB_VIRTUAL_POS  
    {STRUCT_FLD(field_name, "POS"),
     STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
     STRUCT_FLD(field_type, MYSQL_TYPE_LONG), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_UNSIGNED), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
#define INNODB_VIRTUAL_BASE_POS  
    {STRUCT_FLD(field_name, "BASE_POS"),
     STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
     STRUCT_FLD(field_type, MYSQL_TYPE_LONG), STRUCT_FLD(value, 0),
     STRUCT_FLD(field_flags, MY_I_S_UNSIGNED), STRUCT_FLD(old_name, ""),
     STRUCT_FLD(open_method, 0)},
 
    END_OF_ST_FIELD_INFO}

INNODB_VIRTUAL.

Fields of the dynamic table INFORMATION_SCHEMA.INNODB_VIRTUAL Every time any column gets changed, added or removed, please remember to change i_s_innodb_plugin_version_postfix accordingly, so that the change can be propagated to server

◆ LOCK_global_system_variables

mysql_mutex_t LOCK_global_system_variables

extern

◆ MAX_BUF_INFO_CACHED

const ulint MAX_BUF_INFO_CACHED = 10000

Maximum number of buffer page info we would cache.

◆ plugin_author

constexpr char plugin_author[] = PLUGIN_AUTHOR_ORACLE

constexpr

Classes

Macros

Typedefs

Functions

Variables

Detailed Description

Macro Definition Documentation

◆ CACHED_INDEXES_INDEX_ID

◆ CACHED_INDEXES_N_CACHED_PAGES

◆ CACHED_INDEXES_SPACE_ID

◆ END_OF_ST_FIELD_INFO

◆ FTS_CONFIG_KEY

◆ FTS_CONFIG_VALUE

◆ I_S_FTS_DOC_COUNT

◆ I_S_FTS_DOC_ID

◆ I_S_FTS_FIRST_DOC_ID

◆ I_S_FTS_ILIST_DOC_ID

◆ I_S_FTS_ILIST_DOC_POS

◆ I_S_FTS_LAST_DOC_ID

◆ I_S_FTS_WORD

◆ IDX_BUF_LRU_PAGE_ACCESS_TIME

◆ IDX_BUF_LRU_PAGE_DATA_SIZE

◆ IDX_BUF_LRU_PAGE_FIX_COUNT

◆ IDX_BUF_LRU_PAGE_FLUSH_TYPE

◆ IDX_BUF_LRU_PAGE_FREE_CLOCK

◆ IDX_BUF_LRU_PAGE_HASHED

◆ IDX_BUF_LRU_PAGE_INDEX_NAME

◆ IDX_BUF_LRU_PAGE_IO_FIX

◆ IDX_BUF_LRU_PAGE_IS_OLD

◆ IDX_BUF_LRU_PAGE_NEWEST_MOD

◆ IDX_BUF_LRU_PAGE_NUM

◆ IDX_BUF_LRU_PAGE_NUM_RECS

◆ IDX_BUF_LRU_PAGE_OLDEST_MOD

◆ IDX_BUF_LRU_PAGE_SPACE

◆ IDX_BUF_LRU_PAGE_STATE

◆ IDX_BUF_LRU_PAGE_TABLE_NAME

◆ IDX_BUF_LRU_PAGE_TYPE

◆ IDX_BUF_LRU_PAGE_ZIP_SIZE

◆ IDX_BUF_LRU_POOL_ID

◆ IDX_BUF_LRU_POS

◆ IDX_BUF_STATS_FLUSH_LIST

◆ IDX_BUF_STATS_FLUSH_LIST_LEN

◆ IDX_BUF_STATS_FLUSH_LRU

◆ IDX_BUF_STATS_FREE_BUFFERS

◆ IDX_BUF_STATS_GET

◆ IDX_BUF_STATS_HIT_RATE

◆ IDX_BUF_STATS_LRU_IO_CUR

◆ IDX_BUF_STATS_LRU_IO_SUM

◆ IDX_BUF_STATS_LRU_LEN

◆ IDX_BUF_STATS_MADE_YOUNG_PCT

◆ IDX_BUF_STATS_NOT_MADE_YOUNG_PCT

◆ IDX_BUF_STATS_OLD_LRU_LEN

◆ IDX_BUF_STATS_PAGE_CREATE_RATE

◆ IDX_BUF_STATS_PAGE_CREATED

◆ IDX_BUF_STATS_PAGE_NOT_YOUNG

◆ IDX_BUF_STATS_PAGE_NOT_YOUNG_RATE

◆ IDX_BUF_STATS_PAGE_READ

◆ IDX_BUF_STATS_PAGE_READ_RATE

◆ IDX_BUF_STATS_PAGE_WRITTEN

◆ IDX_BUF_STATS_PAGE_WRITTEN_RATE

◆ IDX_BUF_STATS_PAGE_YOUNG

◆ IDX_BUF_STATS_PAGE_YOUNG_RATE

◆ IDX_BUF_STATS_PENDING_READ

◆ IDX_BUF_STATS_PENDING_ZIP

◆ IDX_BUF_STATS_POOL_ID

◆ IDX_BUF_STATS_POOL_SIZE

◆ IDX_BUF_STATS_READ_AHEAD_EVICT_RATE

◆ IDX_BUF_STATS_READ_AHEAD_EVICTED

◆ IDX_BUF_STATS_READ_AHEAD_RATE

◆ IDX_BUF_STATS_READ_AHREAD

◆ IDX_BUF_STATS_UNZIP_CUR

◆ IDX_BUF_STATS_UNZIP_SUM

◆ IDX_BUFFER_BLOCK_ID

◆ IDX_BUFFER_PAGE_ACCESS_TIME

◆ IDX_BUFFER_PAGE_DATA_SIZE

◆ IDX_BUFFER_PAGE_FIX_COUNT

◆ IDX_BUFFER_PAGE_FLUSH_TYPE

◆ IDX_BUFFER_PAGE_FREE_CLOCK

◆ IDX_BUFFER_PAGE_HASHED

◆ IDX_BUFFER_PAGE_INDEX_NAME