ha_innodb.cc File Reference

#include "my_config.h"
#include <cstdint>
#include <auto_thd.h>
#include <errno.h>
#include <fcntl.h>
#include <gstream.h>
#include <limits.h>
#include <log.h>
#include <math.h>
#include <my_compare.h>
#include <mysqld.h>
#include <stdlib.h>
#include <strfunc.h>
#include <time.h>
#include <algorithm>
#include <memory>
#include <sql_table.h>
#include "mysql/components/services/system_variable_source.h"
#include <current_thd.h>
#include <debug_sync.h>
#include <derror.h>
#include <my_bitmap.h>
#include <my_check_opt.h>
#include <mysql/service_thd_alloc.h>
#include <mysql/service_thd_wait.h>
#include <mysql_com.h>
#include <sql_acl.h>
#include <sql_class.h>
#include <sql_show.h>
#include <sql_tablespace.h>
#include <sql_thd_internal_api.h>
#include "api0api.h"
#include "api0misc.h"
#include "arch0arch.h"
#include "arch0page.h"
#include "auth_acls.h"
#include "btr0btr.h"
#include "btr0cur.h"
#include "btr0sea.h"
#include "buf0dblwr.h"
#include "buf0dump.h"
#include "buf0flu.h"
#include "buf0lru.h"
#include "buf0stats.h"
#include "clone0api.h"
#include "clone0clone.h"
#include "dd/dd.h"
#include "dd/dictionary.h"
#include "dd/impl/bootstrap/bootstrap_ctx.h"
#include "dd/properties.h"
#include "dd/types/index.h"
#include "dd/types/object_table.h"
#include "dd/types/object_table_definition.h"
#include "dd/types/partition.h"
#include "dd/types/table.h"
#include "dd/types/tablespace.h"
#include "ddl0ddl.h"
#include "dict0boot.h"
#include "dict0crea.h"
#include "dict0dd.h"
#include "dict0dict.h"
#include "dict0load.h"
#include "dict0stats.h"
#include "dict0stats_bg.h"
#include "fil0fil.h"
#include "fsp0fsp.h"
#include "fsp0space.h"
#include "fsp0sysspace.h"
#include "fts0fts.h"
#include "fts0plugin.h"
#include "fts0priv.h"
#include "fts0types.h"
#include "ha_innodb.h"
#include "ha_innopart.h"
#include "ha_prototypes.h"
#include "handler0alter.h"
#include "i_s.h"
#include "ibuf0ibuf.h"
#include "lex_string.h"
#include "lob0lob.h"
#include "lock0lock.h"
#include "log0buf.h"
#include "log0chkp.h"
#include "log0encryption.h"
#include "log0meb.h"
#include "log0pfs.h"
#include "log0pre_8_0_30.h"
#include "log0sys.h"
#include "log0write.h"
#include "mem0mem.h"
#include "mtr0mtr.h"
#include "my_compiler.h"
#include "my_dbug.h"
#include "my_double2ulonglong.h"
#include "my_io.h"
#include "my_macros.h"
#include "my_psi_config.h"
#include "mysql/components/services/log_builtins.h"
#include "mysql/plugin.h"
#include "mysql/psi/mysql_data_lock.h"
#include "mysql/psi/mysql_metric.h"
#include "mysql/strings/int2str.h"
#include "mysql/strings/m_ctype.h"
#include "mysys_err.h"
#include "nulls.h"
#include "os0thread-create.h"
#include "os0thread.h"
#include "p_s.h"
#include "page0zip.h"
#include "pars0pars.h"
#include "rem0types.h"
#include "row0ext.h"
#include "row0import.h"
#include "row0ins.h"
#include "row0mysql.h"
#include "row0quiesce.h"
#include "row0sel.h"
#include "row0upd.h"
#include "sql/plugin_table.h"
#include "srv0mon.h"
#include "srv0srv.h"
#include "srv0start.h"
#include "string_with_len.h"
#include "sync0sync.h"
#include "trx0purge.h"
#include "dict0priv.h"
#include "dict0sdi.h"
#include "dict0upgrade.h"
#include "sql/item.h"
#include "sql_base.h"
#include "srv0tmp.h"
#include "trx0rec.h"
#include "trx0roll.h"
#include "trx0rseg.h"
#include "trx0sys.h"
#include "trx0trx.h"
#include "trx0xa.h"
#include "ut0mem.h"
#include "ut0test.h"
#include "ut0ut.h"
#include "log0files_io.h"
#include "sql-common/json_binary.h"
#include "sql-common/json_dom.h"
#include "os0enc.h"
#include "os0file.h"
#include <mutex>
#include <sstream>
#include <string>
#include <vector>
#include <unistd.h>

Classes
class	Validate_files
	Validate the DD tablespace data against what's read during the directory scan on startup. More...
struct	ShowStatus
	Callback for collecting mutex statistics. More...
struct	ShowStatus::Value
	For tracking the mutex metrics. More...
struct	ShowStatus::OrderByWaits
	Order by m_waits, in descending order. More...
struct	ShowStatus::GetCount
	Collect the individual latch counts. More...

Namespaces
namespace	innobase
namespace	innobase::component_services

Macros
#define	PSI_KEY(n, flag, volatility, doc)    { &(n##_key.m_value), #n, flag, volatility, doc }
#define	PSI_MEMORY_KEY(n, flag, volatility, doc)    { &(n##_key), #n, flag, volatility, doc }
#define	PSI_MUTEX_KEY(n, flag, volatility, doc)    { &(n##_key.m_value), #n, flag, volatility, doc }
#define	PSI_RWLOCK_KEY(n, volatility, doc)    { &n##_key.m_value, #n, PSI_FLAG_RWLOCK_SX, volatility, doc }
#define	PSI_THREAD_KEY(n, osn, flag, volatility, doc)    { &(n##_key.m_value), #n, osn, flag, volatility, doc }
#define	INNODB_API_CB_ARRAY_ELEMENT_TRANSFORM(stem)   (ib_cb_t) ib_##stem,
	Set up InnoDB API callback function array. More...
#define	BP_IN_CORE_DEFAULT   false

Enumerations
enum	default_row_format_enum { DEFAULT_ROW_FORMAT_REDUNDANT = 0 , DEFAULT_ROW_FORMAT_COMPACT = 1 , DEFAULT_ROW_FORMAT_DYNAMIC = 2 }
	Note we cannot use rec_format_enum because we do not allow COMPRESSED row format for innodb_default_row_format option. More...

Functions
static bool	innobase::component_services::intitialize_service_handles ()
	Initialize component service handles. More...
static void	innobase::component_services::deinitialize_service_handles ()
	Deinitialize component service handles. More...
static bool	EQ_CURRENT_THD (THD *thd)
static void	release_plugin_services ()
	Release all acquired services from mysql server. More...
static void	acquire_plugin_services ()
	Acquire required services from mysql server. More...
static rec_format_t	get_row_format (ulong row_format)
	Return the InnoDB ROW_FORMAT enum value. More...
static void	trx_deregister_from_2pc (trx_t *trx)
	Note that a transaction has been deregistered. More...
static float	innobase_fts_retrieve_ranking (FT_INFO *fts_hdl)
	Retrieve the FTS Relevance Ranking result for doc with doc_id of m_prebuilt->fts_doc_id. More...
static void	innobase_fts_close_ranking (FT_INFO *fts_hdl)
	Free the memory for the FTS handler. More...
static float	innobase_fts_find_ranking (FT_INFO *fts_hdl, uchar *, uint)
	Find and Retrieve the FTS Relevance Ranking result for doc with doc_id of m_prebuilt->fts_doc_id. More...
static uint	innobase_fts_get_version ()
static ulonglong	innobase_fts_flags ()
static ulonglong	innobase_fts_retrieve_docid (FT_INFO_EXT *fts_hdl)
	Find and Retrieve the FTS doc_id for the current result row. More...
static ulonglong	innobase_fts_count_matches (FT_INFO_EXT *fts_hdl)
	Find and retrieve the size of the current result. More...
static void	doublewrite_update (THD *thd, SYS_VAR *var, void *var_ptr, const void *save)
	Plugin update function to handle validation and then switch the innodb_doublewrite mode. More...
static int	innodb_check_session_admin (THD *thd, SYS_VAR *var, void *save, struct st_mysql_value *value)
	Check if SESSION_VARIABLES_ADMIN granted. More...
static int	innodb_stopword_table_validate (THD *thd, SYS_VAR *var, void *save, struct st_mysql_value *value)
	Check whether valid argument given to innobase_*_stopword_table. More...
static int	innodb_tmpdir_validate (THD *thd, SYS_VAR *, void *save, struct st_mysql_value *value)
	Validate passed-in "value" is a valid directory name. More...
static uint	get_field_offset (const TABLE *table, const Field *field)
	Gets field offset for a field in a table. More...
static	MYSQL_THDVAR_BOOL (table_locks, PLUGIN_VAR_OPCMDARG, "Enable InnoDB locking in LOCK TABLES", nullptr, nullptr, true)
static	MYSQL_THDVAR_BOOL (strict_mode, PLUGIN_VAR_OPCMDARG, "Use strict mode when evaluating create options.", innodb_check_session_admin, nullptr, true)
static	MYSQL_THDVAR_BOOL (ft_enable_stopword, PLUGIN_VAR_OPCMDARG, "Create FTS index with stopword.", nullptr, nullptr, true)
static	MYSQL_THDVAR_ULONG (lock_wait_timeout, PLUGIN_VAR_RQCMDARG, "Timeout in seconds an InnoDB transaction may wait " "for a lock before being rolled back. Values above " "100000000 disable the timeout.", nullptr, nullptr, 50, 1, 1024 *1024 *1024, 0)
static	MYSQL_THDVAR_STR (ft_user_stopword_table, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_MEMALLOC, "User supplied stopword table name, effective in the session level.", innodb_stopword_table_validate, nullptr, nullptr)
static	MYSQL_THDVAR_STR (tmpdir, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_MEMALLOC, "Directory for temporary non-tablespace files.", innodb_tmpdir_validate, nullptr, nullptr)
static	MYSQL_THDVAR_ULONG (parallel_read_threads, PLUGIN_VAR_RQCMDARG, "Number of threads to do parallel read.", nullptr, nullptr, std::clamp(ulong{std::thread::hardware_concurrency()/8}, 4UL, ulong{Parallel_reader::MAX_THREADS}), 1, Parallel_reader::MAX_THREADS, 0)
static	MYSQL_THDVAR_ULONG (ddl_buffer_size, PLUGIN_VAR_RQCMDARG, "Maximum size of memory to use (in bytes) for DDL.", nullptr, nullptr, 1048576, 65536, 4294967295, 0)
static	MYSQL_THDVAR_ULONG (ddl_threads, PLUGIN_VAR_RQCMDARG, "Maximum number of threads to use for DDL.", nullptr, nullptr, 4, 1, 64, 0)
static INNOBASE_SHARE *	get_share (const char *table_name)
	Handling the shared INNOBASE_SHARE structure that is needed to provide table locking. More...
static void	free_share (INNOBASE_SHARE *share)
	Free the shared object that was registered with get_share(). More...
static int	innobase_close_connection (handlerton *hton, THD *thd)
	Frees a possible InnoDB trx object associated with the current THD. More...
static void	innobase_kill_connection (handlerton *hton, THD *thd)
	Cancel any pending lock request associated with the current THD. More...
static int	innobase_commit (handlerton *hton, THD *thd, bool commit_trx)
	Commits a transaction in an InnoDB database or marks an SQL statement ended. More...
static int	innobase_rollback (handlerton *hton, THD *thd, bool rollback_trx)
	Rolls back a transaction to a savepoint. More...
static int	innobase_rollback_to_savepoint (handlerton *hton, THD *thd, void *savepoint)
	Rolls back a transaction to a savepoint. More...
static bool	innobase_rollback_to_savepoint_can_release_mdl (handlerton *hton, THD *thd)
	Check whether innodb state allows to safely release MDL locks after rollback to savepoint. More...
static int	innobase_savepoint (handlerton *hton, THD *thd, void *savepoint)
	Sets a transaction savepoint. More...
static int	innobase_release_savepoint (handlerton *hton, THD *thd, void *savepoint)
	Release transaction savepoint name. More...
static handler *	innobase_create_handler (handlerton *hton, TABLE_SHARE *table, bool partitioned, MEM_ROOT *mem_root)
	Function for constructing an InnoDB table handler instance. More...
static bool	innobase_get_table_statistics (const char *db_name, const char *table_name, dd::Object_id se_private_id, const dd::Properties &ts_se_private_data, const dd::Properties &tbl_se_private_data, uint stat_flags, ha_statistics *stats)
	Retrieve table satistics. More...
static bool	innobase_get_index_column_cardinality (const char *db_name, const char *table_name, const char *index_name, uint index_ordinal_position, uint column_ordinal_position, dd::Object_id se_private_id, ulonglong *cardinality)
	Retrieve index column cardinality. More...
static bool	innobase_get_tablespace_statistics (const char *tablespace_name, const char *file_name, const dd::Properties &ts_se_private_data, ha_tablespace_statistics *stats)
	Retrieve ha_tablespace_statistics for the tablespace. More...
static bool	innobase_get_tablespace_type (const dd::Tablespace &space, Tablespace_type *space_type)
	Retrieve the tablespace type. More...
static bool	innobase_get_tablespace_type_by_name (const char *tablespace_name, Tablespace_type *space_type)
	Get the tablespace type given the name. More...
static void	innobase_post_ddl (THD *thd)
	Perform post-commit/rollback cleanup after DDL statement. More...
static bool	innodb_check_fk_column_compat (const Ha_fk_column_type *child_column_type, const Ha_fk_column_type *parent_column_type, bool check_charsets)
	Check if types of child and parent columns in foreign key are compatible. More...
static void	innobase_commit_concurrency_init_default ()
	Initialize the default value of innodb_commit_concurrency. More...
static int	innobase_xa_prepare (handlerton *hton, THD *thd, bool all)
	This function is used to prepare an X/Open XA distributed transaction. More...
static int	innobase_xa_recover (handlerton *hton, XA_recover_txn *txn_list, uint len, MEM_ROOT *mem_root)
	This function is used to recover X/Open XA distributed transactions. More...
static int	innobase_xa_recover_prepared_in_tc (handlerton *hton, Xa_state_list &xa_list)
	Find prepared transactions that are marked as prepared in TC, for recovery purposes. More...
static xa_status_code	innobase_commit_by_xid (handlerton *hton, XID *xid)
	This function is used to commit one X/Open XA distributed transaction which is in the prepared state. More...
static xa_status_code	innobase_rollback_by_xid (handlerton *hton, XID *xid)
	This function is used to rollback one X/Open XA distributed transaction which is in the prepared state. More...
static int	innobase_set_prepared_in_tc (handlerton *hton, THD *thd)
	This function is used to write mark an X/Open XA distributed transaction as been prepared in the server transaction coordinator. More...
static xa_status_code	innobase_set_prepared_in_tc_by_xid (handlerton *hton, XID *xid)
	Mark an X/Open XA distributed transaction as been prepared in the server transaction coordinator. More...
static bool	innobase_check_reserved_file_name (handlerton *hton, const char *name)
	Checks if the file name is reserved in InnoDB. More...
static bool	innobase_is_valid_tablespace_name (ts_command_type ts_cmd, const char *name)
	Check tablespace name validity. More...
static int	innobase_alter_tablespace (handlerton *hton, THD *thd, st_alter_tablespace *alter_info, const dd::Tablespace *old_ts_def, dd::Tablespace *new_ts_def)
	This API handles CREATE, ALTER & DROP commands for InnoDB tablespaces. More...
static const char *	innobase_get_tablespace_filename_ext ()
	Get tablespace datafile name extension. More...
static void	innodb_space_shutdown ()
	Free tablespace resources. More...
static int	innodb_shutdown (handlerton *, ha_panic_function)
	Shut down InnoDB after the Global Data Dictionary has been shut down. More...
static void	innodb_pre_dd_shutdown (handlerton *)
	Shut down all InnoDB background tasks that may access the Global Data Dictionary, before the Global Data Dictionary and the rest of InnoDB have been shut down. More...
static int	innobase_start_trx_and_assign_read_view (handlerton *hton, THD *thd)
	Creates an InnoDB transaction struct for the thd if it does not yet have one. More...
static bool	innobase_flush_logs (handlerton *hton, bool binlog_group_flush)
	Flush InnoDB redo logs to the file system. More...
static int	innodb_show_status (handlerton *hton, THD *thd, stat_print_fn *stat_print)
	Implements the SHOW ENGINE INNODB STATUS command. More...
static bool	innobase_lock_hton_log (handlerton *hton)
	Implements Log_resource lock. More...
static bool	innobase_unlock_hton_log (handlerton *hton)
	Implements Log_resource unlock. More...
static bool	innobase_collect_hton_log_info (handlerton *hton, Json_dom *json)
	Implements Log_resource collect_info. More...
static bool	innobase_show_status (handlerton *hton, THD *thd, stat_print_fn *stat_print, enum ha_stat_type stat_type)
	Return 0 on success and non-zero on failure. More...
static void	innodb_enable_monitor_at_startup (char *str)
	Parse and enable InnoDB monitor counters during server startup. More...
static void	innobase_fts_store_docid (TABLE *tbl, ulonglong doc_id)
	Store doc_id value into FTS_DOC_ID field. More...
static int	innobase_commit_concurrency_validate (THD *, SYS_VAR *, void *save, struct st_mysql_value *value)
	Check for a valid value of innobase_commit_concurrency. More...
bool	thd_is_replication_slave_thread (THD *thd)
	Returns true if the thread is the replication thread on the slave server. More...
enum durability_properties	thd_requested_durability (const THD *thd)
	Gets information on the durability property requested by thread. More...
bool	thd_trx_is_read_only (THD *thd)
	Returns true if transaction should be flagged as read-only. More...
THD *	thd_trx_arbitrate (THD *requestor, THD *holder)
	Check if the transaction can be rolled back. More...
int	thd_trx_priority (THD *thd)
bool	thd_trx_is_auto_commit (THD *thd)
	Check if the transaction is an auto-commit transaction. More...
time_t	thd_start_time (const THD *thd)
std::chrono::system_clock::time_point	thd_start_time (THD *)
	Get the thread start time. More...
static dberr_t	innobase_srv_conc_enter_innodb (row_prebuilt_t *prebuilt)
	Enter InnoDB engine after checking the max number of user threads allowed, else the thread is put into sleep. More...
static void	innobase_srv_conc_exit_innodb (row_prebuilt_t *prebuilt)
	Note that the thread wants to leave InnoDB only if it doesn't have any spare tickets. More...
static void	innobase_srv_conc_force_exit_innodb (trx_t *trx)
	Force a thread to leave InnoDB even if it has spare tickets. More...
const char *	server_get_hostname ()
	Returns the NUL terminated value of glob_hostname. More...
bool	thd_has_edited_nontrans_tables (THD *thd)
	Returns true if the transaction this thread is processing has edited non-transactional tables. More...
bool	thd_is_query_block (const THD *thd)
	Returns true if the thread is executing a SELECT statement. More...
bool	innobase_should_madvise_buf_pool ()
	Checks sys_vars and determines if allocator should mark large memory segments with MADV_DONTDUMP. More...
void	innobase_disable_core_dump ()
	Make sure that core file will not be generated, as generating a core file might violate our promise to not dump buffer pool data, and/or might dump not the expected memory pages due to failure in using madvise. More...
std::chrono::seconds	thd_lock_wait_timeout (THD *thd)
	Returns the lock wait timeout for the current connection. More...
void	thd_set_lock_wait_time (THD *thd, std::chrono::steady_clock::duration value)
	Set the time waited for the lock for the current query. More...
const char *	thd_innodb_tmpdir (THD *thd)
	Get the value of innodb_tmpdir. More...
innodb_session_t *&	thd_to_innodb_session (THD *thd)
	Obtain the private handler of InnoDB session specific data. More...
trx_t *&	thd_to_trx (THD *thd)
	Obtain the InnoDB transaction of a MySQL thread. More...
ulong	thd_parallel_read_threads (THD *thd)
	Return the number of read threads for this session. More...
ulong	thd_ddl_buffer_size (THD *thd)
	Return the maximum buffer size to use for DDL. More...
size_t	thd_ddl_threads (THD *thd) noexcept
static bool	thd_is_ins_sel_stmt (THD *user_thd)
	Check if statement is of type INSERT .... More...
static void	add_table_to_thread_cache (dict_table_t *table, mem_heap_t *heap, THD *thd)
	Add the table handler to thread cache. More...
void	innobase_active_small (void)
	Increments innobase_active_counter and every INNOBASE_WAKE_INTERVALth time calls srv_active_wake_master_thread. More...
int	convert_error_code_to_mysql (dberr_t error, uint32_t flags, THD *thd)
	Converts an InnoDB error code to a MySQL error code. More...
void	innobase_mysql_print_thd (FILE *f, THD *thd, uint max_query_len)
	Prints info of a THD object (== user session thread) to the given file. More...
const char *	innobase_get_err_msg (int error_code)
	Get the error message format string. More...
void	innobase_get_cset_width (ulint cset, ulint *mbminlen, ulint *mbmaxlen)
	Get the variable length bounds of the given character set. More...
bool	innobase_check_identifier_length (const char *id)
int	innobase_strcasecmp (const char *a, const char *b)
	Compares NUL-terminated UTF-8 strings case insensitively. More...
static int	innobase_wildcasecmp (const char *a, const char *b)
	Compares NUL-terminated UTF-8 strings case insensitively. More...
const char *	innobase_basename (const char *path_name)
	Strip dir name from a full path name and return only the file name. More...
void	innobase_casedn_str (char *a)
	Makes all characters in a NUL-terminated UTF-8 string lower case. More...
void	innobase_casedn_path (char *a)
	Makes all characters in a NUL-terminated UTF-8 path string lower case. More...
const CHARSET_INFO *	innobase_get_charset (THD *mysql_thd)
	Determines the connection character set. More...
const char *	innobase_get_stmt_unsafe (THD *thd, size_t *length)
	Determines the current SQL statement. More...
size_t	innobase_get_stmt_safe (THD *thd, char *buf, size_t buflen)
	Determines the current SQL statement. More...
ulint	innobase_get_table_cache_size (void)
	Get the current setting of the table_def_size global parameter. More...
ulint	innobase_get_lower_case_table_names (void)
	Get the current setting of the lower_case_table_names global parameter from mysqld.cc. More...
char *	innobase_mysql_tmpdir ()
	return any of the tmpdir path More...
os_fd_t	innobase_mysql_tmpfile (const char *path)
	Creates a temporary file in the location specified by the parameter path. More...
static ulint	innobase_convert_string (void *to, ulint to_length, const CHARSET_INFO *to_cs, const void *from, ulint from_length, const CHARSET_INFO *from_cs, uint *errors)
	Wrapper around MySQL's copy_and_convert function. More...
ulint	innobase_raw_format (const char *data, ulint data_len, ulint charset_coll, char *buf, ulint buf_size)
	Formats the raw data in "data" (in InnoDB on-disk format) that is of type DATA_(CHAR|VARCHAR|MYSQL|VARMYSQL) using "charset_coll" and writes the result to "buf". More...
ulonglong	innobase_next_autoinc (ulonglong current, ulonglong need, ulonglong step, ulonglong offset, ulonglong max_value)
	Compute the next autoinc value. More...
static void	innobase_trx_init (THD *thd, trx_t *trx)
	Initializes some fields in an InnoDB transaction object. More...
trx_t *	innobase_trx_allocate (THD *thd)
	Allocates an InnoDB transaction for a MySQL handler object for DML. More...
trx_t *	check_trx_exists (THD *thd)
	Gets the InnoDB transaction handle for a MySQL handler object, creates an InnoDB transaction struct if the corresponding MySQL thread struct still lacks one. More...
static void	innodb_replace_trx_in_thd (THD *thd, void *new_trx_arg, void **ptr_trx_arg)
	InnoDB transaction object that is currently associated with THD is replaced with that of the 2nd argument. More...
static void	trx_register_for_2pc (trx_t *trx)
	Note that a transaction has been registered with MySQL 2PC coordinator. More...
static void	innobase_copy_frm_flags_from_create_info (dict_table_t *innodb_table, const HA_CREATE_INFO *create_info)
	Copy table flags from MySQL's HA_CREATE_INFO into an InnoDB table object. More...
void	innobase_copy_frm_flags_from_table_share (dict_table_t *innodb_table, const TABLE_SHARE *table_share)
	Copy table flags from MySQL's TABLE_SHARE into an InnoDB table object. More...
void	innobase_register_trx (handlerton *hton, THD *thd, trx_t *trx)
	Registers an InnoDB transaction with the MySQL 2PC coordinator, so that the MySQL XA code knows to call the InnoDB prepare and commit, or rollback for the transaction. More...
void	innobase_quote_identifier (FILE *file, trx_t *trx, const char *id)
	Quote a standard SQL identifier like tablespace, index or column name. More...
static char *	innobase_convert_identifier (char *buf, ulint buflen, const char *id, ulint idlen, THD *thd)
	Convert a table name to the MySQL system_charset_info (UTF-8) and quote it. More...
char *	innobase_convert_name (char *buf, ulint buflen, const char *id, ulint idlen, THD *thd)
	Convert a table name to the MySQL system_charset_info (UTF-8). More...
void	innobase_format_name (char *buf, ulint buflen, const char *name)
	A wrapper function of innobase_convert_name(), convert a table name to the MySQL system_charset_info (UTF-8) and quote it if needed. More...
bool	trx_is_interrupted (const trx_t *trx)
	Determines if the currently running transaction has been interrupted. More...
bool	trx_is_strict (trx_t *trx)
	Determines if the currently running transaction is in strict mode. More...
static int	innodb_init_abort ()
	Free any resources that were allocated and return failure. More...
static int	innobase_init_files (dict_init_mode_t dict_init_mode, List< const Plugin_tablespace > *tablespaces)
	Open or create InnoDB data files. More...
static bool	innobase_ddse_dict_init (dict_init_mode_t dict_init_mode, uint version, List< const dd::Object_table > *tables, List< const Plugin_tablespace > *tablespaces)
	Initialize InnoDB for being used to store the DD tables. More...
bool	apply_dd_undo_state (space_id_t space_id, const dd::Tablespace *dd_space)
	Save the state of undo tablespaces from the dd to the undo::Tablespace. More...
static void	innobase_dict_register_dd_table_id (dd::Object_id dd_table_id)
	Initialize the set of hard coded DD table ids. More...
static bool	boot_tablespaces (THD *thd)
	Discover all InnoDB tablespaces. More...
static bool	predefine_tablespace (dd::cache::Dictionary_client *dd_client, space_id_t space_id, uint32_t flags, const char *name, const char *filename)
	Create metadata for a predefined tablespace at server initialization. More...
static bool	innobase_is_dict_readonly ()
	Check if InnoDB is in a mode where the data dictionary is read-only. More...
static bool	update_innodb_temporary_metadata (THD *thd)
	Update metadata for innodb_temporary tablespace at server startup. More...
static bool	predefine_undo_tablespaces (dd::cache::Dictionary_client *dd_client)
	Predefine the undo tablespace metadata at server initialization. More...
static void	innobase_dict_cache_reset (const char *schema_name, const char *table_name)
	Invalidate an entry or entries for partitioned table from the dict cache. More...
static void	innobase_dict_cache_reset_tables_and_tablespaces ()
	Invalidate user table dict cache after Replication Plugin recovers. More...
static bool	innobase_dict_recover (dict_recovery_mode_t dict_recovery_mode, uint version)
	Perform high-level recovery in InnoDB as part of initializing the data dictionary. More...
static void	innobase_post_recover ()
	DDL crash recovery: process the records recovered from "log_ddl" table. More...
static bool	innobase_dict_get_server_version (uint *version)
	Get the server version id stored in the header of the dictionary tablespace. More...
static bool	innobase_dict_set_server_version ()
	Store the current server version number into the header of the dictionary tablespace. More...
static int	innobase_page_track_start (uint64_t *start_id)
	Start page tracking. More...
static int	innobase_page_track_stop (uint64_t *stop_id)
	Stop page tracking. More...
static int	innobase_page_track_purge (uint64_t *purge_id)
	Purge page tracking data. More...
static int	innobase_page_track_get_page_ids (Page_Track_Callback cbk_func, void *cbk_ctx, uint64_t *start_id, uint64_t *stop_id, unsigned char *buffer, size_t buffer_len)
	Fetch tracked pages. More...
static int	innobase_page_track_get_num_page_ids (uint64_t *start_id, uint64_t *stop_id, uint64_t *num_pages)
	Fetch approximate number of tracked pages in the given range. More...
static void	innobase_page_track_get_status (std::vector< std::pair< lsn_t, bool > > &status)
	Fetch the page tracking status. More...
static bool	innobase_is_supported_system_table (const char *, const char *, bool is_sql_layer_system_table)
	This function checks if the given db.tablename is a system table supported by Innodb and is used as an initializer for the data member is_supported_system_table of InnoDB storage engine handlerton. More...
bool	innobase_encryption_key_rotation ()
	Rotate the encrypted tablespace keys according to master key rotation. More...
static bool	innobase_redo_set_state (THD *thd, bool enable)
	Enable or Disable SE write ahead logging. More...
static uint	innobase_partition_flags ()
	Return partitioning flags. More...
static void	innodb_log_checksums_func_update (bool check)
	Update log_checksum_algorithm_ptr with a pointer to the function corresponding to whether checksums are enabled. More...
static void	innodb_undo_tablespaces_deprecate ()
	Validate innodb_undo_tablespaces. More...
template<size_t N>
static bool	innodb_variable_is_set (const char(&var_name)[N])
static bool	innodb_redo_log_capacity_is_set ()
bool	innodb_log_file_size_is_set ()
bool	innodb_log_n_files_is_set ()
static bool	innodb_buffer_pool_instances_is_set ()
static bool	innodb_page_cleaners_is_set ()
static bool	innodb_io_capacity_max_is_set ()
static bool	innodb_flush_method_is_set ()
static void	innodb_buffer_pool_size_init ()
	Initialize and normalize innodb_buffer_pool_size. More...
static void	innodb_redo_log_capacity_update_default (ulonglong new_def)
	Update the mysql_sysvar_redo_log_capacity's default value. More...
static void	innodb_redo_log_capacity_init ()
	Initialize srv_redo_log_capacity / srv_redo_log_capacity_used. More...
static void	innodb_io_capacity_max_update_default (ulong new_def)
	Update the mysql_sysvar_io_capacity_max's default value. More...
static int	innodb_init_params ()
	Initialize, validate and normalize the InnoDB startup parameters. More...
long	innobase_get_open_files_limit ()
	Returns current value of the "innodb_open_files" configuration variable. More...
void	innobase_set_open_files_limit (long new_limit)
	Sets new value of the "innodb_open_files" configuration variable to present to users. More...
template<typename T >
static void	get_metric_simple_integer (void *measurement_context, measurement_delivery_callback_t delivery, void *delivery_context)
template<typename T >
constexpr PSI_metric_info_v1	simple (const char *name, const char *unit, const char *description, MetricOTELType type, T &variable)
static int	innodb_init (void *p)
	Initialize the InnoDB storage engine plugin. More...
static int	innodb_deinit (MYSQL_PLUGIN plugin_info)
	De initialize the InnoDB storage engine plugin. More...
static bool	dd_create_hardcoded (space_id_t space_id, const char *filename)
	Create a hard-coded tablespace file at server initialization. More...
static bool	dd_open_hardcoded (space_id_t space_id, const char *filename)
	Open a hard-coded tablespace file at server initialization. More...
void	innobase_commit_low (trx_t *trx)
	Commits a transaction in an InnoDB database. More...
static int	innobase_rollback_trx (trx_t *trx)
	Rolls back a transaction. More...
static uint32_t	get_zip_shift_size (ulint key_block_size)
	** InnoDB database tables More...
static void	test_normalize_table_name ()
static void	test_ut_format_name ()
bool	innobase_match_index_columns (const KEY *key_info, const dict_index_t *index_info)
	Match index columns between MySQL and InnoDB. More...
static void	innobase_vcol_build_templ (const TABLE *table, const dict_index_t *clust_index, Field *field, const dict_col_t *col, mysql_row_templ_t *templ, ulint col_no)
	Build a template for a base column for a virtual column. More...
void	innobase_build_v_templ_callback (const TABLE *table, void *ib_table)
	Callback used by MySQL server layer to initialize the table virtual columns' template. More...
void	innobase_build_v_templ (const TABLE *table, const dict_table_t *ib_table, dict_vcol_templ_t *s_templ, const dict_add_v_col_t *add_v, bool locked, const char *share_tbl_name)
	Build template for the virtual columns and their base columns. More...
static bool	innobase_build_index_translation (const TABLE *table, dict_table_t *ib_table, INNOBASE_SHARE *share)
	This function builds a translation table in INNOBASE_SHARE structure for fast index location with mysql array number from its table->key_info structure. More...
static dict_index_t *	innobase_index_lookup (INNOBASE_SHARE *share, uint keynr)
	This function uses index translation table to quickly locate the requested index structure. More...
int	innobase_fts_text_cmp (const void *cs, const void *p1, const void *p2)
	Compare two character string according to their charset. More...
int	innobase_fts_nocase_compare (const CHARSET_INFO *cs, const fts_string_t *s1, const fts_string_t *s2)
	Compare two FTS character strings case insensitively according to their charset. More...
int	innobase_nocase_compare (const void *cs, const char *s1, const char *s2)
	Compare two character strings case insensitively according to their charset. More...
ulint	innobase_strnxfrm (const CHARSET_INFO *cs, const uchar *str, const ulint len)
	Get the first character's code position for FTS index partition. More...
int	innobase_fts_text_cmp_prefix (const void *cs, const void *p1, const void *p2)
	Compare two character string according to their charset. More...
size_t	innobase_fts_casedn_str (CHARSET_INFO *cs, char *src, size_t src_len, char *dst, size_t dst_len)
	Makes all characters in a string lower case. More...
bool	true_word_char (int c, uint8_t ch)
ulint	innobase_mysql_fts_get_token (CHARSET_INFO *cs, const byte *start, const byte *end, fts_string_t *token)
	Get the next token from the given string and store it in *token. More...
ulint	get_innobase_type_from_mysql_type (ulint *unsigned_flag, const void *f)
	Converts a MySQL type to an InnoDB type. More...
ulint	get_innobase_type_from_mysql_dd_type (ulint *unsigned_flag, ulint *binary_type, ulint *charset_no, dd::enum_column_types dd_type, const CHARSET_INFO *field_charset, bool is_unsigned)
	Converts a MySQL data-dictionary type to an InnoDB type. More...
static uint	innobase_read_from_2_little_endian (const uchar *buf)
	Reads an unsigned integer value < 64k from 2 bytes, in the little-endian storage format. More...
static const Field *	build_template_needs_field (bool index_contains, bool read_just_key, bool fetch_all_in_key, bool fetch_primary_key_cols, dict_index_t *index, const TABLE *table, ulint i, ulint num_v)
	Determines if a field is needed in a m_prebuilt struct 'template'. More...
bool	build_template_needs_field_in_icp (const dict_index_t *index, const row_prebuilt_t *prebuilt, bool contains, ulint i, bool is_virtual)
	Determines if a field is needed in a m_prebuilt struct 'template'. More...
static mysql_row_templ_t *	build_template_field (row_prebuilt_t *prebuilt, dict_index_t *clust_index, dict_index_t *index, TABLE *table, const Field *field, ulint i, ulint v_no)
	Adds a field to a m_prebuilt struct 'template'. More...
static void	set_templ_icp (mysql_row_templ_t *templ, const dict_index_t *index, const dict_index_t *scan_index, ulint col_position)
	Set Index Condition Push down (ICP) field number in template. More...
static void	innobase_store_multi_value_low (json_binary::Value *bv, multi_value_data **valuep, Field_typed_array *fld, dfield_t *dfield, ulint comp, mem_heap_t *heap)
	Parse out multi-value and store in a multi_value_data struct. More...
static bool	innobase_store_multi_value (json_binary::Value &v, multi_value_data *value, Field_typed_array *fld, dfield_t *dfield, bool comp, mem_heap_t *heap)
	Handle the multi-value array, parse the values and store them. More...
void	innobase_get_multi_value (const TABLE *mysql_table, ulint f_idx, dfield_t *dfield, multi_value_data *value, uint old_val, ulint comp, mem_heap_t *heap)
	Parse out multi-values from a MySQL record. More...
static byte *	innodb_fill_old_vcol_val (row_prebuilt_t *prebuilt, dfield_t *vfield, ulint o_len, const byte *old_mysql_row_col, ulint col_pack_len, byte *buf)
	Fill the update vector's "old_vrow" field for those non-updated, but indexed columns. More...
static void	innobase_get_multi_value_and_diff (const TABLE *mysql_table, ulint field_idx, dfield_t *old_field, dfield_t *new_field, uint old_value, ulint comp, mem_heap_t *heap)
	Parse out multi-values from both old and new MySQL records, at the meantime, calculate the difference between two records. More...
static dberr_t	calc_row_difference (upd_t *uvect, const uchar *old_row, uchar *new_row, TABLE *table, uchar *upd_buff, ulint buff_len, row_prebuilt_t *prebuilt, THD *thd)
	Checks which fields have changed in a row and stores information of them to an update vector. More...
page_cur_mode_t	convert_search_mode_to_innobase (ha_rkey_function find_flag)
	Converts a search mode flag understood by MySQL to a flag understood by InnoDB. More...
static void	innobase_fts_create_doc_id_key (dtuple_t *tuple, const dict_index_t *index, doc_id_t *doc_id)
	Set up search tuple for a query through FTS_DOC_ID_INDEX on supplied Doc ID. More...
void	innodb_base_col_setup (dict_table_t *table, const Field *field, dict_v_col_t *v_col)
	Set up base columns for virtual column. More...
void	innodb_base_col_setup_for_stored (const dict_table_t *table, const Field *field, dict_s_col_t *s_col)
	Set up base columns for stored column. More...
