/*****************************************************************************Copyright ( c ) 2007 , 2016 , Oracle and / or its affiliates . All Rights Reserved . Copyright ( c ) 2014 , 2023 , MariaDB Corporation . This program is free software ; you can redistribute it and / or modify it under the terms of the GNU General Public License as published by the Free Software Foundation ; version 2 of the License . This program is distributed in the hope that it will be useful , but WITHOUT ANY WARRANTY ; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE . See the GNU General Public License for more details . You should have received a copy of the GNU General Public License along with this program ; if not , write to the Free Software Foundation , Inc . , 51 Franklin Street , Fifth Floor , Boston , MA 02110 - 1335 USA /**************************************************//** 18 , 2007 Vasil Dimov#include "univ.i" #include <mysql_version.h>#include <field.h>#include <sql_acl.h>#include <sql_show.h>#include <sql_time.h>#include "i_s.h" #include "btr0pcur.h" #include "btr0types.h" #include "dict0dict.h" #include "dict0load.h" #include "buf0buddy.h" #include "buf0buf.h" #include "dict0mem.h" #include "dict0types.h" #include "srv0start.h" #include "trx0i_s.h" #include "trx0trx.h" #include "srv0mon.h" #include "pars0pars.h" #include "fts0types.h" #include "fts0opt.h" #include "fts0priv.h" #include "fts0exec.h" #include "btr0btr.h" #include "page0zip.h" #include "fil0fil.h" #include "fil0crypt.h" #include "dict0crea.h" #include "fts0vlc.h" #include "scope.h" #include "log.h" /** The latest successfully looked up innodb_fts_aux_table */ /** structure associates a name string with a file page type and/or buffer struct buf_page_desc_t{const char * type_str; /*!< String explain the page /*!< Page type or page state */ /** We also define I_S_PAGE_TYPE_INDEX as the Index Page's position #define I_S_PAGE_TYPE_INDEX 1 /** Any unassigned FIL_PAGE_TYPE will be treated as unknown. */ #define I_S_PAGE_TYPE_UNKNOWN FIL_PAGE_TYPE_UNKNOWN/** R-tree index page */ #define I_S_PAGE_TYPE_RTREE (FIL_PAGE_TYPE_LAST + 1 )#define I_S_PAGE_TYPE_LAST I_S_PAGE_TYPE_RTREE#define I_S_PAGE_TYPE_BITS 4 /** Name string for File Page Types */ static buf_page_desc_t i_s_page_type[] = {"ALLOCATED" , FIL_PAGE_TYPE_ALLOCATED},"INDEX" , FIL_PAGE_INDEX},"UNDO_LOG" , FIL_PAGE_UNDO_LOG},"INODE" , FIL_PAGE_INODE},"IBUF_FREE_LIST" , FIL_PAGE_IBUF_FREE_LIST},"IBUF_BITMAP" , FIL_PAGE_IBUF_BITMAP},"SYSTEM" , FIL_PAGE_TYPE_SYS},"TRX_SYSTEM" , FIL_PAGE_TYPE_TRX_SYS},"FILE_SPACE_HEADER" , FIL_PAGE_TYPE_FSP_HDR},"EXTENT_DESCRIPTOR" , FIL_PAGE_TYPE_XDES},"BLOB" , FIL_PAGE_TYPE_BLOB},"COMPRESSED_BLOB" , FIL_PAGE_TYPE_ZBLOB},"COMPRESSED_BLOB2" , FIL_PAGE_TYPE_ZBLOB2},"UNKNOWN" , I_S_PAGE_TYPE_UNKNOWN},"RTREE_INDEX" , I_S_PAGE_TYPE_RTREE},/** This structure defines information we will fetch from pagescurrently cached in the buffer pool . It will be used to populate struct buf_page_info_t{/*!< Buffer Pool block ID */ /** page identifier */ /*!< Time of first access */ /*!< buf_page_t::state() */ #ifdef BTR_CUR_HASH_ADAPTunsigned hashed:1 ; /*!< Whether hash index has been #endif /* BTR_CUR_HASH_ADAPT */ unsigned is_old:1 ; /*!< TRUE if the block is in the old unsigned freed_page_clock:31 ; /*!< the value of unsigned zip_ssize:PAGE_ZIP_SSIZE_BITS;/*!< Compressed page size */ unsigned compressed_only:1 ; /*!< ROW_FORMAT=COMPRESSED only */ unsigned page_type:I_S_PAGE_TYPE_BITS; /*!< Page type */ unsigned num_recs:UNIV_PAGE_SIZE_SHIFT_MAX-2 ;/*!< Number of records on Page */ unsigned data_size:UNIV_PAGE_SIZE_SHIFT_MAX;/*!< Sum of the sizes of the records */ /*!< Log sequence number of /*!< Log sequence number of /*!< Index ID if a index page */ /*Use the following types mapping : C type ST_FIELD_INFO : : field_type - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - long MYSQL_TYPE_LONGLONG ( field_length = MY_INT64_NUM_DECIMAL_DIGITS ) long unsigned MYSQL_TYPE_LONGLONG ( field_length = MY_INT64_NUM_DECIMAL_DIGITS , field_flags = MY_I_S_UNSIGNED ) char * MYSQL_TYPE_STRING ( field_length = n ) float MYSQL_TYPE_FLOAT ( field_length = 0 is ignored ) void * MYSQL_TYPE_LONGLONG ( field_length = MY_INT64_NUM_DECIMAL_DIGITS , field_flags = MY_I_S_UNSIGNED ) boolean ( if else ) MYSQL_TYPE_LONG ( field_length = 1 ) time_t MYSQL_TYPE_DATETIME ( field_length = 0 ignored ) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - /**Common function to fill any of the dynamic tables : INFORMATION_SCHEMA . innodb_trx INFORMATION_SCHEMA . innodb_locks INFORMATION_SCHEMA . innodb_lock_waits @ retval false if access to the table is blocked static bool trx_i_s_common_fill_table(THD *thd, TABLE_LIST *tables)"trx_i_s_common_fill_table" );/* deny access to non-superusers */ if (check_global_access(thd, PROCESS_ACL))false );/* update the cache */ if (trx_i_s_possibly_fetch_data_into_cache())"InnoDB: Data in %.*s truncated due to memory limit" " of %u bytes" ,int (tables->schema_table_name.length),true );/*******************************************************************//** return 0 on success */static int /*==============*/ void * p); /*!< in/out: table schema object */ /*******************************************************************//** return 0 on success */static int /*===============*/ /*!< in/out: target field for storage */ /*!< in: value to store */ struct tm tm_time;if (time) {#if 0 /* use this if you are sure that `variables' and `time_zone' #else #endif else {0 , sizeof (my_time));/* JAN: TODO: MySQL 5.7 return ( field - > store_time ( & my_time , MYSQL_TIMESTAMP_DATETIME ) ) ; return (field->store_time(&my_time));/*******************************************************************//** char * value in MYSQL_TYPE_STRING field.return 0 on success */static int /*===============*/ /*!< in/out: target field for storage */ const char * str) /*!< in: NUL-terminated utf-8 string, if (!str) {return 0 ;return field->store(str, uint(strlen(str)), system_charset_info);#ifdef BTR_CUR_HASH_ADAPT# define I_S_AHI 1 /* Include the IS_HASHED column */ #else # define I_S_AHI 0 /* Omit the IS_HASHED column */ #endif static const LEX_CSTRING isolation_level_values[] ="READ UNCOMMITTED" ) },"READ COMMITTED" ) },"REPEATABLE READ" ) },"SERIALIZABLE" ) }static TypelibBuffer<4 > isolation_level_values_typelib(isolation_level_values);namespace Show {/* Fields of the dynamic table INFORMATION_SCHEMA.innodb_trx */ static ST_FIELD_INFO innodb_trx_fields_info[]=#define IDX_TRX_ID 0 "trx_id" , ULonglong(), NOT_NULL),#define IDX_TRX_STATE 1 "trx_state" , Varchar(13 ), NOT_NULL),#define IDX_TRX_STARTED 2 "trx_started" , Datetime(0 ), NOT_NULL),#define IDX_TRX_REQUESTED_LOCK_ID 3 "trx_requested_lock_id" ,1 ), NULLABLE),#define IDX_TRX_WAIT_STARTED 4 "trx_wait_started" , Datetime(0 ), NULLABLE),#define IDX_TRX_WEIGHT 5 "trx_weight" , ULonglong(), NOT_NULL),#define IDX_TRX_MYSQL_THREAD_ID 6 "trx_mysql_thread_id" , ULonglong(), NOT_NULL),#define IDX_TRX_QUERY 7 "trx_query" , Varchar(TRX_I_S_TRX_QUERY_MAX_LEN), NULLABLE),#define IDX_TRX_OPERATION_STATE 8 "trx_operation_state" , Varchar(64 ), NULLABLE),#define IDX_TRX_TABLES_IN_USE 9 "trx_tables_in_use" , ULonglong(), NOT_NULL),#define IDX_TRX_TABLES_LOCKED 10 "trx_tables_locked" , ULonglong(), NOT_NULL),#define IDX_TRX_LOCK_STRUCTS 11 "trx_lock_structs" , ULonglong(), NOT_NULL),#define IDX_TRX_LOCK_MEMORY_BYTES 12 "trx_lock_memory_bytes" , ULonglong(), NOT_NULL),#define IDX_TRX_ROWS_LOCKED 13 "trx_rows_locked" , ULonglong(), NOT_NULL),#define IDX_TRX_ROWS_MODIFIED 14 "trx_rows_modified" , ULonglong(), NOT_NULL),#define IDX_TRX_CONNCURRENCY_TICKETS 15 "trx_concurrency_tickets" , ULonglong(), NOT_NULL),#define IDX_TRX_ISOLATION_LEVEL 16 "trx_isolation_level" ,Enum (&isolation_level_values_typelib), NOT_NULL),#define IDX_TRX_UNIQUE_CHECKS 17 "trx_unique_checks" , SLong(1 ), NOT_NULL),#define IDX_TRX_FOREIGN_KEY_CHECKS 18 "trx_foreign_key_checks" , SLong(1 ), NOT_NULL),#define IDX_TRX_LAST_FOREIGN_KEY_ERROR 19 "trx_last_foreign_key_error" ,#define IDX_TRX_READ_ONLY 20 "trx_is_read_only" , SLong(1 ), NOT_NULL),#define IDX_TRX_AUTOCOMMIT_NON_LOCKING 21 "trx_autocommit_non_locking" , SLong(1 ), NOT_NULL),// namespace Show /*******************************************************************//** and fill the INFORMATION_SCHEMA.innodb_trx0 on success1 on failure */static int fill_innodb_trx_from_cache(THD *thd, TABLE_LIST *tables, Item*)char lock_id[TRX_I_S_LOCK_ID_MAX_LEN + 1 ];"fill_innodb_trx_from_cache" );if (!trx_i_s_common_fill_table(thd, tables)) {0 );struct cachefor (i = 0 ; i < rows_num; i++) {/* trx_id */ true ));/* trx_state */ /* trx_started */ /* trx_requested_lock_id */ /* trx_wait_started */ if (row->trx_wait_started != 0 ) {sizeof (lock_id))));/* field_store_string() sets it no notnull */ else {/* trx_weight */ true ));/* trx_mysql_thread_id */ true ));/* trx_query */ if (row->trx_query) {/* store will do appropriate character set static_cast <uint>(strlen(row->trx_query)),else {/* trx_operation_state */ /* trx_tables_in_use */ true ));/* trx_tables_locked */ true ));/* trx_lock_structs */ true ));/* trx_lock_memory_bytes */ true ));/* trx_rows_locked */ true ));/* trx_rows_modified */ true ));/* trx_concurrency_tickets */ 0 , true ));/* trx_isolation_level */ 1 + row->trx_isolation_level, true ));/* trx_unique_checks */ true ));/* trx_foreign_key_checks */ true ));/* trx_last_foreign_key_error */ /* trx_is_read_only*/ true ));/* trx_is_autocommit_non_locking */ true ));0 );/*******************************************************************//** return 0 on success */static int /*============*/ void * p) /*!< in/out: table schema object */ "innodb_trx_init" );0 );static struct st_mysql_information_schema i_s_info =/** version number reported by SHOW PLUGINS */ unsigned i_s_version= MYSQL_VERSION_MAJOR << 8 | MYSQL_VERSION_MINOR;struct st_maria_plugin i_s_innodb_trx =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_TRX" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB transactions" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ static const LEX_CSTRING lock_mode_values[] ="S" ) },"S,GAP" ) },"X" ) },"X,GAP" ) },"IS" ) },"IS,GAP" ) },"IX" ) },"IX,GAP" ) },"AUTO_INC" ) }static TypelibBuffer<9 > lock_mode_values_typelib(lock_mode_values);static const LEX_CSTRING lock_type_values[] ="RECORD" ) },"TABLE" ) }static TypelibBuffer<2 > lock_type_values_typelib(lock_type_values);namespace Show {/* Fields of the dynamic table INFORMATION_SCHEMA.innodb_locks */ static ST_FIELD_INFO innodb_locks_fields_info[]=#define IDX_LOCK_ID 0 "lock_id" , Varchar(TRX_I_S_LOCK_ID_MAX_LEN + 1 ), NOT_NULL),#define IDX_LOCK_TRX_ID 1 "lock_trx_id" , ULonglong(), NOT_NULL),#define IDX_LOCK_MODE 2 "lock_mode" , Enum (&lock_mode_values_typelib), NOT_NULL),#define IDX_LOCK_TYPE 3 "lock_type" , Enum (&lock_type_values_typelib), NOT_NULL),#define IDX_LOCK_TABLE 4 "lock_table" , Varchar(1024 ), NOT_NULL),#define IDX_LOCK_INDEX 5 "lock_index" , Varchar(1024 ), NULLABLE),#define IDX_LOCK_SPACE 6 "lock_space" , ULong(), NULLABLE),#define IDX_LOCK_PAGE 7 "lock_page" , ULong(), NULLABLE),#define IDX_LOCK_REC 8 "lock_rec" , ULong(), NULLABLE),#define IDX_LOCK_DATA 9 "lock_data" , Varchar(TRX_I_S_LOCK_DATA_MAX_LEN), NULLABLE),// namespace Show /*******************************************************************//** and fill the INFORMATION_SCHEMA.innodb_locksreturn 0 on success */static int /*=========================*/ /*!< in: MySQL client connection */ /*!< in/out: fill this table */ char lock_id[TRX_I_S_LOCK_ID_MAX_LEN + 1 ];"fill_innodb_locks_from_cache" );if (!trx_i_s_common_fill_table(thd, tables)) {0 );struct cachefor (i = 0 ; i < rows_num; i++) {char buf[MAX_FULL_NAME_LEN + 1 ];const char * bufend;/* lock_id */ sizeof (lock_id));/* lock_trx_id */ true ));/* lock_mode */ true ));/* lock_type */ 1 : 2 , true ));/* lock_table */ sizeof (buf),if (row->lock_index) {/* record lock */ true ));true ));true ));else {0 );/*******************************************************************//** return 0 on success */static int /*==============*/ void * p) /*!< in/out: table schema object */ "innodb_locks_init" );0 );struct st_maria_plugin i_s_innodb_locks =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_LOCKS" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB conflicting locks" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/* Fields of the dynamic table INFORMATION_SCHEMA.innodb_lock_waits */ static ST_FIELD_INFO innodb_lock_waits_fields_info[]=#define IDX_REQUESTING_TRX_ID 0 "requesting_trx_id" , ULonglong(), NOT_NULL),#define IDX_REQUESTED_LOCK_ID 1 "requested_lock_id" , Varchar(TRX_I_S_LOCK_ID_MAX_LEN + 1 ), NOT_NULL),#define IDX_BLOCKING_TRX_ID 2 "blocking_trx_id" , ULonglong(), NOT_NULL),#define IDX_BLOCKING_LOCK_ID 3 "blocking_lock_id" , Varchar(TRX_I_S_LOCK_ID_MAX_LEN + 1 ), NOT_NULL),// namespace Show /*******************************************************************//** and fill thereturn 0 on success */static int /*==============================*/ /*!< in: used to call /*!< in/out: fill this table */ char requested_lock_id[TRX_I_S_LOCK_ID_MAX_LEN + 1 ];char blocking_lock_id[TRX_I_S_LOCK_ID_MAX_LEN + 1 ];"fill_innodb_lock_waits_from_cache" );if (!trx_i_s_common_fill_table(thd, tables)) {0 );struct cachefor (i = 0 ; i < rows_num; i++) {/* requesting_trx_id */ true ));/* requested_lock_id */ sizeof (requested_lock_id))));/* blocking_trx_id */ true ));/* blocking_lock_id */ sizeof (blocking_lock_id))));0 );/*******************************************************************//** return 0 on success */static int /*===================*/ void * p) /*!< in/out: table schema object */ "innodb_lock_waits_init" );0 );struct st_maria_plugin i_s_innodb_lock_waits =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_LOCK_WAITS" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB which lock is blocking which" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/* Fields of the dynamic table information_schema.innodb_cmp. */ static ST_FIELD_INFO i_s_cmp_fields_info[] ="page_size" , SLong(5 ),NOT_NULL, "Compressed Page Size" ),"compress_ops" , SLong(), NOT_NULL, "Total Number of Compressions" ),"compress_ops_ok" ,SLong(), NOT_NULL, "Total Number of " "Successful Compressions" ),"compress_time" , SLong(), NOT_NULL, "Total Duration of " "Compressions, in Seconds" ),"uncompress_ops" , SLong(), NOT_NULL, "Total Number of Decompressions" ),"uncompress_time" ,SLong(), NOT_NULL, "Total Duration of " "Decompressions, in Seconds" ),// namespace Show /*******************************************************************//** or return 0 on success, 1 on failure */static int /*=============*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ /*!< in: TRUE=reset cumulated counts */ int status = 0 ;"i_s_cmp_fill_low" );/* deny access to non-superusers */ if (check_global_access(thd, PROCESS_ACL)) {0 );for (uint i = 0 ; i < PAGE_ZIP_SSIZE_MAX; i++) {0 ]->store(UNIV_ZIP_SIZE_MIN << i);/* The cumulated counts are not protected by any mutex . Thus , some operation in page0zip . cc could increment a counter between the time we read it and clear it . We could introduce mutex protection , but it could cause a measurable performance hit in 1 ]->store(zip_stat->compressed, true );2 ]->store(zip_stat->compressed_ok, true );3 ]->store(zip_stat->compressed_usec / 1000000 ,true );4 ]->store(zip_stat->decompressed, true );5 ]->store(zip_stat->decompressed_usec / 1000000 ,true );if (reset) {new (zip_stat) page_zip_stat_t();if (schema_table_store_record(thd, table)) {1 ;break ;/*******************************************************************//** return 0 on success, 1 on failure */static int /*=========*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ return (i_s_cmp_fill_low(thd, tables, cond, FALSE ));/*******************************************************************//** return 0 on success, 1 on failure */static int /*===============*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ return (i_s_cmp_fill_low(thd, tables, cond, TRUE ));/*******************************************************************//** return 0 on success */static int /*=========*/ void * p) /*!< in/out: table schema object */ "i_s_cmp_init" );0 );/*******************************************************************//** return 0 on success */static int /*===============*/ void * p) /*!< in/out: table schema object */ "i_s_cmp_reset_init" );0 );struct st_maria_plugin i_s_innodb_cmp =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_CMP" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "Statistics for the InnoDB compression" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ struct st_maria_plugin i_s_innodb_cmp_reset =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_CMP_RESET" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "Statistics for the InnoDB compression;" " reset cumulated counts" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/* Fields of the dynamic tablesinformation_schema . innodb_cmp_per_index and static ST_FIELD_INFO i_s_cmp_per_index_fields_info[]=#define IDX_DATABASE_NAME 0 "database_name" , Varchar(NAME_CHAR_LEN), NOT_NULL),#define IDX_TABLE_NAME 1 /* FIXME: this is in my_charset_filename! */ "table_name" , Varchar(NAME_CHAR_LEN), NOT_NULL),#define IDX_INDEX_NAME 2 "index_name" , Varchar(NAME_CHAR_LEN), NOT_NULL),#define IDX_COMPRESS_OPS 3 "compress_ops" , SLong(), NOT_NULL),#define IDX_COMPRESS_OPS_OK 4 "compress_ops_ok" , SLong(), NOT_NULL),#define IDX_COMPRESS_TIME 5 "compress_time" , SLong(), NOT_NULL),#define IDX_UNCOMPRESS_OPS 6 "uncompress_ops" , SLong(), NOT_NULL),#define IDX_UNCOMPRESS_TIME 7 "uncompress_time" , SLong(), NOT_NULL),// namespace Show /*******************************************************************//** or return 0 on success, 1 on failure */static int /*=======================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ /*!< in: TRUE=reset cumulated counts */ int status = 0 ;"i_s_cmp_per_index_fill_low" );/* deny access to non-superusers */ if (check_global_access(thd, PROCESS_ACL)) {0 );/* Create a snapshot of the stats so we do not bump into lock for (iter = snap.begin(), i = 0 ; iter != snap.end(); iter++, i++) {if (dict_index_t* indexchar db_utf8[MAX_DB_UTF8_LEN];char table_utf8[MAX_TABLE_UTF8_LEN];sizeof (db_utf8),sizeof (table_utf8));else {/* index not found */ char name[MY_INT64_NUM_DECIMAL_DIGITSsizeof "index_id: " ];sizeof name,"index_id: " IB_ID_FMT,if (statustrue )true )1000000 , true )true )1000000 , true )1 ;break ;/* Release and reacquire the dict_sys.latch to allow other threads to proceed . This could eventually result in the contents of INFORMATION_SCHEMA . innodb_cmp_per_index being if (i == 1000 ) {0 ;if (reset) {/*******************************************************************//** return 0 on success, 1 on failure */static int /*===================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ return (i_s_cmp_per_index_fill_low(thd, tables, cond, FALSE ));/*******************************************************************//** return 0 on success, 1 on failure */static int /*=========================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ return (i_s_cmp_per_index_fill_low(thd, tables, cond, TRUE ));/*******************************************************************//** return 0 on success */static int /*===================*/ void * p) /*!< in/out: table schema object */ "i_s_cmp_init" );0 );/*******************************************************************//** return 0 on success */static int /*=========================*/ void * p) /*!< in/out: table schema object */ "i_s_cmp_reset_init" );0 );struct st_maria_plugin i_s_innodb_cmp_per_index =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_CMP_PER_INDEX" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "Statistics for the InnoDB compression (per index)" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ struct st_maria_plugin i_s_innodb_cmp_per_index_reset =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_CMP_PER_INDEX_RESET" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "Statistics for the InnoDB compression (per index);" " reset cumulated counts" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/* Fields of the dynamic table information_schema.innodb_cmpmem. */ static ST_FIELD_INFO i_s_cmpmem_fields_info[] ="page_size" , SLong(5 ), NOT_NULL, "Buddy Block Size" ),"buffer_pool_instance" , SLong(), NOT_NULL, "Buffer Pool Id" ),"pages_used" , SLong(), NOT_NULL, "Currently in Use" ),"pages_free" , SLong(), NOT_NULL, "Currently Available" ),"relocation_ops" , SLonglong(), NOT_NULL, "Total Number of Relocations" ),"relocation_time" , SLong(), NOT_NULL, "Total Duration of Relocations," " in Seconds" ),// namespace Show /*******************************************************************//** or return 0 on success, 1 on failure */static int /*================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ /*!< in: TRUE=reset cumulated counts */ "i_s_cmpmem_fill_low" );/* deny access to non-superusers */ if (check_global_access(thd, PROCESS_ACL)) {0 );1 ];1 ];/* Save buddy stats for buffer pool in local variables. */ for (uint x = 0 ; x <= BUF_BUDDY_SIZES; x++) {0 ;if (reset) {/* This is protected by buf_pool.mutex. */ 0 ;0 ;for (uint x = 0 ; x <= BUF_BUDDY_SIZES; x++) {0 , true );true );true );true );1000000 , true );if (schema_table_store_record(thd, table)) {1 );0 );/*******************************************************************//** return 0 on success, 1 on failure */static int /*============*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ return (i_s_cmpmem_fill_low(thd, tables, cond, FALSE ));/*******************************************************************//** return 0 on success, 1 on failure */static int /*==================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ return (i_s_cmpmem_fill_low(thd, tables, cond, TRUE ));/*******************************************************************//** return 0 on success */static int /*============*/ void * p) /*!< in/out: table schema object */ "i_s_cmpmem_init" );0 );/*******************************************************************//** return 0 on success */static int /*==================*/ void * p) /*!< in/out: table schema object */ "i_s_cmpmem_reset_init" );0 );struct st_maria_plugin i_s_innodb_cmpmem =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_CMPMEM" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "Statistics for the InnoDB compressed buffer pool" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ struct st_maria_plugin i_s_innodb_cmpmem_reset =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_CMPMEM_RESET" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "Statistics for the InnoDB compressed buffer pool;" " reset cumulated counts" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ static const LEX_CSTRING metric_type_values[] ="value" ) },"status_counter" ) },"set_owner" ) },"set_member" ) },"counter" ) }static TypelibBuffer<5 > metric_type_values_typelib(metric_type_values);namespace Show {/* Fields of the dynamic table INFORMATION_SCHEMA.innodb_metrics */ static ST_FIELD_INFO innodb_metrics_fields_info[]=#define METRIC_NAME 0 "NAME" , Varchar(NAME_LEN + 1 ), NOT_NULL),#define METRIC_SUBSYS 1 "SUBSYSTEM" , Varchar(NAME_LEN + 1 ), NOT_NULL),#define METRIC_VALUE_START 2 "COUNT" , SLonglong(), NOT_NULL),#define METRIC_MAX_VALUE_START 3 "MAX_COUNT" , SLonglong(), NULLABLE),#define METRIC_MIN_VALUE_START 4 "MIN_COUNT" , SLonglong(), NULLABLE),#define METRIC_AVG_VALUE_START 5 "AVG_COUNT" , Float (MAX_FLOAT_STR_LENGTH), NULLABLE),#define METRIC_VALUE_RESET 6 "COUNT_RESET" , SLonglong(), NOT_NULL),#define METRIC_MAX_VALUE_RESET 7 "MAX_COUNT_RESET" , SLonglong(), NULLABLE),#define METRIC_MIN_VALUE_RESET 8 "MIN_COUNT_RESET" , SLonglong(), NULLABLE),#define METRIC_AVG_VALUE_RESET 9 "AVG_COUNT_RESET" , Float (MAX_FLOAT_STR_LENGTH), NULLABLE),#define METRIC_START_TIME 10 "TIME_ENABLED" , Datetime(0 ), NULLABLE),#define METRIC_STOP_TIME 11 "TIME_DISABLED" , Datetime(0 ), NULLABLE),#define METRIC_TIME_ELAPSED 12 "TIME_ELAPSED" , SLonglong(), NULLABLE),#define METRIC_RESET_TIME 13 "TIME_RESET" , Datetime(0 ), NULLABLE),#define METRIC_STATUS 14 "ENABLED" , SLong(1 ), NOT_NULL),#define METRIC_TYPE 15 "TYPE" , Enum (&metric_type_values_typelib), NOT_NULL),#define METRIC_DESC 16 "COMMENT" , Varchar(NAME_LEN + 1 ), NOT_NULL),// namespace Show /**********************************************************************//** return 0 on success */static int /*=============*/ /*!< in: thread */ /*!< in/out: fill this table */ int count;double time_diff = 0 ;"i_s_metrics_fill" );for (count = 0 ; count < NUM_MONITOR; count++) {/* A good place to sanity check the Monitor ID */ /* If the item refers to a Module, nothing to fill, if ((monitor_info->monitor_type & MONITOR_MODULE)continue ;/* If this is an existing "status variable", and its corresponding counter is still on , we need to calculate the result from its corresponding if (monitor_info->monitor_type & MONITOR_EXISTING/* Fill in counter's basic information */ /* Fill in counter values */ FALSE ));FALSE ));/* If the max value is MAX_RESERVED, counter max value has not been updated . Set the column value if (MONITOR_MAX_VALUE(count) == MAX_RESERVEDelse {FALSE ));/* If the min value is MAX_RESERVED, counter min value has not been updated . Set the column value if (MONITOR_MIN_VALUE(count) == MIN_RESERVEDelse {FALSE ));/* Calculate the max value since counter started */ if (max_val == MAX_RESERVEDelse {FALSE ));/* Calculate the min value since counter started */ if (min_val == MIN_RESERVEDelse {FALSE ));/* If monitor has been enabled (no matter it is disabled or not now ) , fill METRIC_START_TIME and METRIC_TIME_ELAPSED if (MONITOR_FIELD(count, mon_start_time)) {/* If monitor is enabled, the TIME_ELAPSED is the time difference between current and time when monitor is enabled . Otherwise , it is the time difference between time when monitor is enabled and time if (MONITOR_IS_ON(count)) {else {else {0 ;/* Unless MONITOR_NO_AVERAGE is set, we must to calculate the average value . If this is a monitor set owner marked by MONITOR_SET_OWNER , divide the value by another counter ( number of calls ) designated by monitor_info - > monitor_related_id . Otherwise average the counter value by the time between the time that the counter is enabled and time it is disabled if ((monitor_info->monitor_typeif (value_start) {FALSE ));else {if (mon_type_t related_value =false ));else {else if (!(monitor_info->monitor_typeif (time_diff != 0 ) {double ) MONITOR_VALUE_SINCE_START(else {if (MONITOR_FIELD(count, mon_reset_time)) {/* calculate the time difference since last if (MONITOR_IS_ON(count)) {else {else {0 ;if (time_diff != 0 ) {static_cast <double >(else {else {if (MONITOR_IS_ON(count)) {/* If monitor is on, the stop time will set to NULL */ /* Display latest Monitor Reset Time only if Monitor if (MONITOR_FIELD(count, mon_reset_time)) {else {1 , true ));else {if (MONITOR_FIELD(count, mon_stop_time)) {else {0 , true ));if (monitor_info->monitor_type & MONITOR_DISPLAY_CURRENT) {1 ; /* "value" */ else if (monitor_info->monitor_type & MONITOR_EXISTING) {2 ; /* "status_counter" */ else if (monitor_info->monitor_type & MONITOR_SET_OWNER) {3 ; /* "set_owner" */ else if (monitor_info->monitor_type & MONITOR_SET_MEMBER) {4 ; /* "set_member" */ else {5 ; /* "counter" */ true ));0 );/*******************************************************************//** return 0 on success */static int /*===================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (not used) */ "i_s_metrics_fill_table" );/* deny access to non-superusers */ if (check_global_access(thd, PROCESS_ACL)) {0 );0 );/*******************************************************************//** return 0 on success */static int /*================*/ void * p) /*!< in/out: table schema object */ "innodb_metrics_init" );0 );struct st_maria_plugin i_s_innodb_metrics =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_METRICS" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB Metrics Info" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/* Fields of the dynamic table INFORMATION_SCHEMA.innodb_ft_default_stopword */ static ST_FIELD_INFO i_s_stopword_fields_info[]=#define STOPWORD_VALUE 0 "value" , Varchar(TRX_ID_MAX_LEN + 1 ), NOT_NULL),// namespace Show /*******************************************************************//** return 0 on success, 1 on failure */static int /*==============*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (not used) */ 0 ;"i_s_stopword_fill" );/* Fill with server default stopword list in array while (fts_default_stopword[i]) {0 );/*******************************************************************//** return 0 on success */static int /*==============*/ void * p) /*!< in/out: table schema object */ "i_s_stopword_init" );0 );struct st_maria_plugin i_s_innodb_ft_default_stopword =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_FT_DEFAULT_STOPWORD" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "Default stopword list for InnoDB Full Text Search" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/* Fields of the dynamic table INFORMATION_SCHEMA.INNODB_FT_DELETED static ST_FIELD_INFO i_s_fts_doc_fields_info[]=#define I_S_FTS_DOC_ID 0 "DOC_ID" , ULonglong(), NOT_NULL),// namespace Show /*******************************************************************//** or return 0 on success, 1 on failure */static int /*=========================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: BEING_DELTED table */ "i_s_fts_deleted_generic_fill" );/* deny access to non-superusers */ if (check_global_access(thd, PROCESS_ACL)) {0 );false , DICT_TABLE_OP_NORMAL,if (!user_table) {0 );else if (!dict_table_has_fts_index(user_table)0 );"Select for FTS DELETE TABLE" ;"BEING_DELETED" : "DELETED" , deleted);int ret = 0 ;for (ulint j = 0 ; j < ib_vector_size(deleted->doc_ids); ++j) {true ));/*******************************************************************//** return 0 on success, 1 on failure */static int /*=================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ "i_s_fts_deleted_fill" );FALSE ));/*******************************************************************//** return 0 on success */static int /*=================*/ void * p) /*!< in/out: table schema object */ "i_s_fts_deleted_init" );0 );struct st_maria_plugin i_s_innodb_ft_deleted =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_FT_DELETED" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "INNODB AUXILIARY FTS DELETED TABLE" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ /*******************************************************************//** return 0 on success, 1 on failure */static int /*=======================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ "i_s_fts_being_deleted_fill" );TRUE ));/*******************************************************************//** return 0 on success */static int /*=======================*/ void * p) /*!< in/out: table schema object */ "i_s_fts_deleted_init" );0 );struct st_maria_plugin i_s_innodb_ft_being_deleted =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_FT_BEING_DELETED" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "INNODB AUXILIARY FTS BEING DELETED TABLE" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/* Fields of the dynamic table INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHED and static ST_FIELD_INFO i_s_fts_index_fields_info[]=#define I_S_FTS_WORD 0 "WORD" , Varchar(FTS_MAX_WORD_LEN + 1 ), NOT_NULL),#define I_S_FTS_FIRST_DOC_ID 1 "FIRST_DOC_ID" , ULonglong(), NOT_NULL),#define I_S_FTS_LAST_DOC_ID 2 "LAST_DOC_ID" , ULonglong(), NOT_NULL),#define I_S_FTS_DOC_COUNT 3 "DOC_COUNT" , ULonglong(), NOT_NULL),#define I_S_FTS_ILIST_DOC_ID 4 "DOC_ID" , ULonglong(), NOT_NULL),#define I_S_FTS_ILIST_DOC_POS 5 "POSITION" , ULonglong(), NOT_NULL),// namespace Show /*******************************************************************//** and its ilist, fill the dynamic tablefor one FTS index on the table.return 0 on success, 1 on failure */static int /*===============================*/ /*!< in: FTS index cache */ /*!< in: thread */ /*!< in/out: buffer */ /*!< in/out: tables to fill */ const ib_rbt_node_t* rbt_node;char * word_str;"i_s_fts_index_cache_fill_one_index" );0 ;int ret = 0 ;/* Go through each word in the index cache */ for (rbt_node = rbt_first(index_cache->words);/* Convert word from index charset to system_charset_info */ if (index_charset->cset != system_charset_info->cset) {reinterpret_cast <char *>(conv_str->f_str),static_cast <uint32>(conv_str->f_len),reinterpret_cast <char *>(word->text.f_str),static_cast <uint32>(word->text.f_len),0 ;reinterpret_cast <char *>(conv_str->f_str);else {reinterpret_cast <char *>(word->text.f_str);/* Decrypt the ilist, and display Dod ID and word position */ for (ulint i = 0 ; i < ib_vector_size(word->nodes); i++) {const byte* ptr;0 ;0 ;static_cast <fts_node_t*> (ib_vector_get(while (decoded < node->ilist_size) {/* Get position info */ while (*ptr) {true ));true ));true ));true ));true ));/*******************************************************************//** return 0 on success, 1 on failure */static int /*=====================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ "i_s_fts_index_cache_fill" );/* deny access to non-superusers */ if (check_global_access(thd, PROCESS_ACL)) {0 );false , DICT_TABLE_OP_NORMAL,if (!user_table) {0 );if (!user_table->fts || !user_table->fts->cache) {0 );int ret = 0 ;1 ];sizeof word;for (ulint i = 0 ; i < ib_vector_size(cache->indexes); i++) {static_cast <fts_index_cache_t*> (/*******************************************************************//** return 0 on success */static int /*=====================*/ void * p) /*!< in/out: table schema object */ "i_s_fts_index_cache_init" );0 );struct st_maria_plugin i_s_innodb_ft_index_cache =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_FT_INDEX_CACHE" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "INNODB AUXILIARY FTS INDEX CACHED" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ /** Go through a FTS index auxiliary table, fetch its rows and fillFTS word cache structure . @ param executor FTS query executor @ param reader record reader for processing auxiliary table records @ param selected auxiliary index @ param word word to select static "fts_instrument_result_cache_limit" ,8192 ;);if (error == DB_RECORD_NOT_FOUND)return error;/*******************************************************************//** static void /*===============================*/ /*!< in: words fetched */ for (ulint i = 0 ; i < ib_vector_size(words); i++) {static_cast <fts_word_t*>(ib_vector_get(words, i));for (ulint j = 0 ; j < ib_vector_size(word->nodes); j++) {static_cast <fts_node_t*> (ib_vector_get(/* caller releases every word via /*******************************************************************//** return 0 on success, 1 on failure */static int /*===============================*/ /*!< in: FTS index charset */ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: words fetched */ /*!< in: string for conversion*/ bool has_more) /*!< in: has more to fetch */ char * word_str;int ret = 0 ;"i_s_fts_index_table_fill_one_fetch" );if (has_more) {/* the last word is not fetched completely. */ 1 );1 ;/* Go through each word in the index cache */ for (ulint i = 0 ; i < words_size; i++) {static_cast <fts_word_t*>(ib_vector_get(words, i));0 ;/* Convert word from index charset to system_charset_info */ if (index_charset->cset != system_charset_info->cset) {reinterpret_cast <char *>(conv_str->f_str),static_cast <uint32>(conv_str->f_len),reinterpret_cast <char *>(word->text.f_str),static_cast <uint32>(word->text.f_len),0 ;reinterpret_cast <char *>(conv_str->f_str);else {reinterpret_cast <char *>(word->text.f_str);/* Decrypt the ilist, and display Dod ID and word position */ for (ulint i = 0 ; i < ib_vector_size(word->nodes); i++) {const byte* ptr;0 ;0 ;static_cast <fts_node_t*> (ib_vector_get(while (decoded < node->ilist_size) {/* Get position info */ while (*ptr) {true ));true ));true ));true ));true ));/** Read words from a single auxiliary index with retry logic@ param executor FTS query executor @ param reader record reader @ param selected auxiliary index number @ param thd thread @ param tables tables to fill @ param conv_str conversion buffer @ param heap memory heap @ param words words vector static int i_s_fts_read_aux_index_words(bool has_more= false ;int ret= 0 ;0 ;0 ;do /* Fetch from index with retry logic for lock timeouts */ for (;;)if (UNIV_LIKELY(error == DB_SUCCESS ||break ;else if (error == DB_LOCK_WAIT_TIMEOUT)"InnoDB: Lock wait timeout" " while reading FTS index. Retrying!" );/* Restart transaction after rollback to restore will_lock flag */ /* Clear words and retry */ if (reader.words_heap()) mem_heap_empty(reader.words_heap());/* Reset memory counter on retry */ else "InnoDB: Error occurred while reading" " FTS index: %s" , ut_strerr(error));if (reader.words_heap())return 1 ;if (has_more)/* Prepare start point for next fetch */ static_cast <fts_word_t*>(ib_vector_last(words));/* Reset memory counter for next fetch */ /* Fill into tables */ const_cast <dict_index_t*>(executor->index())),if (reader.words_heap())if (ret != 0 )return ret;while (has_more);return 0 ;/*******************************************************************//** and its auxiliary tables, fetch rows in each tableand fill INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE.return 0 on success, 1 on failure */static int /*===============================*/ /*!< in: FTS index */ /*!< in: thread */ /*!< in/out: buffer */ /*!< in/out: tables to fill */ int ret = 0 ;"i_s_fts_index_table_fill_one_index" );1024 );sizeof (fts_word_t), 256 );"fetching FTS index nodes" ;if (error) return 1 ;0 ;/* Dedicated words heap for fts_word_t internals ( text , nodes vector , heap_alloc ) . Emptied per batch in 4096 );for (uint8_t selected = 0 ; selected < FTS_NUM_AUX_INDEX; selected++) {if (ret != 0 ) {goto func_exit;/*******************************************************************//** return 0 on success, 1 on failure */static int /*=====================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ "i_s_fts_index_table_fill" );/* deny access to non-superusers */ if (check_global_access(thd, PROCESS_ACL)) {0 );false , DICT_TABLE_OP_NORMAL,if (!user_table) {0 );int ret = 0 ;static_cast <byte*>(ut_malloc_nokey(conv_str.f_len));for (index = dict_table_get_first_index(user_table);if (index->type & DICT_FTS) {/*******************************************************************//** return 0 on success */static int /*=====================*/ void * p) /*!< in/out: table schema object */ "i_s_fts_index_table_init" );0 );struct st_maria_plugin i_s_innodb_ft_index_table =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_FT_INDEX_TABLE" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "INNODB AUXILIARY FTS INDEX TABLE" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/* Fields of the dynamic table INFORMATION_SCHEMA.INNODB_FT_CONFIG */ static ST_FIELD_INFO i_s_fts_config_fields_info[]=#define FTS_CONFIG_KEY 0 "KEY" , Varchar(NAME_LEN + 1 ), NOT_NULL),#define FTS_CONFIG_VALUE 1 "VALUE" , Varchar(NAME_LEN + 1 ), NOT_NULL),// namespace Show static const char * fts_config_key[] = {/*******************************************************************//** return 0 on success, 1 on failure */static int /*================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (ignored) */ 0 ;unsigned char str[FTS_MAX_CONFIG_VALUE_LEN + 1 ];"i_s_fts_config_fill" );/* deny access to non-superusers */ if (check_global_access(thd, PROCESS_ACL)) {0 );false , DICT_TABLE_OP_NORMAL,if (!user_table) {0 );if (!dict_table_has_fts_index(user_table)) {0 );"Select for FTS CONFIG TABLE" ;if (!ib_vector_is_empty(user_table->fts->indexes)) {0 );int ret = 0 ;while (fts_config_key[i]) {char * key_name;FALSE ;if (index0 ) {TRUE ;else {char *) fts_config_key[i];if (allocated) {reinterpret_cast <const char *>(value.f_str)));/*******************************************************************//** return 0 on success */static int /*=================*/ void * p) /*!< in/out: table schema object */ "i_s_fts_config_init" );0 );struct st_maria_plugin i_s_innodb_ft_config =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_FT_CONFIG" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "INNODB AUXILIARY FTS CONFIG TABLE" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/* Fields of the dynamic table INNODB_BUFFER_POOL_STATS. */ static ST_FIELD_INFO i_s_innodb_buffer_stats_fields_info[]=#define IDX_BUF_STATS_POOL_ID 0 "POOL_ID" , ULong(), NOT_NULL),#define IDX_BUF_STATS_POOL_SIZE 1 "POOL_SIZE" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_FREE_BUFFERS 2 "FREE_BUFFERS" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_LRU_LEN 3 "DATABASE_PAGES" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_OLD_LRU_LEN 4 "OLD_DATABASE_PAGES" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_FLUSH_LIST_LEN 5 "MODIFIED_DATABASE_PAGES" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_PENDING_ZIP 6 "PENDING_DECOMPRESS" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_PENDING_READ 7 "PENDING_READS" ,ULonglong(), NOT_NULL),#define IDX_BUF_STATS_FLUSH_LRU 8 "PENDING_FLUSH_LRU" ,ULonglong(), NOT_NULL),#define IDX_BUF_STATS_FLUSH_LIST 9 "PENDING_FLUSH_LIST" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_PAGE_YOUNG 10 "PAGES_MADE_YOUNG" ,ULonglong(), NOT_NULL),#define IDX_BUF_STATS_PAGE_NOT_YOUNG 11 "PAGES_NOT_MADE_YOUNG" ,ULonglong(), NOT_NULL),#define IDX_BUF_STATS_PAGE_YOUNG_RATE 12 "PAGES_MADE_YOUNG_RATE" , Float (MAX_FLOAT_STR_LENGTH), NOT_NULL),#define IDX_BUF_STATS_PAGE_NOT_YOUNG_RATE 13 "PAGES_MADE_NOT_YOUNG_RATE" , Float (MAX_FLOAT_STR_LENGTH), NOT_NULL),#define IDX_BUF_STATS_PAGE_READ 14 "NUMBER_PAGES_READ" ,ULonglong(), NOT_NULL),#define IDX_BUF_STATS_PAGE_CREATED 15 "NUMBER_PAGES_CREATED" ,ULonglong(), NOT_NULL),#define IDX_BUF_STATS_PAGE_WRITTEN 16 "NUMBER_PAGES_WRITTEN" ,ULonglong(), NOT_NULL),#define IDX_BUF_STATS_PAGE_READ_RATE 17 "PAGES_READ_RATE" , Float (MAX_FLOAT_STR_LENGTH), NOT_NULL),#define IDX_BUF_STATS_PAGE_CREATE_RATE 18 "PAGES_CREATE_RATE" , Float (MAX_FLOAT_STR_LENGTH), NOT_NULL),#define IDX_BUF_STATS_PAGE_WRITTEN_RATE 19 "PAGES_WRITTEN_RATE" ,Float (MAX_FLOAT_STR_LENGTH), NOT_NULL),#define IDX_BUF_STATS_GET 20 "NUMBER_PAGES_GET" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_HIT_RATE 21 "HIT_RATE" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_MADE_YOUNG_PCT 22 "YOUNG_MAKE_PER_THOUSAND_GETS" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_NOT_MADE_YOUNG_PCT 23 "NOT_YOUNG_MAKE_PER_THOUSAND_GETS" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_READ_AHEAD 24 "NUMBER_PAGES_READ_AHEAD" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_READ_AHEAD_EVICTED 25 "NUMBER_READ_AHEAD_EVICTED" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_READ_AHEAD_RATE 26 "READ_AHEAD_RATE" , Float (MAX_FLOAT_STR_LENGTH), NOT_NULL),#define IDX_BUF_STATS_READ_AHEAD_EVICT_RATE 27 "READ_AHEAD_EVICTED_RATE" ,Float (MAX_FLOAT_STR_LENGTH), NOT_NULL),#define IDX_BUF_STATS_LRU_IO_SUM 28 "LRU_IO_TOTAL" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_LRU_IO_CUR 29 "LRU_IO_CURRENT" , ULonglong(), NOT_NULL),#define IDX_BUF_STATS_UNZIP_SUM 30 "UNCOMPRESS_TOTAL" ,ULonglong(), NOT_NULL),#define IDX_BUF_STATS_UNZIP_CUR 31 "UNCOMPRESS_CURRENT" , ULonglong(), NOT_NULL),// namespace Show /** Fill INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS@ param [ in , out ] thd connection @ param [ in , out ] tables tables to fill static int i_s_innodb_stats_fill(THD *thd, TABLE_LIST * tables, Item *)"i_s_innodb_stats_fill" );/* Only allow the PROCESS privilege holder to access the stats */ if (check_global_access(thd, PROCESS_ACL)) {0 );0 , true ));true ));true ));true ));true ));true ));true ));true ));true ));true ));true ));true ));true ));true ));true ));true ));if (info.n_page_get_delta) {if (info.page_read_delta <= info.n_page_get_delta) {static_cast <double >(1000 - (1000 * info.page_read_deltaelse {0 ));1000 * info.young_making_deltatrue ));1000 * info.not_young_making_deltatrue ));else {0 , true ));0 , true ));0 , true ));true ));true ));true ));true ));true ));true ));/*******************************************************************//** return 0 on success, 1 on failure */static int /*==============================*/ void * p) /*!< in/out: table schema object */ "i_s_innodb_buffer_pool_stats_init" );reinterpret_cast <ST_SCHEMA_TABLE*>(p);0 );struct st_maria_plugin i_s_innodb_buffer_stats =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_BUFFER_POOL_STATS" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB Buffer Pool Statistics Information " ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ /** These must correspond to the first values of buf_page_state */ static const LEX_CSTRING page_state_values[] ="NOT_USED" ) },"MEMORY" ) },"REMOVE_HASH" ) },"FILE_PAGE" ) },static const TypelibBuffer<4 > page_state_values_typelib(page_state_values);static const LEX_CSTRING io_values[] ="IO_NONE" ) },"IO_READ" ) },"IO_WRITE" ) }static TypelibBuffer<3 > io_values_typelib(io_values);namespace Show {/* Fields of the dynamic table INNODB_BUFFER_POOL_PAGE. */ static ST_FIELD_INFO i_s_innodb_buffer_page_fields_info[]=#define IDX_BUFFER_POOL_ID 0 "POOL_ID" , ULong(), NOT_NULL),#define IDX_BUFFER_BLOCK_ID 1 "BLOCK_ID" , ULonglong(), NOT_NULL),#define IDX_BUFFER_PAGE_SPACE 2 "SPACE" , ULong(), NOT_NULL),#define IDX_BUFFER_PAGE_NUM 3 "PAGE_NUMBER" , ULong(), NOT_NULL),#define IDX_BUFFER_PAGE_TYPE 4 "PAGE_TYPE" , Varchar(64 ), NULLABLE),#define IDX_BUFFER_PAGE_FLUSH_TYPE 5 "FLUSH_TYPE" , ULong(), NOT_NULL),#define IDX_BUFFER_PAGE_FIX_COUNT 6 "FIX_COUNT" , ULong(), NOT_NULL),#ifdef BTR_CUR_HASH_ADAPT#define IDX_BUFFER_PAGE_HASHED 7 "IS_HASHED" , SLong(1 ), NOT_NULL),#endif /* BTR_CUR_HASH_ADAPT */ #define IDX_BUFFER_PAGE_NEWEST_MOD 7 + I_S_AHI"NEWEST_MODIFICATION" , ULonglong(), NOT_NULL),#define IDX_BUFFER_PAGE_OLDEST_MOD 8 + I_S_AHI"OLDEST_MODIFICATION" , ULonglong(), NOT_NULL),#define IDX_BUFFER_PAGE_ACCESS_TIME 9 + I_S_AHI"ACCESS_TIME" , ULonglong(), NOT_NULL),#define IDX_BUFFER_PAGE_TABLE_NAME 10 + I_S_AHI"TABLE_NAME" , Varchar(1024 ), NULLABLE),#define IDX_BUFFER_PAGE_INDEX_NAME 11 + I_S_AHI"INDEX_NAME" , Varchar(NAME_CHAR_LEN), NULLABLE),#define IDX_BUFFER_PAGE_NUM_RECS 12 + I_S_AHI"NUMBER_RECORDS" , ULonglong(), NOT_NULL),#define IDX_BUFFER_PAGE_DATA_SIZE 13 + I_S_AHI"DATA_SIZE" , ULonglong(), NOT_NULL),#define IDX_BUFFER_PAGE_ZIP_SIZE 14 + I_S_AHI"COMPRESSED_SIZE" , ULonglong(), NOT_NULL),#define IDX_BUFFER_PAGE_STATE 15 + I_S_AHI"PAGE_STATE" , Enum (&page_state_values_typelib), NOT_NULL),#define IDX_BUFFER_PAGE_IO_FIX 16 + I_S_AHI"IO_FIX" , Enum (&io_values_typelib), NOT_NULL),#define IDX_BUFFER_PAGE_IS_OLD 17 + I_S_AHI"IS_OLD" , SLong(1 ), NOT_NULL),#define IDX_BUFFER_PAGE_FREE_CLOCK 18 + I_S_AHI"FREE_PAGE_CLOCK" , ULonglong(), NOT_NULL),// namespace Show /*******************************************************************//** return 0 on success, 1 on failure */static int /*========================*/ /*!< in: thread */ /*!< in/out: tables to fill */ const buf_page_info_t* info_array, /*!< in: array cached page /*!< in: number of page info 1 << I_S_PAGE_TYPE_BITS);"i_s_innodb_buffer_page_fill" );/* Iterate through the cached array and fill the I_S table rows */ for (ulint i = 0 ; i < num_page; i++) {const buf_page_info_t* page_info;char table_name[MAX_FULL_NAME_LEN + 1 ];const char * table_name_end = NULL;0 , true ));true ));true ));true ));0 , true ));true ));#ifdef BTR_CUR_HASH_ADAPTtrue ));#endif /* BTR_CUR_HASH_ADAPT */ true ));true ));true ));/* If this is an index page, fetch the index name if (page_info->page_type == I_S_PAGE_TYPE_INDEX) {bool ret = false ;const dict_index_t* index =if (index) {sizeof (table_name),static_cast <uint>(if (index) {true ));true ));1 ) << page_info->zip_ssize0 , true ));0 , "compatibility" );1 , "compatibility" );2 , "compatibility" );3 , page_info->state) + 1 , true ));2 U << 29 , "comp." );4 U << 29 , "comp." );6 U << 29 , "comp." );unsigned io_fix = page_info->state >> 29 ;if (io_fix < 4 ) {1 ;else if (io_fix == 4 ) {2 ;else {3 ;true ));true ));true ));0 );/*******************************************************************//** static void /*=====================*/ /*!< in/out: structure to fill with const byte* frame) /*!< in: buffer frame */ if (fil_page_type_is_index(page_type)) {const page_t* page = (const page_t*) frame;/* FIL_PAGE_INDEX and FIL_PAGE_RTREE are a bit special, their values are defined as 17855 and 17854 , so we cannot use them to index into i_s_page_type [ ] array , its array index in the i_s_page_type [ ] array is I_S_PAGE_TYPE_INDEX if (page_type == FIL_PAGE_RTREE) {else {1 U << 14 ) - 1 );else if (page_type > FIL_PAGE_TYPE_LAST) {/* Encountered an unknown page type */ else {/* Make sure we get the right index into the 0 xf;/*******************************************************************//** and collect their general informationnot initialized in the function will default to 0 */static void /*============================*/ const buf_page_t*bpage, /*!< in: buffer pool page to scan */ /*!< in: buffer block position in /*!< in: zero filled info structure; out : structure filled with scanned 0 , "compatibility" );1 , "compatibility" );2 , "compatibility" );2 U << 29 , "compatibility" );4 U << 29 , "compatibility" );6 U << 29 , "compatibility" );if (page_info->state < buf_page_t::UNFIXED) {false ;else {const byte* frame;if (page_info->state >= buf_page_t::READ_FIX0 ;return ;if (UNIV_LIKELY(frame != nullptr)) {#ifdef BTR_CUR_HASH_ADAPT/* Note: this may be a false positive, that is , block - > index will not always be set to NULL when the last adaptive hash index reinterpret_cast <const buf_block_t*>(bpage)#endif /* BTR_CUR_HASH_ADAPT */ else {/*******************************************************************//** This is the function that goes through each block of the buffer pooland fetch information to information schema tables: INNODB_BUFFER_PAGE.return 0 on success, 1 on failure */static int i_s_innodb_buffer_page_fill(THD *thd, TABLE_LIST *tables, Item *)"i_s_innodb_buffer_page_fill" );/* deny access to user without PROCESS privilege */ if (check_global_access(thd, PROCESS_ACL))0 );int status;static_cast <buf_page_info_t*>(my_malloc(PSI_INSTRUMENT_ME,sizeof *b,if (!b)1 );for (size_t j= 0 ;;)void *) b, 0 , MAX_BUF_INFO_CACHED * sizeof *b);const size_t N= buf_pool.curr_size();const size_t n= std::min<size_t>(N, MAX_BUF_INFO_CACHED);for (size_t i= 0 ; i < n && j < N; i++, j++)if (status || j >= N)break ;/*******************************************************************//** return 0 on success, 1 on failure */static int /*========================*/ void * p) /*!< in/out: table schema object */ "i_s_innodb_buffer_page_init" );reinterpret_cast <ST_SCHEMA_TABLE*>(p);0 );struct st_maria_plugin i_s_innodb_buffer_page =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_BUFFER_PAGE" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB Buffer Page Information" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {static ST_FIELD_INFO i_s_innodb_buf_page_lru_fields_info[] =#define IDX_BUF_LRU_POOL_ID 0 "POOL_ID" , ULong(), NOT_NULL),#define IDX_BUF_LRU_POS 1 "LRU_POSITION" , ULonglong(), NOT_NULL),#define IDX_BUF_LRU_PAGE_SPACE 2 "SPACE" , ULong(), NOT_NULL),#define IDX_BUF_LRU_PAGE_NUM 3 "PAGE_NUMBER" , ULong(), NOT_NULL),#define IDX_BUF_LRU_PAGE_TYPE 4 "PAGE_TYPE" , Varchar(64 ), NULLABLE),#define IDX_BUF_LRU_PAGE_FLUSH_TYPE 5 "FLUSH_TYPE" , ULong(), NOT_NULL),#define IDX_BUF_LRU_PAGE_FIX_COUNT 6 "FIX_COUNT" , ULong(), NOT_NULL),#ifdef BTR_CUR_HASH_ADAPT#define IDX_BUF_LRU_PAGE_HASHED 7 "IS_HASHED" , SLong(1 ), NOT_NULL),#endif /* BTR_CUR_HASH_ADAPT */ #define IDX_BUF_LRU_PAGE_NEWEST_MOD 7 + I_S_AHI"NEWEST_MODIFICATION" ,ULonglong(), NOT_NULL),#define IDX_BUF_LRU_PAGE_OLDEST_MOD 8 + I_S_AHI"OLDEST_MODIFICATION" ,ULonglong(), NOT_NULL),#define IDX_BUF_LRU_PAGE_ACCESS_TIME 9 + I_S_AHI"ACCESS_TIME" ,ULonglong(), NOT_NULL),#define IDX_BUF_LRU_PAGE_TABLE_NAME 10 + I_S_AHI"TABLE_NAME" , Varchar(1024 ), NULLABLE),#define IDX_BUF_LRU_PAGE_INDEX_NAME 11 + I_S_AHI"INDEX_NAME" , Varchar(NAME_CHAR_LEN), NULLABLE),#define IDX_BUF_LRU_PAGE_NUM_RECS 12 + I_S_AHI"NUMBER_RECORDS" , ULonglong(), NOT_NULL),#define IDX_BUF_LRU_PAGE_DATA_SIZE 13 + I_S_AHI"DATA_SIZE" , ULonglong(), NOT_NULL),#define IDX_BUF_LRU_PAGE_ZIP_SIZE 14 + I_S_AHI"COMPRESSED_SIZE" ,ULonglong(), NOT_NULL),#define IDX_BUF_LRU_PAGE_STATE 15 + I_S_AHI"COMPRESSED" , SLong(1 ), NOT_NULL),#define IDX_BUF_LRU_PAGE_IO_FIX 16 + I_S_AHI"IO_FIX" , Enum (&io_values_typelib), NOT_NULL),#define IDX_BUF_LRU_PAGE_IS_OLD 17 + I_S_AHI"IS_OLD" , SLong(1 ), NULLABLE),#define IDX_BUF_LRU_PAGE_FREE_CLOCK 18 + I_S_AHI"FREE_PAGE_CLOCK" , ULonglong(), NOT_NULL),// namespace Show /*******************************************************************//** return 0 on success, 1 on failure */static int /*=========================*/ /*!< in: thread */ /*!< in/out: tables to fill */ const buf_page_info_t* info_array, /*!< in: array cached page /*!< in: number of page info "i_s_innodb_buf_page_lru_fill" );/* Iterate through the cached array and fill the I_S table rows */ for (ulint i = 0 ; i < num_page; i++) {const buf_page_info_t* page_info;char table_name[MAX_FULL_NAME_LEN + 1 ];const char * table_name_end = NULL;0 , true ));true ));true ));true ));0 , true ));true ));#ifdef BTR_CUR_HASH_ADAPTtrue ));#endif /* BTR_CUR_HASH_ADAPT */ true ));true ));true ));/* If this is an index page, fetch the index name if (page_info->page_type == I_S_PAGE_TYPE_INDEX) {bool ret = false ;const dict_index_t* index =if (index) {sizeof (table_name),static_cast <uint>(if (index) {true ));true ));512 << page_info->zip_ssize : 0 , true ));true ));2 U << 29 , "comp." );4 U << 29 , "comp." );6 U << 29 , "comp." );unsigned io_fix = page_info->state >> 29 ;if (io_fix < 4 ) {1 ;else if (io_fix == 4 ) {2 ;else {3 ;true ));true ));true ));0 );/** Fill the table INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU.@ param [ in ] thd thread @ param [ in , out ] tables tables to fill static int i_s_innodb_fill_buffer_lru(THD *thd, TABLE_LIST *tables, Item *)int status = 0 ;0 ;const buf_page_t* bpage;"i_s_innodb_fill_buffer_lru" );/* deny access to any users that do not hold PROCESS_ACL */ if (check_global_access(thd, PROCESS_ACL)) {0 );/* Acquire the mutex before allocating info_buffer, since /* Print error message if malloc fail */ sizeof *info_buffer, MYF(MY_WME | MY_ZEROFILL));if (!info_buffer) {1 ;goto exit ;/* Walk through Pool's LRU list and print the buffer page while (bpage != NULL) {/* Use the same function that collect buffer info for exit :if (info_buffer) {/*******************************************************************//** return 0 on success, 1 on failure */static int /*============================*/ void * p) /*!< in/out: table schema object */ "i_s_innodb_buffer_page_lru_init" );reinterpret_cast <ST_SCHEMA_TABLE*>(p);0 );struct st_maria_plugin i_s_innodb_buffer_page_lru =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_BUFFER_PAGE_LRU" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB Buffer Page in LRU" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ /*******************************************************************//** return 0 */static int i_s_common_deinit(void *)"i_s_common_deinit" );/* Do nothing */ 0 );static const LEX_CSTRING row_format_values[] ="Redundant" ) },"Compact" ) },"Compressed" ) },"Dynamic" ) }static TypelibBuffer<4 > row_format_values_typelib(row_format_values);static const LEX_CSTRING space_type_values[] ="Single" ) },"System" ) }static TypelibBuffer<2 > space_type_values_typelib(space_type_values);namespace Show {/** SYS_TABLES ***************************************************/ /* Fields of the dynamic table INFORMATION_SCHEMA.SYS_TABLES */ static ST_FIELD_INFO innodb_sys_tables_fields_info[]=#define SYS_TABLES_ID 0 "TABLE_ID" , ULonglong(), NOT_NULL),#define SYS_TABLES_NAME 1 "NAME" , Varchar(MAX_FULL_NAME_LEN + 1 ), NOT_NULL),#define SYS_TABLES_FLAG 2 "FLAG" , SLong(), NOT_NULL),#define SYS_TABLES_NUM_COLUMN 3 "N_COLS" , ULong(), NOT_NULL),#define SYS_TABLES_SPACE 4 "SPACE" , ULong(), NOT_NULL),#define SYS_TABLES_ROW_FORMAT 5 "ROW_FORMAT" , Enum (&row_format_values_typelib), NULLABLE),#define SYS_TABLES_ZIP_PAGE_SIZE 6 "ZIP_PAGE_SIZE" , ULong(), NOT_NULL),#define SYS_TABLES_SPACE_TYPE 7 "SPACE_TYPE" , Enum (&space_type_values_typelib), NULLABLE),// namespace Show /**********************************************************************//** return 0 on success */static int /*=====================*/ /*!< in: thread */ /*!< in: table */ /*!< in/out: fill this table */ const ulint zip_size = dict_tf_get_zip_size(table->flags);const char * row_format;if (!compact) {"Redundant" ;else if (!atomic_blobs) {"Compact" ;else if (DICT_TF_GET_ZIP_SSIZE(table->flags)) {"Compressed" ;else {"Dynamic" ;"i_s_dict_fill_sys_tables" );TRUE ));true ));true ));"Single" : "System" ));0 );/** Handle the error for information schema query@ param err error value @ param thd thread static int i_s_sys_error_handling(int err, THD *thd)return thd_kill_level(thd) ? 0 : err;/** Convert one SYS_TABLES record to dict_table_t.@ param pcur persistent cursor position on SYS_TABLES record @ param mtr mini - transaction ( nullptr = use the dict_sys cache ) @ param rec record to read from ( nullptr = use the dict_sys cache ) @ param table the converted dict_table_t @ return error message static const char *i_s_sys_tables_rec(const btr_pcur_t &pcur, mtr_t *mtr,const rec_t *rec, dict_table_t **table)0 , "compatibility" );if (rec_get_1byte_offs_flag(pcur.old_rec))0 );if (len & REC_1BYTE_SQL_NULL_MASK)return "corrupted SYS_TABLES.NAME" ;else 0 );16384 , "compatibility" );if (len >= REC_2BYTE_EXTERN_MASK)return "corrupted SYS_TABLES.NAME" ;if (rec)return dict_load_table_low(mtr, false , rec, table);const char >{reinterpret_cast <const char *>(pcur.old_rec), len});return *table ? nullptr : "Table not found in cache" ;/*******************************************************************//** and fill thereturn 0 on success */static int /*======================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (not used) */ "i_s_sys_tables_fill_table" );/* deny access to user without PROCESS_ACL privilege */ if (check_global_access(thd, PROCESS_ACL)) {0 );int err = 0 ;for (const rec_t *rec = dict_startscan_system(&pcur, &mtr,if (rec_get_deleted_flag(rec, 0 )) {continue ;const char * err_msg;/* Create and populate a dict_table_t structure with if (!err_msg) {if (err) {if (table_rec) {goto func_exit;else {"%s" ,if (table_rec) {/* Get the next record */ /*******************************************************************//** return 0 on success */static int /*===================*/ void * p) /*!< in/out: table schema object */ "innodb_sys_tables_init" );0 );struct st_maria_plugin i_s_innodb_sys_tables =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_SYS_TABLES" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB SYS_TABLES" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/** SYS_TABLESTATS ***********************************************/ /* Fields of the dynamic table INFORMATION_SCHEMA.SYS_TABLESTATS */ static ST_FIELD_INFO innodb_sys_tablestats_fields_info[]=#define SYS_TABLESTATS_ID 0 "TABLE_ID" , ULonglong(), NOT_NULL),#define SYS_TABLESTATS_NAME 1 "NAME" , Varchar(NAME_CHAR_LEN), NOT_NULL),#define SYS_TABLESTATS_INIT 2 "STATS_INITIALIZED" , SLong(1 ), NOT_NULL),#define SYS_TABLESTATS_NROW 3 "NUM_ROWS" , ULonglong(), NOT_NULL),#define SYS_TABLESTATS_CLUST_SIZE 4 "CLUST_INDEX_SIZE" , ULonglong(), NOT_NULL),#define SYS_TABLESTATS_INDEX_SIZE 5 "OTHER_INDEX_SIZE" , ULonglong(), NOT_NULL),#define SYS_TABLESTATS_MODIFIED 6 "MODIFIED_COUNTER" , ULonglong(), NOT_NULL),#define SYS_TABLESTATS_AUTONINC 7 "AUTOINC" , ULonglong(), NOT_NULL),#define SYS_TABLESTATS_TABLE_REF_COUNT 8 "REF_COUNT" , SLong(), NOT_NULL),// namespace Show /** Populate information_schema.innodb_sys_tablestats table with a table,and release exclusive dict_sys . latch . @ param [ in ] thd connection @ param [ in , out ] table InnoDB table metadata @ param [ in , out ] table_to_fill INFORMATION_SCHEMA . INNODB_SYS_TABLESTATS static int "i_s_dict_fill_sys_tablestats" );auto _ = make_scope_exit([table]() {TRUE ));true ));if (table->stat_initialized())true ));true ));true ));true ));else 0 , true ));0 , true ));0 , true ));0 , true ));true ));true ));0 );/*******************************************************************//** and fill thereturn 0 on success */static int /*============================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (not used) */ "i_s_sys_tables_fill_table_stats" );/* deny access to user without PROCESS_ACL privilege */ if (check_global_access(thd, PROCESS_ACL)) {0 );const rec_t* rec;int err = 0 ;while (rec) {const char * err_msg;/* Fetch the dict_table_t structure corresponding to if (UNIV_LIKELY(!err_msg)) {if (err) {goto func_exit;else {"%s" ,/* Get the next record */ /*******************************************************************//** return 0 on success */static int /*=======================*/ void * p) /*!< in/out: table schema object */ "innodb_sys_tablestats_init" );0 );struct st_maria_plugin i_s_innodb_sys_tablestats =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_SYS_TABLESTATS" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB SYS_TABLESTATS" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/** SYS_INDEXES **************************************************/ /* Fields of the dynamic table INFORMATION_SCHEMA.SYS_INDEXES */ static ST_FIELD_INFO innodb_sysindex_fields_info[]=#define SYS_INDEX_ID 0 "INDEX_ID" , ULonglong(), NOT_NULL),#define SYS_INDEX_NAME 1 "NAME" , Varchar(NAME_CHAR_LEN), NOT_NULL),#define SYS_INDEX_TABLE_ID 2 "TABLE_ID" , ULonglong(), NOT_NULL),#define SYS_INDEX_TYPE 3 "TYPE" , SLong(), NOT_NULL),#define SYS_INDEX_NUM_FIELDS 4 "N_FIELDS" , SLong(), NOT_NULL),#define SYS_INDEX_PAGE_NO 5 "PAGE_NO" , SLong(), NULLABLE),#define SYS_INDEX_SPACE 6 "SPACE" , SLong(), NULLABLE),#define SYS_INDEX_MERGE_THRESHOLD 7 "MERGE_THRESHOLD" , SLong(), NOT_NULL),// namespace Show /**********************************************************************//** return 0 on success */static int /*======================*/ /*!< in: thread */ /*!< in: table id */ /*!< in: tablespace id */ /*!< in: populated dict_index_t /*!< in/out: fill this table */ "i_s_dict_fill_sys_indexes" );if (*index->name == *TEMP_INDEX_PREFIX_STR) {/* Since TEMP_INDEX_PREFIX_STR is not valid UTF-8, we const_cast <char *>(index->name()) = '?' ;true ));true ));true ));/* FIL_NULL is ULINT32_UNDEFINED */ if (index->page == FIL_NULL) {else {true ));if (space_id == FIL_NULL) {else {true ));true ));0 );/*******************************************************************//** and fill thereturn 0 on success */static int /*=======================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (not used) */ "i_s_sys_indexes_fill_table" );/* deny access to user without PROCESS_ACL privilege */ if (check_global_access(thd, PROCESS_ACL)) {0 );const rec_t* rec;int err = 0 ;1000 );/* Start scan the SYS_INDEXES table */ /* Process each record in the table */ while (rec) {const char * err_msg;/* Populate a dict_index_t structure with information from const byte* field = rec_get_nth_field_old(4 ? mach_read_from_4(field)if (!err_msg) {if (err) {goto func_exit;else {"%s" ,/* Get the next record */ /*******************************************************************//** return 0 on success */static int /*====================*/ void * p) /*!< in/out: table schema object */ "innodb_sys_indexes_init" );0 );struct st_maria_plugin i_s_innodb_sys_indexes =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_SYS_INDEXES" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB SYS_INDEXES" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/** SYS_COLUMNS **************************************************/ /* Fields of the dynamic table INFORMATION_SCHEMA.INNODB_SYS_COLUMNS */ static ST_FIELD_INFO innodb_sys_columns_fields_info[]=#define SYS_COLUMN_TABLE_ID 0 "TABLE_ID" , ULonglong(), NOT_NULL),#define SYS_COLUMN_NAME 1 "NAME" , Varchar(NAME_CHAR_LEN), NOT_NULL),#define SYS_COLUMN_POSITION 2 "POS" , ULonglong(), NOT_NULL),#define SYS_COLUMN_MTYPE 3 "MTYPE" , SLong(), NOT_NULL),#define SYS_COLUMN__PRTYPE 4 "PRTYPE" , SLong(), NOT_NULL),#define SYS_COLUMN_COLUMN_LEN 5 "LEN" , SLong(), NOT_NULL),// namespace Show /**********************************************************************//** return 0 on success */static int /*======================*/ /*!< in: thread */ /*!< in: table ID */ const char * col_name, /*!< in: column name */ /*!< in: dict_col_t struct holding /*!< in: virtual column, its /*!< in/out: fill this table */ "i_s_dict_fill_sys_columns" );TRUE ));if (column->is_virtual()) {true ));else {true ));0 );/*******************************************************************//** return 0 on success */static int /*=======================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (not used) */ "i_s_sys_columns_fill_table" );/* deny access to user without PROCESS_ACL privilege */ if (check_global_access(thd, PROCESS_ACL)) {0 );const rec_t* rec;const char * col_name;int err = 0 ;1000 );while (rec) {const char * err_msg;/* populate a dict_col_t structure with information from if (!err_msg) {if (err) {goto func_exit;else {"%s" ,/* Get the next record */ /*******************************************************************//** return 0 on success */static int /*====================*/ void * p) /*!< in/out: table schema object */ "innodb_sys_columns_init" );0 );struct st_maria_plugin i_s_innodb_sys_columns =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_SYS_COLUMNS" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB SYS_COLUMNS" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/** SYS_VIRTUAL **************************************************/ /** Fields of the dynamic table INFORMATION_SCHEMA.INNODB_SYS_VIRTUAL */ static ST_FIELD_INFO innodb_sys_virtual_fields_info[]=#define SYS_VIRTUAL_TABLE_ID 0 "TABLE_ID" , ULonglong(), NOT_NULL),#define SYS_VIRTUAL_POS 1 "POS" , ULong(), NOT_NULL),#define SYS_VIRTUAL_BASE_POS 2 "BASE_POS" , ULong(), NOT_NULL),// namespace Show /** Function to populate the information_schema.innodb_sys_virtual withrelated 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 static int "i_s_dict_fill_sys_virtual" );true ));true ));true ));0 );/** Function to fill information_schema.innodb_sys_virtual with informationcollected by scanning SYS_VIRTUAL table . param [ in ] thd thread param [ in , out ] tables tables to fill param [ in ] item condition ( not used ) static int "i_s_sys_virtual_fill_table" );/* deny access to user without PROCESS_ACL privilege */ if (check_global_access(thd, PROCESS_ACL) || !dict_sys.sys_virtual) {0 );const rec_t* rec;int err = 0 ;while (rec) {const char * err_msg;/* populate a dict_col_t structure with information from if (!err_msg) {if (err) {goto func_exit;else {"%s" ,/* Get the next record */ 0 );/** Bind the dynamic table INFORMATION_SCHEMA.innodb_sys_virtualparam [ in , out ] p table schema object static int void * p)"innodb_sys_virtual_init" );0 );struct st_maria_plugin i_s_innodb_sys_virtual =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_SYS_VIRTUAL" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB SYS_VIRTUAL" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/** SYS_FIELDS ***************************************************/ /* Fields of the dynamic table INFORMATION_SCHEMA.INNODB_SYS_FIELDS */ static ST_FIELD_INFO innodb_sys_fields_fields_info[]=#define SYS_FIELD_INDEX_ID 0 "INDEX_ID" , ULonglong(), NOT_NULL),#define SYS_FIELD_NAME 1 "NAME" , Varchar(NAME_CHAR_LEN), NOT_NULL),#define SYS_FIELD_POS 2 "POS" , ULong(), NOT_NULL),// namespace Show /**********************************************************************//** return 0 on success */static int /*=====================*/ /*!< in: thread */ /*!< in: index id for the field */ /*!< in: table */ /*!< in: Field position */ /*!< in/out: fill this table */ "i_s_dict_fill_sys_fields" );true ));true ));0 );/*******************************************************************//** and fill thereturn 0 on success */static int /*======================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (not used) */ "i_s_sys_fields_fill_table" );/* deny access to user without PROCESS_ACL privilege */ if (check_global_access(thd, PROCESS_ACL)) {0 );const rec_t* rec;int err = 0 ;1000 );/* will save last index id so that we know whether we move to 0 ;while (rec) {const char * err_msg;/* Populate a dict_field_t structure with information from if (!err_msg) {if (err) {goto func_exit;else {"%s" ,/* Get the next record */ /*******************************************************************//** return 0 on success */static int /*===================*/ void * p) /*!< in/out: table schema object */ "innodb_sys_field_init" );0 );struct st_maria_plugin i_s_innodb_sys_fields =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_SYS_FIELDS" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB SYS_FIELDS" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/** SYS_FOREIGN ********************************************/ /* Fields of the dynamic table INFORMATION_SCHEMA.INNODB_SYS_FOREIGN */ static ST_FIELD_INFO innodb_sys_foreign_fields_info[]=#define SYS_FOREIGN_ID 0 "ID" , Varchar(NAME_LEN + 1 ), NOT_NULL),#define SYS_FOREIGN_FOR_NAME 1 "FOR_NAME" , Varchar(NAME_LEN + 1 ), NOT_NULL),#define SYS_FOREIGN_REF_NAME 2 "REF_NAME" , Varchar(NAME_LEN + 1 ), NOT_NULL),#define SYS_FOREIGN_NUM_COL 3 "N_COLS" , ULong(), NOT_NULL),#define SYS_FOREIGN_TYPE 4 "TYPE" , ULong(), NOT_NULL),// namespace Show /**********************************************************************//** return 0 on success */static int /*======================*/ /*!< in: thread */ /*!< in: table */ /*!< in/out: fill this table */ "i_s_dict_fill_sys_foreign" );0 );/*******************************************************************//** and extract the foreign keyreturn 0 on success */static int /*=======================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (not used) */ "i_s_sys_foreign_fill_table" );/* deny access to user without PROCESS_ACL privilege */ if (check_global_access(thd, PROCESS_ACL) || !dict_sys.sys_foreign) {0 );const rec_t* rec;int err = 0 ;1000 );while (rec) {const char * err_msg;/* Populate a dict_foreign_t structure with information from if (!err_msg) {if (err) {goto func_exit;else {"%s" ,/* Get the next record */ /*******************************************************************//** return 0 on success */static int /*====================*/ void * p) /*!< in/out: table schema object */ "innodb_sys_foreign_init" );0 );struct st_maria_plugin i_s_innodb_sys_foreign =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_SYS_FOREIGN" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB SYS_FOREIGN" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/** SYS_FOREIGN_COLS ********************************************/ /* Fields of the dynamic table INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS */ static ST_FIELD_INFO innodb_sys_foreign_cols_fields_info[]=#define SYS_FOREIGN_COL_ID 0 "ID" , Varchar(NAME_LEN + 1 ), NOT_NULL),#define SYS_FOREIGN_COL_FOR_NAME 1 "FOR_COL_NAME" , Varchar(NAME_CHAR_LEN), NOT_NULL),#define SYS_FOREIGN_COL_REF_NAME 2 "REF_COL_NAME" , Varchar(NAME_CHAR_LEN), NOT_NULL),#define SYS_FOREIGN_COL_POS 3 "POS" , ULong(), NOT_NULL),// namespace Show /**********************************************************************//** return 0 on success */static int /*==========================*/ /*!< in: thread */ const char * name, /*!< in: foreign key constraint name */ const char * for_col_name, /*!< in: referencing column name*/ const char * ref_col_name, /*!< in: referenced column /*!< in: column position */ /*!< in/out: fill this table */ "i_s_dict_fill_sys_foreign_cols" );const char * id = strchr(name, '\377' );if (!id) id = strchr(name, '/' );1 : name;true ));0 );/*******************************************************************//** and extract the foreign key columnand fill the INFORMATION_SCHEMA.innodb_sys_foreign_cols table.return 0 on success */static int /*============================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (not used) */ "i_s_sys_foreign_cols_fill_table" );/* deny access to user without PROCESS_ACL privilege */ if (check_global_access(thd, PROCESS_ACL)0 );const rec_t* rec;int err = 0 ;1000 );while (rec) {const char * err_msg;const char * name;const char * for_col_name;const char * ref_col_name;/* Extract necessary information from a SYS_FOREIGN_COLS row */ if (!err_msg) {if (err) {goto func_exit;else {"%s" ,/* Get the next record */ /*******************************************************************//** return 0 on success */static int /*========================*/ void * p) /*!< in/out: table schema object */ "innodb_sys_foreign_cols_init" );0 );struct st_maria_plugin i_s_innodb_sys_foreign_cols =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_SYS_FOREIGN_COLS" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB SYS_FOREIGN_COLS" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/** SYS_TABLESPACES ********************************************/ /* Fields of the dynamic table INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES */ static ST_FIELD_INFO innodb_sys_tablespaces_fields_info[]=#define SYS_TABLESPACES_SPACE 0 "SPACE" , ULong(), NOT_NULL),#define SYS_TABLESPACES_NAME 1 "NAME" , Varchar(MAX_FULL_NAME_LEN + 1 ), NOT_NULL),#define SYS_TABLESPACES_FLAGS 2 "FLAG" , ULong(), NOT_NULL),#define SYS_TABLESPACES_ROW_FORMAT 3 "ROW_FORMAT" , Varchar(22 ), NULLABLE),#define SYS_TABLESPACES_PAGE_SIZE 4 "PAGE_SIZE" , ULong(), NOT_NULL),#define SYS_TABLESPACES_FILENAME 5 "FILENAME" , Varchar(FN_REFLEN), NOT_NULL),#define SYS_TABLESPACES_FS_BLOCK_SIZE 6 "FS_BLOCK_SIZE" , ULong(),NOT_NULL),#define SYS_TABLESPACES_FILE_SIZE 7 "FILE_SIZE" , ULonglong(), NOT_NULL),#define SYS_TABLESPACES_ALLOC_SIZE 8 "ALLOCATED_SIZE" , ULonglong(), NOT_NULL),// namespace Show extern size_t os_file_get_fs_block_size(const char *path);/** Produce one row of INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES.@ param thd connection @ param s tablespace @ param t output table static int i_s_sys_tablespaces_fill(THD *thd, const fil_space_t &s, TABLE *t)"i_s_sys_tablespaces_fill" );const char *row_format;if (s.full_crc32() || is_system_tablespace(s.id))else if (FSP_FLAGS_GET_ZIP_SSIZE(s.flags))"Compressed" ;else if (FSP_FLAGS_HAS_ATOMIC_BLOBS(s.flags))"Dynamic" ;else "Compact or Redundant" ;true ));const auto name= s.name();if (name.data())else if (srv_is_undo_tablespace(s.id))char name[15 ];sizeof name, "innodb_undo%03u" ,1 ));else f->set_notnull();true ));const char *filepath= s.chain.start->name;true ));if (file.m_total_size == os_offset_t(~0 ))0 ;0 ;0 ;else true ));true ));true ));0 );/** Populate INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES.@ param thd connection @ param tables table to fill static int i_s_sys_tablespaces_fill_table(THD *thd, TABLE_LIST *tables, Item*)"i_s_sys_tablespaces_fill_table" );if (check_global_access(thd, PROCESS_ACL))0 );int err= 0 ;for (fil_space_t &space : fil_system.space_list)if (!space.is_temporary() && !space.is_being_imported() &&if (err)break ;if (err == DB_SUCCESS)else /*******************************************************************//** return 0 on success */static int /*========================*/ void * p) /*!< in/out: table schema object */ "innodb_sys_tablespaces_init" );0 );struct st_maria_plugin i_s_innodb_sys_tablespaces =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_SYS_TABLESPACES" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ /* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB tablespaces" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */ namespace Show {/** TABLESPACES_ENCRYPTION ********************************************/ /* Fields of the table INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION */ static ST_FIELD_INFO innodb_tablespaces_encryption_fields_info[]=#define TABLESPACES_ENCRYPTION_SPACE 0 "SPACE" , ULong(), NOT_NULL),#define TABLESPACES_ENCRYPTION_NAME 1 "NAME" , Varchar(MAX_FULL_NAME_LEN + 1 ), NULLABLE),#define TABLESPACES_ENCRYPTION_ENCRYPTION_SCHEME 2 "ENCRYPTION_SCHEME" , ULong(), NOT_NULL),#define TABLESPACES_ENCRYPTION_KEYSERVER_REQUESTS 3 "KEYSERVER_REQUESTS" , ULong(), NOT_NULL),#define TABLESPACES_ENCRYPTION_MIN_KEY_VERSION 4 "MIN_KEY_VERSION" , ULong(), NOT_NULL),#define TABLESPACES_ENCRYPTION_CURRENT_KEY_VERSION 5 "CURRENT_KEY_VERSION" , ULong(), NOT_NULL),#define TABLESPACES_ENCRYPTION_KEY_ROTATION_PAGE_NUMBER 6 "KEY_ROTATION_PAGE_NUMBER" , ULonglong(), NULLABLE),#define TABLESPACES_ENCRYPTION_KEY_ROTATION_MAX_PAGE_NUMBER 7 "KEY_ROTATION_MAX_PAGE_NUMBER" , ULonglong(), NULLABLE),#define TABLESPACES_ENCRYPTION_CURRENT_KEY_ID 8 "CURRENT_KEY_ID" , ULong(), NOT_NULL),#define TABLESPACES_ENCRYPTION_ROTATING_OR_FLUSHING 9 "ROTATING_OR_FLUSHING" , SLong(1 ), NOT_NULL),// namespace Show /**********************************************************************//** return 0 on success */static int struct fil_space_crypt_status_t status;"i_s_dict_fill_tablespaces_encryption" );/* If tablespace id does not match, we did not find if (!space->crypt_data || space->id != status.space) {goto skip;true ));const auto name = space->name();if (name.data()) {else if (srv_is_undo_tablespace(space->id)) {char undo_name[sizeof "innodb_undo000" ];sizeof undo_name,"innodb_undo%03" PRIu32, space->id);else {true ));true ));true ));true ));true ));true ));if (status.rotating) {true ));true ));else {0 );/*******************************************************************//** and extract the columnand fill the INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION table.return 0 on success */static int /*===========================*/ /*!< in: thread */ /*!< in/out: tables to fill */ /*!< in: condition (not used) */ "i_s_tablespaces_encryption_fill_table" );/* deny access to user without PROCESS_ACL privilege */ if (check_global_access(thd, PROCESS_ACL)) {0 );int err = 0 ;for (fil_space_t& space : fil_system.space_list) {if (!space.is_temporary() && !space.is_being_imported()if (err) {break ;/*******************************************************************//** return 0 on success */static int /*========================*/ void * p) /*!< in/out: table schema object */ "innodb_tablespaces_encryption_init" );0 );struct st_maria_plugin i_s_innodb_tablespaces_encryption =/* the plugin type (a MYSQL_XXX_PLUGIN value) */ /* int */ /* pointer to type-specific plugin descriptor */ /* void* */ /* plugin name */ /* const char* */ "INNODB_TABLESPACES_ENCRYPTION" ,/* plugin author (for SHOW PLUGINS) */ /* const char* */ "Google Inc" ,/* general descriptive text (for SHOW PLUGINS) */ /* const char* */ "InnoDB TABLESPACES_ENCRYPTION" ,/* the plugin license (PLUGIN_LICENSE_XXX) */ /* int */ /* the function to invoke when plugin is loaded */ /* int (*)(void*); */ /* the function to invoke when plugin is unloaded */ /* int (*)(void*); */
Messung V0.5 in Prozent C=85 H=91 G=87
¤ Diese beiden folgenden Angebotsgruppen bietet das Unternehmen0.211Angebot
(Wie Sie bei der Firma Beratungs- und Dienstleistungen beauftragen können 2026-10-08)
¤ *Eine klare Vorstellung vom Zielzustand