template<typename Index >
const dd::Index *	get_my_dd_index (const Index *index)
template<>
const dd::Index *	get_my_dd_index< dd::Index > (const dd::Index *dd_index)
template<>
const dd::Index *	get_my_dd_index< dd::Partition_index > (const dd::Partition_index *dd_index)
int	create_index (trx_t *trx, const TABLE *form, uint32_t flags, const char *table_name, uint key_num, const dd::Table *dd_table)
	Creates an index in an InnoDB database. More...
int	create_clustered_index_when_no_primary (trx_t *trx, uint32_t flags, const char *table_name)
	Creates an index to an InnoDB table when the user has defined no primary index. More...
static int	validate_tablespace_name (ts_command_type ts_command, const char *name)
	Validate the tablespace name provided for a tablespace DDL. More...
bool	innobase_fts_load_stopword (dict_table_t *table, trx_t *trx, THD *thd)
	Initialize the table FTS stopword list. More...
static ulint	innobase_parse_merge_threshold (THD *thd, const char *str)
	Parse MERGE_THRESHOLD value from the string. More...
void	innobase_parse_hint_from_comment (THD *thd, dict_table_t *table, const TABLE_SHARE *table_share)
	Parse hint for table and its indexes, and update the information in dictionary. More...
static bool	innobase_is_base_s_col (const TABLE *table, const char *name)
	Check a column (name) is a base column for any stored column in the table. More...
static dberr_t	innobase_check_fk_base_col (const dd::Table *dd_table, const TABLE *table)
	Check any cascading foreign key columns are base columns for any stored columns in the table. More...
template int	create_table_info_t::create_table_update_global_dd< dd::Table > (dd::Table *)
template int	create_table_info_t::create_table_update_global_dd< dd::Partition > (dd::Partition *)
template int	innobase_basic_ddl::create_impl< dd::Table > (THD *, const char *, TABLE *, HA_CREATE_INFO *, dd::Table *, bool, bool, bool, uint32_t, uint32_t, const dd::Table *)
template int	innobase_basic_ddl::create_impl< dd::Partition > (THD *, const char *, TABLE *, HA_CREATE_INFO *, dd::Partition *, bool, bool, bool, uint32_t, uint32_t, const dd::Table *)
template int	innobase_basic_ddl::delete_impl< dd::Table > (THD *, const char *, const dd::Table *, const TABLE *)
template int	innobase_basic_ddl::delete_impl< dd::Partition > (THD *, const char *, const dd::Partition *, const TABLE *)
template int	innobase_basic_ddl::rename_impl< dd::Table > (THD *, const char *, const char *, const dd::Table *, const dd::Table *, const TABLE *)
template int	innobase_basic_ddl::rename_impl< dd::Partition > (THD *, const char *, const char *, const dd::Partition *, const dd::Partition *, const TABLE *)
static bool	dd_is_only_column (const dd::Index *index, const dd::Column *column)
	Check if a column is the only column in an index. More...
static int	validate_create_tablespace_info (ib_file_suffix type, st_alter_tablespace *alter_info)
	Validate the parameters in st_alter_tablespace before using them in InnoDB tablespace functions. More...
static int	innodb_create_tablespace (handlerton *hton, THD *thd, st_alter_tablespace *alter_info, dd::Tablespace *dd_space)
	CREATE a tablespace. More...
static int	innobase_alter_autoextend_size_tablespace (handlerton *hton, st_alter_tablespace *alter_info, const dd::Tablespace *old_dd_space)
	Alter AUTOEXTEND_SIZE a tablespace. More...
static int	innobase_alter_encrypt_tablespace (handlerton *hton, THD *thd, st_alter_tablespace *alter_info, const dd::Tablespace *old_dd_space, dd::Tablespace *new_dd_space)
	Alter Encrypt/Unencrypt a tablespace. More...
static int	innodb_alter_tablespace (handlerton *hton, THD *thd, st_alter_tablespace *alter_info, const dd::Tablespace *old_dd_space, dd::Tablespace *new_dd_space)
	ALTER an undo tablespace. More...
static int	innodb_drop_tablespace (handlerton *hton, THD *thd, st_alter_tablespace *alter_info, const dd::Tablespace *dd_space)
	DROP a tablespace. More...
static int	innodb_create_undo_tablespace (handlerton *hton, THD *thd, st_alter_tablespace *alter_info, dd::Tablespace *dd_space)
	CREATE an undo tablespace. More...
static int	innodb_alter_undo_tablespace_active (undo::Tablespace *undo_space, dd::String_type dd_state, dd::Tablespace *dd_space)
	ALTER an undo tablespace to ACTIVE. More...
static int	innodb_alter_undo_tablespace_inactive (undo::Tablespace *undo_space, dd::String_type dd_state, dd::Tablespace *dd_space)
	ALTER an undo tablespace to INACTIVE. More...
static int	innodb_alter_undo_tablespace (handlerton *hton, st_alter_tablespace *alter_info, dd::Tablespace *dd_space)
	ALTER an undo tablespace. More...
static int	innodb_drop_undo_tablespace (handlerton *hton, THD *thd, st_alter_tablespace *alter_info, const dd::Tablespace *dd_space)
	DROP an undo tablespace. More...
void	innodb_set_buf_pool_size (long long buf_pool_size)
	Update the system variable with the given value of the InnoDB buffer pool size. More...
static int	innobase_get_mysql_key_number_for_index (INNOBASE_SHARE *share, const TABLE *table, dict_table_t *ib_table, const dict_index_t *index)
	Calculates the key number used inside MySQL for an Innobase index. More...
rec_per_key_t	innodb_rec_per_key (const dict_index_t *index, ulint i, ha_rows records)
	Calculate Record Per Key value. More...
static ulonglong	innobase_peek_autoinc (dict_table_t *innodb_table, bool print_note)
	Read the auto_increment counter of a table, using the AUTOINC lock irrespective of innodb_autoinc_lock_mode. More...
static void	calculate_delete_length_stat (const dict_table_t *ib_table, ha_statistics *stats, THD *thd)
	Calculate delete length statistic. More...
static void	calculate_index_size_stats (const dict_table_t *ib_table, uint64_t n_rows, ulint stat_clustered_index_size, ulint stat_sum_of_other_index_sizes, ha_statistics *stats)
	Calculate stats based on index size. More...
double	index_pct_cached (const dict_index_t *index)
	Estimate what percentage of an index's pages are cached in the buffer pool. More...
static uint64_t	innodb_get_auto_increment_for_uncached (dd::Object_id se_private_id, const dd::Properties &tbl_se_private_data)
	Get the autoincrement for the given table id which is not in the cache. More...
static bool	innodb_get_table_statistics_for_uncached (const char *db_name, const char *tbl_name, const char *norm_name, dd::Object_id se_private_id, const dd::Properties &ts_se_private_data, const dd::Properties &tbl_se_private_data, ulint stat_flags, ha_statistics *stats)
	Retrieves table statistics only for uncache table only. More...
trx_t::isolation_level_t	innobase_trx_map_isolation_level (enum_tx_isolation iso)
	Maps a MySQL trx isolation level code to the InnoDB isolation level code. More...
static void	innodb_export_status ()
	Here we export InnoDB status variables to MySQL. More...
static int	innodb_show_mutex_status (handlerton *hton, THD *thd, stat_print_fn *stat_print)
	Implements the SHOW MUTEX STATUS command, for mutexes. More...
static int	innodb_show_rwlock_status (handlerton *hton, THD *thd, stat_print_fn *stat_print)
	Implements the SHOW MUTEX STATUS command. More...
static int	innodb_show_latch_status (handlerton *hton, THD *thd, stat_print_fn *stat_print)
	Implements the SHOW MUTEX STATUS command. More...
ulint	innobase_get_at_most_n_mbchars (ulint charset_id, ulint prefix_len, ulint data_len, const char *str)
	This function is used to find the storage length in bytes of the first n characters for prefix indexes using a multibyte character set. More...
static void	innodb_io_capacity_max_update (THD *thd, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_io_capacity_max using the "saved" value. More...
static void	innodb_io_capacity_update (THD *thd, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_io_capacity using the "saved" value. More...
static void	innodb_max_dirty_pages_pct_update (THD *thd, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_max_dirty_pages_pct using the "saved" value. More...
static void	innodb_max_dirty_pages_pct_lwm_update (THD *thd, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_max_dirty_pages_pct_lwm using the "saved" value. More...
static int	check_func_bool (THD *, SYS_VAR *, void *save, st_mysql_value *value)
	Utility method that checks if user provided valid value. More...
static int	check_session_admin (THD *thd)
	Utility method that checks if user has correct session administrative dynamic privileges. More...
static void	innodb_srv_buffer_pool_in_core_file_update (THD *, SYS_VAR *, void *, const void *save)
static bool	innodb_buffer_pool_size_validate (THD *thd, longlong buffer_pool_size, ulint &aligned_buffer_pool_size)
	Validate the requested buffer pool size. More...
static void	innodb_extend_and_initialize_update (THD *thd, SYS_VAR *, void *var_ptr, const void *save)
	Set the variable tbsp_extend_and_initialize. More...
static void	innodb_buffer_pool_size_update (THD *thd, SYS_VAR *, void *var_ptr, const void *save)
	Update the system variable innodb_buffer_pool_size using the "saved" value. More...
static void	innobase_deadlock_detect_update (THD *, SYS_VAR *, void *, const void *save)
	Update the system variable innobase_deadlock_detect using the "saved" value. More...
static int	innodb_internal_table_validate (THD *thd, SYS_VAR *, void *save, struct st_mysql_value *value)
	Check whether valid argument given to "innodb_fts_internal_tbl_name" This function is registered as a callback with MySQL. More...
static void	innodb_adaptive_hash_index_update (THD *, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_adaptive_hash_index using the "saved" value. More...
static void	innodb_cmp_per_index_update (THD *, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_cmp_per_index using the "saved" value. More...
static void	innodb_old_blocks_pct_update (THD *, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_old_blocks_pct using the "saved" value. More...
static void	innodb_change_buffer_max_size_update (THD *, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_old_blocks_pct using the "saved" value. More...
static void	innodb_save_page_no (THD *, SYS_VAR *, void *, const void *save)
	Save an InnoDB page number. More...
static void	innodb_make_page_dirty (THD *, SYS_VAR *, void *, const void *save)
	Make the first page of given user tablespace dirty. More...
static void	innodb_monitor_set_option (const monitor_info_t *monitor_info, mon_option_t set_option)
	Update the monitor counter according to the "set_option", turn on/off or reset specified monitor counter. More...
static void	innodb_monitor_update_wildcard (const char *name, mon_option_t set_option)
	Find matching InnoDB monitor counters and update their status according to the "set_option", turn on/off or reset specified monitor counter. More...
static ulint	innodb_monitor_id_by_name_get (const char *name)
	Given a configuration variable name, find corresponding monitor counter and return its monitor ID if found. More...
static bool	innodb_monitor_validate_wildcard_name (const char *name)
	Validate that the passed in monitor name matches at least one monitor counter name with wildcard compare. More...
static int	innodb_monitor_valid_byname (void *save, const char *name)
	Validate the passed in monitor name, find and save the corresponding monitor name in the function parameter "save". More...
static int	innodb_monitor_validate (THD *, SYS_VAR *, void *save, struct st_mysql_value *value)
	Validate passed-in "value" is a valid monitor counter name. More...
static void	innodb_monitor_update (THD *thd, void *var_ptr, const void *save, mon_option_t set_option, bool free_mem)
	Update the system variable innodb_enable(disable/reset/reset_all)_monitor according to the "set_option" and turn on/off or reset specified monitor counter. More...
static int	innodb_srv_buf_dump_filename_validate (THD *thd, SYS_VAR *, void *save, struct st_mysql_value *value)
	Validate if passed-in "value" is a valid value for innodb_buffer_pool_filename. More...
static bool	innodb_buffer_pool_evict_uncompressed (void)
	Evict all uncompressed pages of compressed tables from the buffer pool. More...
static void	innodb_buffer_pool_evict_update (THD *, SYS_VAR *, void *, const void *save)
	Called on SET GLOBAL innodb_buffer_pool_evict=... Handles some values specially, to evict pages from the buffer pool. More...
static void	innodb_enable_monitor_update (THD *thd, SYS_VAR *, void *var_ptr, const void *save)
	Update the system variable innodb_monitor_enable and enable specified monitor counter. More...
static void	innodb_disable_monitor_update (THD *thd, SYS_VAR *, void *var_ptr, const void *save)
	Update the system variable innodb_monitor_disable and turn off specified monitor counter. More...
static void	innodb_reset_monitor_update (THD *thd, SYS_VAR *, void *var_ptr, const void *save)
	Update the system variable innodb_monitor_reset and reset specified monitor counter(s). More...
static void	innodb_reset_all_monitor_update (THD *thd, SYS_VAR *, void *var_ptr, const void *save)
	Update the system variable innodb_monitor_reset_all and reset all value related monitor counter. More...
static void	innodb_undo_tablespaces_update (THD *thd, SYS_VAR *var, void *var_ptr, const void *save)
	Validate the value of innodb_undo_tablespaces global variable. More...
static int	validate_innodb_undo_log_encrypt (THD *thd, SYS_VAR *var, void *save, struct st_mysql_value *value)
	Validate the value of innodb_undo_log_encrypt global variable. More...
static int	validate_innodb_redo_log_encrypt (THD *thd, SYS_VAR *var, void *save, struct st_mysql_value *value)
	Validate the value of innodb_redo_log_encrypt global variable. More...
static void	innodb_rollback_segments_update (THD *, SYS_VAR *, void *, const void *save)
	Update the number of rollback segments per tablespace when the system variable innodb_rollback_segments is changed. More...
static int	show_innodb_vars (THD *, SHOW_VAR *var, char *)
	Callback function for accessing the InnoDB variables from MySQL: SHOW VARIABLES. More...
bool	innobase_index_name_is_reserved (THD *thd, const KEY *key_info, ulint num_of_keys)
	This function checks each index name for a table against reserved system default primary index name 'GEN_CLUST_INDEX'. More...
static void	wait_background_drop_list_empty (THD *, SYS_VAR *, void *, const void *)
	Wait for the background drop list to become empty. More...
static void	purge_run_now_set (THD *, SYS_VAR *, void *, const void *save)
	Set the purge state to RUN. More...
static void	purge_stop_now_set (THD *, SYS_VAR *, void *, const void *save)
	Set the purge state to STOP. More...
static void	log_flush_now_set (THD *, SYS_VAR *, void *, const void *save)
	Force InnoDB to flush redo log up to current_lsn. More...
static void	checkpoint_now_set (THD *, SYS_VAR *, void *, const void *save)
	Force InnoDB to do sharp checkpoint. More...
static void	checkpoint_fuzzy_now_set (THD *, SYS_VAR *, void *, const void *save)
	Force InnoDB to do fuzzy checkpoint. More...
static void	checkpoint_disabled_update (THD *, SYS_VAR *, void *, const void *save)
	Updates srv_checkpoint_disabled - allowing or disallowing checkpoints. More...
static void	buf_flush_list_now_set (THD *, SYS_VAR *, void *, const void *save)
	Force a dirty pages flush now. More...
static void	innodb_merge_threshold_set_all_debug_update (THD *, SYS_VAR *, void *, const void *save)
	Override current MERGE_THRESHOLD setting for all indexes at dictionary now. More...
static void	buffer_pool_dump_now (THD *, SYS_VAR *, void *, const void *save)
	Trigger a dump of the buffer pool if innodb_buffer_pool_dump_now is set to ON. More...
static void	buffer_pool_load_now (THD *, SYS_VAR *, void *, const void *save)
	Trigger a load of the buffer pool if innodb_buffer_pool_load_now is set to ON. More...
static void	buffer_pool_load_abort (THD *, SYS_VAR *, void *, const void *save)
	Abort a load of the buffer pool if innodb_buffer_pool_load_abort is set to ON. More...
static void	innodb_log_write_ahead_size_update (THD *thd, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_log_write_ahead_size using the "saved" value. More...
static void	innodb_log_buffer_size_update (THD *, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_log_buffer_size using the "saved" value. More...
static void	innodb_log_writer_threads_update (THD *, SYS_VAR *, void *var_ptr, const void *save)
	Update the innodb_log_writer_threads parameter. More...
static void	innodb_redo_log_capacity_update (THD *thd, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_redo_log_capacity using the "saved" value. More...
static void	innodb_thread_concurrency_update (THD *thd, SYS_VAR *, void *, const void *save)
	Update the system variable innodb_thread_concurrency using the "saved" value. More...
static void	innodb_log_checksums_update (THD *, SYS_VAR *, void *var_ptr, const void *save)
	Update the innodb_log_checksums parameter. More...
static	MYSQL_SYSVAR_ENUM (checksum_algorithm, srv_checksum_algorithm, PLUGIN_VAR_RQCMDARG, "The algorithm InnoDB uses for page checksumming. Possible values are" " CRC32 (hardware accelerated if the CPU supports it)" " write crc32, allow any of the other checksums to match when reading;" " STRICT_CRC32" " write crc32, do not allow other algorithms to match when reading;" " INNODB" " write a software calculated checksum, allow any other checksums" " to match when reading;" " STRICT_INNODB" " write a software calculated checksum, do not allow other algorithms" " to match when reading;" " NONE" " write a constant magic number, do not do any checksum verification" " when reading;" " STRICT_NONE" " write a constant magic number, do not allow values other than that" " magic number when reading;" " Files updated when this option is set to crc32 or strict_crc32 will" " not be readable by MySQL versions older than 5.6.3", nullptr, nullptr, SRV_CHECKSUM_ALGORITHM_CRC32, &innodb_checksum_algorithm_typelib)
static	MYSQL_SYSVAR_BOOL (log_checksums, srv_log_checksums, PLUGIN_VAR_RQCMDARG, "Whether to compute and require checksums for InnoDB redo log blocks", nullptr, innodb_log_checksums_update, true)
static	MYSQL_SYSVAR_STR (data_home_dir, innobase_data_home_dir, PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "The common part for InnoDB table spaces.", nullptr, nullptr, nullptr)
static	MYSQL_SYSVAR_BOOL (stats_include_delete_marked, srv_stats_include_delete_marked, PLUGIN_VAR_OPCMDARG, "Include delete marked records when calculating persistent statistics", nullptr, nullptr, false)
static	MYSQL_SYSVAR_ULONG (io_capacity, srv_io_capacity, PLUGIN_VAR_RQCMDARG, "Number of IOPs the server can do. Tunes the background IO rate", nullptr, innodb_io_capacity_update, 10000, 100, ~0UL, 0)
static	MYSQL_SYSVAR_ULONG (io_capacity_max, srv_max_io_capacity, PLUGIN_VAR_RQCMDARG, "Limit to which innodb_io_capacity can be inflated.", nullptr, innodb_io_capacity_max_update, SRV_MAX_IO_CAPACITY_DUMMY_DEFAULT, 100, SRV_MAX_IO_CAPACITY_LIMIT, 0)
static	MYSQL_SYSVAR_BOOL (background_drop_list_empty, innodb_background_drop_list_empty, PLUGIN_VAR_OPCMDARG, "Wait for the background drop list to become empty", nullptr, wait_background_drop_list_empty, false)
static	MYSQL_SYSVAR_BOOL (purge_run_now, innodb_purge_run_now, PLUGIN_VAR_OPCMDARG, "Set purge state to RUN", nullptr, purge_run_now_set, false)
static	MYSQL_SYSVAR_BOOL (purge_stop_now, innodb_purge_stop_now, PLUGIN_VAR_OPCMDARG, "Set purge state to STOP", nullptr, purge_stop_now_set, false)
static	MYSQL_SYSVAR_BOOL (log_flush_now, innodb_log_flush_now, PLUGIN_VAR_OPCMDARG, "Force flush of redo up to current lsn", nullptr, log_flush_now_set, false)
static	MYSQL_SYSVAR_BOOL (log_checkpoint_now, innodb_log_checkpoint_now, PLUGIN_VAR_OPCMDARG, "Force sharp checkpoint now", nullptr, checkpoint_now_set, false)
static	MYSQL_SYSVAR_BOOL (log_checkpoint_fuzzy_now, innodb_log_checkpoint_fuzzy_now, PLUGIN_VAR_OPCMDARG, "Force fuzzy checkpoint now", nullptr, checkpoint_fuzzy_now_set, false)
static	MYSQL_SYSVAR_BOOL (checkpoint_disabled, srv_checkpoint_disabled, PLUGIN_VAR_OPCMDARG, "Disable checkpoints", nullptr, checkpoint_disabled_update, false)
static	MYSQL_SYSVAR_BOOL (buf_flush_list_now, innodb_buf_flush_list_now, PLUGIN_VAR_OPCMDARG, "Force dirty page flush now", nullptr, buf_flush_list_now_set, false)
static	MYSQL_SYSVAR_UINT (merge_threshold_set_all_debug, innodb_merge_threshold_set_all_debug, PLUGIN_VAR_RQCMDARG, "Override current MERGE_THRESHOLD setting for all indexes at dictionary" " cache by the specified value dynamically, at the time.", nullptr, innodb_merge_threshold_set_all_debug_update, DICT_INDEX_MERGE_THRESHOLD_DEFAULT, 1, 50, 0)
static	MYSQL_SYSVAR_ULONG (semaphore_wait_timeout_debug, srv_fatal_semaphore_wait_threshold, PLUGIN_VAR_RQCMDARG, "Number of seconds that a semaphore can be held. If semaphore wait crosses" "this value, server will crash", nullptr, nullptr, 600, 25, 600, 0)
static	MYSQL_SYSVAR_ULONG (purge_batch_size, srv_purge_batch_size, PLUGIN_VAR_OPCMDARG, "Number of UNDO log pages to purge in one batch from the history list.", nullptr, nullptr, 300, 1, 5000, 0)
static	MYSQL_SYSVAR_ULONG (purge_threads, srv_n_purge_threads, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY, "Purge threads can be from 1 to 32. Default is 1 if number of available " "CPUs is 16 or less, 4 otherwise.", nullptr, nullptr,(std::thread::hardware_concurrency()<=16 ? 1UL :4UL), 1, MAX_PURGE_THREADS, 0)
static	MYSQL_SYSVAR_ULONG (sync_array_size, srv_sync_array_size, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY, "Size of the mutex/lock wait array.", nullptr, nullptr, 1, 1, 1024, 0)
static	MYSQL_SYSVAR_ULONG (fast_shutdown, srv_fast_shutdown, PLUGIN_VAR_OPCMDARG, "Speeds up the shutdown process of the InnoDB storage engine. Possible" " values are 0, 1 (faster) or 2 (fastest - crash-like).", nullptr, nullptr, 1, 0, 2, 0)
static	MYSQL_SYSVAR_BOOL (file_per_table, srv_file_per_table, PLUGIN_VAR_NOCMDARG, "Stores each InnoDB table to an .ibd file in the database dir.", nullptr, nullptr, true)
static	MYSQL_SYSVAR_STR (ft_server_stopword_table, innobase_server_stopword_table, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_MEMALLOC, "The user supplied stopword table name.", innodb_stopword_table_validate, nullptr, nullptr)
static	MYSQL_SYSVAR_UINT (flush_log_at_timeout, srv_flush_log_at_timeout, PLUGIN_VAR_OPCMDARG, "Write and flush logs every (n) second.", nullptr, nullptr, 1, 0, 2700, 0)
static	MYSQL_SYSVAR_ULONG (flush_log_at_trx_commit, srv_flush_log_at_trx_commit, PLUGIN_VAR_OPCMDARG, "Set to 0 (write and flush once per second)," " 1 (write and flush at each commit)," " or 2 (write at commit, flush once per second).", nullptr, nullptr, 1, 0, 2, 0)
static	MYSQL_SYSVAR_ENUM (flush_method, innodb_flush_method, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "With which method to flush data", nullptr, nullptr, 0, &innodb_flush_method_typelib)
static	MYSQL_SYSVAR_BOOL (force_load_corrupted, srv_load_corrupted, PLUGIN_VAR_NOCMDARG|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "Force InnoDB to load metadata of corrupted table.", nullptr, nullptr, false)
static	MYSQL_SYSVAR_STR (log_group_home_dir, srv_log_group_home_dir, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "Path to InnoDB log files.", nullptr, nullptr, nullptr)
static	MYSQL_SYSVAR_ULONG (page_cleaners, srv_n_page_cleaners, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY, "Page cleaner threads can be from 1 to 64. Default " "is number of buffer pool instances.", nullptr, nullptr, 1, 1, 64, 0)
static	MYSQL_SYSVAR_DOUBLE (max_dirty_pages_pct, srv_max_buf_pool_modified_pct, PLUGIN_VAR_RQCMDARG, "Percentage of dirty pages allowed in bufferpool.", nullptr, innodb_max_dirty_pages_pct_update, 90.0, 0, 99.999, 0)
static	MYSQL_SYSVAR_DOUBLE (max_dirty_pages_pct_lwm, srv_max_dirty_pages_pct_lwm, PLUGIN_VAR_RQCMDARG, "Percentage of dirty pages at which flushing kicks in.", nullptr, innodb_max_dirty_pages_pct_lwm_update, 10, 0, 99.999, 0)
static	MYSQL_SYSVAR_ULONG (adaptive_flushing_lwm, srv_adaptive_flushing_lwm, PLUGIN_VAR_RQCMDARG, "Percentage of log capacity below which no adaptive flushing happens.", nullptr, nullptr, 10, 0, 70, 0)
static	MYSQL_SYSVAR_BOOL (adaptive_flushing, srv_adaptive_flushing, PLUGIN_VAR_NOCMDARG, "Attempt flushing dirty pages to avoid IO bursts at checkpoints.", nullptr, nullptr, true)
static	MYSQL_SYSVAR_BOOL (flush_sync, srv_flush_sync, PLUGIN_VAR_NOCMDARG, "Allow IO bursts at the checkpoints ignoring io_capacity setting.", nullptr, nullptr, true)
static	MYSQL_SYSVAR_ULONG (flushing_avg_loops, srv_flushing_avg_loops, PLUGIN_VAR_RQCMDARG, "Number of iterations over which the background flushing is averaged.", nullptr, nullptr, 30, 1, 1000, 0)
static	MYSQL_SYSVAR_ULONG (max_purge_lag, srv_max_purge_lag, PLUGIN_VAR_RQCMDARG, "Desired maximum length of the purge queue (0 = no limit)", nullptr, nullptr, 0, 0, ~0UL, 0)
static	MYSQL_SYSVAR_ULONG (max_purge_lag_delay, srv_max_purge_lag_delay, PLUGIN_VAR_RQCMDARG, "Maximum delay of user threads in micro-seconds", nullptr, nullptr, 0L, 0L, 10000000UL, 0)
static	MYSQL_SYSVAR_BOOL (rollback_on_timeout, innobase_rollback_on_timeout, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY, "Roll back the complete transaction on lock wait " "timeout, for 4.x compatibility (disabled by default)", nullptr, nullptr, false)
static	MYSQL_SYSVAR_BOOL (status_file, innobase_create_status_file, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_NOSYSVAR, "Enable SHOW ENGINE INNODB STATUS output in the innodb_status.<pid> file", nullptr, nullptr, false)
static	MYSQL_SYSVAR_BOOL (stats_on_metadata, innobase_stats_on_metadata, PLUGIN_VAR_OPCMDARG, "Enable statistics gathering for metadata commands such as" " SHOW TABLE STATUS for tables that use transient statistics (off by " "default)", nullptr, nullptr, false)
static	MYSQL_SYSVAR_ULONGLONG (stats_transient_sample_pages, srv_stats_transient_sample_pages, PLUGIN_VAR_RQCMDARG, "The number of leaf index pages to sample when calculating transient" " statistics (if persistent statistics are not used, default 8)", nullptr, nullptr, 8, 1, ~0ULL, 0)
static	MYSQL_SYSVAR_BOOL (stats_persistent, srv_stats_persistent, PLUGIN_VAR_OPCMDARG, "InnoDB persistent statistics enabled for all tables unless overridden" " at table level", nullptr, nullptr, true)
static	MYSQL_SYSVAR_BOOL (stats_auto_recalc, srv_stats_auto_recalc, PLUGIN_VAR_OPCMDARG, "InnoDB automatic recalculation of persistent statistics enabled for all" " tables unless overridden at table level (automatic recalculation is only" " done when InnoDB decides that the table has changed too much and needs a" " new statistics)", nullptr, nullptr, true)
static	MYSQL_SYSVAR_ULONGLONG (stats_persistent_sample_pages, srv_stats_persistent_sample_pages, PLUGIN_VAR_RQCMDARG, "The number of leaf index pages to sample when calculating persistent" " statistics (by ANALYZE, default 20)", nullptr, nullptr, 20, 1, ~0ULL, 0)
static	MYSQL_SYSVAR_BOOL (adaptive_hash_index, srv_btr_search_enabled, PLUGIN_VAR_OPCMDARG, "Enable InnoDB adaptive hash index (enabled by default). " " Disable with --skip-innodb-adaptive-hash-index.", nullptr, innodb_adaptive_hash_index_update, false)
static	MYSQL_SYSVAR_ULONG (adaptive_hash_index_parts, btr_ahi_parts, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY, "Number of InnoDB Adaptive Hash Index Partitions. (default = 8). ", nullptr, nullptr, 8, 1, 512, 0)
	Number of distinct partitions of AHI. More...
static	MYSQL_SYSVAR_ULONG (replication_delay, srv_replication_delay, PLUGIN_VAR_RQCMDARG, "Replication thread delay (ms) on the slave server if" " innodb_thread_concurrency is reached (0 by default)", nullptr, nullptr, 0, 0, ~0UL, 0)
static	MYSQL_SYSVAR_UINT (compression_level, page_zip_level, PLUGIN_VAR_RQCMDARG, "Compression level used for compressed row format. 0 is no compression" ", 1 is fastest, 9 is best compression and default is 6.", nullptr, nullptr, DEFAULT_COMPRESSION_LEVEL, 0, 9, 0)
static	MYSQL_SYSVAR_BOOL (log_compressed_pages, page_zip_log_pages, PLUGIN_VAR_OPCMDARG, "Enables/disables the logging of entire compressed page images." " InnoDB logs the compressed pages to prevent corruption if" " the zlib compression algorithm changes." " When turned OFF, InnoDB will assume that the zlib" " compression algorithm doesn't change.", nullptr, nullptr, true)
static	MYSQL_SYSVAR_ULONG (autoextend_increment, sys_tablespace_auto_extend_increment, PLUGIN_VAR_RQCMDARG, "Data file autoextend increment in megabytes", nullptr, nullptr, 64L, 1L, 1000L, 0)
static	MYSQL_SYSVAR_BOOL (dedicated_server, srv_dedicated_server, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_NOPERSIST|PLUGIN_VAR_READONLY, "Automatically scale innodb_buffer_pool_size and innodb_redo_log_capacity " "based on system memory.", nullptr, nullptr, false)
static	MYSQL_SYSVAR_DOUBLE (segment_reserve_factor, fseg_reserve_pct, PLUGIN_VAR_OPCMDARG, "The segment_reserve_factor is the ratio x/y expressed in percentage," " where x is the number of free pages in the segment, and y is the total" " number of pages in the segment. The number of used pages in the segment" " is given by (y-x). The number of free pages in the segment (x) will be" " maintained such that the actual segment_reserve_factor will be >= the" " requested segment_reserve_factor, which is contained in this variable.", nullptr, nullptr, FSEG_RESERVE_PCT_DFLT, FSEG_RESERVE_PCT_MIN, FSEG_RESERVE_PCT_MAX, 0)
static	MYSQL_SYSVAR_LONGLONG (buffer_pool_size, srv_buf_pool_curr_size, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_PERSIST_AS_READ_ONLY, "The size of the memory buffer InnoDB uses to " "cache data and indexes of its tables.", nullptr, innodb_buffer_pool_size_update, static_cast< longlong >(srv_buf_pool_def_size), static_cast< longlong >(srv_buf_pool_min_size), longlong{srv_buf_pool_max_size}, 1024 *1024L)
static	MYSQL_SYSVAR_ULONGLONG (buffer_pool_chunk_size, srv_buf_pool_chunk_unit, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Size of a single memory chunk within each buffer pool instance" " for resizing buffer pool. Online buffer pool resizing happens" " at this granularity.", nullptr, nullptr, 128 *1024 *1024, ulonglong{srv_buf_pool_chunk_unit_min}, ulonglong{srv_buf_pool_chunk_unit_max}, ulonglong{srv_buf_pool_chunk_unit_blk_sz})
static	MYSQL_SYSVAR_ULONG (page_hash_locks, srv_n_page_hash_locks, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY, "Number of rw_locks protecting buffer pool " "page_hash. Rounded up to the next power of 2", nullptr, nullptr, 16, 1, MAX_PAGE_HASH_LOCKS, 0)
static	MYSQL_SYSVAR_BOOL (validate_tablespace_paths, srv_validate_tablespace_paths, PLUGIN_VAR_NOCMDARG|PLUGIN_VAR_READONLY, "Enable validation of tablespace paths against the DD. (enabled by " "default)." " Disable with --skip-innodb-validate-tablespace-paths.", nullptr, nullptr, true)
static	MYSQL_SYSVAR_BOOL (use_fdatasync, srv_use_fdatasync, PLUGIN_VAR_NOCMDARG, "Use fdatasync() instead of the default fsync().", nullptr, nullptr, true)
static	MYSQL_SYSVAR_ENUM (doublewrite, dblwr::g_mode, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_NOPERSIST, "Enable InnoDB doublewrite buffer (enabled by default)." " Disable with --skip-innodb-doublewrite.", nullptr, doublewrite_update, dblwr::Mode::ON, &innodb_doublewrite_typelib)
static	MYSQL_SYSVAR_BOOL (extend_and_initialize, tbsp_extend_and_initialize, PLUGIN_VAR_NOCMDARG, "Initialize the allocated space by writing zeros (enabled by default).", nullptr, innodb_extend_and_initialize_update, true)
static	MYSQL_SYSVAR_STR (doublewrite_dir, innobase_doublewrite_dir, PLUGIN_VAR_READONLY, "Use a separate directory for the doublewrite buffer files, ", nullptr, nullptr, nullptr)
static	MYSQL_SYSVAR_ULONG (doublewrite_pages, dblwr::n_pages, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Number of double write pages per thread", nullptr, nullptr, 128, 1, 512, 0)
static	MYSQL_SYSVAR_ULONG (doublewrite_files, dblwr::n_files, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Number of double write files", nullptr, nullptr, 2, 1, 256, 0)
static	MYSQL_SYSVAR_ULONG (doublewrite_batch_size, dblwr::batch_size, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Number of double write pages to write in a batch", nullptr, nullptr, 0, 0, 256, 0)
static	MYSQL_SYSVAR_ULONG (buffer_pool_instances, srv_buf_pool_instances, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Number of buffer pool instances, set to higher " "value on high-end machines to increase scalability", nullptr, nullptr, srv_buf_pool_instances_default, 0, MAX_BUFFER_POOLS, 0)
static	MYSQL_SYSVAR_STR (buffer_pool_filename, srv_buf_dump_filename, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_MEMALLOC, "Filename to/from which to dump/load the InnoDB buffer pool", innodb_srv_buf_dump_filename_validate, nullptr, SRV_BUF_DUMP_FILENAME_DEFAULT)
static	MYSQL_SYSVAR_BOOL (buffer_pool_dump_now, innodb_buffer_pool_dump_now, PLUGIN_VAR_RQCMDARG, "Trigger an immediate dump of the buffer pool into a " "file named @@innodb_buffer_pool_filename", nullptr, buffer_pool_dump_now, false)
static	MYSQL_SYSVAR_BOOL (buffer_pool_dump_at_shutdown, srv_buffer_pool_dump_at_shutdown, PLUGIN_VAR_RQCMDARG, "Dump the buffer pool into a file named @@innodb_buffer_pool_filename", nullptr, nullptr, true)
static	MYSQL_SYSVAR_BOOL (buffer_pool_in_core_file, srv_buffer_pool_in_core_file, PLUGIN_VAR_NOCMDARG, "This option has no effect if @@core_file is OFF. " "If @@core_file is ON, and this option is OFF, then the core dump file will" " be generated only if it is possible to exclude buffer pool from it. " "As soon as it will be determined that such exclusion is impossible a " "warning will be emitted and @@core_file will be set to OFF to prevent " "generating a core dump. If this option is enabled then core dumping logic " "will not be affected. This option is disabled by default if the platforms " "supports MADV_DONTDUMP, otherwise it is enabled by default.", nullptr, innodb_srv_buffer_pool_in_core_file_update, BP_IN_CORE_DEFAULT)
static	MYSQL_SYSVAR_ULONG (buffer_pool_dump_pct, srv_buf_pool_dump_pct, PLUGIN_VAR_RQCMDARG, "Dump only the hottest N% of each buffer pool, defaults to 25", nullptr, nullptr, 25, 1, 100, 0)
static	MYSQL_SYSVAR_ULONG (idle_flush_pct, srv_idle_flush_pct, PLUGIN_VAR_RQCMDARG, "Up to what percentage of dirty pages to be flushed when server is found" " idle.", nullptr, nullptr, srv_idle_flush_pct_default, 0, 100, 0)
static	MYSQL_SYSVAR_STR (buffer_pool_evict, srv_buffer_pool_evict, PLUGIN_VAR_RQCMDARG, "Evict pages from the buffer pool", nullptr, innodb_buffer_pool_evict_update, "")
static	MYSQL_SYSVAR_BOOL (buffer_pool_load_now, innodb_buffer_pool_load_now, PLUGIN_VAR_RQCMDARG, "Trigger an immediate load of the buffer pool from a " "file named @@innodb_buffer_pool_filename", nullptr, buffer_pool_load_now, false)
static	MYSQL_SYSVAR_BOOL (buffer_pool_load_abort, innodb_buffer_pool_load_abort, PLUGIN_VAR_RQCMDARG, "Abort a currently running load of the buffer pool", nullptr, buffer_pool_load_abort, false)
static	MYSQL_SYSVAR_BOOL (buffer_pool_load_at_startup, srv_buffer_pool_load_at_startup, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "Load the buffer pool from a file named @@innodb_buffer_pool_filename", nullptr, nullptr, true)
static	MYSQL_SYSVAR_ULONG (lru_scan_depth, srv_LRU_scan_depth, PLUGIN_VAR_RQCMDARG, "How deep to scan LRU to keep it clean", nullptr, nullptr, 1024, 100, ~0UL, 0)
static	MYSQL_SYSVAR_ULONG (flush_neighbors, srv_flush_neighbors, PLUGIN_VAR_OPCMDARG, "Set to 0 (don't flush neighbors from buffer pool)," " 1 (flush contiguous neighbors from buffer pool)" " or 2 (flush neighbors from buffer pool)," " when flushing a block", nullptr, nullptr, 0, 0, 2, 0)
static	MYSQL_SYSVAR_ULONG (commit_concurrency, innobase_commit_concurrency, PLUGIN_VAR_RQCMDARG, "Helps in performance tuning in heavily concurrent environments.", innobase_commit_concurrency_validate, nullptr, 0, 0, 1000, 0)
static	MYSQL_SYSVAR_ULONG (concurrency_tickets, srv_n_free_tickets_to_enter, PLUGIN_VAR_RQCMDARG, "Number of times a thread is allowed to enter InnoDB " "within the same SQL query after it has once got the " "ticket", nullptr, nullptr, 5000L, 1L, UINT_MAX, 0)
static	MYSQL_SYSVAR_BOOL (deadlock_detect, innobase_deadlock_detect, PLUGIN_VAR_NOCMDARG, "Enable/disable InnoDB deadlock detector (default ON)." " if set to OFF, deadlock detection is skipped," " and we rely on innodb_lock_wait_timeout in case of deadlock.", nullptr, innobase_deadlock_detect_update, true)
static	MYSQL_SYSVAR_LONG (fill_factor, ddl::fill_factor, PLUGIN_VAR_RQCMDARG, "Percentage of B-tree page filled during bulk insert", nullptr, nullptr, 100, 10, 100, 0)
static	MYSQL_SYSVAR_BOOL (ft_enable_diag_print, fts_enable_diag_print, PLUGIN_VAR_OPCMDARG, "Whether to enable additional FTS diagnostic printout ", nullptr, nullptr, false)
static	MYSQL_SYSVAR_BOOL (disable_sort_file_cache, srv_disable_sort_file_cache, PLUGIN_VAR_OPCMDARG, "Whether to disable OS system file cache for sort I/O", nullptr, nullptr, false)
static	MYSQL_SYSVAR_STR (ft_aux_table, fts_internal_tbl_name, PLUGIN_VAR_NOCMDARG|PLUGIN_VAR_MEMALLOC, "FTS internal auxiliary table to be checked", innodb_internal_table_validate, nullptr, nullptr)
static	MYSQL_SYSVAR_ULONG (ft_cache_size, fts_max_cache_size, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "InnoDB Fulltext search cache size in bytes", nullptr, nullptr, 8000000, 1600000, 80000000, 0)
static	MYSQL_SYSVAR_ULONG (ft_total_cache_size, fts_max_total_cache_size, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Total memory allocated for InnoDB Fulltext Search cache", nullptr, nullptr, 640000000, 32000000, 1600000000, 0)
static	MYSQL_SYSVAR_ULONG (ft_result_cache_limit, fts_result_cache_limit, PLUGIN_VAR_RQCMDARG, "InnoDB Fulltext search query result cache limit in bytes", nullptr, nullptr, 2000000000L, 1000000L, 4294967295UL, 0)
static	MYSQL_SYSVAR_ULONG (ft_min_token_size, fts_min_token_size, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "InnoDB Fulltext search minimum token size in characters", nullptr, nullptr, 3, 0, 16, 0)
static	MYSQL_SYSVAR_ULONG (ft_max_token_size, fts_max_token_size, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "InnoDB Fulltext search maximum token size in characters", nullptr, nullptr, FTS_MAX_WORD_LEN_IN_CHAR, 10, FTS_MAX_WORD_LEN_IN_CHAR, 0)
static	MYSQL_SYSVAR_ULONG (ft_num_word_optimize, fts_num_word_optimize, PLUGIN_VAR_OPCMDARG, "InnoDB Fulltext search number of words to optimize " "for each optimize table call ", nullptr, nullptr, 2000, 1000, 10000, 0)
static	MYSQL_SYSVAR_ULONG (ft_sort_pll_degree, ddl::fts_parser_threads, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "InnoDB Fulltext search parallel sort degree, will " "round up to nearest power of 2 number", nullptr, nullptr, 2, 1, 16, 0)
static	MYSQL_SYSVAR_ULONG (sort_buffer_size, srv_sort_buf_size, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Memory buffer size for index creation", nullptr, nullptr, 1048576, 65536, 64<< 20, 0)
static	MYSQL_SYSVAR_ULONGLONG (online_alter_log_max_size, srv_online_max_size, PLUGIN_VAR_RQCMDARG, "Maximum modification log file size for online index creation", nullptr, nullptr, 128<< 20, 65536, ~0ULL, 0)
static	MYSQL_SYSVAR_BOOL (optimize_fulltext_only, innodb_optimize_fulltext_only, PLUGIN_VAR_NOCMDARG, "Only optimize the Fulltext index of the table", nullptr, nullptr, false)
static	MYSQL_SYSVAR_ULONG (read_io_threads, srv_n_read_io_threads, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Number of background read I/O threads in InnoDB.", nullptr, nullptr, std::clamp(std::thread::hardware_concurrency()/2, 4U, 64U), 1, 64, 0)
static	MYSQL_SYSVAR_ULONG (write_io_threads, srv_n_write_io_threads, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Number of background write I/O threads in InnoDB.", nullptr, nullptr, 4, 1, 64, 0)
static	MYSQL_SYSVAR_ULONG (force_recovery, srv_force_recovery, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Helps to save your data in case the disk image of " "the database becomes corrupt.", nullptr, nullptr, 0, 0, 6, 0)
static	MYSQL_SYSVAR_ULONG (force_recovery_crash, srv_force_recovery_crash, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Kills the server during crash recovery.", nullptr, nullptr, 0, 0, 100, 0)
static	MYSQL_SYSVAR_ULONG (page_size, srv_page_size, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "Page size to use for all InnoDB tablespaces.", nullptr, nullptr, UNIV_PAGE_SIZE_DEF, UNIV_PAGE_SIZE_MIN, UNIV_PAGE_SIZE_MAX, 0)
static	MYSQL_SYSVAR_ULONG (log_buffer_size, srv_log_buffer_size, PLUGIN_VAR_RQCMDARG, "The size of the buffer which InnoDB uses to write log to the log files" " on disk.", nullptr, innodb_log_buffer_size_update, INNODB_LOG_BUFFER_SIZE_DEFAULT, INNODB_LOG_BUFFER_SIZE_MIN, INNODB_LOG_BUFFER_SIZE_MAX, 1024)
static	MYSQL_SYSVAR_ULONGLONG (log_file_size, srv_log_file_size, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Size of each log file before upgrading to 8.0.30. Deprecated.", nullptr, nullptr, 48 *1024 *1024L, 4 *1024 *1024L, ULLONG_MAX, 1024 *1024L)
static	MYSQL_SYSVAR_ULONG (log_files_in_group, srv_log_n_files, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "Number of log files before upgrading to 8.0.30. Deprecated.", nullptr, nullptr, 2, 2, 100, 0)
static	MYSQL_SYSVAR_ULONGLONG (redo_log_capacity, srv_redo_log_capacity, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_PERSIST_AS_READ_ONLY, "Limitation for total size of redo log files on disk (expressed in bytes).", nullptr, innodb_redo_log_capacity_update, 100 *1024 *1024, LOG_CAPACITY_MIN, LOG_CAPACITY_MAX, MB)
static	MYSQL_SYSVAR_ULONG (log_write_ahead_size, srv_log_write_ahead_size, PLUGIN_VAR_RQCMDARG, "Log write ahead unit size to avoid read-on-write," " it should match the OS cache block IO size.", nullptr, innodb_log_write_ahead_size_update, INNODB_LOG_WRITE_AHEAD_SIZE_DEFAULT, INNODB_LOG_WRITE_AHEAD_SIZE_MIN, INNODB_LOG_WRITE_AHEAD_SIZE_MAX, OS_FILE_LOG_BLOCK_SIZE)
static	MYSQL_SYSVAR_BOOL (log_writer_threads, srv_log_writer_threads, PLUGIN_VAR_RQCMDARG, "Whether the log writer threads should be activated (ON), or write/flush " "of the redo log should be done by each thread individually (OFF).", nullptr, innodb_log_writer_threads_update, true)
static	MYSQL_SYSVAR_UINT (log_spin_cpu_abs_lwm, srv_log_spin_cpu_abs_lwm, PLUGIN_VAR_RQCMDARG, "Minimum value of cpu time for which spin-delay is used." " Expressed in percentage of single cpu core.", nullptr, nullptr, INNODB_LOG_SPIN_CPU_ABS_LWM_DEFAULT, 0, UINT_MAX, 0)
static	MYSQL_SYSVAR_UINT (log_spin_cpu_pct_hwm, srv_log_spin_cpu_pct_hwm, PLUGIN_VAR_RQCMDARG, "Maximum value of cpu time for which spin-delay is used." " Expressed in percentage of all cpu cores.", nullptr, nullptr, INNODB_LOG_SPIN_CPU_PCT_HWM_DEFAULT, 0, 100, 0)
static	MYSQL_SYSVAR_ULONG (log_wait_for_flush_spin_hwm, srv_log_wait_for_flush_spin_hwm, PLUGIN_VAR_RQCMDARG, "Maximum value of average log flush time for which spin-delay is used." " When flushing takes longer, user threads no longer spin when waiting for" "flushed redo. Expressed in microseconds.", nullptr, nullptr, INNODB_LOG_WAIT_FOR_FLUSH_SPIN_HWM_DEFAULT, 0, ULONG_MAX, 0)
static	MYSQL_SYSVAR_UINT (old_blocks_pct, innobase_old_blocks_pct, PLUGIN_VAR_RQCMDARG, "Percentage of the buffer pool to reserve for 'old' blocks.", nullptr, innodb_old_blocks_pct_update, 100 *3/8, 5, 95, 0)
static	MYSQL_SYSVAR_UINT (old_blocks_time, buf_LRU_old_threshold, PLUGIN_VAR_RQCMDARG, "Move blocks to the 'new' end of the buffer pool if the first access" " was at least this many milliseconds ago." " The timeout is disabled if 0.", nullptr, nullptr, 1000, 0, UINT_MAX32, 0)
static	MYSQL_SYSVAR_LONG (open_files, innobase_open_files, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "How many files at the maximum InnoDB keeps open at the same time.", nullptr, nullptr, 0L, 0L, LONG_MAX, 0)
static	MYSQL_SYSVAR_ULONG (sync_spin_loops, srv_n_spin_wait_rounds, PLUGIN_VAR_RQCMDARG, "Count of spin-loop rounds in InnoDB mutexes (30 by default)", nullptr, nullptr, 30L, 0L, ~0UL, 0)
static	MYSQL_SYSVAR_ULONG (spin_wait_delay, srv_spin_wait_delay, PLUGIN_VAR_OPCMDARG, "Maximum delay between polling for a spin lock (6 by default)", nullptr, nullptr, 6L, 0L, 1000, 0)
static	MYSQL_SYSVAR_ULONG (spin_wait_pause_multiplier, ut::spin_wait_pause_multiplier, PLUGIN_VAR_RQCMDARG, "Controls how many times in a row to use a PAUSE " "instruction to achieve one unit of delay in a spin " "lock (see @@innodb_spin_wait_delay), defaults to 50", nullptr, nullptr, 50, 0, 100, 0)
static	MYSQL_SYSVAR_ULONGLONG (fsync_threshold, os_fsync_threshold, PLUGIN_VAR_RQCMDARG, "The value of this variable determines how often InnoDB calls fsync when " "creating a new file. Default is zero which would make InnoDB flush the " "entire file at once before closing it.", nullptr, nullptr, 0, 0, ~0ULL, UNIV_PAGE_SIZE)
static	MYSQL_SYSVAR_ULONG (thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, "Helps in performance tuning in heavily concurrent " "environments. Sets the maximum number of threads " "allowed inside InnoDB. Value 0 will disable the " "thread throttling.", nullptr, innodb_thread_concurrency_update, 0, 0, 1000, 0)
static	MYSQL_SYSVAR_ULONG (adaptive_max_sleep_delay, srv_adaptive_max_sleep_delay, PLUGIN_VAR_RQCMDARG, "The upper limit of the sleep delay in usec. Value of 0 disables it.", nullptr, nullptr, 150000, 0, 1000000, 0)
static	MYSQL_SYSVAR_ULONG (thread_sleep_delay, srv_thread_sleep_delay, PLUGIN_VAR_RQCMDARG, "Time of innodb thread sleeping before joining InnoDB queue (usec)." " Value 0 disable a sleep", nullptr, nullptr, 10000L, 0L, 1000000L, 0)
static	MYSQL_SYSVAR_STR (data_file_path, innobase_data_file_path, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "Path to individual files and their sizes.", nullptr, nullptr,(char *)"ibdata1:12M:autoextend")
static	MYSQL_SYSVAR_STR (temp_data_file_path, innobase_temp_data_file_path, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "Path to files and their sizes making temp-tablespace.", nullptr, nullptr,(char *)"ibtmp1:12M:autoextend")
static	MYSQL_SYSVAR_STR (undo_directory, srv_undo_dir, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "Directory where undo tablespace files live, this path can be absolute.", nullptr, nullptr, nullptr)
static	MYSQL_SYSVAR_STR (temp_tablespaces_dir, ibt::srv_temp_dir, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "Directory where temp tablespace files live, this path can be absolute.", nullptr, nullptr, nullptr)
static	MYSQL_SYSVAR_ULONG (undo_tablespaces, srv_undo_tablespaces, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_NOPERSIST, "Number of undo tablespaces to use. (deprecated)", nullptr, innodb_undo_tablespaces_update, FSP_IMPLICIT_UNDO_TABLESPACES, FSP_MIN_UNDO_TABLESPACES, FSP_MAX_UNDO_TABLESPACES, 0)
static	MYSQL_SYSVAR_ULONGLONG (max_undo_log_size, srv_max_undo_tablespace_size, PLUGIN_VAR_OPCMDARG, "Maximum size of an UNDO tablespace in MB (If an UNDO tablespace grows" " beyond this size it will be truncated in due course). ", nullptr, nullptr, 1024 *1024 *1024L, 10 *1024 *1024L, ~0ULL, 0)
static	MYSQL_SYSVAR_ULONG (purge_rseg_truncate_frequency, srv_purge_rseg_truncate_frequency, PLUGIN_VAR_OPCMDARG, "Dictates rate at which UNDO records are purged. Value N means" " purge rollback segment(s) on every Nth iteration of purge invocation", nullptr, nullptr, 128, 1, 128, 0)
static	MYSQL_SYSVAR_BOOL (undo_log_truncate, srv_undo_log_truncate, PLUGIN_VAR_OPCMDARG, "Enable or Disable Truncate of UNDO tablespace.", nullptr, nullptr, true)
static	MYSQL_SYSVAR_ULONG (rollback_segments, srv_rollback_segments, PLUGIN_VAR_OPCMDARG, "Number of rollback segments per tablespace. This applies to the system" " tablespace, the temporary tablespace & any undo tablespace.", nullptr, innodb_rollback_segments_update, FSP_MAX_ROLLBACK_SEGMENTS, 1, FSP_MAX_ROLLBACK_SEGMENTS, 0)
static	MYSQL_SYSVAR_BOOL (undo_log_encrypt, srv_undo_log_encrypt, PLUGIN_VAR_OPCMDARG, "Enable or disable Encrypt of UNDO tablespace.", validate_innodb_undo_log_encrypt, nullptr, false)
static	MYSQL_SYSVAR_LONG (autoinc_lock_mode, innobase_autoinc_lock_mode, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY, "The AUTOINC lock modes supported by InnoDB:" " 0 => Old style AUTOINC locking (for backward compatibility);" " 1 => New style AUTOINC locking;" " 2 => No AUTOINC locking (unsafe for SBR)", nullptr, nullptr, AUTOINC_NO_LOCKING, AUTOINC_OLD_STYLE_LOCKING, AUTOINC_NO_LOCKING, 0)
static	MYSQL_SYSVAR_STR (version, innodb_version_str, PLUGIN_VAR_NOCMDOPT|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "InnoDB version", nullptr, nullptr, INNODB_VERSION_STR)
static	MYSQL_SYSVAR_BOOL (use_native_aio, srv_use_native_aio, PLUGIN_VAR_NOCMDARG|PLUGIN_VAR_READONLY, "Use native AIO if supported on this platform.", nullptr, nullptr, true)
static	MYSQL_SYSVAR_BOOL (numa_interleave, srv_numa_interleave, PLUGIN_VAR_NOCMDARG|PLUGIN_VAR_READONLY, "Use NUMA interleave memory policy to allocate InnoDB buffer pool.", nullptr, nullptr, true)
static	MYSQL_SYSVAR_BOOL (api_enable_binlog, ib_binlog_enabled, PLUGIN_VAR_NOCMDARG|PLUGIN_VAR_READONLY, "Enable binlog for applications direct access InnoDB through InnoDB APIs", nullptr, nullptr, false)
static	MYSQL_SYSVAR_BOOL (api_enable_mdl, ib_mdl_enabled, PLUGIN_VAR_NOCMDARG|PLUGIN_VAR_READONLY, "Enable MDL for applications direct access InnoDB through InnoDB APIs", nullptr, nullptr, false)
static	MYSQL_SYSVAR_BOOL (api_disable_rowlock, ib_disable_row_lock, PLUGIN_VAR_NOCMDARG|PLUGIN_VAR_READONLY, "Disable row lock when direct access InnoDB through InnoDB APIs", nullptr, nullptr, false)
static	MYSQL_SYSVAR_ULONG (api_trx_level, ib_trx_level_setting, PLUGIN_VAR_OPCMDARG, "InnoDB API transaction isolation level", nullptr, nullptr, 0, 0, 3, 0)
static	MYSQL_SYSVAR_ULONG (api_bk_commit_interval, ib_bk_commit_interval, PLUGIN_VAR_OPCMDARG, "Background commit interval in seconds", nullptr, nullptr, 5, 1, 1024 *1024 *1024, 0)
static	MYSQL_SYSVAR_ENUM (change_buffering, innodb_change_buffering, PLUGIN_VAR_RQCMDARG, "Buffer changes to reduce random access:" " OFF (default), ON, inserting, deleting, changing, or purging.", nullptr, nullptr, IBUF_USE_NONE, &innodb_change_buffering_typelib)
static	MYSQL_SYSVAR_UINT (change_buffer_max_size, srv_change_buffer_max_size, PLUGIN_VAR_RQCMDARG, "Maximum on-disk size of change buffer in terms of percentage" " of the buffer pool.", nullptr, innodb_change_buffer_max_size_update, CHANGE_BUFFER_DEFAULT_SIZE, 0, 50, 0)
static	MYSQL_SYSVAR_ENUM (stats_method, srv_innodb_stats_method, PLUGIN_VAR_RQCMDARG, "Specifies how InnoDB index statistics collection code should" " treat NULLs. Possible values are NULLS_EQUAL (default)," " NULLS_UNEQUAL and NULLS_IGNORED", nullptr, nullptr, SRV_STATS_NULLS_EQUAL, &innodb_stats_method_typelib)
static	MYSQL_SYSVAR_UINT (change_buffering_debug, ibuf_debug, PLUGIN_VAR_RQCMDARG, "Debug flags for InnoDB change buffering (0=none, 2=crash at merge)", nullptr, nullptr, 0, 0, 2, 0)
static	MYSQL_SYSVAR_BOOL (disable_background_merge, srv_ibuf_disable_background_merge, PLUGIN_VAR_NOCMDARG|PLUGIN_VAR_RQCMDARG, "Disable change buffering merges by the master thread", nullptr, nullptr, false)
static	MYSQL_SYSVAR_ENUM (compress_debug, srv_debug_compress, PLUGIN_VAR_RQCMDARG, "Compress all tables, without specifying the COMPRESS table attribute", nullptr, nullptr, Compression::NONE, &innodb_debug_compress_typelib)
static	MYSQL_SYSVAR_BOOL (random_read_ahead, srv_random_read_ahead, PLUGIN_VAR_NOCMDARG, "Whether to use read ahead for random access within an extent.", nullptr, nullptr, false)
static	MYSQL_SYSVAR_ULONG (read_ahead_threshold, srv_read_ahead_threshold, PLUGIN_VAR_RQCMDARG, "Number of pages that must be accessed sequentially for InnoDB to" " trigger a readahead.", nullptr, nullptr, 56, 0, 64, 0)
static	MYSQL_SYSVAR_STR (monitor_enable, innobase_enable_monitor_counter, PLUGIN_VAR_RQCMDARG, "Turn on a monitor counter", innodb_monitor_validate, innodb_enable_monitor_update, nullptr)
static	MYSQL_SYSVAR_STR (monitor_disable, innobase_disable_monitor_counter, PLUGIN_VAR_RQCMDARG, "Turn off a monitor counter", innodb_monitor_validate, innodb_disable_monitor_update, nullptr)
static	MYSQL_SYSVAR_STR (monitor_reset, innobase_reset_monitor_counter, PLUGIN_VAR_RQCMDARG, "Reset a monitor counter", innodb_monitor_validate, innodb_reset_monitor_update, nullptr)
static	MYSQL_SYSVAR_STR (monitor_reset_all, innobase_reset_all_monitor_counter, PLUGIN_VAR_RQCMDARG, "Reset all values for a monitor counter", innodb_monitor_validate, innodb_reset_all_monitor_update, nullptr)
static	MYSQL_SYSVAR_BOOL (status_output, srv_print_innodb_monitor, PLUGIN_VAR_OPCMDARG, "Enable InnoDB monitor output to the error log.", nullptr, nullptr, false)
static	MYSQL_SYSVAR_BOOL (status_output_locks, srv_print_innodb_lock_monitor, PLUGIN_VAR_OPCMDARG, "Enable InnoDB lock monitor output to the error log." " Requires innodb_status_output=ON.", nullptr, nullptr, false)
static	MYSQL_SYSVAR_BOOL (print_all_deadlocks, srv_print_all_deadlocks, PLUGIN_VAR_OPCMDARG, "Print all deadlocks to MySQL error log (off by default)", nullptr, nullptr, false)
static	MYSQL_SYSVAR_ULONG (compression_failure_threshold_pct, zip_failure_threshold_pct, PLUGIN_VAR_OPCMDARG, "If the compression failure rate of a table is greater than this number" " more padding is added to the pages to reduce the failures. A value of" " zero implies no padding", nullptr, nullptr, 5, 0, 100, 0)
static	MYSQL_SYSVAR_ULONG (compression_pad_pct_max, zip_pad_max, PLUGIN_VAR_OPCMDARG, "Percentage of empty space on a data page that can be reserved" " to make the page compressible.", nullptr, nullptr, 50, 0, 75, 0)
static	MYSQL_SYSVAR_BOOL (read_only, srv_read_only_mode, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "Start InnoDB in read only mode (off by default)", nullptr, nullptr, false)
static	MYSQL_SYSVAR_BOOL (cmp_per_index_enabled, srv_cmp_per_index_enabled, PLUGIN_VAR_OPCMDARG, "Enable INFORMATION_SCHEMA.innodb_cmp_per_index," " may have negative impact on performance (off by default)", nullptr, innodb_cmp_per_index_update, false)
static	MYSQL_SYSVAR_ENUM (default_row_format, innodb_default_row_format, PLUGIN_VAR_RQCMDARG, "The default ROW FORMAT for all innodb tables created without explicit" " ROW_FORMAT. Possible values are REDUNDANT, COMPACT, and DYNAMIC." " The ROW_FORMAT value COMPRESSED is not allowed", nullptr, nullptr, DEFAULT_ROW_FORMAT_DYNAMIC, &innodb_default_row_format_typelib)
static	MYSQL_SYSVAR_STR (redo_log_archive_dirs, meb::redo_log_archive_dirs, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_MEMALLOC, "Limit the location of the redo log archive to the semicolon " "separated list of labeled directories", meb::validate_redo_log_archive_dirs, nullptr, nullptr)
static	MYSQL_SYSVAR_BOOL (redo_log_encrypt, srv_redo_log_encrypt, PLUGIN_VAR_OPCMDARG, "Enable or disable Encryption of REDO tablespace.", validate_innodb_redo_log_encrypt, nullptr, false)
static	MYSQL_SYSVAR_BOOL (print_ddl_logs, srv_print_ddl_logs, PLUGIN_VAR_OPCMDARG, "Print all DDl logs to MySQL error log (off by default)", nullptr, nullptr, false)
static	MYSQL_SYSVAR_UINT (trx_rseg_n_slots_debug, trx_rseg_n_slots_debug, PLUGIN_VAR_RQCMDARG, "Debug flags for InnoDB to limit TRX_RSEG_N_SLOTS for " "trx_rsegf_undo_find_free()", nullptr, nullptr, 0, 0, 1024, 0)
static	MYSQL_SYSVAR_UINT (limit_optimistic_insert_debug, btr_cur_limit_optimistic_insert_debug, PLUGIN_VAR_RQCMDARG, "Artificially limit the number of records per B-tree page (0=unlimited).", nullptr, nullptr, 0, 0, UINT_MAX32, 0)
static	MYSQL_SYSVAR_BOOL (trx_purge_view_update_only_debug, srv_purge_view_update_only_debug, PLUGIN_VAR_NOCMDARG, "Pause actual purging any delete-marked records, but " "merely update the purge view." " It is to create artificially the situation the " "purge view have been updated" " but the each purges were not done yet.", nullptr, nullptr, false)
static	MYSQL_SYSVAR_ULONG (fil_make_page_dirty_debug, srv_fil_make_page_dirty_debug, PLUGIN_VAR_OPCMDARG, "Make the first page of the given tablespace dirty.", nullptr, innodb_make_page_dirty, UINT_MAX32, 0, UINT_MAX32, 0)
static	MYSQL_SYSVAR_ULONG (saved_page_number_debug, srv_saved_page_number_debug, PLUGIN_VAR_OPCMDARG, "An InnoDB page number.", nullptr, innodb_save_page_no, 0, 0, UINT_MAX32, 0)
static	MYSQL_SYSVAR_BOOL (page_cleaner_disabled_debug, innodb_page_cleaner_disabled_debug, PLUGIN_VAR_OPCMDARG, "Disable page cleaner", nullptr, buf_flush_page_cleaner_disabled_debug_update, false)
static	MYSQL_SYSVAR_BOOL (dict_stats_disabled_debug, innodb_dict_stats_disabled_debug, PLUGIN_VAR_OPCMDARG, "Disable dict_stats thread", nullptr, dict_stats_disabled_debug_update, false)
static	MYSQL_SYSVAR_BOOL (master_thread_disabled_debug, srv_master_thread_disabled_debug, PLUGIN_VAR_OPCMDARG, "Disable master thread", nullptr, srv_master_thread_disabled_debug_update, false)
static	MYSQL_SYSVAR_BOOL (sync_debug, srv_sync_debug, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY, "Enable the sync debug checks", nullptr, nullptr, false)
static	MYSQL_SYSVAR_BOOL (buffer_pool_debug, srv_buf_pool_debug, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY, "Enable buffer pool debug", nullptr, nullptr, false)
static	MYSQL_SYSVAR_BOOL (ddl_log_crash_reset_debug, innodb_ddl_log_crash_reset_debug, PLUGIN_VAR_OPCMDARG, "Reset all crash injection counters to 1", nullptr, ddl_log_crash_reset, false)
static	MYSQL_SYSVAR_STR (directories, srv_innodb_directories, PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|PLUGIN_VAR_NOPERSIST, "List of directories 'dir1;dir2;..;dirN' to scan for " "tablespace files. Default is to scan " "'innodb-data-home-dir;innodb-undo-directory;datadir'", nullptr, nullptr, nullptr)
static	MYSQL_THDVAR_STR (interpreter, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_NOPERSIST, "Invoke InnoDB test interpreter with commands" " to be executed.", ib_interpreter_check, ib_interpreter_update, "init")
	Use this variable innodb_interpreter to execute debug code within InnoDB. More...
static	MYSQL_THDVAR_STR (interpreter_output, PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_MEMALLOC|PLUGIN_VAR_NOPERSIST, "Output from InnoDB testing module (ut0test).", nullptr, nullptr, "The Default Value")
	When testing commands are executed in the innodb_interpreter variable, the output is stored in this innodb_interpreter_output variable. More...
char **	thd_innodb_interpreter_output (THD *thd)
	Obtain the value of the latest output from InnoDB Interpreter/Tester module (ib::Tester). More...
char **	thd_innodb_interpreter (THD *thd)
	Obtain the latest command executed by InnoDB Interpreter/Tester module (ib::Tester). More...
	mysql_declare_plugin (innobase)
ICP_RESULT	innobase_index_cond (ha_innobase *h)
	Index Condition Pushdown interface implementation. More...
void	innobase_init_vc_templ (dict_table_t *table)
	Get the computed value by supplying the base column values. More...
void	innobase_rename_vc_templ (dict_table_t *table)
	Change dbname and table name in table->vc_templ. More...
dfield_t *	innobase_get_field_from_update_vector (dict_foreign_t *foreign, upd_t *update, uint32_t col_no)
	Get the updated parent field value from the update vector for the given col_no. More...
dfield_t *	innobase_get_computed_value (const dtuple_t *row, const dict_v_col_t *col, const dict_index_t *index, mem_heap_t **local_heap, mem_heap_t *heap, const dict_field_t *ifield, THD *thd, TABLE *mysql_table, const dict_table_t *old_table, upd_t *parent_update, dict_foreign_t *foreign)
	Get the computed value by supplying the base column values. More...
void	ib_senderrf (THD *thd, ib_log_level_t level, uint32_t code,...)
	Use this when the args are passed to the format string from messages_to_clients.txt directly as is. More...
void	ib_errf (THD *thd, ib_log_level_t level, uint32_t code, const char *format,...)
	Use this when the args are first converted to a formatted string and then passed to the format string from messages_to_clients.txt. More...
uint	innobase_convert_to_filename_charset (char *to, const char *from, ulint len)
uint	innobase_convert_to_system_charset (char *to, const char *from, ulint len, uint *errors)
void	ib_warn_row_too_big (const dict_table_t *table)
static void	innodb_fill_fake_column_struct (dict_col_t *col, const Ha_fk_column_type *fk_col_type)
	Constructs fake dict_col_t describing column for foreign key type compatibility check from column description in Ha_fk_column_type form. More...

Variables
const mysql_service_registry_t *	innobase::component_services::reg_srv = nullptr
static const size_t	MOVED_FILES_PRINT_THRESHOLD = 32
	Stop printing warnings, if the count exceeds this threshold. More...
const mysql_service_registry_t *	reg_svc
const mysql_service_system_variable_source_t *	sysvar_source_svc
const mysql_service_clone_protocol_t *	clone_protocol_svc
	Clone protocol service. More...
static const uint64_t	KB = 1024
static const uint64_t	MB = KB * 1024
static const uint64_t	GB = MB * 1024
uint32_t	predefined_flags
	fil_space_t::flags for hard-coded tablespaces More...
static mysql_mutex_t	innobase_share_mutex
	to protect innobase_open_files More...
ib_mutex_t	master_key_id_mutex
static ulong	commit_threads = 0
	to force correct commit order in binlog More...
static mysql_cond_t	commit_cond
static mysql_mutex_t	commit_cond_m
mysql_cond_t	resume_encryption_cond
mysql_mutex_t	resume_encryption_cond_m
os_event_t	recovery_lock_taken
static bool	innodb_inited = false
static struct handlerton *	innodb_hton_ptr
static const long	AUTOINC_OLD_STYLE_LOCKING = 0
static const long	AUTOINC_NEW_STYLE_LOCKING = 1
static const long	AUTOINC_NO_LOCKING = 2
static long	innobase_open_files
static long	innobase_autoinc_lock_mode
static ulong	innobase_commit_concurrency = 0
bool	srv_buffer_pool_in_core_file = true
static uint	innobase_old_blocks_pct
	Percentage of the buffer pool to reserve for 'old' blocks. More...
static char *	innobase_data_home_dir = nullptr
static char *	innobase_data_file_path = nullptr
static char *	innobase_temp_data_file_path = nullptr
static char *	innobase_enable_monitor_counter = nullptr
static char *	innobase_disable_monitor_counter = nullptr
static char *	innobase_reset_monitor_counter = nullptr
static char *	innobase_reset_all_monitor_counter = nullptr
static char *	innobase_doublewrite_dir = nullptr
static ulong	innodb_flush_method
static char *	innobase_server_stopword_table = nullptr
static bool	innobase_rollback_on_timeout = false
static bool	innobase_create_status_file = false
bool	innobase_stats_on_metadata = true
static bool	innodb_optimize_fulltext_only = false
static char *	innodb_version_str = (char *)INNODB_VERSION_STR
static Innodb_data_lock_inspector	innodb_data_lock_inspector
static ulong	innodb_default_row_format = DEFAULT_ROW_FORMAT_DYNAMIC
static const char *	innodb_debug_compress_names []
	Values for –innodb-debug-compress names. More...
static TYPELIB	innodb_debug_compress_typelib
	Enumeration of –innodb-debug-compress. More...
static const char *	innodb_stats_method_names []
	Possible values for system variable "innodb_stats_method". More...
static TYPELIB	innodb_stats_method_typelib
	Used to define an enumerate type of the system variable innodb_stats_method. More...
static const char *	innodb_checksum_algorithm_names []
	Possible values of the parameter innodb_checksum_algorithm. More...
static TYPELIB	innodb_checksum_algorithm_typelib
	Used to define an enumerate type of the system variable innodb_checksum_algorithm. More...
static const char *	innodb_flush_method_names []
	Names of allowed values of innodb_flush_method. More...
static TYPELIB	innodb_flush_method_typelib
	Enumeration of innodb_flush_method. More...
static const char *	innodb_default_row_format_names []
	Possible values for system variable "innodb_default_row_format". More...
static TYPELIB	innodb_default_row_format_typelib
	Used to define an enumerate type of the system variable innodb_default_row_format. More...
static const char *	innodb_doublewrite_names []
	Possible values for system variable "innodb_doublewrite". More...
static TYPELIB	innodb_doublewrite_typelib
	Used to define an enumerate type of the system variable innodb_default_row_format. More...
constexpr uint32_t	INNOBASE_WAKE_INTERVAL = 32
static ulong	innobase_active_counter = 0
static hash_table_t *	innobase_open_tables
static std::vector< Plugin_tablespace::Plugin_tablespace_file *, ut::allocator< Plugin_tablespace::Plugin_tablespace_file * > >	innobase_sys_files
	Array of data files of the system tablespace. More...
static const char *	innodb_change_buffering_names []
	Allowed values of innodb_change_buffering. More...
static TYPELIB	innodb_change_buffering_typelib
	Enumeration of innodb_change_buffering. More...
const struct _ft_vft	ft_vft_result
const struct _ft_vft_ext	ft_vft_ext_result
static mysql_pfs_key_t	innobase_share_mutex_key
static mysql_pfs_key_t	commit_cond_mutex_key
static mysql_pfs_key_t	commit_cond_key
mysql_pfs_key_t	resume_encryption_cond_mutex_key
mysql_pfs_key_t	resume_encryption_cond_key
static PSI_mutex_info	all_pthread_mutexes []
static PSI_cond_info	all_innodb_conds []
static ib_cb_t	innodb_api_cb []
static SHOW_VAR	innodb_status_variables []
static const char *	ha_innobase_exts [] = {dot_ext[IBD], NullS}
	Gives the file extension of an InnoDB single-table tablespace. More...
static const ulint	MIN_EXPECTED_TABLESPACE_SIZE = 5 * 1024 * 1024
	Minimum expected tablespace size. More...
static PSI_metric_info_v1	inno_metrics []
static PSI_metric_info_v1	buffer_metrics []
static PSI_metric_info_v1	data_metrics []
static PSI_meter_info_v1	inno_meter []
static ulong	srv_fil_make_page_dirty_debug = 0
static ulong	srv_saved_page_number_debug = 0
static char *	srv_buffer_pool_evict
static bool	innodb_background_drop_list_empty = true
static bool	innodb_purge_run_now = true
static bool	innodb_purge_stop_now = true
static bool	innodb_log_checkpoint_now = true
static bool	innodb_log_checkpoint_fuzzy_now = true
static bool	innodb_log_flush_now = true
static bool	innodb_buf_flush_list_now = true
static uint	innodb_merge_threshold_set_all_debug
static bool	innodb_buffer_pool_dump_now = false
static bool	innodb_buffer_pool_load_now = false
static bool	innodb_buffer_pool_load_abort = false
static SHOW_VAR	innodb_status_variables_export []
static struct st_mysql_storage_engine	innobase_storage_engine
static SYS_VAR *	innobase_system_variables []
	i_s_innodb_trx
	i_s_innodb_cmp
	i_s_innodb_cmp_reset
	i_s_innodb_cmpmem
	i_s_innodb_cmpmem_reset
	i_s_innodb_cmp_per_index
	i_s_innodb_cmp_per_index_reset
	i_s_innodb_buffer_page
	i_s_innodb_buffer_page_lru
	i_s_innodb_buffer_stats
	i_s_innodb_temp_table_info
	i_s_innodb_metrics
	i_s_innodb_ft_default_stopword
	i_s_innodb_ft_deleted
	i_s_innodb_ft_being_deleted
	i_s_innodb_ft_config
	i_s_innodb_ft_index_cache
	i_s_innodb_ft_index_table
	i_s_innodb_tables
	i_s_innodb_tablestats
	i_s_innodb_indexes
	i_s_innodb_tablespaces
	i_s_innodb_columns
	i_s_innodb_virtual
	i_s_innodb_cached_indexes
i_s_innodb_session_temp_tablespaces	mysql_declare_plugin_end
const char *	TROUBLESHOOTING_MSG
const char *	TROUBLESHOOT_DATADICT_MSG
const char *	FORCE_RECOVERY_MSG
const char *	ERROR_CREATING_MSG
const char *	OPERATING_SYSTEM_ERROR_MSG
const char *	FOREIGN_KEY_CONSTRAINTS_MSG
const char *	INNODB_PARAMETERS_MSG

Macro Definition Documentation

BP_IN_CORE_DEFAULT

#define BP_IN_CORE_DEFAULT   false

INNODB_API_CB_ARRAY_ELEMENT_TRANSFORM

#define INNODB_API_CB_ARRAY_ELEMENT_TRANSFORM

(

stem

)

(ib_cb_t) ib_##stem,

Set up InnoDB API callback function array.

PSI_KEY

#define PSI_KEY	(		n,
			flag,
			volatility,
			doc
	)		{ &(n##_key.m_value), #n, flag, volatility, doc }

PSI_MEMORY_KEY

#define PSI_MEMORY_KEY	(		n,
			flag,
			volatility,
			doc
	)		{ &(n##_key), #n, flag, volatility, doc }

PSI_MUTEX_KEY

#define PSI_MUTEX_KEY	(		n,
			flag,
			volatility,
			doc
	)		{ &(n##_key.m_value), #n, flag, volatility, doc }

PSI_RWLOCK_KEY

#define PSI_RWLOCK_KEY	(		n,
			volatility,
			doc
	)		{ &n##_key.m_value, #n, PSI_FLAG_RWLOCK_SX, volatility, doc }

PSI_THREAD_KEY

#define PSI_THREAD_KEY	(		n,
			osn,
			flag,
			volatility,
			doc
	)		{ &(n##_key.m_value), #n, osn, flag, volatility, doc }

Enumeration Type Documentation

default_row_format_enum

enum default_row_format_enum

Note we cannot use rec_format_enum because we do not allow COMPRESSED row format for innodb_default_row_format option.

Enumerator
DEFAULT_ROW_FORMAT_REDUNDANT
DEFAULT_ROW_FORMAT_COMPACT
DEFAULT_ROW_FORMAT_DYNAMIC

Function Documentation

acquire_plugin_services()

static void acquire_plugin_services ( )

static

Acquire required services from mysql server.

add_table_to_thread_cache()

static void add_table_to_thread_cache ( dict_table_t *  table, mem_heap_t *  heap, THD *  thd  )

inlinestatic

Add the table handler to thread cache.

Obtain the InnoDB transaction of a MySQL thread.

Parameters

[in,out]	table	table handler
[in,out]	heap	heap for allocating system columns.
[in,out]	thd	MySQL thread handler

apply_dd_undo_state()

bool apply_dd_undo_state	(	space_id_t	space_id,
		const dd::Tablespace *	dd_space
	)

Save the state of undo tablespaces from the dd to the undo::Tablespace.

Parameters

[in]	space_id	tablespace ID
[in]	dd_space	dd::Tablespace object

Returns

true if success and false if the undo tablespace state is not saved.

boot_tablespaces()

static bool boot_tablespaces ( THD *  thd )

static

Discover all InnoDB tablespaces.

Parameters

[in,out]

thd

thread handle

Return values

true	on error
false	on success

buf_flush_list_now_set()

static void buf_flush_list_now_set ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Force a dirty pages flush now.

Parameters

[in]

save

immediate result from check function

buffer_pool_dump_now()

static void buffer_pool_dump_now ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Trigger a dump of the buffer pool if innodb_buffer_pool_dump_now is set to ON.

This function is registered as a callback with MySQL.

Parameters

[in]

save

immediate result from check function

buffer_pool_load_abort()

static void buffer_pool_load_abort ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Abort a load of the buffer pool if innodb_buffer_pool_load_abort is set to ON.

This function is registered as a callback with MySQL.

Parameters

[in]

save

immediate result from check function

buffer_pool_load_now()

static void buffer_pool_load_now ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Trigger a load of the buffer pool if innodb_buffer_pool_load_now is set to ON.

This function is registered as a callback with MySQL.

Parameters

[in]

save

immediate result from check function

build_template_field()

static mysql_row_templ_t * build_template_field ( row_prebuilt_t *  prebuilt, dict_index_t *  clust_index, dict_index_t *  index, TABLE *  table, const Field *  field, ulint  i, ulint  v_no  )

static

Adds a field to a m_prebuilt struct 'template'.

Returns

the field template

Parameters

prebuilt	in/out: template
clust_index	in: InnoDB clustered index
index	in: InnoDB index to use
table	in: MySQL table object
field	in: field in MySQL table
i	in: field index in InnoDB table
v_no	in: field index for virtual col

build_template_needs_field()

static const Field * build_template_needs_field ( bool  index_contains, bool  read_just_key, bool  fetch_all_in_key, bool  fetch_primary_key_cols, dict_index_t *  index, const TABLE *  table, ulint  i, ulint  num_v  )

static

Determines if a field is needed in a m_prebuilt struct 'template'.

Returns

field to use, or NULL if the field is not needed

Parameters

index_contains	in: dict_index_contains_col_or_prefix( index, i)
read_just_key	in: true when MySQL calls ha_innobase::extra with the argument HA_EXTRA_KEYREAD; it is enough to read just columns defined in the index (i.e., no read of the clustered index record necessary)
fetch_all_in_key	in: true=fetch all fields in the index
fetch_primary_key_cols	in: true=fetch the primary key columns
index	in: InnoDB index to use
table	in: MySQL table object
i	in: field index in InnoDB table
num_v	in: num virtual column so far

build_template_needs_field_in_icp()

bool build_template_needs_field_in_icp ( const dict_index_t *  index, const row_prebuilt_t *  prebuilt, bool  contains, ulint  i, bool  is_virtual  )

inline

Determines if a field is needed in a m_prebuilt struct 'template'.

Returns

whether the field is needed for index condition pushdown

Parameters

index	in: InnoDB index
prebuilt	in: row fetch template
contains	in: whether the index contains column i
i	in: column number
is_virtual	in: a virtual column or not

calc_row_difference()

static dberr_t calc_row_difference ( upd_t *  uvect, const uchar *  old_row, uchar *  new_row, TABLE *  table, uchar *  upd_buff, ulint  buff_len, row_prebuilt_t *  prebuilt, THD *  thd  )

static

Checks which fields have changed in a row and stores information of them to an update vector.

Returns

DB_SUCCESS or error code

Parameters

uvect	in/out: update vector
old_row	in: old row in MySQL format
new_row	in: new row in MySQL format
table	in: table in MySQL data dictionary
upd_buff	in: buffer to use
buff_len	in: buffer length
prebuilt	in: InnoDB prebuilt struct
thd	in: user thread

calculate_delete_length_stat()

static void calculate_delete_length_stat ( const dict_table_t *  ib_table, ha_statistics *  stats, THD *  thd  )

static

Calculate delete length statistic.

Parameters

[in]	ib_table	table object
[in,out]	stats	stats structure to hold calculated values
[in,out]	thd	user thread handle (for issuing warnings)

calculate_index_size_stats()

static void calculate_index_size_stats ( const dict_table_t *  ib_table, uint64_t  n_rows, ulint  stat_clustered_index_size, ulint  stat_sum_of_other_index_sizes, ha_statistics *  stats  )

static

Calculate stats based on index size.

Parameters

[in]	ib_table	table object
[in]	n_rows	number of rows
[in]	stat_clustered_index_size	clustered index size
[in]	stat_sum_of_other_index_sizes	sum of non-clustered index sizes
[in,out]	stats	the stats structure to hold calculated values

check_func_bool()

static int check_func_bool ( THD *  , SYS_VAR *  , void *  save, st_mysql_value *  value  )

static

Utility method that checks if user provided valid value.

If yes, then store that in the save variable.

Returns

0 on success, 1 on failure.

check_session_admin()

static int check_session_admin ( THD *  thd )

static

Utility method that checks if user has correct session administrative dynamic privileges.

Returns

0 on success, 1 on failure.

check_trx_exists()

trx_t * check_trx_exists

(

THD *

thd

)

Gets the InnoDB transaction handle for a MySQL handler object, creates an InnoDB transaction struct if the corresponding MySQL thread struct still lacks one.

Returns

InnoDB transaction handle

Parameters

thd	in: user thread handle

checkpoint_disabled_update()

static void checkpoint_disabled_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Updates srv_checkpoint_disabled - allowing or disallowing checkpoints.

This is called when user invokes SET GLOBAL innodb_checkpoints_disabled=0/1. After checkpoints are disabled, there will be no write of a checkpoint, until checkpoints are re-enabled (log_sys->checkpointer_mutex protects that)

Parameters

[in]

save

immediate result from check function

checkpoint_fuzzy_now_set()

static void checkpoint_fuzzy_now_set ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Force InnoDB to do fuzzy checkpoint.

Fuzzy checkpoint does not force InnoDB to flush dirty pages. It only forces to write the new checkpoint_lsn to the header of the log file containing that LSN. This LSN is where the recovery starts. You can read more about the fuzzy checkpoints in the internet.

Parameters

[in]

save

immediate result from check function

checkpoint_now_set()

static void checkpoint_now_set ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Force InnoDB to do sharp checkpoint.

This forces a flush of all dirty pages.

Parameters

[in]

save

immediate result from check function

convert_error_code_to_mysql()

int convert_error_code_to_mysql	(	dberr_t	error,
		uint32_t	flags,
		THD *	thd
	)

Converts an InnoDB error code to a MySQL error code.

Also tells to MySQL about a possible transaction rollback inside InnoDB caused by a lock wait timeout or a deadlock.

Parameters

[in]	error	InnoDB error code.
[in]	flags	InnoDB table flags or 0.
[in]	thd	MySQL thread or NULL.

Returns

MySQL error code

convert_search_mode_to_innobase()

page_cur_mode_t convert_search_mode_to_innobase

(

enum ha_rkey_function

find_flag

)

Converts a search mode flag understood by MySQL to a flag understood by InnoDB.

Parameters

[in]

find_flag

MySQL search mode flag.

Returns

InnoDB search mode flag.

create_clustered_index_when_no_primary()

int create_clustered_index_when_no_primary ( trx_t *  trx, uint32_t  flags, const char *  table_name  )

inline

Creates an index to an InnoDB table when the user has defined no primary index.

Parameters

trx	in: InnoDB transaction handle
flags	in: InnoDB table flags
table_name	in: table name

create_index()

int create_index ( trx_t *  trx, const TABLE *  form, uint32_t  flags, const char *  table_name, uint  key_num, const dd::Table *  dd_table  )

inline

Creates an index in an InnoDB database.

Parameters

trx	in: InnoDB transaction handle
form	in: information on table columns and indexes
flags	in: InnoDB table flags
table_name	in: table name
key_num	in: index number
dd_table	in: dd::Table for the table

create_table_info_t::create_table_update_global_dd< dd::Partition >()

template int create_table_info_t::create_table_update_global_dd< dd::Partition >

(

dd::Partition *

)

create_table_info_t::create_table_update_global_dd< dd::Table >()

template int create_table_info_t::create_table_update_global_dd< dd::Table >

(

dd::Table *

)

dd_create_hardcoded()

static bool dd_create_hardcoded ( space_id_t  space_id, const char *  filename  )

static

Create a hard-coded tablespace file at server initialization.

Parameters

[in]	space_id	fil_space_t::id
[in]	filename	file name

Return values

false	on success
true	on failure

dd_is_only_column()

static bool dd_is_only_column ( const dd::Index *  index, const dd::Column *  column  )

static

Check if a column is the only column in an index.

Parameters

[in]	index	data dictionary index
[in]	column	the column to look for

Returns

whether the column is the only column in the index

dd_open_hardcoded()

static bool dd_open_hardcoded ( space_id_t  space_id, const char *  filename  )

static

Open a hard-coded tablespace file at server initialization.

Parameters

[in]	space_id	fil_space_t::id
[in]	filename	file name

Return values

false	on success
true	on failure

doublewrite_update()

static void doublewrite_update ( THD *  thd, SYS_VAR *  var, void *  var_ptr, const void *  save  )

static

Plugin update function to handle validation and then switch the innodb_doublewrite mode.

Parameters

[in]	thd	thread handle
[in]	var	pointer to system variable
[in]	var_ptr	where the formal string goes
[in]	save	immediate result from check function

EQ_CURRENT_THD()

static bool EQ_CURRENT_THD ( THD *  thd )

inlinestatic

free_share()

static void free_share ( INNOBASE_SHARE *  share )

static

Free the shared object that was registered with get_share().

in/own: share to free

Parameters

share

in/own: table share to free

get_field_offset()

static uint get_field_offset ( const TABLE *  table, const Field *  field  )

inlinestatic

Gets field offset for a field in a table.

Parameters

[in]	table	MySQL table object
[in]	field	MySQL field object

Returns

offset

get_innobase_type_from_mysql_dd_type()

ulint get_innobase_type_from_mysql_dd_type	(	ulint *	unsigned_flag,
		ulint *	binary_type,
		ulint *	charset_no,
		dd::enum_column_types	dd_type,
		const CHARSET_INFO *	field_charset,
		bool	is_unsigned
	)

Converts a MySQL data-dictionary type to an InnoDB type.

Also returns a few attributes which are useful for precise type calculation.

Note

This function is version of get_innobase_type_from_mysql_type() with added knowledge about how additional attributes calculated (e.g. in create_table_info_t::create_table_def()) and about behavior of Field class and its descendats.

It allows to get InnoDB generic and precise types directly from MySQL data-dictionary info, bypassing expensive construction of Field objects.

Parameters

[out]	unsigned_flag	DATA_UNSIGNED if an 'unsigned type'.
[out]	binary_type	DATA_BINARY_TYPE if a 'binary type'.
[out]	charset_no	Collation id for string types.
[in]	dd_type	MySQL data-dictionary type.
[in]	field_charset	Charset.
[in]	is_unsigned	MySQL data-dictionary unsigned flag.

Returns

DATA_BINARY, DATA_VARCHAR, ...

get_innobase_type_from_mysql_type()

ulint get_innobase_type_from_mysql_type	(	ulint *	unsigned_flag,
		const void *	f
	)

Converts a MySQL type to an InnoDB type.

Note that this function returns the 'mtype' of InnoDB. InnoDB differentiates between MySQL's old <= 4.1 VARCHAR and the new true VARCHAR in >= 5.0.3 by the 'prtype'.

Parameters

[out]	unsigned_flag	DATA_UNSIGNED if an 'unsigned type'; at least ENUM and SET, and unsigned integer types are 'unsigned types'
[in]	f	MySQL Field

Returns

DATA_BINARY, DATA_VARCHAR, ...

get_metric_simple_integer()

template<typename T >

static void get_metric_simple_integer ( void *  measurement_context, measurement_delivery_callback_t  delivery, void *  delivery_context  )

static

get_my_dd_index()

template<typename Index >

const dd::Index * get_my_dd_index

(

const Index *

index

)

get_my_dd_index< dd::Index >()

template<>

const dd::Index * get_my_dd_index< dd::Index >

(

const dd::Index *

dd_index

)

get_my_dd_index< dd::Partition_index >()

template<>

const dd::Index * get_my_dd_index< dd::Partition_index >

(

const dd::Partition_index *

dd_index

)

get_row_format()

static rec_format_t get_row_format ( ulong  row_format )

static

Return the InnoDB ROW_FORMAT enum value.

Parameters

[in]

row_format

row_format from "innodb_default_row_format"

Returns

InnoDB ROW_FORMAT value from rec_format_t enum.

get_share()

static INNOBASE_SHARE * get_share ( const char *  table_name )

static

Handling the shared INNOBASE_SHARE structure that is needed to provide table locking.

Register the table name if it doesn't exist in the hash table. in: table to lookup

Register the table name if it doesn't exist in the hash table.

get_zip_shift_size()

static uint32_t get_zip_shift_size ( ulint  key_block_size )

static

** InnoDB database tables

The requested compressed page size (key_block_size) is given in kilobytes. If it is a valid number, store that value as the number of log2 shifts from 512 in zip_ssize. Zero means it is not compressed.

ib_errf()

void ib_errf	(	THD *	thd,
		ib_log_level_t	level,
		uint32_t	code,
		const char *	format,
			...
	)

Use this when the args are first converted to a formatted string and then passed to the format string from messages_to_clients.txt.

The error message format must be: "Some string ... %s".

Push a warning message to the client, it is a wrapper around:

void push_warning_printf( THD *thd, Sql_condition::enum_condition_level level, uint code, const char *format, ...);

Parameters

thd	in/out: session
level	in: warning level
code	MySQL error code
format	printf format
...	Args

ib_senderrf()

void ib_senderrf	(	THD *	thd,
		ib_log_level_t	level,
		uint32_t	code,
			...
	)

Use this when the args are passed to the format string from messages_to_clients.txt directly as is.

Push a warning message to the client, it is a wrapper around:

void push_warning_printf( THD *thd, Sql_condition::enum_warning_level level, uint code, const char *format, ...);

Parameters

[in,out]	thd	session
[in]	level	warning level
[in]	code	MySQL error code
[in]	...	Args

ib_warn_row_too_big()

void ib_warn_row_too_big

(

const dict_table_t *

table

)

index_pct_cached()

double index_pct_cached ( const dict_index_t *  index )

inline

Estimate what percentage of an index's pages are cached in the buffer pool.

Parameters

[in]

index

index whose pages to look up

Returns

a real number in [0.0, 1.0] designating the percentage of cached pages

innobase_active_small()

void innobase_active_small ( void  )

inline

Increments innobase_active_counter and every INNOBASE_WAKE_INTERVALth time calls srv_active_wake_master_thread.

This function should be used when a single database operation may introduce a small need for server utility activity, like checkpointing.

innobase_alter_autoextend_size_tablespace()

static int innobase_alter_autoextend_size_tablespace ( handlerton *  hton, st_alter_tablespace *  alter_info, const dd::Tablespace *  old_dd_space  )

static

Alter AUTOEXTEND_SIZE a tablespace.

Parameters

[in]	hton	Handlerton of InnoDB
[in]	alter_info	How to do the command
[in]	old_dd_space	Tablespace metadata

Returns

MySQL error code

innobase_alter_encrypt_tablespace()

static int innobase_alter_encrypt_tablespace ( handlerton *  hton, THD *  thd, st_alter_tablespace *  alter_info, const dd::Tablespace *  old_dd_space, dd::Tablespace *  new_dd_space  )

static

Alter Encrypt/Unencrypt a tablespace.

Parameters

[in]	hton	Handlerton of InnoDB
[in]	thd	Connection
[in]	alter_info	How to do the command
[in]	old_dd_space	Tablespace metadata
[in,out]	new_dd_space	Tablespace metadata

Returns

MySQL error code

innobase_alter_tablespace()

static int innobase_alter_tablespace ( handlerton *  hton, THD *  thd, st_alter_tablespace *  alter_info, const dd::Tablespace *  old_ts_def, dd::Tablespace *  new_ts_def  )

static

This API handles CREATE, ALTER & DROP commands for InnoDB tablespaces.

Parameters

[in]	hton	Handlerton of InnoDB
[in]	thd	Connection
[in]	alter_info	Describes the command and how to do it.
[in]	old_ts_def	Old version of dd::Tablespace object for the tablespace.
[in,out]	new_ts_def	New version of dd::Tablespace object for the tablespace. Can be adjusted by SE. Changes will be persisted in the data-dictionary at statement commit.

Returns

MySQL error code

innobase_basename()

const char * innobase_basename

(

const char *

path_name

)

Strip dir name from a full path name and return only the file name.

Parameters

[in]

path_name

full path name

Returns

file name or "null" if no file name

innobase_basic_ddl::create_impl< dd::Partition >()

template int innobase_basic_ddl::create_impl< dd::Partition >	(	THD *	,
		const char *	,
		TABLE *	,
		HA_CREATE_INFO *	,
		dd::Partition *	,
		bool	,
		bool	,
		bool	,
		uint32_t	,
		uint32_t	,
		const dd::Table *
	)

innobase_basic_ddl::create_impl< dd::Table >()

template int innobase_basic_ddl::create_impl< dd::Table >	(	THD *	,
		const char *	,
		TABLE *	,
		HA_CREATE_INFO *	,
		dd::Table *	,
		bool	,
		bool	,
		bool	,
		uint32_t	,
		uint32_t	,
		const dd::Table *
	)

innobase_basic_ddl::delete_impl< dd::Partition >()

template int innobase_basic_ddl::delete_impl< dd::Partition >	(	THD *	,
		const char *	,
		const dd::Partition *	,
		const TABLE *
	)

innobase_basic_ddl::delete_impl< dd::Table >()

template int innobase_basic_ddl::delete_impl< dd::Table >	(	THD *	,
		const char *	,
		const dd::Table *	,
		const TABLE *
	)

innobase_basic_ddl::rename_impl< dd::Partition >()

template int innobase_basic_ddl::rename_impl< dd::Partition >	(	THD *	,
		const char *	,
		const char *	,
		const dd::Partition *	,
		const dd::Partition *	,
		const TABLE *
	)

innobase_basic_ddl::rename_impl< dd::Table >()

template int innobase_basic_ddl::rename_impl< dd::Table >	(	THD *	,
		const char *	,
		const char *	,
		const dd::Table *	,
		const dd::Table *	,
		const TABLE *
	)

innobase_build_index_translation()

static bool innobase_build_index_translation ( const TABLE *  table, dict_table_t *  ib_table, INNOBASE_SHARE *  share  )

static

This function builds a translation table in INNOBASE_SHARE structure for fast index location with mysql array number from its table->key_info structure.

This also provides the necessary translation between the key order in mysql key_info and InnoDB ib_table->indexes if they are not fully matched with each other. Note we do not have any mutex protecting the translation table building based on the assumption that there is no concurrent index creation/drop and DMLs that requires index lookup. All table handle will be closed before the index creation/drop.

Returns

true if index translation table built successfully

Parameters

table	in: table in MySQL data dictionary
ib_table	in: table in InnoDB data dictionary
share	in/out: share structure where index translation table will be constructed in.

innobase_build_v_templ()

void innobase_build_v_templ	(	const TABLE *	table,
		const dict_table_t *	ib_table,
		dict_vcol_templ_t *	s_templ,
		const dict_add_v_col_t *	add_v,
		bool	locked,
		const char *	share_tbl_name
	)

Build template for the virtual columns and their base columns.

This is done when the table first opened.

Parameters

[in]	table	MySQL TABLE
[in]	ib_table	InnoDB dict_table_t
[in,out]	s_templ	InnoDB template structure
[in]	add_v	new virtual columns added along with add index call
[in]	locked	true if dict_sys mutex is held
[in]	share_tbl_name	original MySQL table name

innobase_build_v_templ_callback()

void innobase_build_v_templ_callback	(	const TABLE *	table,
		void *	ib_table
	)

Callback used by MySQL server layer to initialize the table virtual columns' template.

Parameters

[in]	table	MySQL TABLE
[in,out]	ib_table	InnoDB table

innobase_casedn_path()

void innobase_casedn_path

(

char *

a

)

Makes all characters in a NUL-terminated UTF-8 path string lower case.

in/out: string to put in lower case

Parameters

a	in/out: string to put in lower case

innobase_casedn_str()

void innobase_casedn_str

(

char *

a

)

Makes all characters in a NUL-terminated UTF-8 string lower case.

in/out: string to put in lower case

Parameters

a	in/out: string to put in lower case

innobase_check_fk_base_col()

static dberr_t innobase_check_fk_base_col ( const dd::Table *  dd_table, const TABLE *  table  )

static

Check any cascading foreign key columns are base columns for any stored columns in the table.

Parameters

[in]	dd_table	dd::Table for the table
[in]	table	TABLE* for the table

Returns

DB_NO_FK_ON_S_BASE_COL if found or DB_SUCCESS

innobase_check_identifier_length()

bool innobase_check_identifier_length

(

const char *

id

)

innobase_check_reserved_file_name()

static bool innobase_check_reserved_file_name ( handlerton *  hton, const char *  name  )

static

Checks if the file name is reserved in InnoDB.

Currently redo log file names from the old redo format (ib_logfile*) are reserved. There is no need to reserve file names from the newer redo formats, because they start with '#'.

Returns

true if the name is reserved

Parameters

[in]	hton	handlerton of InnoDB
[in]	name	Name of the database

innobase_close_connection()

static int innobase_close_connection ( handlerton *  hton, THD *  thd  )

static

Frees a possible InnoDB trx object associated with the current THD.

Returns

0 or error number in: MySQL thread handle for which to close the connection

0 or error number

Parameters

hton	in/out: InnoDB handlerton
thd	in: handle to the MySQL thread of the user whose resources should be free'd

innobase_collect_hton_log_info()

static bool innobase_collect_hton_log_info ( handlerton *  hton, Json_dom *  json  )

static

Implements Log_resource collect_info.

Parameters

[in]	hton	the innodb handlerton
[in]	json	the JSON dom to receive the log info

Returns

false on success

innobase_commit()

static int innobase_commit ( handlerton *  hton, THD *  thd, bool  commit_trx  )

static

Commits a transaction in an InnoDB database or marks an SQL statement ended.

Returns

0 in: true - commit transaction false - the current SQL statement ended

0 or deadlock error if the transaction was aborted by another higher priority transaction.

Parameters

hton	in/out: InnoDB handlerton
thd	in: MySQL thread handle of the user for whom the transaction should be committed
commit_trx	in: true - commit transaction false - the current SQL statement ended

innobase_commit_by_xid()

static xa_status_code innobase_commit_by_xid ( handlerton *  hton, XID *  xid  )

static

This function is used to commit one X/Open XA distributed transaction which is in the prepared state.

Returns

0 or error number in: X/Open XA transaction identification

0 or error number

Parameters

hton	in: InnoDB handlerton
xid	in: X/Open XA transaction identification

innobase_commit_concurrency_init_default()

static void innobase_commit_concurrency_init_default ( )

static

Initialize the default value of innodb_commit_concurrency.

Once InnoDB is running, the innodb_commit_concurrency must not change from zero to nonzero. (Bug #42101)

The initial default value is 0, and without this extra initialization, SET GLOBAL innodb_commit_concurrency=DEFAULT would set the parameter to 0, even if it was initially set to nonzero at the command line or configuration file.

innobase_commit_concurrency_validate()

static int innobase_commit_concurrency_validate ( THD *  , SYS_VAR *  , void *  save, struct st_mysql_value *  value  )

static

Check for a valid value of innobase_commit_concurrency.

Returns

0 for valid innodb_commit_concurrency

Parameters

save	out: immediate result for update function
value	in: incoming string

innobase_commit_low()

void innobase_commit_low

(

trx_t *

trx

)

Commits a transaction in an InnoDB database.

Parameters

[in]

trx

Transaction handle.

Parameters

trx	in: transaction handle

innobase_convert_identifier()

static char * innobase_convert_identifier ( char *  buf, ulint  buflen, const char *  id, ulint  idlen, THD *  thd  )

static

Convert a table name to the MySQL system_charset_info (UTF-8) and quote it.

Parameters

[out]	buf	buffer for converted identifier
[in]	buflen	length of buf, in bytes
[in]	id	identifier to convert
[in]	idlen	length of id, in bytes
[in]	thd	MySQL connection thread, or NULL

Returns

pointer to the end of buf

innobase_convert_name()

char * innobase_convert_name	(	char *	buf,
		ulint	buflen,
		const char *	id,
		ulint	idlen,
		THD *	thd
	)

Convert a table name to the MySQL system_charset_info (UTF-8).

Returns

pointer to the end of buf

Parameters

buf	out: buffer for converted identifier
buflen	in: length of buf, in bytes
id	in: table name to convert
idlen	in: length of id, in bytes
thd	in: MySQL connection thread, or NULL

innobase_convert_string()

static ulint innobase_convert_string ( void *  to, ulint  to_length, const CHARSET_INFO *  to_cs, const void *  from, ulint  from_length, const CHARSET_INFO *  from_cs, uint *  errors  )

static

Wrapper around MySQL's copy_and_convert function.

Returns

number of bytes copied to 'to'

Parameters

to	out: converted string
to_length	in: number of bytes reserved for the converted string
to_cs	in: character set to convert to
from	in: string to convert
from_length	in: number of bytes to convert
from_cs	in: character set to convert from
errors	out: number of errors encountered during the conversion

innobase_convert_to_filename_charset()

uint innobase_convert_to_filename_charset	(	char *	to,
		const char *	from,
		ulint	len
	)

innobase_convert_to_system_charset()

uint innobase_convert_to_system_charset	(	char *	to,
		const char *	from,
		ulint	len,
		uint *	errors
	)

innobase_copy_frm_flags_from_create_info()

static void innobase_copy_frm_flags_from_create_info ( dict_table_t *  innodb_table, const HA_CREATE_INFO *  create_info  )

static

Copy table flags from MySQL's HA_CREATE_INFO into an InnoDB table object.

Those flags are stored in .frm file and end up in the MySQL table object, but are frequently used inside InnoDB so we keep their copies into the InnoDB table object.

Parameters

innodb_table	in/out: InnoDB table
create_info	in: create info

innobase_copy_frm_flags_from_table_share()

void innobase_copy_frm_flags_from_table_share	(	dict_table_t *	innodb_table,
		const TABLE_SHARE *	table_share
	)

Copy table flags from MySQL's TABLE_SHARE into an InnoDB table object.

Those flags are stored in .frm file and end up in the MySQL table object, but are frequently used inside InnoDB so we keep their copies into the InnoDB table object.

Parameters

innodb_table	in/out: InnoDB table
table_share	in: table share

innobase_create_handler()

static handler * innobase_create_handler ( handlerton *  hton, TABLE_SHARE *  table, bool  partitioned, MEM_ROOT *  mem_root  )

static

Function for constructing an InnoDB table handler instance.

Parameters

[in,out]	hton	handlerton for InnoDB
[in]	table	MySQL table
[in]	partitioned	Indicates whether table is partitioned
[in]	mem_root	memory context

innobase_ddse_dict_init()

static bool innobase_ddse_dict_init ( dict_init_mode_t  dict_init_mode, uint  version, List< const dd::Object_table > *  tables, List< const Plugin_tablespace > *  tablespaces  )

static

Initialize InnoDB for being used to store the DD tables.

Create the required files according to the dict_init_mode. Create strings representing the required DDSE tables, i.e., tables that InnoDB expects to exist in the DD, and add them to the appropriate out parameter.

Parameters

[in]	dict_init_mode	How to initialize files
[in]	version	Target DD version if a new server is being installed. 0 if restarting an existing server.
[out]	tables	List of SQL DDL statements for creating DD tables that are needed by the DDSE.
[out]	tablespaces	List of meta data for predefined tablespaces created by the DDSE.

Return values

true	An error occurred.
false	Success - no errors.

innobase_deadlock_detect_update()

static void innobase_deadlock_detect_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innobase_deadlock_detect using the "saved" value.

Makes sure to "wake up" the dedicated deadlock detector thread if needed. This function is registered as a callback with MySQL.

Parameters

[in]

save

immediate result from check function

innobase_dict_cache_reset()

static void innobase_dict_cache_reset ( const char *  schema_name, const char *  table_name  )

static

Invalidate an entry or entries for partitioned table from the dict cache.

Parameters

[in]	schema_name	Schema name
[in]	table_name	Table name

innobase_dict_cache_reset_tables_and_tablespaces()

static void innobase_dict_cache_reset_tables_and_tablespaces ( )

static

Invalidate user table dict cache after Replication Plugin recovers.

Table definition could be different with XA commit/rollback of DDL operations

innobase_dict_get_server_version()

static bool innobase_dict_get_server_version ( uint *  version )

static

Get the server version id stored in the header of the dictionary tablespace.

Parameters

[out]

version

Version number from the DD tablespace header.

Return values

Operation

outcome, false if no error, otherwise true.

innobase_dict_recover()

static bool innobase_dict_recover ( dict_recovery_mode_t  dict_recovery_mode, uint  version  )

static

Perform high-level recovery in InnoDB as part of initializing the data dictionary.

Parameters

[in]	dict_recovery_mode	How to do recovery
[in]	version	Target DD version if a new server is being installed. Actual DD version if restarting an existing server.

Return values

true	An error occurred.
false	Success - no errors.

innobase_dict_register_dd_table_id()

static void innobase_dict_register_dd_table_id ( dd::Object_id  dd_table_id )

static

Initialize the set of hard coded DD table ids.

Parameters

[in]

dd_table_id

Table id of DD table.

innobase_dict_set_server_version()

static bool innobase_dict_set_server_version ( )

static

Store the current server version number into the header of the dictionary tablespace.

Return values

Operation

outcome, false if no error, otherwise true.

innobase_disable_core_dump()

void innobase_disable_core_dump

(

)

Make sure that core file will not be generated, as generating a core file might violate our promise to not dump buffer pool data, and/or might dump not the expected memory pages due to failure in using madvise.

innobase_encryption_key_rotation()

bool innobase_encryption_key_rotation

(

)

Rotate the encrypted tablespace keys according to master key rotation.

Returns

false on success, true on failure

innobase_flush_logs()

static bool innobase_flush_logs ( handlerton *  hton, bool  binlog_group_flush  )

static

Flush InnoDB redo logs to the file system.

Parameters

[in]	hton	InnoDB handlerton
[in]	binlog_group_flush	true if we got invoked by binlog group commit during flush stage, false in other cases.

Returns

false

innobase_format_name()

void innobase_format_name	(	char *	buf,
		ulint	buflen,
		const char *	name
	)

A wrapper function of innobase_convert_name(), convert a table name to the MySQL system_charset_info (UTF-8) and quote it if needed.

Parameters

[out]	buf	Buffer for converted identifier
[in]	buflen	Length of buf, in bytes
[in]	name	Table name to format

innobase_fts_casedn_str()

size_t innobase_fts_casedn_str	(	CHARSET_INFO *	cs,
		char *	src,
		size_t	src_len,
		char *	dst,
		size_t	dst_len
	)

Makes all characters in a string lower case.

Parameters

[in]	cs	Character set
[in]	src	String to put in lower case
[in]	src_len	Input string length
[in]	dst	Buffer for result string
[in]	dst_len	Buffer size

innobase_fts_close_ranking()

static void innobase_fts_close_ranking ( FT_INFO *  fts_hdl )

static

Free the memory for the FTS handler.

Parameters

[in,out]

fts_hdl

FTS handler

innobase_fts_count_matches()

static ulonglong innobase_fts_count_matches ( FT_INFO_EXT *  fts_hdl )

static

Find and retrieve the size of the current result.

Parameters

[in,out]

fts_hdl

FTS handler

Returns

number of matching rows

Parameters

fts_hdl

in: FTS handler

innobase_fts_create_doc_id_key()

static void innobase_fts_create_doc_id_key ( dtuple_t *  tuple, const dict_index_t *  index, doc_id_t *  doc_id  )

static

Set up search tuple for a query through FTS_DOC_ID_INDEX on supplied Doc ID.

This is used by MySQL to retrieve the documents once the search result (Doc IDs) is available

innobase_fts_find_ranking()

static float innobase_fts_find_ranking ( FT_INFO *  fts_hdl, uchar *  , uint    )

static

Find and Retrieve the FTS Relevance Ranking result for doc with doc_id of m_prebuilt->fts_doc_id.

Parameters

[in,out]

fts_hdl

FTS handler

Returns

the relevance ranking value

innobase_fts_flags()

static ulonglong innobase_fts_flags ( )

static

Returns

Which part of the extended FTS API is supported

innobase_fts_get_version()

static uint innobase_fts_get_version ( )

static

Returns

version of the extended FTS API

innobase_fts_load_stopword()

bool innobase_fts_load_stopword	(	dict_table_t *	table,
		trx_t *	trx,
		THD *	thd
	)

Initialize the table FTS stopword list.

Returns

true if success

Parameters

table	in: Table has the FTS
trx	in: transaction
thd	in: current thread

innobase_fts_nocase_compare()

int innobase_fts_nocase_compare	(	const CHARSET_INFO *	cs,
		const fts_string_t *	s1,
		const fts_string_t *	s2
	)

Compare two FTS character strings case insensitively according to their charset.

This assumes that s1 is already in lower case.

Parameters

[in]	cs	character set
[in]	s1	key
[in]	s2	node

Returns

0 if the two strings are equal

innobase_fts_retrieve_docid()

static ulonglong innobase_fts_retrieve_docid ( FT_INFO_EXT *  fts_hdl )

static

Find and Retrieve the FTS doc_id for the current result row.

Parameters

[in,out]

fts_hdl

FTS handler

Returns

the document ID

innobase_fts_retrieve_ranking()

static float innobase_fts_retrieve_ranking ( FT_INFO *  fts_hdl )

static

Retrieve the FTS Relevance Ranking result for doc with doc_id of m_prebuilt->fts_doc_id.

Parameters

[in,out]

fts_hdl

FTS handler

Returns

the relevance ranking value

innobase_fts_store_docid()

static void innobase_fts_store_docid ( TABLE *  tbl, ulonglong  doc_id  )

static

Store doc_id value into FTS_DOC_ID field.

Parameters

[in,out]	tbl	table containing FULLTEXT index
[in]	doc_id	FTS_DOC_ID value

innobase_fts_text_cmp()

int innobase_fts_text_cmp	(	const void *	cs,
		const void *	p1,
		const void *	p2
	)

Compare two character string according to their charset.

Parameters

[in]	cs	Character set
[in]	p1	Key
[in]	p2	Node

innobase_fts_text_cmp_prefix()

int innobase_fts_text_cmp_prefix	(	const void *	cs,
		const void *	p1,
		const void *	p2
	)

Compare two character string according to their charset.

Parameters

[in]	cs	Character set
[in]	p1	Key
[in]	p2	Node

innobase_get_at_most_n_mbchars()

ulint innobase_get_at_most_n_mbchars	(	ulint	charset_id,
		ulint	prefix_len,
		ulint	data_len,
		const char *	str
	)

This function is used to find the storage length in bytes of the first n characters for prefix indexes using a multibyte character set.

The function finds charset information and returns length of prefix_len characters in the index field in bytes.

Returns

number of bytes occupied by the first n characters

< character length in bytes

< number of characters in prefix

< charset used in the field

Parameters

charset_id	in: character set id
prefix_len	in: prefix length in bytes of the index (this has to be divided by mbmaxlen to get the number of CHARACTERS n in the prefix)
data_len	in: length of the string in bytes
str	in: character string

innobase_get_charset()

const CHARSET_INFO * innobase_get_charset

(

THD *

mysql_thd

)

Determines the connection character set.

Returns

connection character set

Parameters

mysql_thd

in: MySQL thread handle

innobase_get_computed_value()

dfield_t * innobase_get_computed_value	(	const dtuple_t *	row,
		const dict_v_col_t *	col,
		const dict_index_t *	index,
		mem_heap_t **	local_heap,
		mem_heap_t *	heap,
		const dict_field_t *	ifield,
		THD *	thd,
		TABLE *	mysql_table,
		const dict_table_t *	old_table,
		upd_t *	parent_update,
		dict_foreign_t *	foreign
	)

Get the computed value by supplying the base column values.

Parameters

[in,out]	row	the data row
[in]	col	virtual column
[in]	index	index on the virtual column
[in,out]	local_heap	heap memory for processing large data etc.
[in,out]	heap	memory heap that copies the actual index row
[in]	ifield	index field
[in]	thd	MySQL thread handle
[in,out]	mysql_table	mysql table object
[in]	old_table	during ALTER TABLE, this is the old table or NULL.
[in]	parent_update	update vector for the parent row
[in]	foreign	foreign key information

Returns

the field filled with computed value, or NULL if just want to store the value in passed in "my_rec"

innobase_get_cset_width()

void innobase_get_cset_width	(	ulint	cset,
		ulint *	mbminlen,
		ulint *	mbmaxlen
	)

Get the variable length bounds of the given character set.

Parameters

[in]	cset	Mysql charset-collation code
[out]	mbminlen	Minimum length of a char (in bytes)
[out]	mbmaxlen	Maximum length of a char (in bytes)

innobase_get_err_msg()

const char * innobase_get_err_msg

(

int

error_code

)

Get the error message format string.

Returns

the format string or 0 if not found.

Parameters

error_code

in: MySQL error code

innobase_get_field_from_update_vector()

dfield_t * innobase_get_field_from_update_vector	(	dict_foreign_t *	foreign,
		upd_t *	update,
		uint32_t	col_no
	)

Get the updated parent field value from the update vector for the given col_no.

Parameters

[in]	foreign	foreign key information
[in]	update	updated parent vector.
[in]	col_no	base column position of the child table to check

Returns

updated field from the parent update vector, else NULL

innobase_get_index_column_cardinality()

static bool innobase_get_index_column_cardinality ( const char *  db_name, const char *  table_name, const char *  index_name, uint  index_ordinal_position, uint  column_ordinal_position, dd::Object_id  se_private_id, ulonglong *  cardinality  )

static

Retrieve index column cardinality.

Parameters

[in]	db_name	name of schema
[in]	table_name	name of table
[in]	index_name	name of index
[in]	index_ordinal_position	position of index
[in]	column_ordinal_position	position of column in index
[in]	se_private_id	the internal id of the table
[in,out]	cardinality	cardinality of index column

Return values

false	success
true	failure

If the table doesn't have persistent stats then load the table from disk.

innobase_get_lower_case_table_names()

ulint innobase_get_lower_case_table_names

(

void

)

Get the current setting of the lower_case_table_names global parameter from mysqld.cc.

We do a dirty read because for one there is no synchronization object and secondly there is little harm in doing so even if we get a torn read.

Returns

value of lower_case_table_names

innobase_get_multi_value()

void innobase_get_multi_value	(	const TABLE *	mysql_table,
		ulint	f_idx,
		dfield_t *	dfield,
		multi_value_data *	value,
		uint	old_val,
		ulint	comp,
		mem_heap_t *	heap
	)

Parse out multi-values from a MySQL record.

Parameters

[in]	mysql_table	MySQL table structure
[in]	f_idx	field index of the multi-value column
[in,out]	dfield	field structure to store parsed multi-value
[in,out]	value	nullptr or the multi-value structure to store the parsed values
[in]	old_val	old value if exists
[in]	comp	true if InnoDB table uses compact row format
[in,out]	heap	memory heap

innobase_get_multi_value_and_diff()

static void innobase_get_multi_value_and_diff ( const TABLE *  mysql_table, ulint  field_idx, dfield_t *  old_field, dfield_t *  new_field, uint  old_value, ulint  comp, mem_heap_t *  heap  )

static

Parse out multi-values from both old and new MySQL records, at the meantime, calculate the difference between two records.

Parameters

[in]	mysql_table	MySQL table structure
[in]	field_idx	field index of the multi-value column
[in,out]	old_field	field structure to store the parsed old value
[in,out]	new_field	field structure to store the parsed new value
[in]	old_value	old value to parse
[in]	comp	true if InnoDB table uses compact row format
[in,out]	heap	memory heap

innobase_get_mysql_key_number_for_index()

static int innobase_get_mysql_key_number_for_index ( INNOBASE_SHARE *  share, const TABLE *  table, dict_table_t *  ib_table, const dict_index_t *  index  )

static

Calculates the key number used inside MySQL for an Innobase index.

We will first check the "index translation table" for a match of the index to get the index number. If there does not exist an "index translation table", or not able to find the index in the translation table, then we will fall back to the traditional way of looping through dict_index_t list to find a match. In this case, we have to take into account if we generated a default clustered index for the table

Returns

the key number used inside MySQL

Parameters

share	in: share structure for index translation table.
table	in: table in MySQL data dictionary
ib_table	in: table in InnoDB data dictionary
index	in: index

innobase_get_open_files_limit()

long innobase_get_open_files_limit

(

)

Returns current value of the "innodb_open_files" configuration variable.

innobase_get_stmt_safe()

size_t innobase_get_stmt_safe	(	THD *	thd,
		char *	buf,
		size_t	buflen
	)

Determines the current SQL statement.

Thread safe, can be called from any thread as the string is copied into the provided buffer.

Parameters

[in]	thd	MySQL thread handle
[out]	buf	Buffer containing SQL statement
[in]	buflen	Length of provided buffer

Returns

Length of the SQL statement

innobase_get_stmt_unsafe()

const char * innobase_get_stmt_unsafe	(	THD *	thd,
		size_t *	length
	)

Determines the current SQL statement.

Thread unsafe, can only be called from the thread owning the THD.

Parameters

[in]	thd	MySQL thread handle
[out]	length	Length of the SQL statement

Returns

SQL statement string

innobase_get_table_cache_size()

ulint innobase_get_table_cache_size

(

void

)

Get the current setting of the table_def_size global parameter.

Get the current setting of the table_cache_size global parameter.

We do a dirty read because for one there is no synchronization object and secondly there is little harm in doing so even if we get a torn read.

Returns

value of table_def_size

innobase_get_table_statistics()

static bool innobase_get_table_statistics ( const char *  db_name, const char *  table_name, dd::Object_id  se_private_id, const dd::Properties &  ts_se_private_data, const dd::Properties &  tbl_se_private_data, uint  stat_flags, ha_statistics *  stats  )

static

Retrieve table satistics.

Parameters

[in]	db_name	database name
[in]	table_name	table name
[in]	se_private_id	The internal id of the table
[in]	ts_se_private_data	Tablespace SE Private data
[in]	tbl_se_private_data	Table SE private data
[in]	stat_flags	flags used to retrieve specific stats
[in,out]	stats	structure to save the retrieved statistics

Returns

false on success, true on failure

If the table doesn't have persistent stats then load the table from disk.

innobase_get_tablespace_filename_ext()

static const char * innobase_get_tablespace_filename_ext ( )

static

Get tablespace datafile name extension.

Return data filename extension for a InnoDB tablespace.

innobase_get_tablespace_statistics()

static bool innobase_get_tablespace_statistics ( const char *  tablespace_name, const char *  file_name, const dd::Properties &  ts_se_private_data, ha_tablespace_statistics *  stats  )

static

Retrieve ha_tablespace_statistics for the tablespace.

Parameters

	tablespace_name	Tablespace_name
	file_name	Data file name.
	ts_se_private_data	Tablespace SE private data.
[out]	stats	Contains tablespace statistics read from SE.

Returns

false on success, true on failure

Store maximum size

Store autoextend size

innobase_get_tablespace_type()

static bool innobase_get_tablespace_type ( const dd::Tablespace &  space, Tablespace_type *  space_type  )

static

Retrieve the tablespace type.

Parameters

	space	Tablespace object.
[out]	space_type	Tablespace category.

Returns

false on success, true on failure

innobase_get_tablespace_type_by_name()

static bool innobase_get_tablespace_type_by_name ( const char *  tablespace_name, Tablespace_type *  space_type  )

static

Get the tablespace type given the name.

Parameters

[in]	tablespace_name	tablespace name
[out]	space_type	type of space

Returns

Operation status.

Return values

false

on success and true for failure.

innobase_index_cond()

ICP_RESULT innobase_index_cond

(

ha_innobase *

h

)

Index Condition Pushdown interface implementation.

InnoDB index push-down condition check defined in ha_innodb.cc.

InnoDB index push-down condition check

Returns

ICP_NO_MATCH, ICP_MATCH, or ICP_OUT_OF_RANGE

Parameters

h	in/out: pointer to ha_innobase

innobase_index_lookup()

static dict_index_t * innobase_index_lookup ( INNOBASE_SHARE *  share, uint  keynr  )

static

This function uses index translation table to quickly locate the requested index structure.

Note we do not have mutex protection for the index translation table access, it is based on the assumption that there is no concurrent translation table rebuild (fter create/drop index) and DMLs that require index lookup.

Returns

dict_index_t structure for requested index. NULL if fail to locate the index structure.

Parameters

share	in: share structure for index translation table.
keynr	in: index number for the requested index

innobase_index_name_is_reserved()

bool innobase_index_name_is_reserved	(	THD *	thd,
		const KEY *	key_info,
		ulint	num_of_keys
	)

This function checks each index name for a table against reserved system default primary index name 'GEN_CLUST_INDEX'.

If a name matches, this function pushes an warning message to the client, and returns true.

Returns

true if the index name matches the reserved name

Parameters

thd	in/out: MySQL connection
key_info	in: Indexes to be created
num_of_keys	in: Number of indexes to be created.

innobase_init_files()

static int innobase_init_files ( dict_init_mode_t  dict_init_mode, List< const Plugin_tablespace > *  tablespaces  )

static

Open or create InnoDB data files.

Parameters

[in]	dict_init_mode	whether to create or open the files
[in,out]	tablespaces	predefined tablespaces created by the DDSE

Returns

0 on success, 1 on failure

innobase_init_vc_templ()

void innobase_init_vc_templ

(

dict_table_t *

table

)

Get the computed value by supplying the base column values.

Parameters

[in,out]

table

the table whose virtual column template to be built

innobase_is_base_s_col()

static bool innobase_is_base_s_col ( const TABLE *  table, const char *  name  )

static

Check a column (name) is a base column for any stored column in the table.

Parameters

[in]	table	TABLE* for the table
[in]	name	column name to check

Returns

true if this is a base column

innobase_is_dict_readonly()

static bool innobase_is_dict_readonly ( )

static

Check if InnoDB is in a mode where the data dictionary is read-only.

Returns

true if srv_read_only_mode is true or if srv_force_recovery > 0

innobase_is_supported_system_table()

static bool innobase_is_supported_system_table ( const char *  , const char *  , bool  is_sql_layer_system_table  )

static

This function checks if the given db.tablename is a system table supported by Innodb and is used as an initializer for the data member is_supported_system_table of InnoDB storage engine handlerton.

Except general_log and slow_log, currently all system tables are supported by InnoDB. Please don't add any SE-specific system tables here.

Parameters

is_sql_layer_system_table

if the supplied db.table_name is a SQL layer system table.

Returns

whether the table name is supported

innobase_is_valid_tablespace_name()

bool innobase_is_valid_tablespace_name ( ts_command_type  ts_cmd, const char *  name  )

static

Check tablespace name validity.

Parameters

[in]	ts_cmd	whether this is tablespace DDL or not
[in]	name	name to check

Return values

false	invalid name
true	valid name

innobase_kill_connection()

static void innobase_kill_connection ( handlerton *  hton, THD *  thd  )

static

Cancel any pending lock request associated with the current THD.

in: MySQL thread handle for which to close the connection

Parameters

hton	in/out: InnoDB handlerton
thd	in: handle to the MySQL thread being killed

innobase_lock_hton_log()

static bool innobase_lock_hton_log ( handlerton *  hton )

static

Implements Log_resource lock.

Parameters

[in]

hton

the innodb handlerton

Returns

false on success

innobase_match_index_columns()

bool innobase_match_index_columns	(	const KEY *	key_info,
		const dict_index_t *	index_info
	)

Match index columns between MySQL and InnoDB.

This function checks whether the index column information is consistent between KEY info from mysql and that from innodb index.

Parameters

[in]	key_info	Index info from mysql
[in]	index_info	Index info from InnoDB

Returns

true if all column types match.

innobase_mysql_fts_get_token()

ulint innobase_mysql_fts_get_token	(	CHARSET_INFO *	cs,
		const byte *	start,
		const byte *	end,
		fts_string_t *	token
	)

Get the next token from the given string and store it in *token.

It is mostly copied from MyISAM's doc parsing function ft_simple_get_word()

Returns

length of string processed

Parameters

cs	in: Character set
start	in: start of text
end	in: one character past end of text
token	out: token's text

innobase_mysql_print_thd()

void innobase_mysql_print_thd	(	FILE *	f,
		THD *	thd,
		uint	max_query_len
	)

Prints info of a THD object (== user session thread) to the given file.

Parameters

[in]	f	Output stream
[in]	thd	Pointer to a mysql thd object
[in]	max_query_len	Max query length to print, must be positive

Parameters

f	in: output stream
thd	in: MySQL THD object
max_query_len	in: max query length to print, must be positive

innobase_mysql_tmpdir()

char * innobase_mysql_tmpdir

(

)

return any of the tmpdir path

innobase_mysql_tmpfile()

os_fd_t innobase_mysql_tmpfile

(

const char *

path

)

Creates a temporary file in the location specified by the parameter path.

If the path is NULL, then it will be created in –tmpdir.

Parameters

[in]

path

location for creating temporary file

Returns

temporary file descriptor, or OS_FD_CLOSED on error

innobase_next_autoinc()

ulonglong innobase_next_autoinc	(	ulonglong	current,
		ulonglong	need,
		ulonglong	step,
		ulonglong	offset,
		ulonglong	max_value
	)

Compute the next autoinc value.

For MySQL replication the autoincrement values can be partitioned among the nodes. The offset is the start or origin of the autoincrement value for a particular node. For n nodes the increment will be n and the offset will be in the interval [1, n]. The formula tries to allocate the next value for a particular node.

Note: This function is also called with increment set to the number of values we want to reserve for multi-value inserts e.g.,

    INSERT INTO T VALUES(), (), ();

innobase_next_autoinc() will be called with increment set to 3 where autoinc_lock_mode != TRADITIONAL because we want to reserve 3 values for the multi-value INSERT above.

Returns

the next value

Parameters

current	in: Current value
need	in: count of values needed
step	in: AUTOINC increment step
offset	in: AUTOINC offset
max_value	in: max value for type

innobase_nocase_compare()

int innobase_nocase_compare	(	const void *	cs,
		const char *	s1,
		const char *	s2
	)

Compare two character strings case insensitively according to their charset.

Parameters

[in]	cs	character set
[in]	s1	string 1
[in]	s2	string 2

Returns

0 if the two strings are equal

innobase_page_track_get_num_page_ids()

static int innobase_page_track_get_num_page_ids ( uint64_t *  start_id, uint64_t *  stop_id, uint64_t *  num_pages  )

static

Fetch approximate number of tracked pages in the given range.

Parameters

[in,out]

start_id

SE specific sequence number [LSN for Innodb] from where the pages tracked would be returned.

Note

the range might get expanded and the actual start_id used for the querying will be updated.

Parameters

[in,out]

stop_id

SE specific sequence number [LSN for Innodb] until where the pages tracked would be returned.

Note

the range might get expanded and the actual stop_id used for the querying will be updated.

Parameters

[out]

num_pages

number of pages tracked

Returns

Operation status.

Return values

0	Success
other	ER_* mysql error. Get error details from THD.

innobase_page_track_get_page_ids()

static int innobase_page_track_get_page_ids ( Page_Track_Callback  cbk_func, void *  cbk_ctx, uint64_t *  start_id, uint64_t *  stop_id, unsigned char *  buffer, size_t  buffer_len  )

static

Fetch tracked pages.

Parameters

[in]	cbk_func	callback function return page IDs
[in]	cbk_ctx	caller's context for callback
[in,out]	start_id	SE specific sequence number [LSN for Innodb] from where the pages tracked would be returned.

Note

The range might get expanded and the actual start_id used for the querying will be updated.

Parameters

[in,out]

stop_id

SE specific sequence number [LSN for Innodb] until where the pages tracked would be returned.

Note

The range might get expanded and the actual stop_id used for the querying will be updated.

Parameters

[out]	buffer	allocated buffer to copy page IDs
[in]	buffer_len	length of buffer in bytes

Returns

Operation status.

Return values

0	Success
other	ER_* mysql error. Get error details from THD.

innobase_page_track_get_status()

static void innobase_page_track_get_status ( std::vector< std::pair< lsn_t, bool > > &  status )

static

Fetch the page tracking status.

Parameters

[out]

status

vector of a pair of (ID, bool) where ID is the start/stop point and bool is true if the ID is a start point else false

innobase_page_track_purge()

static int innobase_page_track_purge ( uint64_t *  purge_id )

static

Purge page tracking data.

Parameters

[in,out]

purge_id

Purge LSN initially indicating till where the data needs to be purged and finally updated to until where it was actually purged

Returns

Operation status.

Return values

0	Success
other	ER_* mysql error. Get error details from THD.

innobase_page_track_start()

static int innobase_page_track_start ( uint64_t *  start_id )

static

Start page tracking.

Parameters

[out]

start_id

LSN indicating when the tracking was started

Returns

Operation status.

Return values

0	Success
other	ER_* mysql error. Get error details from THD.

innobase_page_track_stop()

static int innobase_page_track_stop ( uint64_t *  stop_id )

static

Stop page tracking.

Parameters

[out]

stop_id

Stop LSN indicating when the tracking was stopped

Returns

Operation status.

Return values

0	Success
other	ER_* mysql error. Get error details from THD.

innobase_parse_hint_from_comment()

void innobase_parse_hint_from_comment	(	THD *	thd,
		dict_table_t *	table,
		const TABLE_SHARE *	table_share
	)

Parse hint for table and its indexes, and update the information in dictionary.

Parameters

[in]	thd	Connection thread
[in,out]	table	Target table
[in]	table_share	Table definition

innobase_parse_merge_threshold()

static ulint innobase_parse_merge_threshold ( THD *  thd, const char *  str  )

static

Parse MERGE_THRESHOLD value from the string.

Parameters

[in]	thd	connection
[in]	str	string which might include 'MERGE_THRESHOLD='

Returns

value parsed. 0 means not found or invalid value.

innobase_partition_flags()

static uint innobase_partition_flags ( )

static

Return partitioning flags.

innobase_peek_autoinc()

static ulonglong innobase_peek_autoinc ( dict_table_t *  innodb_table, bool  print_note  )

static

Read the auto_increment counter of a table, using the AUTOINC lock irrespective of innodb_autoinc_lock_mode.

Parameters

[in,out]	innodb_table	InnoDB table object
[in]	print_note	Print note if not an I_S query.

Returns

the autoinc value

innobase_post_ddl()

static void innobase_post_ddl ( THD *  thd )

static

Perform post-commit/rollback cleanup after DDL statement.

Parameters

[in,out]

thd

connection thread

innobase_post_recover()

static void innobase_post_recover ( )

static

DDL crash recovery: process the records recovered from "log_ddl" table.

innobase_quote_identifier()

void innobase_quote_identifier	(	FILE *	file,
		trx_t *	trx,
		const char *	id
	)

Quote a standard SQL identifier like tablespace, index or column name.

Parameters

[in]	file	output stream
[in]	trx	InnoDB transaction, or NULL
[in]	id	identifier to quote

innobase_raw_format()

ulint innobase_raw_format	(	const char *	data,
		ulint	data_len,
		ulint	charset_coll,
		char *	buf,
		ulint	buf_size
	)

Formats the raw data in "data" (in InnoDB on-disk format) that is of type DATA_(CHAR|VARCHAR|MYSQL|VARMYSQL) using "charset_coll" and writes the result to "buf".

The result is converted to "system_charset_info". Not more than "buf_size" bytes are written to "buf". The result is always NUL-terminated (provided buf_size > 0) and the number of bytes that were written to "buf" is returned (including the terminating NUL).

Returns

number of bytes that were written

Parameters

data	in: raw data
data_len	in: raw data length in bytes
charset_coll	in: charset collation
buf	out: output buffer
buf_size	in: output buffer size in bytes

innobase_read_from_2_little_endian()

static uint innobase_read_from_2_little_endian ( const uchar *  buf )

inlinestatic

Reads an unsigned integer value < 64k from 2 bytes, in the little-endian storage format.

Returns

value

Parameters

buf	in: from where to read

innobase_redo_set_state()

static bool innobase_redo_set_state ( THD *  thd, bool  enable  )

static

Enable or Disable SE write ahead logging.

Parameters

[in]	thd	connection THD
[in]	enable	enable/disable redo logging

Returns

true iff failed.

innobase_register_trx()

void innobase_register_trx	(	handlerton *	hton,
		THD *	thd,
		trx_t *	trx
	)

Registers an InnoDB transaction with the MySQL 2PC coordinator, so that the MySQL XA code knows to call the InnoDB prepare and commit, or rollback for the transaction.

Allocates an InnoDB transaction for a MySQL handler object for DML.

This MUST be called for every transaction for which the user may call commit or rollback. Calling this several times to register the same transaction is allowed, too. This function also registers the current SQL statement.

innobase_release_savepoint()

static int innobase_release_savepoint ( handlerton *  hton, THD *  thd, void *  savepoint  )

static

Release transaction savepoint name.

Returns

0 if success, HA_ERR_NO_SAVEPOINT if no savepoint with the given name in: savepoint data

0 if success, HA_ERR_NO_SAVEPOINT if no savepoint with the given name

Parameters

hton	in/out: handlerton for InnoDB
thd	in: handle to the MySQL thread of the user whose transaction's savepoint should be released
savepoint	in: savepoint data

innobase_rename_vc_templ()

void innobase_rename_vc_templ

(

dict_table_t *

table

)

Change dbname and table name in table->vc_templ.

Parameters

[in,out]

table

the table whose virtual column template dbname and tbname to be renamed.

innobase_rollback()

static int innobase_rollback ( handlerton *  hton, THD *  thd, bool  rollback_trx  )

static

Rolls back a transaction to a savepoint.

Rolls back a transaction or the latest SQL statement.

Returns

0 if success, HA_ERR_NO_SAVEPOINT if no savepoint with the given name in: true - rollback entire transaction false - rollback the current statement only

0 or error number

Parameters

hton	in/out: InnoDB handlerton
thd	in: handle to the MySQL thread of the user whose transaction should be rolled back
rollback_trx	in: true - rollback entire transaction false - rollback the current statement only

innobase_rollback_by_xid()

static xa_status_code innobase_rollback_by_xid ( handlerton *  hton, XID *  xid  )

static

This function is used to rollback one X/Open XA distributed transaction which is in the prepared state.

Returns

0 or error number in: X/Open XA transaction identification

0 or error number

Parameters

hton	in: InnoDB handlerton
xid	in: X/Open XA transaction identification

innobase_rollback_to_savepoint()

static int innobase_rollback_to_savepoint ( handlerton *  hton, THD *  thd, void *  savepoint  )

static

Rolls back a transaction to a savepoint.

Returns

0 if success, HA_ERR_NO_SAVEPOINT if no savepoint with the given name in: savepoint data

0 if success, HA_ERR_NO_SAVEPOINT if no savepoint with the given name

Parameters

hton	in/out: InnoDB handlerton
thd	in: handle to the MySQL thread of the user whose XA transaction should be rolled back to savepoint
savepoint	in: savepoint data

innobase_rollback_to_savepoint_can_release_mdl()

static bool innobase_rollback_to_savepoint_can_release_mdl ( handlerton *  hton, THD *  thd  )

static

Check whether innodb state allows to safely release MDL locks after rollback to savepoint.

Returns

true if it is safe, false if its not safe. in: handle to the MySQL thread of the user whose XA transaction should be rolled back to savepoint

When binlog is on, MDL locks acquired after savepoint unit are not released if there are any locks held in InnoDB.

Returns

true if it is safe, false if its not safe.

Parameters

hton	in/out: InnoDB handlerton
thd	in: handle to the MySQL thread of the user whose transaction should be rolled back to savepoint

innobase_rollback_trx()

static int innobase_rollback_trx ( trx_t *  trx )

static

Rolls back a transaction.

Returns

0 or error number

Parameters

trx	in: transaction

innobase_savepoint()

static int innobase_savepoint ( handlerton *  hton, THD *  thd, void *  savepoint  )

static

Sets a transaction savepoint.

Returns

always 0, that is, always succeeds in: savepoint data

always 0, that is, always succeeds

Parameters

hton	in/out: InnoDB handlerton
thd	in: handle to the MySQL thread of the user's XA transaction for which we need to take a savepoint
savepoint	in: savepoint data

innobase_set_open_files_limit()

void innobase_set_open_files_limit

(

long

new_limit

)

Sets new value of the "innodb_open_files" configuration variable to present to users.

Parameters

[in]

new_limit

new limit to be set.

innobase_set_prepared_in_tc()

static int innobase_set_prepared_in_tc ( handlerton *  hton, THD *  thd  )

static

This function is used to write mark an X/Open XA distributed transaction as been prepared in the server transaction coordinator.

Parameters

[in]	hton	InnoDB handlerton
[in]	thd	handle to the MySQL thread of the user whose XA transaction should be prepared

Returns

0 or error number

innobase_set_prepared_in_tc_by_xid()

static xa_status_code innobase_set_prepared_in_tc_by_xid ( handlerton *  hton, XID *  xid  )

static

Mark an X/Open XA distributed transaction as been prepared in the server transaction coordinator.

Parameters

[in]	hton	InnoDB handlerton
[in]	xid	X/Open XA transaction identification the MySQL thread of the user whosefo the XA transaction that should be prepared

Returns

XA_OK or error number

innobase_should_madvise_buf_pool()

bool innobase_should_madvise_buf_pool

(

)

Checks sys_vars and determines if allocator should mark large memory segments with MADV_DONTDUMP.

Returns

true iff @global.core_file AND NOT @global.innodb_buffer_pool_in_core_file

innobase_show_status()

static bool innobase_show_status ( handlerton *  hton, THD *  thd, stat_print_fn *  stat_print, enum ha_stat_type  stat_type  )

static

Return 0 on success and non-zero on failure.

Note: the bool return type seems to be abused here, should be an int.

Parameters

[in]	hton	the innodb handlerton
[in]	thd	the MySQL query thread of the caller
[in]	stat_print	print function
[in]	stat_type	status to show

innobase_srv_conc_enter_innodb()

static dberr_t innobase_srv_conc_enter_innodb ( row_prebuilt_t *  prebuilt )

inlinestatic

Enter InnoDB engine after checking the max number of user threads allowed, else the thread is put into sleep.

Parameters

[in,out]

prebuilt

row prebuilt handler

Returns

InnoDB error code.

innobase_srv_conc_exit_innodb()

static void innobase_srv_conc_exit_innodb ( row_prebuilt_t *  prebuilt )

inlinestatic

Note that the thread wants to leave InnoDB only if it doesn't have any spare tickets.

Parameters

[in,out]

prebuilt

row prebuilt handler

innobase_srv_conc_force_exit_innodb()

static void innobase_srv_conc_force_exit_innodb ( trx_t *  trx )

inlinestatic

Force a thread to leave InnoDB even if it has spare tickets.

Parameters

trx	in: transaction handle

innobase_start_trx_and_assign_read_view()

static int innobase_start_trx_and_assign_read_view ( handlerton *  hton, THD *  thd  )

static

Creates an InnoDB transaction struct for the thd if it does not yet have one.

Starts a new InnoDB transaction if a transaction is not yet started. And assigns a new snapshot for a consistent read if the transaction does not yet have one.

Returns

0

Parameters

hton	in: InnoDB handlerton
thd	in: MySQL thread handle of the user for whom the transaction should be committed

innobase_store_multi_value()

static bool innobase_store_multi_value ( json_binary::Value &  v, multi_value_data *  value, Field_typed_array *  fld, dfield_t *  dfield, bool  comp, mem_heap_t *  heap  )

inlinestatic

Handle the multi-value array, parse the values and store them.

Parameters

[in]	v	JSON binary that has the mult-value
[out]	value	store the parsed out value
[in]	fld	array Field for the data
[in]	dfield	InnoDB indexed field struct
[in]	comp	if this is new InnoDB row type
[in,out]	heap	heap memory

Returns

true if values are valid and stored, otherwise false

innobase_store_multi_value_low()

static void innobase_store_multi_value_low ( json_binary::Value *  bv, multi_value_data **  valuep, Field_typed_array *  fld, dfield_t *  dfield, ulint  comp, mem_heap_t *  heap  )

static

Parse out multi-value and store in a multi_value_data struct.

Parameters

[in]	bv	JSON binary that has the mult-value
[out]	valuep	store the parsed out value
[in]	fld	Array Field for the data
[in]	dfield	InnoDB indexed field struct
[in]	comp	if this is new InnoDB row type
[in,out]	heap	heap memory

innobase_strcasecmp()

int innobase_strcasecmp	(	const char *	a,
		const char *	b
	)

Compares NUL-terminated UTF-8 strings case insensitively.

Returns

0 if a=b, <0 if a<b, >1 if a>b

Parameters

a	in: first string to compare
b	in: second string to compare

innobase_strnxfrm()

ulint innobase_strnxfrm	(	const CHARSET_INFO *	cs,
		const uchar *	p2,
		const ulint	len2
	)

Get the first character's code position for FTS index partition.

Parameters

[in]	cs	Character set
[in]	p2	string
[in]	len2	string length

innobase_trx_allocate()

trx_t * innobase_trx_allocate

(

THD *

thd

)

Allocates an InnoDB transaction for a MySQL handler object for DML.

Allocates an InnoDB transaction for a MySQL handler object.

Returns

InnoDB transaction handle

Parameters

thd	in: user thread handle

innobase_trx_init()

static void innobase_trx_init ( THD *  thd, trx_t *  trx  )

static

Initializes some fields in an InnoDB transaction object.

Parameters

thd	in: user thread handle
trx	in/out: InnoDB transaction handle

innobase_trx_map_isolation_level()

trx_t::isolation_level_t innobase_trx_map_isolation_level

(

enum_tx_isolation

iso

)

Maps a MySQL trx isolation level code to the InnoDB isolation level code.

Parameters

[in]

iso

MySQL isolation level code

Returns

InnoDB isolation level

innobase_unlock_hton_log()

static bool innobase_unlock_hton_log ( handlerton *  hton )

static

Implements Log_resource unlock.

Parameters

[in]

hton

the innodb handlerton

Returns

false on success

innobase_vcol_build_templ()

static void innobase_vcol_build_templ ( const TABLE *  table, const dict_index_t *  clust_index, Field *  field, const dict_col_t *  col, mysql_row_templ_t *  templ, ulint  col_no  )

static

Build a template for a base column for a virtual column.

Parameters

[in]	table	MySQL TABLE
[in]	clust_index	InnoDB clustered index
[in]	field	field in MySQL table
[in]	col	InnoDB column
[in,out]	templ	template to fill
[in]	col_no	field index for virtual col

innobase_wildcasecmp()

static int innobase_wildcasecmp ( const char *  a, const char *  b  )

static

Compares NUL-terminated UTF-8 strings case insensitively.

The second string contains wildcards.

Returns

0 if a match is found, 1 if not

Parameters

a	in: string to compare
b	in: wildcard string to compare

innobase_xa_prepare()

static int innobase_xa_prepare ( handlerton *  hton, THD *  thd, bool  prepare_trx  )

static

This function is used to prepare an X/Open XA distributed transaction.

Returns

0 or error number in: true - prepare transaction false - the current SQL statement ended

0 or error number

Parameters

hton	in: InnoDB handlerton
thd	in: handle to the MySQL thread of the user whose XA transaction should be prepared
prepare_trx	in: true - prepare transaction false - the current SQL statement ended

innobase_xa_recover()

static int innobase_xa_recover ( handlerton *  hton, XA_recover_txn *  txn_list, uint  len, MEM_ROOT *  mem_root  )

static

This function is used to recover X/Open XA distributed transactions.

Returns

number of prepared transactions stored in xid_list in: memory for table names

number of prepared transactions stored in xid_list

Parameters

hton	in: InnoDB handlerton
txn_list	in/out: prepared transactions
len	in: number of slots in xid_list
mem_root	in: memory for table names

innobase_xa_recover_prepared_in_tc()

static int innobase_xa_recover_prepared_in_tc ( handlerton *  hton, Xa_state_list &  xa_list  )

static

Find prepared transactions that are marked as prepared in TC, for recovery purposes.

Parameters

[in]	hton	InnoDB handlerton
[in,out]	xa_list	prepared transactions state

Returns

0 if successful or error number

innodb_adaptive_hash_index_update()

static void innodb_adaptive_hash_index_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_adaptive_hash_index using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

save	in: immediate result from check function

innodb_alter_tablespace()

static int innodb_alter_tablespace ( handlerton *  hton, THD *  thd, st_alter_tablespace *  alter_info, const dd::Tablespace *  old_dd_space, dd::Tablespace *  new_dd_space  )

static

ALTER an undo tablespace.

Parameters

[in]	hton	Handlerton of InnoDB
[in]	thd	Connection
[in]	alter_info	How to do the command
[in]	old_dd_space	Tablespace metadata
[in]	new_dd_space	Tablespace metadata

Returns

MySQL error code

innodb_alter_undo_tablespace()

static int innodb_alter_undo_tablespace ( handlerton *  hton, st_alter_tablespace *  alter_info, dd::Tablespace *  dd_space  )

static

ALTER an undo tablespace.

Either make it ACTIVE or INACTIVE.

Parameters

[in]	hton	Handlerton of InnoDB
[in]	alter_info	How to do the command
[in]	dd_space	Tablespace metadata

Returns

MySQL error code

innodb_alter_undo_tablespace_active()

static int innodb_alter_undo_tablespace_active ( undo::Tablespace *  undo_space, dd::String_type  dd_state, dd::Tablespace *  dd_space  )

static

ALTER an undo tablespace to ACTIVE.

Parameters

[in]	undo_space	Undo Tablespace object
[in]	dd_state	Current state in the DD.
[in]	dd_space	Tablespace metadata

Returns

MySQL error code

innodb_alter_undo_tablespace_inactive()

static int innodb_alter_undo_tablespace_inactive ( undo::Tablespace *  undo_space, dd::String_type  dd_state, dd::Tablespace *  dd_space  )

static

ALTER an undo tablespace to INACTIVE.

Parameters

[in]	undo_space	Undo Tablespace object
[in]	dd_state	Current state in the DD.
[in]	dd_space	Tablespace metadata

Returns

MySQL error code

innodb_base_col_setup()

void innodb_base_col_setup	(	dict_table_t *	table,
		const Field *	field,
		dict_v_col_t *	v_col
	)

Set up base columns for virtual column.

Parameters

[in]	table	the InnoDB table
[in]	field	MySQL field
[in,out]	v_col	virtual column to be set up

innodb_base_col_setup_for_stored()

void innodb_base_col_setup_for_stored	(	const dict_table_t *	table,
		const Field *	field,
		dict_s_col_t *	s_col
	)

Set up base columns for stored column.

Parameters

[in]	table	InnoDB table
[in]	field	MySQL field
[in,out]	s_col	stored column

innodb_buffer_pool_evict_uncompressed()

static bool innodb_buffer_pool_evict_uncompressed ( void  )

static

Evict all uncompressed pages of compressed tables from the buffer pool.

Keep the compressed pages in the buffer pool.

Returns

whether all uncompressed pages were evicted

innodb_buffer_pool_evict_update()

static void innodb_buffer_pool_evict_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Called on SET GLOBAL innodb_buffer_pool_evict=... Handles some values specially, to evict pages from the buffer pool.

SET GLOBAL innodb_buffer_pool_evict='uncompressed' evicts all uncompressed page frames of compressed tablespaces.

Parameters

[in]

save

immediate result from check function

innodb_buffer_pool_instances_is_set()

static bool innodb_buffer_pool_instances_is_set ( )

inlinestatic

innodb_buffer_pool_size_init()

static void innodb_buffer_pool_size_init ( )

static

Initialize and normalize innodb_buffer_pool_size.

innodb_buffer_pool_size_update()

static void innodb_buffer_pool_size_update ( THD *  thd, SYS_VAR *  , void *  var_ptr, const void *  save  )

static

Update the system variable innodb_buffer_pool_size using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[out]	var_ptr	where the formal string goes
[in]	save	immediate result from check function

innodb_buffer_pool_size_validate()

static bool innodb_buffer_pool_size_validate ( THD *  thd, longlong  buffer_pool_size, ulint &  aligned_buffer_pool_size  )

static

Validate the requested buffer pool size.

Also, reserve the necessary memory needed for buffer pool resize.

Parameters

[in]	thd	thread handle
[in]	buffer_pool_size	buffer pool size value to be validated
[out]	aligned_buffer_pool_size	aligned version of buffer_pool_size if validation succeeds, else original value passed in

Returns

true on success, false on failure.

innodb_change_buffer_max_size_update()

static void innodb_change_buffer_max_size_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_old_blocks_pct using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

save	in: immediate result from check function

innodb_check_fk_column_compat()

static bool innodb_check_fk_column_compat ( const Ha_fk_column_type *  child_column_type, const Ha_fk_column_type *  parent_column_type, bool  check_charsets  )

static

Check if types of child and parent columns in foreign key are compatible.

Parameters

[in]	child_column_type	Child column type description.
[in]	parent_column_type	Parent column type description.
[in]	check_charsets	Indicates whether we need to check that charsets of string columns match. Which is true in most cases.

Returns

True if types are compatible, False if not.

innodb_check_session_admin()

static int innodb_check_session_admin ( THD *  thd, SYS_VAR *  var, void *  save, struct st_mysql_value *  value  )

static

Check if SESSION_VARIABLES_ADMIN granted.

Throw SQL error if not. We also accept SYSTEM_VARIABLES_ADMIN since it doesn't make a lot of sense to be allowed to set the global variable and not the session ones.

Parameters

thd	the session context
var	the system variable to set value for
save	set the updated value
value	A struct that reads us the values from mysqld

Return values

1	failure
0	success

innodb_cmp_per_index_update()

static void innodb_cmp_per_index_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_cmp_per_index using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

save	in: immediate result from check function

innodb_create_tablespace()

static int innodb_create_tablespace ( handlerton *  hton, THD *  thd, st_alter_tablespace *  alter_info, dd::Tablespace *  dd_space  )

static

CREATE a tablespace.

Parameters

[in]	hton	Handlerton of InnoDB
[in]	thd	Connection
[in]	alter_info	How to do the command
[in,out]	dd_space	Tablespace metadata

Returns

MySQL error code

innodb_create_undo_tablespace()

static int innodb_create_undo_tablespace ( handlerton *  hton, THD *  thd, st_alter_tablespace *  alter_info, dd::Tablespace *  dd_space  )

static

CREATE an undo tablespace.

Parameters

[in]	hton	Handlerton of InnoDB
[in]	thd	Connection
[in]	alter_info	How to do the command
[in,out]	dd_space	Tablespace metadata

Returns

MySQL error code

innodb_deinit()

static int innodb_deinit ( MYSQL_PLUGIN  plugin_info )

static

De initialize the InnoDB storage engine plugin.

innodb_disable_monitor_update()

static void innodb_disable_monitor_update ( THD *  thd, SYS_VAR *  , void *  var_ptr, const void *  save  )

static

Update the system variable innodb_monitor_disable and turn off specified monitor counter.

Parameters

[in]	thd	thread handle
[out]	var_ptr	where the formal string goes
[in]	save	immediate result from check function

innodb_drop_tablespace()

static int innodb_drop_tablespace ( handlerton *  hton, THD *  thd, st_alter_tablespace *  alter_info, const dd::Tablespace *  dd_space  )

static

DROP a tablespace.

Parameters

[in]	hton	Handlerton of InnoDB
[in]	thd	Connection
[in]	alter_info	How to do the command
[in]	dd_space	Tablespace metadata

Returns

MySQL error code

innodb_drop_undo_tablespace()

static int innodb_drop_undo_tablespace ( handlerton *  hton, THD *  thd, st_alter_tablespace *  alter_info, const dd::Tablespace *  dd_space  )

static

DROP an undo tablespace.

Parameters

[in]	hton	Handlerton of InnoDB
[in]	thd	Connection
[in]	alter_info	How to do the command
[in]	dd_space	Tablespace metadata

Returns

MySQL error code

innodb_enable_monitor_at_startup()

static void innodb_enable_monitor_at_startup ( char *  str )

static

Parse and enable InnoDB monitor counters during server startup.

User can enable monitor counters/groups by specifying "loose-innodb_monitor_enable = monitor_name1;monitor_name2..." in server configuration file or at the command line. in: monitor counter enable list

User can list the monitor counters/groups to be enable by specifying "loose-innodb_monitor_enable=monitor_name1;monitor_name2..." in server configuration file or at the command line. The string separate could be ";", "," or empty space.

Parameters

str	in/out: monitor counter enable list

innodb_enable_monitor_update()

static void innodb_enable_monitor_update ( THD *  thd, SYS_VAR *  , void *  var_ptr, const void *  save  )

static

Update the system variable innodb_monitor_enable and enable specified monitor counter.

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[out]	var_ptr	where the formal string goes
[in]	save	immediate result from check function

innodb_export_status()

static void innodb_export_status ( )

static

Here we export InnoDB status variables to MySQL.

innodb_extend_and_initialize_update()

static void innodb_extend_and_initialize_update ( THD *  thd, SYS_VAR *  , void *  var_ptr, const void *  save  )

static

Set the variable tbsp_extend_and_initialize.

This function is registered as a callback to MySQL. On Linux, the variable tbsp_extend_and_initialize will be set to the value passed by the user. A warning will be printed that the user is not allowed to change the value if the server is running on Windows or other posix implementations.

Parameters

[in]	thd	thread handle
[out]	var_ptr	value to be set after the validation
[in]	save	value set by the user

innodb_fill_fake_column_struct()

static void innodb_fill_fake_column_struct ( dict_col_t *  col, const Ha_fk_column_type *  fk_col_type  )

static

Constructs fake dict_col_t describing column for foreign key type compatibility check from column description in Ha_fk_column_type form.

Note

dict_col_t which is produced by this call is not valid for general purposes.

Parameters

[out]	col	dict_col_t filled by this function
[in]	fk_col_type	foreign key type information

innodb_fill_old_vcol_val()

static byte * innodb_fill_old_vcol_val ( row_prebuilt_t *  prebuilt, dfield_t *  vfield, ulint  o_len, const byte *  old_mysql_row_col, ulint  col_pack_len, byte *  buf  )

static

Fill the update vector's "old_vrow" field for those non-updated, but indexed columns.

Such columns could still present in the virtual index rec fields even if they are not updated (some other fields updated), so needs to be logged.

Parameters

[in]	prebuilt	InnoDB prebuilt struct
[in,out]	vfield	field to filled
[in]	o_len	actual column length
[in]	old_mysql_row_col	MySQL old field ptr
[in]	col_pack_len	MySQL field col length
[in,out]	buf	buffer for a converted integer value

Returns

used buffer ptr from row_mysql_store_col_in_innobase_format()

innodb_flush_method_is_set()

static bool innodb_flush_method_is_set ( )

inlinestatic

innodb_get_auto_increment_for_uncached()

static uint64_t innodb_get_auto_increment_for_uncached ( dd::Object_id  se_private_id, const dd::Properties &  tbl_se_private_data  )

static

Get the autoincrement for the given table id which is not in the cache.

Parameters

[in]	se_private_id	InnoDB table id
[in]	tbl_se_private_data	table SE private data

Returns

autoincrement value for the given table_id.

Get the auto_increment from the table SE private data.

Get the auto_increment value from innodb_dynamic_metadata table.

innodb_get_table_statistics_for_uncached()

static bool innodb_get_table_statistics_for_uncached ( const char *  db_name, const char *  tbl_name, const char *  norm_name, dd::Object_id  se_private_id, const dd::Properties &  ts_se_private_data, const dd::Properties &  tbl_se_private_data, ulint  stat_flags, ha_statistics *  stats  )

static

Retrieves table statistics only for uncache table only.

Parameters

[in]	db_name	database name
[in]	tbl_name	table name
[in]	norm_name	tablespace name
[in]	se_private_id	InnoDB table id
[in]	ts_se_private_data	tablespace se private data
[in]	tbl_se_private_data	table se private data
[in]	stat_flags	flags used to retrieve specific stats
[in,out]	stats	structure to save the retrieved statistics

Returns

true if the stats information filled successfully

false if tablespace is missing or table doesn't have persistent stats.

Server passes dummy ts_se_private_data for file_per_table tablespace. In that case, InnoDB should find the space_id using the tablespace name.

Tablespace is missing in this case.

innodb_init()

static int innodb_init ( void *  p )

static

Initialize the InnoDB storage engine plugin.

Parameters

[in,out]

p

InnoDB handlerton

Returns

error code

Return values

0	on success

Count of Performance Schema keys that have been registered.

innodb_init_abort()

static int innodb_init_abort ( )

static

Free any resources that were allocated and return failure.

Returns

always return 1

innodb_init_params()

static int innodb_init_params ( )

static

Initialize, validate and normalize the InnoDB startup parameters.

Returns

failure code

Return values

0	on success
HA_ERR_OUT_OF_MEM	when out of memory
HA_ERR_INITIALIZATION	when some parameters are out of range

innodb_internal_table_validate()

static int innodb_internal_table_validate ( THD *  thd, SYS_VAR *  , void *  save, struct st_mysql_value *  value  )

static

Check whether valid argument given to "innodb_fts_internal_tbl_name" This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[out]	save	immediate result for update function
[in]	value	incoming string

Returns

0 for valid stopword table

innodb_io_capacity_max_is_set()

static bool innodb_io_capacity_max_is_set ( )

inlinestatic

innodb_io_capacity_max_update()

static void innodb_io_capacity_max_update ( THD *  thd, SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_io_capacity_max using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

thd	in: thread handle
save	in: immediate result from check function

innodb_io_capacity_max_update_default()

static void innodb_io_capacity_max_update_default ( ulong  new_def )

static

Update the mysql_sysvar_io_capacity_max's default value.

Parameters

[in]

new_def

New default value

innodb_io_capacity_update()

static void innodb_io_capacity_update ( THD *  thd, SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_io_capacity using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

thd	in: thread handle
save	in: immediate result from check function

innodb_log_buffer_size_update()

static void innodb_log_buffer_size_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_log_buffer_size using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

[in]

save

immediate result from check function

innodb_log_checksums_func_update()

static void innodb_log_checksums_func_update ( bool  check )

static

Update log_checksum_algorithm_ptr with a pointer to the function corresponding to whether checksums are enabled.

Parameters

[in]

check

whether redo log block checksums are enabled

innodb_log_checksums_update()

static void innodb_log_checksums_update ( THD *  , SYS_VAR *  , void *  var_ptr, const void *  save  )

static

Update the innodb_log_checksums parameter.

Parameters

[out]	var_ptr	current value
[in]	save	immediate result from check function

innodb_log_file_size_is_set()

bool innodb_log_file_size_is_set

(

)

innodb_log_n_files_is_set()

bool innodb_log_n_files_is_set

(

)

innodb_log_write_ahead_size_update()

static void innodb_log_write_ahead_size_update ( THD *  thd, SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_log_write_ahead_size using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[in]	save	immediate result from check function

innodb_log_writer_threads_update()

static void innodb_log_writer_threads_update ( THD *  , SYS_VAR *  , void *  var_ptr, const void *  save  )

static

Update the innodb_log_writer_threads parameter.

Parameters

[out]	var_ptr	current value
[in]	save	immediate result from check function

innodb_make_page_dirty()

static void innodb_make_page_dirty ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Make the first page of given user tablespace dirty.

Parameters

save	in: immediate result from check function

innodb_max_dirty_pages_pct_lwm_update()

static void innodb_max_dirty_pages_pct_lwm_update ( THD *  thd, SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_max_dirty_pages_pct_lwm using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

thd	in: thread handle
save	in: immediate result from check function

innodb_max_dirty_pages_pct_update()

static void innodb_max_dirty_pages_pct_update ( THD *  thd, SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_max_dirty_pages_pct using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

thd	in: thread handle
save	in: immediate result from check function

innodb_merge_threshold_set_all_debug_update()

static void innodb_merge_threshold_set_all_debug_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Override current MERGE_THRESHOLD setting for all indexes at dictionary now.

Parameters

[in]

save

immediate result from check function

innodb_monitor_id_by_name_get()

static ulint innodb_monitor_id_by_name_get ( const char *  name )

static

Given a configuration variable name, find corresponding monitor counter and return its monitor ID if found.

Returns

monitor ID if found, MONITOR_NO_MATCH if there is no match

Parameters

name	in: monitor counter namer

innodb_monitor_set_option()

static void innodb_monitor_set_option ( const monitor_info_t *  monitor_info, mon_option_t  set_option  )

static

Update the monitor counter according to the "set_option", turn on/off or reset specified monitor counter.

Parameters

monitor_info	in: monitor info for the monitor to set
set_option	in: Turn on/off reset the counter

innodb_monitor_update()

static void innodb_monitor_update ( THD *  thd, void *  var_ptr, const void *  save, mon_option_t  set_option, bool  free_mem  )

static

Update the system variable innodb_enable(disable/reset/reset_all)_monitor according to the "set_option" and turn on/off or reset specified monitor counter.

Parameters

thd	in: thread handle
var_ptr	out: where the formal string goes
save	in: immediate result from check function
set_option	in: the set option, whether to turn on/off or reset the counter
free_mem	in: whether we will need to free the memory

innodb_monitor_update_wildcard()

static void innodb_monitor_update_wildcard ( const char *  name, mon_option_t  set_option  )

static

Find matching InnoDB monitor counters and update their status according to the "set_option", turn on/off or reset specified monitor counter.

Parameters

name	in: monitor name to match
set_option	in: the set option, whether to turn on/off or reset the counter

innodb_monitor_valid_byname()

static int innodb_monitor_valid_byname ( void *  save, const char *  name  )

static

Validate the passed in monitor name, find and save the corresponding monitor name in the function parameter "save".

Returns

0 if monitor name is valid

Parameters

save	out: immediate result for update function
name	in: incoming monitor name

innodb_monitor_validate()

static int innodb_monitor_validate ( THD *  , SYS_VAR *  , void *  save, struct st_mysql_value *  value  )

static

Validate passed-in "value" is a valid monitor counter name.

This function is registered as a callback with MySQL.

Returns

0 for valid name

Parameters

save	out: immediate result for update function
value	in: incoming string

innodb_monitor_validate_wildcard_name()

static bool innodb_monitor_validate_wildcard_name ( const char *  name )

static

Validate that the passed in monitor name matches at least one monitor counter name with wildcard compare.

Returns

true if at least one monitor name matches

Parameters

name	in: monitor counter namer

innodb_old_blocks_pct_update()

static void innodb_old_blocks_pct_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_old_blocks_pct using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

save	in: immediate result from check function

innodb_page_cleaners_is_set()

static bool innodb_page_cleaners_is_set ( )

inlinestatic

innodb_pre_dd_shutdown()

static void innodb_pre_dd_shutdown ( handlerton *  )

static

Shut down all InnoDB background tasks that may access the Global Data Dictionary, before the Global Data Dictionary and the rest of InnoDB have been shut down.

See also

dd::shutdown()

innodb_shutdown()

innodb_rec_per_key()

rec_per_key_t innodb_rec_per_key	(	const dict_index_t *	index,
		ulint	i,
		ha_rows	records
	)

Calculate Record Per Key value.

Need to exclude the NULL value if innodb_stats_method is set to "nulls_ignored"

Parameters

[in]	index	InnoDB index.
[in]	i	The column we are calculating rec per key.
[in]	records	Estimated total records.

Returns

estimated record per key value

innodb_redo_log_capacity_init()

static void innodb_redo_log_capacity_init ( )

static

Initialize srv_redo_log_capacity / srv_redo_log_capacity_used.

innodb_redo_log_capacity_is_set()

static bool innodb_redo_log_capacity_is_set ( )

static

innodb_redo_log_capacity_update()

static void innodb_redo_log_capacity_update ( THD *  thd, SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_redo_log_capacity using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[in]	save	immediate result from check function

innodb_redo_log_capacity_update_default()

static void innodb_redo_log_capacity_update_default ( ulonglong  new_def )

static

Update the mysql_sysvar_redo_log_capacity's default value.

Parameters

[in]

new_def

New default value

innodb_replace_trx_in_thd()

static void innodb_replace_trx_in_thd ( THD *  thd, void *  new_trx_arg, void **  ptr_trx_arg  )

static

InnoDB transaction object that is currently associated with THD is replaced with that of the 2nd argument.

The previous value is returned through the 3rd argument's buffer, unless it's NULL. When the buffer is not provided (value NULL) that should mean the caller restores previously saved association so the current trx has to be additionally freed from all association with MYSQL.

Parameters

[in,out]	thd	MySQL thread handle
[in]	new_trx_arg	replacement trx_t
[in,out]	ptr_trx_arg	pointer to a buffer to store old trx_t

innodb_reset_all_monitor_update()

static void innodb_reset_all_monitor_update ( THD *  thd, SYS_VAR *  , void *  var_ptr, const void *  save  )

static

Update the system variable innodb_monitor_reset_all and reset all value related monitor counter.

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[out]	var_ptr	where the formal string goes
[in]	save	immediate result from check function

innodb_reset_monitor_update()

static void innodb_reset_monitor_update ( THD *  thd, SYS_VAR *  , void *  var_ptr, const void *  save  )

static

Update the system variable innodb_monitor_reset and reset specified monitor counter(s).

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[out]	var_ptr	where the formal string goes
[in]	save	immediate result from check function

innodb_rollback_segments_update()

static void innodb_rollback_segments_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Update the number of rollback segments per tablespace when the system variable innodb_rollback_segments is changed.

This function is registered as a callback with MySQL.

Parameters

[in]

save

immediate result from check function

innodb_save_page_no()

static void innodb_save_page_no ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Save an InnoDB page number.

Parameters

save	in: immediate result from check function

innodb_set_buf_pool_size()

void innodb_set_buf_pool_size

(

long long

buf_pool_size

)

Update the system variable with the given value of the InnoDB buffer pool size.

Parameters

[in]

buf_pool_size

given value of buffer pool size.

innodb_show_latch_status()

static int innodb_show_latch_status ( handlerton *  hton, THD *  thd, stat_print_fn *  stat_print  )

static

Implements the SHOW MUTEX STATUS command.

Parameters

[in,out]	hton	the innodb handlerton
[in,out]	thd	the MySQL query thread of the caller
[in,out]	stat_print	function for printing statistics

Returns

0 on success.

innodb_show_mutex_status()

static int innodb_show_mutex_status ( handlerton *  hton, THD *  thd, stat_print_fn *  stat_print  )

static

Implements the SHOW MUTEX STATUS command, for mutexes.

Parameters

[in,out]	hton	the innodb handlerton
[in,out]	thd	the MySQL query thread of the caller
[in,out]	stat_print	function for printing statistics

Returns

0 on success.

innodb_show_rwlock_status()

static int innodb_show_rwlock_status ( handlerton *  hton, THD *  thd, stat_print_fn *  stat_print  )

static

Implements the SHOW MUTEX STATUS command.

Parameters

[in,out]	hton	the innodb handlerton
[in,out]	thd	the MySQL query thread of the caller
[in,out]	stat_print	function for printing statistics

Returns

0 on success.

innodb_show_status()

static int innodb_show_status ( handlerton *  hton, THD *  thd, stat_print_fn *  stat_print  )

static

Implements the SHOW ENGINE INNODB STATUS command.

Sends the output of the InnoDB Monitor to the client.

Parameters

[in]	hton	the innodb handlerton
[in]	thd	the MySQL query thread of the caller
[in]	stat_print	print function

Returns

0 on success

innodb_shutdown()

static int innodb_shutdown ( handlerton *  , ha_panic_function    )

static

Shut down InnoDB after the Global Data Dictionary has been shut down.

See also

innodb_pre_dd_shutdown()

Return values

0

always

innodb_space_shutdown()

static void innodb_space_shutdown ( )

static

Free tablespace resources.

innodb_srv_buf_dump_filename_validate()

static int innodb_srv_buf_dump_filename_validate ( THD *  thd, SYS_VAR *  , void *  save, struct st_mysql_value *  value  )

static

Validate if passed-in "value" is a valid value for innodb_buffer_pool_filename.

On Windows, file names with colon (:) are not allowed.

Parameters

[in]	thd	thread handle
[in]	save	immediate result from update function
[in]	value	incoming string

Returns

0 for valid name

innodb_srv_buffer_pool_in_core_file_update()

static void innodb_srv_buffer_pool_in_core_file_update ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

innodb_stopword_table_validate()

static int innodb_stopword_table_validate ( THD *  thd, SYS_VAR *  var, void *  save, struct st_mysql_value *  value  )

static

Check whether valid argument given to innobase_*_stopword_table.

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[in]	var	pointer to system variable
[out]	save	immediate result for update function
[in]	value	incoming string

Returns

0 for valid stopword table

innodb_thread_concurrency_update()

static void innodb_thread_concurrency_update ( THD *  thd, SYS_VAR *  , void *  , const void *  save  )

static

Update the system variable innodb_thread_concurrency using the "saved" value.

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[in]	save	immediate result from check function

innodb_tmpdir_validate()

static int innodb_tmpdir_validate ( THD *  thd, SYS_VAR *  , void *  save, struct st_mysql_value *  value  )

static

Validate passed-in "value" is a valid directory name.

This function is registered as a callback with MySQL.

Parameters

[in,out]	thd	thread handle
[out]	save	immediate result for update
[in]	value	incoming string

Returns

0 for valid name

innodb_undo_tablespaces_deprecate()

static void innodb_undo_tablespaces_deprecate ( )

static

Validate innodb_undo_tablespaces.

Log a warning if it was set explicitly.

innodb_undo_tablespaces_update()

static void innodb_undo_tablespaces_update ( THD *  thd, SYS_VAR *  var, void *  var_ptr, const void *  save  )

static

Validate the value of innodb_undo_tablespaces global variable.

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[in]	var	pointer to system variable
[in]	var_ptr	where the formal string goes
[in]	save	immediate result from check function

innodb_variable_is_set()

template<size_t N>

static bool innodb_variable_is_set ( const char(&)  var_name[N] )

static

log_flush_now_set()

static void log_flush_now_set ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Force InnoDB to flush redo log up to current_lsn.

This function is registered as a callback with MySQL.

Parameters

[in]

save

immediate result from check function

mysql_declare_plugin()

mysql_declare_plugin

(

innobase

)

MYSQL_SYSVAR_BOOL() [1/59]

static MYSQL_SYSVAR_BOOL ( adaptive_flushing  , srv_adaptive_flushing  , PLUGIN_VAR_NOCMDARG  , "Attempt flushing dirty pages to avoid IO bursts at checkpoints."  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [2/59]

static MYSQL_SYSVAR_BOOL ( adaptive_hash_index  , srv_btr_search_enabled  , PLUGIN_VAR_OPCMDARG  , "Enable InnoDB adaptive hash index (enabled by default). " " Disable with --skip-innodb-adaptive-hash-index."  , nullptr  , innodb_adaptive_hash_index_update  , false    )

static

MYSQL_SYSVAR_BOOL() [3/59]

static MYSQL_SYSVAR_BOOL ( api_disable_rowlock  , ib_disable_row_lock  , PLUGIN_VAR_NOCMDARG|  PLUGIN_VAR_READONLY, "Disable row lock when direct access InnoDB through InnoDB APIs"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [4/59]

static MYSQL_SYSVAR_BOOL ( api_enable_binlog  , ib_binlog_enabled  , PLUGIN_VAR_NOCMDARG|  PLUGIN_VAR_READONLY, "Enable binlog for applications direct access InnoDB through InnoDB APIs"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [5/59]

static MYSQL_SYSVAR_BOOL ( api_enable_mdl  , ib_mdl_enabled  , PLUGIN_VAR_NOCMDARG|  PLUGIN_VAR_READONLY, "Enable MDL for applications direct access InnoDB through InnoDB APIs"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [6/59]

static MYSQL_SYSVAR_BOOL ( background_drop_list_empty  , innodb_background_drop_list_empty  , PLUGIN_VAR_OPCMDARG  , "Wait for the background drop list to become empty"  , nullptr  , wait_background_drop_list_empty  , false    )

static

MYSQL_SYSVAR_BOOL() [7/59]

static MYSQL_SYSVAR_BOOL ( buf_flush_list_now  , innodb_buf_flush_list_now  , PLUGIN_VAR_OPCMDARG  , "Force dirty page flush now"  , nullptr  , buf_flush_list_now_set  , false    )

static

MYSQL_SYSVAR_BOOL() [8/59]

static MYSQL_SYSVAR_BOOL ( buffer_pool_debug  , srv_buf_pool_debug  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_READONLY, "Enable buffer pool debug"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [9/59]

static MYSQL_SYSVAR_BOOL ( buffer_pool_dump_at_shutdown  , srv_buffer_pool_dump_at_shutdown  , PLUGIN_VAR_RQCMDARG  , "Dump the buffer pool into a file named @@innodb_buffer_pool_filename"  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [10/59]

static MYSQL_SYSVAR_BOOL ( buffer_pool_dump_now  , innodb_buffer_pool_dump_now  , PLUGIN_VAR_RQCMDARG  , "Trigger an immediate dump of the buffer pool into a " "file named @@innodb_buffer_pool_filename"  , nullptr  , buffer_pool_dump_now  , false    )

static

MYSQL_SYSVAR_BOOL() [11/59]

static MYSQL_SYSVAR_BOOL ( buffer_pool_in_core_file  , srv_buffer_pool_in_core_file  , PLUGIN_VAR_NOCMDARG  , "This option has no effect if @@core_file is OFF. " "If @@core_file is  ON, and this option is  OFF, then the core dump file will" " be generated only if it is possible to exclude buffer pool from it. " "As soon as it will be determined that such exclusion is impossible a " "warning will be emitted and @ @core_file will be set to OFF to prevent " "generating a core dump. If this option is enabled then core dumping logic " "will not be affected. This option is disabled by default if the platforms " "supports  MADV_DONTDUMP, otherwise it is enabled by default."  , nullptr  , innodb_srv_buffer_pool_in_core_file_update  , BP_IN_CORE_DEFAULT    )

static

MYSQL_SYSVAR_BOOL() [12/59]

static MYSQL_SYSVAR_BOOL ( buffer_pool_load_abort  , innodb_buffer_pool_load_abort  , PLUGIN_VAR_RQCMDARG  , "Abort a currently running load of the buffer pool"  , nullptr  , buffer_pool_load_abort  , false    )

static

MYSQL_SYSVAR_BOOL() [13/59]

static MYSQL_SYSVAR_BOOL ( buffer_pool_load_at_startup  , srv_buffer_pool_load_at_startup  , PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "Load the buffer pool from a file named @@innodb_buffer_pool_filename"  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [14/59]

static MYSQL_SYSVAR_BOOL ( buffer_pool_load_now  , innodb_buffer_pool_load_now  , PLUGIN_VAR_RQCMDARG  , "Trigger an immediate load of the buffer pool from a " "file named @@innodb_buffer_pool_filename"  , nullptr  , buffer_pool_load_now  , false    )

static

MYSQL_SYSVAR_BOOL() [15/59]

static MYSQL_SYSVAR_BOOL ( checkpoint_disabled  , srv_checkpoint_disabled  , PLUGIN_VAR_OPCMDARG  , "Disable checkpoints"  , nullptr  , checkpoint_disabled_update  , false    )

static

MYSQL_SYSVAR_BOOL() [16/59]

static MYSQL_SYSVAR_BOOL ( cmp_per_index_enabled  , srv_cmp_per_index_enabled  , PLUGIN_VAR_OPCMDARG  , "Enable INFORMATION_SCHEMA.  innodb_cmp_per_index, " " may have negative impact on performance(off by default)"  , nullptr  , innodb_cmp_per_index_update  , false    )

static

MYSQL_SYSVAR_BOOL() [17/59]

static MYSQL_SYSVAR_BOOL ( ddl_log_crash_reset_debug  , innodb_ddl_log_crash_reset_debug  , PLUGIN_VAR_OPCMDARG  , "Reset all crash injection counters to 1"  , nullptr  , ddl_log_crash_reset  , false    )

static

MYSQL_SYSVAR_BOOL() [18/59]

static MYSQL_SYSVAR_BOOL ( deadlock_detect  , innobase_deadlock_detect  , PLUGIN_VAR_NOCMDARG  , "Enable/disable InnoDB deadlock detector (default ON)." " if set to  OFF, deadlock detection is  skipped, " " and we rely on innodb_lock_wait_timeout in case of deadlock."  , nullptr  , innobase_deadlock_detect_update  , true    )

static

MYSQL_SYSVAR_BOOL() [19/59]

static MYSQL_SYSVAR_BOOL ( dedicated_server  , srv_dedicated_server  , PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_NOPERSIST|  PLUGIN_VAR_READONLY, "Automatically scale innodb_buffer_pool_size and innodb_redo_log_capacity " "based on system memory."  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [20/59]

static MYSQL_SYSVAR_BOOL ( dict_stats_disabled_debug  , innodb_dict_stats_disabled_debug  , PLUGIN_VAR_OPCMDARG  , "Disable dict_stats thread"  , nullptr  , dict_stats_disabled_debug_update  , false    )

static

MYSQL_SYSVAR_BOOL() [21/59]

static MYSQL_SYSVAR_BOOL ( disable_background_merge  , srv_ibuf_disable_background_merge  , PLUGIN_VAR_NOCMDARG|  PLUGIN_VAR_RQCMDARG, "Disable change buffering merges by the master thread"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [22/59]

static MYSQL_SYSVAR_BOOL ( disable_sort_file_cache  , srv_disable_sort_file_cache  , PLUGIN_VAR_OPCMDARG  , "Whether to disable OS system file cache for sort I/O"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [23/59]

static MYSQL_SYSVAR_BOOL ( extend_and_initialize  , tbsp_extend_and_initialize  , PLUGIN_VAR_NOCMDARG  , "Initialize the allocated space by writing zeros (enabled by default)."  , nullptr  , innodb_extend_and_initialize_update  , true    )

static

MYSQL_SYSVAR_BOOL() [24/59]

static MYSQL_SYSVAR_BOOL ( file_per_table  , srv_file_per_table  , PLUGIN_VAR_NOCMDARG  , "Stores each InnoDB table to an .ibd file in the database dir."  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [25/59]

static MYSQL_SYSVAR_BOOL ( flush_sync  , srv_flush_sync  , PLUGIN_VAR_NOCMDARG  , "Allow IO bursts at the checkpoints ignoring io_capacity setting."  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [26/59]

static MYSQL_SYSVAR_BOOL ( force_load_corrupted  , srv_load_corrupted  , PLUGIN_VAR_NOCMDARG|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "Force InnoDB to load metadata of corrupted table."  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [27/59]

static MYSQL_SYSVAR_BOOL ( ft_enable_diag_print  , fts_enable_diag_print  , PLUGIN_VAR_OPCMDARG  , "Whether to enable additional FTS diagnostic printout "  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [28/59]

static MYSQL_SYSVAR_BOOL ( log_checkpoint_fuzzy_now  , innodb_log_checkpoint_fuzzy_now  , PLUGIN_VAR_OPCMDARG  , "Force fuzzy checkpoint now"  , nullptr  , checkpoint_fuzzy_now_set  , false    )

static

MYSQL_SYSVAR_BOOL() [29/59]

static MYSQL_SYSVAR_BOOL ( log_checkpoint_now  , innodb_log_checkpoint_now  , PLUGIN_VAR_OPCMDARG  , "Force sharp checkpoint now"  , nullptr  , checkpoint_now_set  , false    )

static

MYSQL_SYSVAR_BOOL() [30/59]

static MYSQL_SYSVAR_BOOL ( log_checksums  , srv_log_checksums  , PLUGIN_VAR_RQCMDARG  , "Whether to compute and require checksums for InnoDB redo log blocks"  , nullptr  , innodb_log_checksums_update  , true    )

static

MYSQL_SYSVAR_BOOL() [31/59]

static MYSQL_SYSVAR_BOOL ( log_compressed_pages  , page_zip_log_pages  , PLUGIN_VAR_OPCMDARG  , "Enables/disables the logging of entire compressed page images." " InnoDB logs the compressed pages to prevent corruption if" " the zlib compression algorithm changes." " When turned  OFF, InnoDB will assume that the zlib" " compression algorithm doesn 't change."  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [32/59]

static MYSQL_SYSVAR_BOOL ( log_flush_now  , innodb_log_flush_now  , PLUGIN_VAR_OPCMDARG  , "Force flush of redo up to current lsn"  , nullptr  , log_flush_now_set  , false    )

static

MYSQL_SYSVAR_BOOL() [33/59]

static MYSQL_SYSVAR_BOOL ( log_writer_threads  , srv_log_writer_threads  , PLUGIN_VAR_RQCMDARG  , "Whether the log writer threads should be activated   ON, or write/flush " "of the redo log should be done by each thread individually(OFF)."  , nullptr  , innodb_log_writer_threads_update  , true    )

static

MYSQL_SYSVAR_BOOL() [34/59]

static MYSQL_SYSVAR_BOOL ( master_thread_disabled_debug  , srv_master_thread_disabled_debug  , PLUGIN_VAR_OPCMDARG  , "Disable master thread"  , nullptr  , srv_master_thread_disabled_debug_update  , false    )

static

MYSQL_SYSVAR_BOOL() [35/59]

static MYSQL_SYSVAR_BOOL ( numa_interleave  , srv_numa_interleave  , PLUGIN_VAR_NOCMDARG|  PLUGIN_VAR_READONLY, "Use NUMA interleave memory policy to allocate InnoDB buffer pool."  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [36/59]

static MYSQL_SYSVAR_BOOL ( optimize_fulltext_only  , innodb_optimize_fulltext_only  , PLUGIN_VAR_NOCMDARG  , "Only optimize the Fulltext index of the table"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [37/59]

static MYSQL_SYSVAR_BOOL ( page_cleaner_disabled_debug  , innodb_page_cleaner_disabled_debug  , PLUGIN_VAR_OPCMDARG  , "Disable page cleaner"  , nullptr  , buf_flush_page_cleaner_disabled_debug_update  , false    )

static

MYSQL_SYSVAR_BOOL() [38/59]

static MYSQL_SYSVAR_BOOL ( print_all_deadlocks  , srv_print_all_deadlocks  , PLUGIN_VAR_OPCMDARG  , "Print all deadlocks to MySQL error log (off by default)"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [39/59]

static MYSQL_SYSVAR_BOOL ( print_ddl_logs  , srv_print_ddl_logs  , PLUGIN_VAR_OPCMDARG  , "Print all DDl logs to MySQL error log (off by default)"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [40/59]

static MYSQL_SYSVAR_BOOL ( purge_run_now  , innodb_purge_run_now  , PLUGIN_VAR_OPCMDARG  , "Set purge state to RUN"  , nullptr  , purge_run_now_set  , false    )

static

MYSQL_SYSVAR_BOOL() [41/59]

static MYSQL_SYSVAR_BOOL ( purge_stop_now  , innodb_purge_stop_now  , PLUGIN_VAR_OPCMDARG  , "Set purge state to STOP"  , nullptr  , purge_stop_now_set  , false    )

static

MYSQL_SYSVAR_BOOL() [42/59]

static MYSQL_SYSVAR_BOOL ( random_read_ahead  , srv_random_read_ahead  , PLUGIN_VAR_NOCMDARG  , "Whether to use read ahead for random access within an extent."  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [43/59]

static MYSQL_SYSVAR_BOOL ( read_only  , srv_read_only_mode  , PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "Start InnoDB in read only mode (off by default)"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [44/59]

static MYSQL_SYSVAR_BOOL ( redo_log_encrypt  , srv_redo_log_encrypt  , PLUGIN_VAR_OPCMDARG  , "Enable or disable Encryption of REDO tablespace."  , validate_innodb_redo_log_encrypt  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [45/59]

static MYSQL_SYSVAR_BOOL ( rollback_on_timeout  , innobase_rollback_on_timeout  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_READONLY, "Roll back the complete transaction on lock wait " "  timeout, for 4.x compatibility(disabled by default)"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [46/59]

static MYSQL_SYSVAR_BOOL ( stats_auto_recalc  , srv_stats_auto_recalc  , PLUGIN_VAR_OPCMDARG  , "InnoDB automatic recalculation of persistent statistics enabled for all" " tables unless overridden at table level (automatic recalculation is only" " done when InnoDB decides that the table has changed too much and needs a" " new statistics)"  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [47/59]

static MYSQL_SYSVAR_BOOL ( stats_include_delete_marked  , srv_stats_include_delete_marked  , PLUGIN_VAR_OPCMDARG  , "Include delete marked records when calculating persistent statistics"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [48/59]

static MYSQL_SYSVAR_BOOL ( stats_on_metadata  , innobase_stats_on_metadata  , PLUGIN_VAR_OPCMDARG  , "Enable statistics gathering for metadata commands such as" " SHOW TABLE STATUS for tables that use transient statistics (off by " "default)"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [49/59]

static MYSQL_SYSVAR_BOOL ( stats_persistent  , srv_stats_persistent  , PLUGIN_VAR_OPCMDARG  , "InnoDB persistent statistics enabled for all tables unless overridden" " at table level"  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [50/59]

static MYSQL_SYSVAR_BOOL ( status_file  , innobase_create_status_file  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_NOSYSVAR, "Enable SHOW ENGINE INNODB STATUS output in the innodb_status.<pid> file"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [51/59]

static MYSQL_SYSVAR_BOOL ( status_output  , srv_print_innodb_monitor  , PLUGIN_VAR_OPCMDARG  , "Enable InnoDB monitor output to the error log."  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [52/59]

static MYSQL_SYSVAR_BOOL ( status_output_locks  , srv_print_innodb_lock_monitor  , PLUGIN_VAR_OPCMDARG    )

static

MYSQL_SYSVAR_BOOL() [53/59]

static MYSQL_SYSVAR_BOOL ( sync_debug  , srv_sync_debug  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_READONLY, "Enable the sync debug checks"  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [54/59]

static MYSQL_SYSVAR_BOOL ( trx_purge_view_update_only_debug  , srv_purge_view_update_only_debug  , PLUGIN_VAR_NOCMDARG  , "Pause actual purging any delete-marked  records, but " "merely update the purge view." " It is to create artificially the situation the " "purge view have been updated" " but the each purges were not done yet."  , nullptr  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [55/59]

static MYSQL_SYSVAR_BOOL ( undo_log_encrypt  , srv_undo_log_encrypt  , PLUGIN_VAR_OPCMDARG  , "Enable or disable Encrypt of UNDO tablespace."  , validate_innodb_undo_log_encrypt  , nullptr  , false    )

static

MYSQL_SYSVAR_BOOL() [56/59]

static MYSQL_SYSVAR_BOOL ( undo_log_truncate  , srv_undo_log_truncate  , PLUGIN_VAR_OPCMDARG  , "Enable or Disable Truncate of UNDO tablespace."  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [57/59]

static MYSQL_SYSVAR_BOOL ( use_fdatasync  , srv_use_fdatasync  , PLUGIN_VAR_NOCMDARG  , "Use fdatasync() instead of the default fsync()."  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [58/59]

static MYSQL_SYSVAR_BOOL ( use_native_aio  , srv_use_native_aio  , PLUGIN_VAR_NOCMDARG|  PLUGIN_VAR_READONLY, "Use native AIO if supported on this platform."  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_BOOL() [59/59]

static MYSQL_SYSVAR_BOOL ( validate_tablespace_paths  , srv_validate_tablespace_paths  , PLUGIN_VAR_NOCMDARG|  PLUGIN_VAR_READONLY, "Enable validation of tablespace paths against the DD. (enabled by " "default)." " Disable with --skip-innodb-validate-tablespace-paths."  , nullptr  , nullptr  , true    )

static

MYSQL_SYSVAR_DOUBLE() [1/3]

static MYSQL_SYSVAR_DOUBLE ( max_dirty_pages_pct  , srv_max_buf_pool_modified_pct  , PLUGIN_VAR_RQCMDARG  , "Percentage of dirty pages allowed in bufferpool."  , nullptr  , innodb_max_dirty_pages_pct_update  , 90.  0, 0  , 99.  999, 0    )

static

MYSQL_SYSVAR_DOUBLE() [2/3]

static MYSQL_SYSVAR_DOUBLE ( max_dirty_pages_pct_lwm  , srv_max_dirty_pages_pct_lwm  , PLUGIN_VAR_RQCMDARG  , "Percentage of dirty pages at which flushing kicks in."  , nullptr  , innodb_max_dirty_pages_pct_lwm_update  , 10  , 0  , 99.  999, 0    )

static

MYSQL_SYSVAR_DOUBLE() [3/3]

static MYSQL_SYSVAR_DOUBLE ( segment_reserve_factor  , fseg_reserve_pct  , PLUGIN_VAR_OPCMDARG  , "The segment_reserve_factor is the ratio x/y expressed in  percentage, " " where x is the number of free pages in the  segment, and y is the total" " number of pages in the segment. The number of used pages in the segment" " is given by(y-x). The number of free pages in the segment(x) will be" " maintained such that the actual segment_reserve_factor will be >=the" " requested  segment_reserve_factor, which is contained in this variable."  , nullptr  , nullptr  , FSEG_RESERVE_PCT_DFLT  , FSEG_RESERVE_PCT_MIN  , FSEG_RESERVE_PCT_MAX  , 0    )

static

MYSQL_SYSVAR_ENUM() [1/7]

static MYSQL_SYSVAR_ENUM ( change_buffering  , innodb_change_buffering  , PLUGIN_VAR_RQCMDARG  , "Buffer changes to reduce random access:" " OFF   default, ON  , inserting  , deleting  , changing  , or purging."  , nullptr  , nullptr  , IBUF_USE_NONE  , &  innodb_change_buffering_typelib  )

static

MYSQL_SYSVAR_ENUM() [2/7]

static MYSQL_SYSVAR_ENUM ( checksum_algorithm  , srv_checksum_algorithm  , PLUGIN_VAR_RQCMDARG  , "The algorithm InnoDB uses for page checksumming. Possible values are" " CRC32 (hardware accelerated if the CPU supports it)" " write  crc32, allow any of the other checksums to match when reading;" " STRICT_CRC32" " write  crc32, do not allow other algorithms to match when reading;" " INNODB" " write a software calculated  checksum, allow any other checksums" " to match when reading;" " STRICT_INNODB" " write a software calculated  checksum, do not allow other algorithms" " to match when reading;" " NONE" " write a constant magic  number, do not do any checksum verification" " when reading;" " STRICT_NONE" " write a constant magic  number, do not allow values other than that" " magic number when reading;" " Files updated when this option is set to crc32 or strict_crc32 will" " not be readable by MySQL versions older than 5.6.3"  , nullptr  , nullptr  , SRV_CHECKSUM_ALGORITHM_CRC32  , &  innodb_checksum_algorithm_typelib  )

static

MYSQL_SYSVAR_ENUM() [3/7]

static MYSQL_SYSVAR_ENUM ( compress_debug  , srv_debug_compress  , PLUGIN_VAR_RQCMDARG  , "Compress all  tables, without specifying the COMPRESS table attribute"  , nullptr  , nullptr  , Compression::NONE  , &  innodb_debug_compress_typelib  )

static

MYSQL_SYSVAR_ENUM() [4/7]

static MYSQL_SYSVAR_ENUM ( default_row_format  , innodb_default_row_format  , PLUGIN_VAR_RQCMDARG  , "The default ROW FORMAT for all innodb tables created without explicit" " ROW_FORMAT. Possible values are  REDUNDANT, COMPACT  , and DYNAMIC." " The ROW_FORMAT value COMPRESSED is not allowed"  , nullptr  , nullptr  , DEFAULT_ROW_FORMAT_DYNAMIC  , &  innodb_default_row_format_typelib  )

static

MYSQL_SYSVAR_ENUM() [5/7]

static MYSQL_SYSVAR_ENUM ( doublewrite  , dblwr::g_mode  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_NOPERSIST, "Enable InnoDB doublewrite buffer (enabled by default)." " Disable with --skip-innodb-doublewrite."  , nullptr  , doublewrite_update  , dblwr::Mode::ON  , &  innodb_doublewrite_typelib  )

static

MYSQL_SYSVAR_ENUM() [6/7]

static MYSQL_SYSVAR_ENUM ( flush_method  , innodb_flush_method  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "With which method to flush data"  , nullptr  , nullptr  , 0  , &  innodb_flush_method_typelib  )

static

MYSQL_SYSVAR_ENUM() [7/7]

static MYSQL_SYSVAR_ENUM ( stats_method  , srv_innodb_stats_method  , PLUGIN_VAR_RQCMDARG  , "Specifies how InnoDB index statistics collection code should" " treat NULLs. Possible values are NULLS_EQUAL   default, " " NULLS_UNEQUAL and NULLS_IGNORED"  , nullptr  , nullptr  , SRV_STATS_NULLS_EQUAL  , &  innodb_stats_method_typelib  )

static

MYSQL_SYSVAR_LONG() [1/3]

static MYSQL_SYSVAR_LONG ( autoinc_lock_mode  , innobase_autoinc_lock_mode  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "The AUTOINC lock modes supported by InnoDB:" "  0, Old style AUTOINC locking(for backward compatibility);" "  1, New style AUTOINC locking;" "  2, No AUTOINC locking(unsafe for SBR)"  , nullptr  , nullptr  , AUTOINC_NO_LOCKING  , AUTOINC_OLD_STYLE_LOCKING  , AUTOINC_NO_LOCKING  , 0    )

static

MYSQL_SYSVAR_LONG() [2/3]

static MYSQL_SYSVAR_LONG ( fill_factor  , ddl::fill_factor  , PLUGIN_VAR_RQCMDARG  , "Percentage of B-tree page filled during bulk insert"  , nullptr  , nullptr  , 100  , 10  , 100  , 0    )

static

MYSQL_SYSVAR_LONG() [3/3]

static MYSQL_SYSVAR_LONG ( open_files  , innobase_open_files  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "How many files at the maximum InnoDB keeps open at the same time."  , nullptr  , nullptr  , 0L  , 0L  , LONG_MAX  , 0    )

static

MYSQL_SYSVAR_LONGLONG()

static MYSQL_SYSVAR_LONGLONG ( buffer_pool_size  , srv_buf_pool_curr_size  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_PERSIST_AS_READ_ONLY, "The size of the memory buffer InnoDB uses to " "cache data and indexes of its tables."  , nullptr  , innodb_buffer_pool_size_update  , static_cast< longlong >  srv_buf_pool_def_size, static_cast< longlong >  srv_buf_pool_min_size, longlong{srv_buf_pool_max_size}  , 1024 *  1024L  )

static

MYSQL_SYSVAR_STR() [1/18]

static MYSQL_SYSVAR_STR ( buffer_pool_evict  , srv_buffer_pool_evict  , PLUGIN_VAR_RQCMDARG  , "Evict pages from the buffer pool"  , nullptr  , innodb_buffer_pool_evict_update  , ""    )

static

MYSQL_SYSVAR_STR() [2/18]

static MYSQL_SYSVAR_STR ( buffer_pool_filename  , srv_buf_dump_filename  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_MEMALLOC, "Filename to/from which to dump/load the InnoDB buffer pool"  , innodb_srv_buf_dump_filename_validate  , nullptr  , SRV_BUF_DUMP_FILENAME_DEFAULT    )

static

MYSQL_SYSVAR_STR() [3/18]

static MYSQL_SYSVAR_STR ( data_file_path  , innobase_data_file_path  , PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "Path to individual files and their sizes."  , nullptr  , nullptr  , (char *)"ibdata1:12M:autoextend"    )

static

MYSQL_SYSVAR_STR() [4/18]

static MYSQL_SYSVAR_STR ( data_home_dir  , innobase_data_home_dir  , PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "The common part for InnoDB table spaces."  , nullptr  , nullptr  , nullptr    )

static

MYSQL_SYSVAR_STR() [5/18]

static MYSQL_SYSVAR_STR ( directories  , srv_innodb_directories  , PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "List of directories 'dir1;dir2;..;dirN' to scan for " "tablespace files. Default is to scan " "'innodb-data-home-dir;innodb-undo-directory;datadir'"  , nullptr  , nullptr  , nullptr    )

static

MYSQL_SYSVAR_STR() [6/18]

static MYSQL_SYSVAR_STR ( doublewrite_dir  , innobase_doublewrite_dir  , PLUGIN_VAR_READONLY  , "Use a separate directory for the doublewrite buffer  files, "  , nullptr  , nullptr  , nullptr    )

static

MYSQL_SYSVAR_STR() [7/18]

static MYSQL_SYSVAR_STR ( ft_aux_table  , fts_internal_tbl_name  , PLUGIN_VAR_NOCMDARG|  PLUGIN_VAR_MEMALLOC, "FTS internal auxiliary table to be checked"  , innodb_internal_table_validate  , nullptr  , nullptr    )

static

MYSQL_SYSVAR_STR() [8/18]

static MYSQL_SYSVAR_STR ( ft_server_stopword_table  , innobase_server_stopword_table  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_MEMALLOC, "The user supplied stopword table name."  , innodb_stopword_table_validate  , nullptr  , nullptr    )

static

MYSQL_SYSVAR_STR() [9/18]

static MYSQL_SYSVAR_STR ( log_group_home_dir  , srv_log_group_home_dir  , PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "Path to InnoDB log files."  , nullptr  , nullptr  , nullptr    )

static

MYSQL_SYSVAR_STR() [10/18]

static MYSQL_SYSVAR_STR ( monitor_disable  , innobase_disable_monitor_counter  , PLUGIN_VAR_RQCMDARG  , "Turn off a monitor counter"  , innodb_monitor_validate  , innodb_disable_monitor_update  , nullptr    )

static

MYSQL_SYSVAR_STR() [11/18]

static MYSQL_SYSVAR_STR ( monitor_enable  , innobase_enable_monitor_counter  , PLUGIN_VAR_RQCMDARG  , "Turn on a monitor counter"  , innodb_monitor_validate  , innodb_enable_monitor_update  , nullptr    )

static

MYSQL_SYSVAR_STR() [12/18]

static MYSQL_SYSVAR_STR ( monitor_reset  , innobase_reset_monitor_counter  , PLUGIN_VAR_RQCMDARG  , "Reset a monitor counter"  , innodb_monitor_validate  , innodb_reset_monitor_update  , nullptr    )

static

MYSQL_SYSVAR_STR() [13/18]

static MYSQL_SYSVAR_STR ( monitor_reset_all  , innobase_reset_all_monitor_counter  , PLUGIN_VAR_RQCMDARG  , "Reset all values for a monitor counter"  , innodb_monitor_validate  , innodb_reset_all_monitor_update  , nullptr    )

static

MYSQL_SYSVAR_STR() [14/18]

static MYSQL_SYSVAR_STR ( redo_log_archive_dirs  , meb::redo_log_archive_dirs  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_MEMALLOC, "Limit the location of the redo log archive to the semicolon " "separated list of labeled directories"  , meb::validate_redo_log_archive_dirs  , nullptr  , nullptr    )

static

MYSQL_SYSVAR_STR() [15/18]

static MYSQL_SYSVAR_STR ( temp_data_file_path  , innobase_temp_data_file_path  , PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "Path to files and their sizes making temp-tablespace."  , nullptr  , nullptr  , (char *)"ibtmp1:12M:autoextend"    )

static

MYSQL_SYSVAR_STR() [16/18]

static MYSQL_SYSVAR_STR ( temp_tablespaces_dir  , ibt::srv_temp_dir  , PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "Directory where temp tablespace files  live, this path can be absolute."  , nullptr  , nullptr  , nullptr    )

static

MYSQL_SYSVAR_STR() [17/18]

static MYSQL_SYSVAR_STR ( undo_directory  , srv_undo_dir  , PLUGIN_VAR_RQCMDARG|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "Directory where undo tablespace files  live, this path can be absolute."  , nullptr  , nullptr  , nullptr    )

static

MYSQL_SYSVAR_STR() [18/18]

static MYSQL_SYSVAR_STR ( version  , innodb_version_str  , PLUGIN_VAR_NOCMDOPT|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "InnoDB version"  , nullptr  , nullptr  , INNODB_VERSION_STR    )

static

MYSQL_SYSVAR_UINT() [1/11]

static MYSQL_SYSVAR_UINT ( change_buffer_max_size  , srv_change_buffer_max_size  , PLUGIN_VAR_RQCMDARG  , "Maximum on-disk size of change buffer in terms of percentage" " of the buffer pool."  , nullptr  , innodb_change_buffer_max_size_update  , CHANGE_BUFFER_DEFAULT_SIZE  , 0  , 50  , 0    )

static

MYSQL_SYSVAR_UINT() [2/11]

static MYSQL_SYSVAR_UINT ( change_buffering_debug  , ibuf_debug  , PLUGIN_VAR_RQCMDARG  , "Debug flags for InnoDB change buffering (0=none, 2=crash at merge)"  , nullptr  , nullptr  , 0  , 0  , 2  , 0    )

static

MYSQL_SYSVAR_UINT() [3/11]

static MYSQL_SYSVAR_UINT ( compression_level  , page_zip_level  , PLUGIN_VAR_RQCMDARG  , "Compression level used for compressed row format. 0 is no compression" "  , 1 is  fastest, 9 is best compression and default is 6."  , nullptr  , nullptr  , DEFAULT_COMPRESSION_LEVEL  , 0  , 9  , 0    )

static

MYSQL_SYSVAR_UINT() [4/11]

static MYSQL_SYSVAR_UINT ( flush_log_at_timeout  , srv_flush_log_at_timeout  , PLUGIN_VAR_OPCMDARG  , "Write and flush logs every (n) second."  , nullptr  , nullptr  , 1  , 0  , 2700  , 0    )

static

MYSQL_SYSVAR_UINT() [5/11]

static MYSQL_SYSVAR_UINT ( limit_optimistic_insert_debug  , btr_cur_limit_optimistic_insert_debug  , PLUGIN_VAR_RQCMDARG  , "Artificially limit the number of records per B-tree page (0=unlimited)."  , nullptr  , nullptr  , 0  , 0  , UINT_MAX32  , 0    )

static

MYSQL_SYSVAR_UINT() [6/11]

static MYSQL_SYSVAR_UINT ( log_spin_cpu_abs_lwm  , srv_log_spin_cpu_abs_lwm  , PLUGIN_VAR_RQCMDARG  , "Minimum value of cpu time for which spin-delay is used." " Expressed in percentage of single cpu core."  , nullptr  , nullptr  , INNODB_LOG_SPIN_CPU_ABS_LWM_DEFAULT  , 0  , UINT_MAX  , 0    )

static

MYSQL_SYSVAR_UINT() [7/11]

static MYSQL_SYSVAR_UINT ( log_spin_cpu_pct_hwm  , srv_log_spin_cpu_pct_hwm  , PLUGIN_VAR_RQCMDARG  , "Maximum value of cpu time for which spin-delay is used." " Expressed in percentage of all cpu cores."  , nullptr  , nullptr  , INNODB_LOG_SPIN_CPU_PCT_HWM_DEFAULT  , 0  , 100  , 0    )

static

MYSQL_SYSVAR_UINT() [8/11]

static MYSQL_SYSVAR_UINT ( merge_threshold_set_all_debug  , innodb_merge_threshold_set_all_debug  , PLUGIN_VAR_RQCMDARG  , "Override current MERGE_THRESHOLD setting for all indexes at dictionary" " cache by the specified value  dynamically, at the time."  , nullptr  , innodb_merge_threshold_set_all_debug_update  , DICT_INDEX_MERGE_THRESHOLD_DEFAULT  , 1  , 50  , 0    )

static

MYSQL_SYSVAR_UINT() [9/11]

static MYSQL_SYSVAR_UINT ( old_blocks_pct  , innobase_old_blocks_pct  , PLUGIN_VAR_RQCMDARG  , "Percentage of the buffer pool to reserve for 'old' blocks."  , nullptr  , innodb_old_blocks_pct_update  , 100 *3/  8, 5  , 95  , 0    )

static

MYSQL_SYSVAR_UINT() [10/11]

static MYSQL_SYSVAR_UINT ( old_blocks_time  , buf_LRU_old_threshold  , PLUGIN_VAR_RQCMDARG  , "Move blocks to the 'new' end of the buffer pool if the first access" " was at least this many milliseconds ago." " The timeout is disabled if 0."  , nullptr  , nullptr  , 1000  , 0  , UINT_MAX32  , 0    )

static

MYSQL_SYSVAR_UINT() [11/11]

static MYSQL_SYSVAR_UINT ( trx_rseg_n_slots_debug  , trx_rseg_n_slots_debug  , PLUGIN_VAR_RQCMDARG  , "Debug flags for InnoDB to limit TRX_RSEG_N_SLOTS for " "trx_rsegf_undo_find_free()"  , nullptr  , nullptr  , 0  , 0  , 1024  , 0    )

static

MYSQL_SYSVAR_ULONG() [1/60]

static MYSQL_SYSVAR_ULONG ( adaptive_flushing_lwm  , srv_adaptive_flushing_lwm  , PLUGIN_VAR_RQCMDARG  , "Percentage of log capacity below which no adaptive flushing happens."  , nullptr  , nullptr  , 10  , 0  , 70  , 0    )

static

MYSQL_SYSVAR_ULONG() [2/60]

static MYSQL_SYSVAR_ULONG ( adaptive_hash_index_parts  , btr_ahi_parts  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_READONLY, "Number of InnoDB Adaptive Hash Index Partitions. (default = 8). "  , nullptr  , nullptr  , 8  , 1  , 512  , 0    )

static

Number of distinct partitions of AHI.

Each partition is protected by its own latch and so we have parts number of latches protecting complete search system.

MYSQL_SYSVAR_ULONG() [3/60]

static MYSQL_SYSVAR_ULONG ( adaptive_max_sleep_delay  , srv_adaptive_max_sleep_delay  , PLUGIN_VAR_RQCMDARG  , "The upper limit of the sleep delay in usec. Value of 0 disables it."  , nullptr  , nullptr  , 150000  , 0  , 1000000  , 0    )

static

MYSQL_SYSVAR_ULONG() [4/60]

static MYSQL_SYSVAR_ULONG ( api_bk_commit_interval  , ib_bk_commit_interval  , PLUGIN_VAR_OPCMDARG  , "Background commit interval in seconds"  , nullptr  , nullptr  , 5  , 1  , 1024 *1024 *  1024, 0    )

static

MYSQL_SYSVAR_ULONG() [5/60]

static MYSQL_SYSVAR_ULONG ( api_trx_level  , ib_trx_level_setting  , PLUGIN_VAR_OPCMDARG  , "InnoDB API transaction isolation level"  , nullptr  , nullptr  , 0  , 0  , 3  , 0    )

static

MYSQL_SYSVAR_ULONG() [6/60]

static MYSQL_SYSVAR_ULONG ( autoextend_increment  , sys_tablespace_auto_extend_increment  , PLUGIN_VAR_RQCMDARG  , "Data file autoextend increment in megabytes"  , nullptr  , nullptr  , 64L  , 1L  , 1000L  , 0    )

static

MYSQL_SYSVAR_ULONG() [7/60]

static MYSQL_SYSVAR_ULONG ( buffer_pool_dump_pct  , srv_buf_pool_dump_pct  , PLUGIN_VAR_RQCMDARG  , "Dump only the hottest N% of each buffer  pool, defaults to 25"  , nullptr  , nullptr  , 25  , 1  , 100  , 0    )

static

MYSQL_SYSVAR_ULONG() [8/60]

static MYSQL_SYSVAR_ULONG ( buffer_pool_instances  , srv_buf_pool_instances  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Number of buffer pool  instances, set to higher " "value on high-end machines to increase scalability"  , nullptr  , nullptr  , srv_buf_pool_instances_default  , 0  , MAX_BUFFER_POOLS  , 0    )

static

MYSQL_SYSVAR_ULONG() [9/60]

static MYSQL_SYSVAR_ULONG ( commit_concurrency  , innobase_commit_concurrency  , PLUGIN_VAR_RQCMDARG  , "Helps in performance tuning in heavily concurrent environments."  , innobase_commit_concurrency_validate  , nullptr  , 0  , 0  , 1000  , 0    )

static

MYSQL_SYSVAR_ULONG() [10/60]

static MYSQL_SYSVAR_ULONG ( compression_failure_threshold_pct  , zip_failure_threshold_pct  , PLUGIN_VAR_OPCMDARG  , "If the compression failure rate of a table is greater than this number" " more padding is added to the pages to reduce the failures. A value of" " zero implies no padding"  , nullptr  , nullptr  , 5  , 0  , 100  , 0    )

static

MYSQL_SYSVAR_ULONG() [11/60]

static MYSQL_SYSVAR_ULONG ( compression_pad_pct_max  , zip_pad_max  , PLUGIN_VAR_OPCMDARG  , "Percentage of empty space on a data page that can be reserved" " to make the page compressible."  , nullptr  , nullptr  , 50  , 0  , 75  , 0    )

static

MYSQL_SYSVAR_ULONG() [12/60]

static MYSQL_SYSVAR_ULONG ( concurrency_tickets  , srv_n_free_tickets_to_enter  , PLUGIN_VAR_RQCMDARG  , "Number of times a thread is allowed to enter InnoDB " "within the same SQL query after it has once got the " "ticket"  , nullptr  , nullptr  , 5000L  , 1L  , UINT_MAX  , 0    )

static

MYSQL_SYSVAR_ULONG() [13/60]

static MYSQL_SYSVAR_ULONG ( doublewrite_batch_size  , dblwr::batch_size  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Number of double write pages to write in a batch"  , nullptr  , nullptr  , 0  , 0  , 256  , 0    )

static

MYSQL_SYSVAR_ULONG() [14/60]

static MYSQL_SYSVAR_ULONG ( doublewrite_files  , dblwr::n_files  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Number of double write files"  , nullptr  , nullptr  , 2  , 1  , 256  , 0    )

static

MYSQL_SYSVAR_ULONG() [15/60]

static MYSQL_SYSVAR_ULONG ( doublewrite_pages  , dblwr::n_pages  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Number of double write pages per thread"  , nullptr  , nullptr  , 128  , 1  , 512  , 0    )

static

MYSQL_SYSVAR_ULONG() [16/60]

static MYSQL_SYSVAR_ULONG ( fast_shutdown  , srv_fast_shutdown  , PLUGIN_VAR_OPCMDARG  , "Speeds up the shutdown process of the InnoDB storage engine. Possible" " values are  0, 1(faster) or 2(fastest - crash-like)."  , nullptr  , nullptr  , 1  , 0  , 2  , 0    )

static

MYSQL_SYSVAR_ULONG() [17/60]

static MYSQL_SYSVAR_ULONG ( fil_make_page_dirty_debug  , srv_fil_make_page_dirty_debug  , PLUGIN_VAR_OPCMDARG  , "Make the first page of the given tablespace dirty."  , nullptr  , innodb_make_page_dirty  , UINT_MAX32  , 0  , UINT_MAX32  , 0    )

static

MYSQL_SYSVAR_ULONG() [18/60]

static MYSQL_SYSVAR_ULONG ( flush_log_at_trx_commit  , srv_flush_log_at_trx_commit  , PLUGIN_VAR_OPCMDARG  , "Set to 0   write and flush once per second, " "   1write and flush at each commit, " " or 2(write at commit, flush once per second)."  , nullptr  , nullptr  , 1  , 0  , 2  , 0    )

static

MYSQL_SYSVAR_ULONG() [19/60]

static MYSQL_SYSVAR_ULONG ( flush_neighbors  , srv_flush_neighbors  , PLUGIN_VAR_OPCMDARG  , "Set to 0   don't flush neighbors from buffer pool, " "   1flush contiguous neighbors from buffer pool)" " or 2(flush neighbors from buffer pool, " " when flushing a block"  , nullptr  , nullptr  , 0  , 0  , 2  , 0    )

static

MYSQL_SYSVAR_ULONG() [20/60]

static MYSQL_SYSVAR_ULONG ( flushing_avg_loops  , srv_flushing_avg_loops  , PLUGIN_VAR_RQCMDARG  , "Number of iterations over which the background flushing is averaged."  , nullptr  , nullptr  , 30  , 1  , 1000  , 0    )

static

MYSQL_SYSVAR_ULONG() [21/60]

static MYSQL_SYSVAR_ULONG ( force_recovery  , srv_force_recovery  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Helps to save your data in case the disk image of " "the database becomes corrupt."  , nullptr  , nullptr  , 0  , 0  , 6  , 0    )

static

MYSQL_SYSVAR_ULONG() [22/60]

static MYSQL_SYSVAR_ULONG ( force_recovery_crash  , srv_force_recovery_crash  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Kills the server during crash recovery."  , nullptr  , nullptr  , 0  , 0  , 100  , 0    )

static

MYSQL_SYSVAR_ULONG() [23/60]

static MYSQL_SYSVAR_ULONG ( ft_cache_size  , fts_max_cache_size  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "InnoDB Fulltext search cache size in bytes"  , nullptr  , nullptr  , 8000000  , 1600000  , 80000000  , 0    )

static

MYSQL_SYSVAR_ULONG() [24/60]

static MYSQL_SYSVAR_ULONG ( ft_max_token_size  , fts_max_token_size  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "InnoDB Fulltext search maximum token size in characters"  , nullptr  , nullptr  , FTS_MAX_WORD_LEN_IN_CHAR  , 10  , FTS_MAX_WORD_LEN_IN_CHAR  , 0    )

static

MYSQL_SYSVAR_ULONG() [25/60]

static MYSQL_SYSVAR_ULONG ( ft_min_token_size  , fts_min_token_size  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "InnoDB Fulltext search minimum token size in characters"  , nullptr  , nullptr  , 3  , 0  , 16  , 0    )

static

MYSQL_SYSVAR_ULONG() [26/60]

static MYSQL_SYSVAR_ULONG ( ft_num_word_optimize  , fts_num_word_optimize  , PLUGIN_VAR_OPCMDARG  , "InnoDB Fulltext search number of words to optimize " "for each optimize table call "  , nullptr  , nullptr  , 2000  , 1000  , 10000  , 0    )

static

MYSQL_SYSVAR_ULONG() [27/60]

static MYSQL_SYSVAR_ULONG ( ft_result_cache_limit  , fts_result_cache_limit  , PLUGIN_VAR_RQCMDARG  , "InnoDB Fulltext search query result cache limit in bytes"  , nullptr  , nullptr  , 2000000000L  , 1000000L  , 4294967295UL  , 0    )

static

MYSQL_SYSVAR_ULONG() [28/60]

static MYSQL_SYSVAR_ULONG ( ft_sort_pll_degree  , ddl::fts_parser_threads  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "InnoDB Fulltext search parallel sort  degree, will " "round up to nearest power of 2 number"  , nullptr  , nullptr  , 2  , 1  , 16  , 0    )

static

MYSQL_SYSVAR_ULONG() [29/60]

static MYSQL_SYSVAR_ULONG ( ft_total_cache_size  , fts_max_total_cache_size  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Total memory allocated for InnoDB Fulltext Search cache"  , nullptr  , nullptr  , 640000000  , 32000000  , 1600000000  , 0    )

static

MYSQL_SYSVAR_ULONG() [30/60]

static MYSQL_SYSVAR_ULONG ( idle_flush_pct  , srv_idle_flush_pct  , PLUGIN_VAR_RQCMDARG  , "Up to what percentage of dirty pages to be flushed when server is found" " idle."  , nullptr  , nullptr  , srv_idle_flush_pct_default  , 0  , 100  , 0    )

static

MYSQL_SYSVAR_ULONG() [31/60]

static MYSQL_SYSVAR_ULONG ( io_capacity  , srv_io_capacity  , PLUGIN_VAR_RQCMDARG  , "Number of IOPs the server can do. Tunes the background IO rate"  , nullptr  , innodb_io_capacity_update  , 10000  , 100  , ~  0UL, 0    )

static

MYSQL_SYSVAR_ULONG() [32/60]

static MYSQL_SYSVAR_ULONG ( io_capacity_max  , srv_max_io_capacity  , PLUGIN_VAR_RQCMDARG  , "Limit to which innodb_io_capacity can be inflated."  , nullptr  , innodb_io_capacity_max_update  , SRV_MAX_IO_CAPACITY_DUMMY_DEFAULT  , 100  , SRV_MAX_IO_CAPACITY_LIMIT  , 0    )

static

MYSQL_SYSVAR_ULONG() [33/60]

static MYSQL_SYSVAR_ULONG ( log_buffer_size  , srv_log_buffer_size  , PLUGIN_VAR_RQCMDARG  , "The size of the buffer which InnoDB uses to write log to the log files" " on disk."  , nullptr  , innodb_log_buffer_size_update  , INNODB_LOG_BUFFER_SIZE_DEFAULT  , INNODB_LOG_BUFFER_SIZE_MIN  , INNODB_LOG_BUFFER_SIZE_MAX  , 1024    )

static

MYSQL_SYSVAR_ULONG() [34/60]

static MYSQL_SYSVAR_ULONG ( log_files_in_group  , srv_log_n_files  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Number of log files before upgrading to 8.0.30. Deprecated."  , nullptr  , nullptr  , 2  , 2  , 100  , 0    )

static

MYSQL_SYSVAR_ULONG() [35/60]

static MYSQL_SYSVAR_ULONG ( log_wait_for_flush_spin_hwm  , srv_log_wait_for_flush_spin_hwm  , PLUGIN_VAR_RQCMDARG  , "Maximum value of average log flush time for which spin-delay is used." " When flushing takes  longer, user threads no longer spin when waiting for" "flushed redo. Expressed in microseconds."  , nullptr  , nullptr  , INNODB_LOG_WAIT_FOR_FLUSH_SPIN_HWM_DEFAULT  , 0  , ULONG_MAX  , 0    )

static

MYSQL_SYSVAR_ULONG() [36/60]

static MYSQL_SYSVAR_ULONG ( log_write_ahead_size  , srv_log_write_ahead_size  , PLUGIN_VAR_RQCMDARG  , "Log write ahead unit size to avoid read-on-  write, " " it should match the OS cache block IO size."  , nullptr  , innodb_log_write_ahead_size_update  , INNODB_LOG_WRITE_AHEAD_SIZE_DEFAULT  , INNODB_LOG_WRITE_AHEAD_SIZE_MIN  , INNODB_LOG_WRITE_AHEAD_SIZE_MAX  , OS_FILE_LOG_BLOCK_SIZE    )

static

MYSQL_SYSVAR_ULONG() [37/60]

static MYSQL_SYSVAR_ULONG ( lru_scan_depth  , srv_LRU_scan_depth  , PLUGIN_VAR_RQCMDARG  , "How deep to scan LRU to keep it clean"  , nullptr  , nullptr  , 1024  , 100  , ~  0UL, 0    )

static

MYSQL_SYSVAR_ULONG() [38/60]

static MYSQL_SYSVAR_ULONG ( max_purge_lag  , srv_max_purge_lag  , PLUGIN_VAR_RQCMDARG  , "Desired maximum length of the purge queue (0 = no limit)"  , nullptr  , nullptr  , 0  , 0  , ~  0UL, 0    )

static

MYSQL_SYSVAR_ULONG() [39/60]

static MYSQL_SYSVAR_ULONG ( max_purge_lag_delay  , srv_max_purge_lag_delay  , PLUGIN_VAR_RQCMDARG  , "Maximum delay of user threads in micro-seconds"  , nullptr  , nullptr  , 0L  , 0L  , 10000000UL  , 0    )

static

MYSQL_SYSVAR_ULONG() [40/60]

static MYSQL_SYSVAR_ULONG ( page_cleaners  , srv_n_page_cleaners  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_READONLY, "Page cleaner threads can be from 1 to 64. Default " "is number of buffer pool instances."  , nullptr  , nullptr  , 1  , 1  , 64  , 0    )

static

MYSQL_SYSVAR_ULONG() [41/60]

static MYSQL_SYSVAR_ULONG ( page_hash_locks  , srv_n_page_hash_locks  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_READONLY, "Number of rw_locks protecting buffer pool " "page_hash. Rounded up to the next power of 2"  , nullptr  , nullptr  , 16  , 1  , MAX_PAGE_HASH_LOCKS  , 0    )

static

MYSQL_SYSVAR_ULONG() [42/60]

static MYSQL_SYSVAR_ULONG ( page_size  , srv_page_size  , PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_READONLY|  PLUGIN_VAR_NOPERSIST, "Page size to use for all InnoDB tablespaces."  , nullptr  , nullptr  , UNIV_PAGE_SIZE_DEF  , UNIV_PAGE_SIZE_MIN  , UNIV_PAGE_SIZE_MAX  , 0    )

static

MYSQL_SYSVAR_ULONG() [43/60]

static MYSQL_SYSVAR_ULONG ( purge_batch_size  , srv_purge_batch_size  , PLUGIN_VAR_OPCMDARG  , "Number of UNDO log pages to purge in one batch from the history list."  , nullptr  , nullptr  , 300  , 1  , 5000  , 0    )

static

MYSQL_SYSVAR_ULONG() [44/60]

static MYSQL_SYSVAR_ULONG ( purge_rseg_truncate_frequency  , srv_purge_rseg_truncate_frequency  , PLUGIN_VAR_OPCMDARG  , "Dictates rate at which UNDO records are purged. Value N means" " purge rollback segment(s) on every Nth iteration of purge invocation"  , nullptr  , nullptr  , 128  , 1  , 128  , 0    )

static

MYSQL_SYSVAR_ULONG() [45/60]

static MYSQL_SYSVAR_ULONG ( purge_threads  , srv_n_purge_threads  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_READONLY, "Purge threads can be from 1 to 32. Default is 1 if number of available " "CPUs is 16 or  less, 4 otherwise."  , nullptr  , nullptr  , (std::thread::hardware_concurrency()<=16 ? 1UL :4UL)  , 1  , MAX_PURGE_THREADS  , 0    )

static

MYSQL_SYSVAR_ULONG() [46/60]

static MYSQL_SYSVAR_ULONG ( read_ahead_threshold  , srv_read_ahead_threshold  , PLUGIN_VAR_RQCMDARG  , "Number of pages that must be accessed sequentially for InnoDB to" " trigger a readahead."  , nullptr  , nullptr  , 56  , 0  , 64  , 0    )

static

MYSQL_SYSVAR_ULONG() [47/60]

static MYSQL_SYSVAR_ULONG ( read_io_threads  , srv_n_read_io_threads  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Number of background read I/O threads in InnoDB."  , nullptr  , nullptr  , std::clamp(std::thread::hardware_concurrency()/2, 4U, 64U)  , 1  , 64  , 0    )

static

MYSQL_SYSVAR_ULONG() [48/60]

static MYSQL_SYSVAR_ULONG ( replication_delay  , srv_replication_delay  , PLUGIN_VAR_RQCMDARG  , "Replication thread delay (ms) on the slave server if" " innodb_thread_concurrency is reached (0 by default)"  , nullptr  , nullptr  , 0  , 0  , ~  0UL, 0    )

static

MYSQL_SYSVAR_ULONG() [49/60]

static MYSQL_SYSVAR_ULONG ( rollback_segments  , srv_rollback_segments  , PLUGIN_VAR_OPCMDARG  , "Number of rollback segments per tablespace. This applies to the system" "  tablespace, the temporary tablespace &any undo tablespace."  , nullptr  , innodb_rollback_segments_update  , FSP_MAX_ROLLBACK_SEGMENTS  , 1  , FSP_MAX_ROLLBACK_SEGMENTS  , 0    )

static

MYSQL_SYSVAR_ULONG() [50/60]

static MYSQL_SYSVAR_ULONG ( saved_page_number_debug  , srv_saved_page_number_debug  , PLUGIN_VAR_OPCMDARG  , "An InnoDB page number."  , nullptr  , innodb_save_page_no  , 0  , 0  , UINT_MAX32  , 0    )

static

MYSQL_SYSVAR_ULONG() [51/60]

static MYSQL_SYSVAR_ULONG ( semaphore_wait_timeout_debug  , srv_fatal_semaphore_wait_threshold  , PLUGIN_VAR_RQCMDARG  , "Number of seconds that a semaphore can be held. If semaphore wait crosses" "this  value, server will crash"  , nullptr  , nullptr  , 600  , 25  , 600  , 0    )

static

MYSQL_SYSVAR_ULONG() [52/60]

static MYSQL_SYSVAR_ULONG ( sort_buffer_size  , srv_sort_buf_size  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Memory buffer size for index creation"  , nullptr  , nullptr  , 1048576  , 65536  , 64<<  20, 0    )

static

MYSQL_SYSVAR_ULONG() [53/60]

static MYSQL_SYSVAR_ULONG ( spin_wait_delay  , srv_spin_wait_delay  , PLUGIN_VAR_OPCMDARG  , "Maximum delay between polling for a spin lock (6 by default)"  , nullptr  , nullptr  , 6L  , 0L  , 1000  , 0    )

static

MYSQL_SYSVAR_ULONG() [54/60]

static MYSQL_SYSVAR_ULONG ( spin_wait_pause_multiplier  , ut::spin_wait_pause_multiplier  , PLUGIN_VAR_RQCMDARG  , "Controls how many times in a row to use a PAUSE " "instruction to achieve one unit of delay in a spin " "lock   see @@innodb_spin_wait_delay, defaults to 50"  , nullptr  , nullptr  , 50  , 0  , 100  , 0    )

static

MYSQL_SYSVAR_ULONG() [55/60]

static MYSQL_SYSVAR_ULONG ( sync_array_size  , srv_sync_array_size  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_READONLY, "Size of the mutex/lock wait array."  , nullptr  , nullptr  , 1  , 1  , 1024  , 0    )

static

MYSQL_SYSVAR_ULONG() [56/60]

static MYSQL_SYSVAR_ULONG ( sync_spin_loops  , srv_n_spin_wait_rounds  , PLUGIN_VAR_RQCMDARG  , "Count of spin-loop rounds in InnoDB mutexes (30 by default)"  , nullptr  , nullptr  , 30L  , 0L  , ~  0UL, 0    )

static

MYSQL_SYSVAR_ULONG() [57/60]

static MYSQL_SYSVAR_ULONG ( thread_concurrency  , srv_thread_concurrency  , PLUGIN_VAR_RQCMDARG  , "Helps in performance tuning in heavily concurrent " "environments. Sets the maximum number of threads " "allowed inside InnoDB. Value 0 will disable the " "thread throttling."  , nullptr  , innodb_thread_concurrency_update  , 0  , 0  , 1000  , 0    )

static

MYSQL_SYSVAR_ULONG() [58/60]

static MYSQL_SYSVAR_ULONG ( thread_sleep_delay  , srv_thread_sleep_delay  , PLUGIN_VAR_RQCMDARG  , "Time of innodb thread sleeping before joining InnoDB queue (usec)." " Value 0 disable a sleep"  , nullptr  , nullptr  , 10000L  , 0L  , 1000000L  , 0    )

static

MYSQL_SYSVAR_ULONG() [59/60]

static MYSQL_SYSVAR_ULONG ( undo_tablespaces  , srv_undo_tablespaces  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_NOPERSIST, "Number of undo tablespaces to use. (deprecated)"  , nullptr  , innodb_undo_tablespaces_update  , FSP_IMPLICIT_UNDO_TABLESPACES  , FSP_MIN_UNDO_TABLESPACES  , FSP_MAX_UNDO_TABLESPACES  , 0    )

static

MYSQL_SYSVAR_ULONG() [60/60]

static MYSQL_SYSVAR_ULONG ( write_io_threads  , srv_n_write_io_threads  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Number of background write I/O threads in InnoDB."  , nullptr  , nullptr  , 4  , 1  , 64  , 0    )

static

MYSQL_SYSVAR_ULONGLONG() [1/8]

static MYSQL_SYSVAR_ULONGLONG ( buffer_pool_chunk_size  , srv_buf_pool_chunk_unit  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Size of a single memory chunk within each buffer pool instance" " for resizing buffer pool. Online buffer pool resizing happens" " at this granularity."  , nullptr  , nullptr  , 128 *1024 *  1024, ulonglong{srv_buf_pool_chunk_unit_min}  , ulonglong{srv_buf_pool_chunk_unit_max}  , ulonglong{srv_buf_pool_chunk_unit_blk_sz}    )

static

MYSQL_SYSVAR_ULONGLONG() [2/8]

static MYSQL_SYSVAR_ULONGLONG ( fsync_threshold  , os_fsync_threshold  , PLUGIN_VAR_RQCMDARG  , "The value of this variable determines how often InnoDB calls fsync when " "creating a new file. Default is zero which would make InnoDB flush the " "entire file at once before closing it."  , nullptr  , nullptr  , 0  , 0  , ~  0ULL, UNIV_PAGE_SIZE    )

static

MYSQL_SYSVAR_ULONGLONG() [3/8]

static MYSQL_SYSVAR_ULONGLONG ( log_file_size  , srv_log_file_size  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_READONLY, "Size of each log file before upgrading to 8.0.30. Deprecated."  , nullptr  , nullptr  , 48 *1024 *  1024L, 4 *1024 *  1024L, ULLONG_MAX  , 1024 *  1024L  )

static

MYSQL_SYSVAR_ULONGLONG() [4/8]

static MYSQL_SYSVAR_ULONGLONG ( max_undo_log_size  , srv_max_undo_tablespace_size  , PLUGIN_VAR_OPCMDARG  , "Maximum size of an UNDO tablespace in MB (If an UNDO tablespace grows" " beyond this size it will be truncated in due course). "  , nullptr  , nullptr  , 1024 *1024 *  1024L, 10 *1024 *  1024L, ~  0ULL, 0    )

static

MYSQL_SYSVAR_ULONGLONG() [5/8]

static MYSQL_SYSVAR_ULONGLONG ( online_alter_log_max_size  , srv_online_max_size  , PLUGIN_VAR_RQCMDARG  , "Maximum modification log file size for online index creation"  , nullptr  , nullptr  , 128<<  20, 65536  , ~  0ULL, 0    )

static

MYSQL_SYSVAR_ULONGLONG() [6/8]

static MYSQL_SYSVAR_ULONGLONG ( redo_log_capacity  , srv_redo_log_capacity  , PLUGIN_VAR_RQCMDARG|  PLUGIN_VAR_PERSIST_AS_READ_ONLY, "Limitation for total size of redo log files on disk (expressed in bytes)."  , nullptr  , innodb_redo_log_capacity_update  , 100 *1024 *  1024, LOG_CAPACITY_MIN  , LOG_CAPACITY_MAX  , MB    )

static

MYSQL_SYSVAR_ULONGLONG() [7/8]

static MYSQL_SYSVAR_ULONGLONG ( stats_persistent_sample_pages  , srv_stats_persistent_sample_pages  , PLUGIN_VAR_RQCMDARG  , "The number of leaf index pages to sample when calculating persistent" " statistics (by ANALYZE, default 20)"  , nullptr  , nullptr  , 20  , 1  , ~  0ULL, 0    )

static

MYSQL_SYSVAR_ULONGLONG() [8/8]

static MYSQL_SYSVAR_ULONGLONG ( stats_transient_sample_pages  , srv_stats_transient_sample_pages  , PLUGIN_VAR_RQCMDARG  , "The number of leaf index pages to sample when calculating transient" " statistics (if persistent statistics are not used, default 8)"  , nullptr  , nullptr  , 8  , 1  , ~  0ULL, 0    )

static

MYSQL_THDVAR_BOOL() [1/3]

static MYSQL_THDVAR_BOOL ( ft_enable_stopword  , PLUGIN_VAR_OPCMDARG  , "Create FTS index with stopword."  , nullptr  , nullptr  , true    )

static

MYSQL_THDVAR_BOOL() [2/3]

static MYSQL_THDVAR_BOOL ( strict_mode  , PLUGIN_VAR_OPCMDARG  , "Use strict mode when evaluating create options."  , innodb_check_session_admin  , nullptr  , true    )

static

MYSQL_THDVAR_BOOL() [3/3]

static MYSQL_THDVAR_BOOL ( table_locks  , PLUGIN_VAR_OPCMDARG  , "Enable InnoDB locking in LOCK TABLES"  , nullptr  , nullptr  , true    )

static

MYSQL_THDVAR_STR() [1/4]

static MYSQL_THDVAR_STR ( ft_user_stopword_table  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_MEMALLOC, "User supplied stopword table  name, effective in the session level."  , innodb_stopword_table_validate  , nullptr  , nullptr    )

static

MYSQL_THDVAR_STR() [2/4]

static MYSQL_THDVAR_STR ( interpreter  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_NOPERSIST, "Invoke InnoDB test interpreter with commands" " to be executed."  , ib_interpreter_check  , ib_interpreter_update  , "init"    )

static

Use this variable innodb_interpreter to execute debug code within InnoDB.

The output is stored in the innodb_interpreter_output variable.

MYSQL_THDVAR_STR() [3/4]

static MYSQL_THDVAR_STR ( interpreter_output  , PLUGIN_VAR_OPCMDARG|PLUGIN_VAR_MEMALLOC|  PLUGIN_VAR_NOPERSIST, "Output from InnoDB testing module (ut0test)."  , nullptr  , nullptr  , "The Default Value"    )

static

When testing commands are executed in the innodb_interpreter variable, the output is stored in this innodb_interpreter_output variable.

MYSQL_THDVAR_STR() [4/4]

static MYSQL_THDVAR_STR ( tmpdir  , PLUGIN_VAR_OPCMDARG|  PLUGIN_VAR_MEMALLOC, "Directory for temporary non-tablespace files."  , innodb_tmpdir_validate  , nullptr  , nullptr    )

static

MYSQL_THDVAR_ULONG() [1/4]

static MYSQL_THDVAR_ULONG ( ddl_buffer_size  , PLUGIN_VAR_RQCMDARG  , "Maximum size of memory to use (in bytes) for DDL."  , nullptr  , nullptr  , 1048576  , 65536  , 4294967295  , 0    )

static

MYSQL_THDVAR_ULONG() [2/4]

static MYSQL_THDVAR_ULONG ( ddl_threads  , PLUGIN_VAR_RQCMDARG  , "Maximum number of threads to use for DDL."  , nullptr  , nullptr  , 4  , 1  , 64  , 0    )

static

MYSQL_THDVAR_ULONG() [3/4]

static MYSQL_THDVAR_ULONG ( lock_wait_timeout  , PLUGIN_VAR_RQCMDARG  , "Timeout in seconds an InnoDB transaction may wait " "for a lock before being rolled back. Values above " "100000000 disable the timeout."  , nullptr  , nullptr  , 50  , 1  , 1024 *1024 *  1024, 0    )

static

MYSQL_THDVAR_ULONG() [4/4]

static MYSQL_THDVAR_ULONG ( parallel_read_threads  , PLUGIN_VAR_RQCMDARG  , "Number of threads to do parallel read."  , nullptr  , nullptr  , std::clamp(ulong{std::thread::hardware_concurrency()/8}, 4UL, ulong{Parallel_reader::MAX_THREADS})  , 1  , Parallel_reader::MAX_THREADS  , 0    )

static

predefine_tablespace()

static bool predefine_tablespace ( dd::cache::Dictionary_client *  dd_client, space_id_t  space_id, uint32_t  flags, const char *  name, const char *  filename  )

static

Create metadata for a predefined tablespace at server initialization.

Parameters

[in,out]	dd_client	data dictionary client
[in]	space_id	InnoDB tablespace ID
[in]	flags	tablespace flags
[in]	name	tablespace name
[in]	filename	tablespace file name

Return values

false	on success
true	on failure

predefine_undo_tablespaces()

static bool predefine_undo_tablespaces ( dd::cache::Dictionary_client *  dd_client )

static

Predefine the undo tablespace metadata at server initialization.

Parameters

[in,out]

dd_client

data dictionary client

Return values

false	on success
true	on failure

Undo tablespaces use a reserved range of tablespace ID.

purge_run_now_set()

static void purge_run_now_set ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Set the purge state to RUN.

If purge is disabled then it is a no-op. This function is registered as a callback with MySQL.

Parameters

[in]

save

immediate result from check function

purge_stop_now_set()

static void purge_stop_now_set ( THD *  , SYS_VAR *  , void *  , const void *  save  )

static

Set the purge state to STOP.

If purge is disabled then it is a no-op. This function is registered as a callback with MySQL.

Parameters

[in]

save

immediate result from check function

release_plugin_services()

static void release_plugin_services ( )

static

Release all acquired services from mysql server.

server_get_hostname()

const char * server_get_hostname

(

)

Returns the NUL terminated value of glob_hostname.

Returns

pointer to glob_hostname.

set_templ_icp()

static void set_templ_icp ( mysql_row_templ_t *  templ, const dict_index_t *  index, const dict_index_t *  scan_index, ulint  col_position  )

static

Set Index Condition Push down (ICP) field number in template.

Parameters

[in,out]	templ	mysql column template
[in]	index	index used to build the template
[in]	scan_index	active index for current scan
[in]	col_position	position of current column

show_innodb_vars()

static int show_innodb_vars ( THD *  , SHOW_VAR *  var, char *    )

static

Callback function for accessing the InnoDB variables from MySQL: SHOW VARIABLES.

simple()

template<typename T >

constexpr PSI_metric_info_v1 simple ( const char *  name, const char *  unit, const char *  description, MetricOTELType  type, T &  variable  )

constexpr

test_normalize_table_name()

static void test_normalize_table_name ( )

static

test_ut_format_name()

static void test_ut_format_name ( )

static

thd_ddl_buffer_size()

ulong thd_ddl_buffer_size

(

THD *

thd

)

Return the maximum buffer size to use for DDL.

Parameters

[in]

thd

Session instance, or nullptr to query the global innodb_ddl_buffer_size value.

Returns

memory upper limit in bytes.

thd_ddl_threads()

size_t thd_ddl_threads ( THD *  thd )

noexcept

Returns

the number of DDL threads to use (global/session).

thd_has_edited_nontrans_tables()

bool thd_has_edited_nontrans_tables

(

THD *

thd

)

Returns true if the transaction this thread is processing has edited non-transactional tables.

Used by the deadlock detector when deciding which transaction to rollback in case of a deadlock - we try to avoid rolling back transactions that have edited non-transactional tables.

Returns

true if non-transactional tables have been edited

Parameters

thd	in: thread handle

thd_innodb_interpreter()

char ** thd_innodb_interpreter

(

THD *

thd

)

Obtain the latest command executed by InnoDB Interpreter/Tester module (ib::Tester).

Parameters

[in]

thd

thread handle

Returns

pointer to the output string.

thd_innodb_interpreter_output()

char ** thd_innodb_interpreter_output

(

THD *

thd

)

Obtain the value of the latest output from InnoDB Interpreter/Tester module (ib::Tester).

Parameters

[in]

thd

thread handle

Returns

pointer to the output string.

thd_innodb_tmpdir()

const char * thd_innodb_tmpdir

(

THD *

thd

)

Get the value of innodb_tmpdir.

Parameters

[in]

thd

thread handle, or nullptr to query the global innodb_tmpdir.

Returns

nullptr if innodb_tmpdir=""

thd_is_ins_sel_stmt()

static bool thd_is_ins_sel_stmt ( THD *  user_thd )

inlinestatic

Check if statement is of type INSERT ....

SELECT that involves use of intrinsic tables.

Parameters

[in]

user_thd

thread handler

Returns

true if INSERT .... SELECT statement.

thd_is_query_block()

bool thd_is_query_block

(

const THD *

thd

)

Returns true if the thread is executing a SELECT statement.

Returns

true if thd is executing SELECT

Parameters

thd	in: thread handle

thd_is_replication_slave_thread()

bool thd_is_replication_slave_thread

(

THD *

thd

)

Returns true if the thread is the replication thread on the slave server.

Used in srv_conc_enter_innodb() to determine if the thread should be allowed to enter InnoDB - the replication thread is treated differently than other threads. Also used in srv_conc_force_exit_innodb().

Returns

true if thd is the replication thread

Parameters

thd	in: thread handle

thd_lock_wait_timeout()

std::chrono::seconds thd_lock_wait_timeout

(

THD *

thd

)

Returns the lock wait timeout for the current connection.

Returns

the lock wait timeout in: thread handle, or NULL to query the global innodb_lock_wait_timeout

thd_parallel_read_threads()

ulong thd_parallel_read_threads

(

THD *

thd

)

Return the number of read threads for this session.

Parameters

[in]

thd

Session instance, or nullptr to query the global innodb_parallel_read_threads value.

thd_requested_durability()

enum durability_properties thd_requested_durability

(

const THD *

thd

)

Gets information on the durability property requested by thread.

Used when writing either a prepare or commit record to the log buffer.

Returns

the durability property.

Parameters

thd	in: thread handle

thd_set_lock_wait_time()

void thd_set_lock_wait_time	(	THD *	thd,
		std::chrono::steady_clock::duration	value
	)

Set the time waited for the lock for the current query.

Parameters

[in,out]	thd	Thread handle.
[in]	value	Time waited for the lock.

thd_start_time() [1/2]

time_t thd_start_time

(

const THD *

thd

)

thd_start_time() [2/2]

std::chrono::system_clock::time_point thd_start_time

(

THD *

thd

)

Get the thread start time.

Returns

the thread start time. in: thread handle, or NULL

thd_to_innodb_session()

innodb_session_t *& thd_to_innodb_session

(

THD *

thd

)

Obtain the private handler of InnoDB session specific data.

Parameters

[in,out]

thd

MySQL thread handler.

Returns

reference to private handler

thd_to_trx()

trx_t *& thd_to_trx

(

THD *

thd

)

Obtain the InnoDB transaction of a MySQL thread.

Parameters

[in,out]

thd

MySQL thread handler.

Returns

reference to transaction pointer

thd_trx_arbitrate()

THD * thd_trx_arbitrate	(	THD *	requestor,
		THD *	holder
	)

Check if the transaction can be rolled back.

Parameters

[in]	requestor	Session requesting the lock
[in]	holder	Session that holds the lock

Returns

the session that will be rolled back, null don't care

thd_trx_is_auto_commit()

bool thd_trx_is_auto_commit

(

THD *

thd

)

Check if the transaction is an auto-commit transaction.

true also implies that it is a SELECT (read-only) transaction.

Returns

true if the transaction is an auto commit read-only transaction.

Parameters

thd	in: thread handle, can be NULL

thd_trx_is_read_only()

bool thd_trx_is_read_only

(

THD *

thd

)

Returns true if transaction should be flagged as read-only.

Returns

true if the thd is marked as read-only

Parameters

thd	in: thread handle

thd_trx_priority()

int thd_trx_priority

(

THD *

thd

)

Parameters

[in]

thd

Session to check

Returns

the priority

true_word_char()

bool true_word_char ( int  c, uint8_t  ch  )

inline

trx_deregister_from_2pc()

static void trx_deregister_from_2pc ( trx_t *  trx )

inlinestatic

Note that a transaction has been deregistered.

Parameters

[in]

trx

transaction

trx_is_interrupted()

bool trx_is_interrupted

(

const trx_t *

trx

)

Determines if the currently running transaction has been interrupted.

Returns

true if interrupted

Parameters

trx	in: transaction

trx_is_strict()

bool trx_is_strict

(

trx_t *

trx

)

Determines if the currently running transaction is in strict mode.

Returns

true if strict

Parameters

trx	in: transaction

trx_register_for_2pc()

static void trx_register_for_2pc ( trx_t *  trx )

inlinestatic

Note that a transaction has been registered with MySQL 2PC coordinator.

update_innodb_temporary_metadata()

static bool update_innodb_temporary_metadata ( THD *  thd )

static

Update metadata for innodb_temporary tablespace at server startup.

This information is used by the information_schema.files to show the filename for the temporary tablespace innodb_temporary.

Parameters

[in,out]

thd

THD

Return values

false	on success
true	on failure

validate_create_tablespace_info()

static int validate_create_tablespace_info ( ib_file_suffix  type, st_alter_tablespace *  alter_info  )

static

Validate the parameters in st_alter_tablespace before using them in InnoDB tablespace functions.

Parameters

[in]	type	Type os tablespace being validated
[in]	alter_info	How to do the command.

Returns

MySQL handler error code like HA_...

validate_innodb_redo_log_encrypt()

static int validate_innodb_redo_log_encrypt ( THD *  thd, SYS_VAR *  var, void *  save, struct st_mysql_value *  value  )

static

Validate the value of innodb_redo_log_encrypt global variable.

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[in]	var	pointer to system variable
[in]	save	possibly updated variable value
[in]	value	current variable value

Returns

error code

validate_innodb_undo_log_encrypt()

static int validate_innodb_undo_log_encrypt ( THD *  thd, SYS_VAR *  var, void *  save, struct st_mysql_value *  value  )

static

Validate the value of innodb_undo_log_encrypt global variable.

This function is registered as a callback with MySQL.

Parameters

[in]	thd	thread handle
[in]	var	pointer to system variable
[in]	save	possibly updated variable value
[in]	value	current variable value

Returns

error code

validate_tablespace_name()

static int validate_tablespace_name ( ts_command_type  ts_command, const char *  name  )

static

Validate the tablespace name provided for a tablespace DDL.

Parameters

[in]	ts_command	tablespace command type
[in]	name	A proposed tablespace name

Returns

MySQL handler error code like HA_...

wait_background_drop_list_empty()

static void wait_background_drop_list_empty ( THD *  , SYS_VAR *  , void *  , const void *    )

static

Wait for the background drop list to become empty.

Variable Documentation

all_innodb_conds

PSI_cond_info all_innodb_conds[]

static

Initial value:

= {
    PSI_KEY(commit_cond, 0, 0, PSI_DOCUMENT_ME),
    PSI_KEY(resume_encryption_cond, 0, 0, PSI_DOCUMENT_ME)}

all_pthread_mutexes

PSI_mutex_info all_pthread_mutexes[]

static

Initial value:

= {
    PSI_MUTEX_KEY(commit_cond_mutex, 0, 0, PSI_DOCUMENT_ME),
    PSI_MUTEX_KEY(innobase_share_mutex, 0, 0, PSI_DOCUMENT_ME),
    PSI_MUTEX_KEY(resume_encryption_cond_mutex, 0, 0, PSI_DOCUMENT_ME)}

AUTOINC_NEW_STYLE_LOCKING

const long AUTOINC_NEW_STYLE_LOCKING = 1

static

AUTOINC_NO_LOCKING

const long AUTOINC_NO_LOCKING = 2

static

AUTOINC_OLD_STYLE_LOCKING

const long AUTOINC_OLD_STYLE_LOCKING = 0

static

buffer_metrics

PSI_metric_info_v1 buffer_metrics[]

static

clone_protocol_svc

const mysql_service_clone_protocol_t* clone_protocol_svc

Clone protocol service.

commit_cond

mysql_cond_t commit_cond

static

commit_cond_key

mysql_pfs_key_t commit_cond_key

static

commit_cond_m

mysql_mutex_t commit_cond_m

static

commit_cond_mutex_key

mysql_pfs_key_t commit_cond_mutex_key

static

commit_threads

ulong commit_threads = 0

static

to force correct commit order in binlog

data_metrics

PSI_metric_info_v1 data_metrics[]

static

ERROR_CREATING_MSG

const char* ERROR_CREATING_MSG

Initial value:

=
    "Please refer to " REFMAN "error-creating-innodb.html"

FORCE_RECOVERY_MSG

const char* FORCE_RECOVERY_MSG

Initial value:

= "Please refer to " REFMAN
                                 "forcing-innodb-recovery.html"
                                 " for information about forcing recovery."

FOREIGN_KEY_CONSTRAINTS_MSG

const char* FOREIGN_KEY_CONSTRAINTS_MSG

Initial value:

=
    "Please refer to " REFMAN
    "create-table-foreign-keys.html"
    " for correct foreign key definition."

ft_vft_ext_result

const struct _ft_vft_ext ft_vft_ext_result

Initial value:

= {
    innobase_fts_get_version, innobase_fts_flags, innobase_fts_retrieve_docid,
    innobase_fts_count_matches}

ft_vft_result

const struct _ft_vft ft_vft_result

Initial value:

= {nullptr, innobase_fts_find_ranking,
                                      innobase_fts_close_ranking,
                                      innobase_fts_retrieve_ranking, nullptr}

GB

const uint64_t GB = MB * 1024

static

ha_innobase_exts

const char* ha_innobase_exts[] = {dot_ext[IBD], NullS}

static

Gives the file extension of an InnoDB single-table tablespace.

i_s_innodb_buffer_page

i_s_innodb_buffer_page

i_s_innodb_buffer_page_lru

i_s_innodb_buffer_page_lru

i_s_innodb_buffer_stats

i_s_innodb_buffer_stats

i_s_innodb_cached_indexes

i_s_innodb_cached_indexes

i_s_innodb_cmp

i_s_innodb_cmp

i_s_innodb_cmp_per_index

i_s_innodb_cmp_per_index

i_s_innodb_cmp_per_index_reset

i_s_innodb_cmp_per_index_reset

i_s_innodb_cmp_reset

i_s_innodb_cmp_reset

i_s_innodb_cmpmem

i_s_innodb_cmpmem

i_s_innodb_cmpmem_reset

i_s_innodb_cmpmem_reset

i_s_innodb_columns

i_s_innodb_columns

i_s_innodb_ft_being_deleted

i_s_innodb_ft_being_deleted

i_s_innodb_ft_config

i_s_innodb_ft_config

i_s_innodb_ft_default_stopword

i_s_innodb_ft_default_stopword

i_s_innodb_ft_deleted

i_s_innodb_ft_deleted

i_s_innodb_ft_index_cache

i_s_innodb_ft_index_cache

i_s_innodb_ft_index_table

i_s_innodb_ft_index_table

i_s_innodb_indexes

i_s_innodb_indexes

i_s_innodb_metrics

i_s_innodb_metrics

i_s_innodb_tables

i_s_innodb_tables

i_s_innodb_tablespaces

i_s_innodb_tablespaces

i_s_innodb_tablestats

i_s_innodb_tablestats

i_s_innodb_temp_table_info

i_s_innodb_temp_table_info

i_s_innodb_trx

i_s_innodb_trx

i_s_innodb_virtual

i_s_innodb_virtual

inno_meter

PSI_meter_info_v1 inno_meter[]

static

Initial value:

= {
    {"mysql.inno", "MySql InnoDB metrics", 10, 0, 0, inno_metrics,
     std::size(inno_metrics)},
    {"mysql.inno.buffer_pool", "MySql InnoDB buffer pool metrics", 10, 0, 0,
     buffer_metrics, std::size(buffer_metrics)},
    {"mysql.inno.data", "MySql InnoDB data metrics", 10, 0, 0, data_metrics,
     std::size(data_metrics)}}

inno_metrics

PSI_metric_info_v1 inno_metrics[]

static

innobase_active_counter

ulong innobase_active_counter = 0

static

innobase_autoinc_lock_mode

long innobase_autoinc_lock_mode

static

innobase_commit_concurrency

ulong innobase_commit_concurrency = 0

static

innobase_create_status_file

bool innobase_create_status_file = false

static

innobase_data_file_path

char* innobase_data_file_path = nullptr

static

innobase_data_home_dir

char* innobase_data_home_dir = nullptr

static

innobase_disable_monitor_counter

char* innobase_disable_monitor_counter = nullptr

static

innobase_doublewrite_dir

char* innobase_doublewrite_dir = nullptr

static

innobase_enable_monitor_counter

char* innobase_enable_monitor_counter = nullptr

static

innobase_old_blocks_pct

uint innobase_old_blocks_pct

static

Percentage of the buffer pool to reserve for 'old' blocks.

Connected to buf_LRU_old_ratio.

innobase_open_files

long innobase_open_files

static

innobase_open_tables

hash_table_t* innobase_open_tables

static

innobase_reset_all_monitor_counter

char* innobase_reset_all_monitor_counter = nullptr

static

innobase_reset_monitor_counter

char* innobase_reset_monitor_counter = nullptr

static

innobase_rollback_on_timeout

bool innobase_rollback_on_timeout = false

static

innobase_server_stopword_table

char* innobase_server_stopword_table = nullptr

static

innobase_share_mutex

mysql_mutex_t innobase_share_mutex

static

to protect innobase_open_files

innobase_share_mutex_key

mysql_pfs_key_t innobase_share_mutex_key

static

innobase_stats_on_metadata

bool innobase_stats_on_metadata = true

innobase_storage_engine

struct st_mysql_storage_engine innobase_storage_engine

static

Initial value:

= {
    MYSQL_HANDLERTON_INTERFACE_VERSION}

innobase_sys_files

std::vector<Plugin_tablespace::Plugin_tablespace_file *, ut::allocator<Plugin_tablespace::Plugin_tablespace_file *> > innobase_sys_files

static

Array of data files of the system tablespace.

innobase_system_variables

SYS_VAR* innobase_system_variables[]

static

innobase_temp_data_file_path

char* innobase_temp_data_file_path = nullptr

static

INNOBASE_WAKE_INTERVAL

constexpr uint32_t INNOBASE_WAKE_INTERVAL = 32

constexpr

innodb_api_cb

ib_cb_t innodb_api_cb[]

static

Initial value:

= {
    FOR_EACH_API_METHOD_NAME_STEM(INNODB_API_CB_ARRAY_ELEMENT_TRANSFORM)}

innodb_background_drop_list_empty

bool innodb_background_drop_list_empty = true

static

innodb_buf_flush_list_now

bool innodb_buf_flush_list_now = true

static

innodb_buffer_pool_dump_now

bool innodb_buffer_pool_dump_now = false

static

innodb_buffer_pool_load_abort

bool innodb_buffer_pool_load_abort = false

static

innodb_buffer_pool_load_now

bool innodb_buffer_pool_load_now = false

static

innodb_change_buffering_names

const char* innodb_change_buffering_names[]

static

Initial value:

= {
    "none",    
    "inserts", 
    "deletes", 
    "changes", 
    "purges",  
    "all",     
    NullS}

Allowed values of innodb_change_buffering.

innodb_change_buffering_typelib

TYPELIB innodb_change_buffering_typelib

static

Initial value:

= {
    array_elements(innodb_change_buffering_names) - 1,
    "innodb_change_buffering_typelib", innodb_change_buffering_names, nullptr}

Enumeration of innodb_change_buffering.

innodb_checksum_algorithm_names

const char* innodb_checksum_algorithm_names[]

static

Initial value:

= {
    "crc32", "strict_crc32", "innodb", "strict_innodb",
    "none",  "strict_none",  NullS}

Possible values of the parameter innodb_checksum_algorithm.

innodb_checksum_algorithm_typelib

TYPELIB innodb_checksum_algorithm_typelib

static

Initial value:

= {
    array_elements(innodb_checksum_algorithm_names) - 1,
    "innodb_checksum_algorithm_typelib", innodb_checksum_algorithm_names,
    nullptr}

Used to define an enumerate type of the system variable innodb_checksum_algorithm.

innodb_data_lock_inspector

Innodb_data_lock_inspector innodb_data_lock_inspector

static

innodb_debug_compress_names

const char* innodb_debug_compress_names[]

static

Initial value:

= {"none", "zlib", "lz4",
                                                    "lz4hc", NullS}

Values for –innodb-debug-compress names.

innodb_debug_compress_typelib

TYPELIB innodb_debug_compress_typelib

static

Initial value:

= {
    array_elements(innodb_debug_compress_names) - 1,
    "innodb_debug_compress_typelib", innodb_debug_compress_names, nullptr}

Enumeration of –innodb-debug-compress.

innodb_default_row_format

ulong innodb_default_row_format = DEFAULT_ROW_FORMAT_DYNAMIC

static

innodb_default_row_format_names

const char* innodb_default_row_format_names[]

static

Initial value:

= {"redundant", "compact",
                                                        "dynamic", NullS}

Possible values for system variable "innodb_default_row_format".

innodb_default_row_format_typelib

TYPELIB innodb_default_row_format_typelib

static

Initial value:

= {
    array_elements(innodb_default_row_format_names) - 1,
    "innodb_default_row_format_typelib", innodb_default_row_format_names,
    nullptr}

Used to define an enumerate type of the system variable innodb_default_row_format.

innodb_doublewrite_names

const char* innodb_doublewrite_names[]

static

Initial value:

= {
    "OFF", "ON", "DETECT_ONLY", "DETECT_AND_RECOVER", "FALSE", "TRUE", NullS}

Possible values for system variable "innodb_doublewrite".

Note

: If you change order or add new values, please update dblwr::mode_t.

innodb_doublewrite_typelib

TYPELIB innodb_doublewrite_typelib

static

Initial value:

= {
    array_elements(innodb_doublewrite_names) - 1, "innodb_doublewrite_typelib",
    innodb_doublewrite_names, nullptr}

Used to define an enumerate type of the system variable innodb_default_row_format.

innodb_flush_method

ulong innodb_flush_method

static

innodb_flush_method_names

const char* innodb_flush_method_names[]

static

Initial value:

= {
 
    "fsync", "O_DSYNC", "littlesync", "nosync", "O_DIRECT", "O_DIRECT_NO_FSYNC",
 
 
 
    NullS}

Names of allowed values of innodb_flush_method.

innodb_flush_method_typelib

TYPELIB innodb_flush_method_typelib

static

Initial value:

= {
    array_elements(innodb_flush_method_names) - 1,
    "innodb_flush_method_typelib", innodb_flush_method_names, nullptr}

Enumeration of innodb_flush_method.

innodb_hton_ptr

struct handlerton* innodb_hton_ptr

static

innodb_inited

bool innodb_inited = false

static

innodb_log_checkpoint_fuzzy_now

bool innodb_log_checkpoint_fuzzy_now = true

static

innodb_log_checkpoint_now

bool innodb_log_checkpoint_now = true

static

innodb_log_flush_now

bool innodb_log_flush_now = true

static

innodb_merge_threshold_set_all_debug

uint innodb_merge_threshold_set_all_debug

static

Initial value:

=
    DICT_INDEX_MERGE_THRESHOLD_DEFAULT

innodb_optimize_fulltext_only

bool innodb_optimize_fulltext_only = false

static

INNODB_PARAMETERS_MSG

const char* INNODB_PARAMETERS_MSG

Initial value:

=
    "Please refer to " REFMAN "innodb-parameters.html"

innodb_purge_run_now

bool innodb_purge_run_now = true

static

innodb_purge_stop_now

bool innodb_purge_stop_now = true

static

innodb_stats_method_names

const char* innodb_stats_method_names[]

static

Initial value:

= {
    "nulls_equal", "nulls_unequal", "nulls_ignored", NullS}

Possible values for system variable "innodb_stats_method".

The values are defined the same as its corresponding MyISAM system variable "myisam_stats_method"(see "myisam_stats_method_names"), for better usability

innodb_stats_method_typelib

TYPELIB innodb_stats_method_typelib

static

Initial value:

= {
    array_elements(innodb_stats_method_names) - 1,
    "innodb_stats_method_typelib", innodb_stats_method_names, nullptr}

Used to define an enumerate type of the system variable innodb_stats_method.

This is the same as "myisam_stats_method_typelib"

innodb_status_variables

SHOW_VAR innodb_status_variables[]

static

innodb_status_variables_export

SHOW_VAR innodb_status_variables_export[]

static

Initial value:

= {
    {"Innodb", (char *)&show_innodb_vars, SHOW_FUNC, SHOW_SCOPE_GLOBAL},
    {NullS, NullS, SHOW_LONG, SHOW_SCOPE_GLOBAL}}

innodb_version_str

char* innodb_version_str = (char *)INNODB_VERSION_STR

static

KB

const uint64_t KB = 1024

static

master_key_id_mutex

ib_mutex_t master_key_id_mutex

MB

const uint64_t MB = KB * 1024

static

MIN_EXPECTED_TABLESPACE_SIZE

const ulint MIN_EXPECTED_TABLESPACE_SIZE = 5 * 1024 * 1024

static

Minimum expected tablespace size.

(5M)

MOVED_FILES_PRINT_THRESHOLD

const size_t MOVED_FILES_PRINT_THRESHOLD = 32

static

Stop printing warnings, if the count exceeds this threshold.

mysql_declare_plugin_end

i_s_innodb_session_temp_tablespaces mysql_declare_plugin_end

OPERATING_SYSTEM_ERROR_MSG

const char* OPERATING_SYSTEM_ERROR_MSG

Initial value:

=
    "Refer to your operating system documentation for operating"
    " system error code information."

predefined_flags

uint32_t predefined_flags

fil_space_t::flags for hard-coded tablespaces

recovery_lock_taken

os_event_t recovery_lock_taken

reg_svc

const mysql_service_registry_t* reg_svc

resume_encryption_cond

mysql_cond_t resume_encryption_cond

resume_encryption_cond_key

mysql_pfs_key_t resume_encryption_cond_key

resume_encryption_cond_m

mysql_mutex_t resume_encryption_cond_m

resume_encryption_cond_mutex_key

mysql_pfs_key_t resume_encryption_cond_mutex_key

srv_buffer_pool_evict

char* srv_buffer_pool_evict

static

srv_buffer_pool_in_core_file

bool srv_buffer_pool_in_core_file = true

srv_fil_make_page_dirty_debug

ulong srv_fil_make_page_dirty_debug = 0

static

srv_saved_page_number_debug

ulong srv_saved_page_number_debug = 0

static

sysvar_source_svc

const mysql_service_system_variable_source_t* sysvar_source_svc

TROUBLESHOOT_DATADICT_MSG

const char* TROUBLESHOOT_DATADICT_MSG

Initial value:

= "Please refer to " REFMAN
                                        "innodb-troubleshooting-datadict.html"
                                        " for how to resolve the issue."

TROUBLESHOOTING_MSG

const char* TROUBLESHOOTING_MSG

Initial value:

= "Please refer to " REFMAN
                                  "innodb-troubleshooting.html"
                                  " for how to resolve the issue."