12.2 Loadable Function Reference可加载函数引用

The following table lists each function that is loadable and runtime and provides a short description of each one. 下表列出了可加载和运行时的每个函数,并提供了每个函数的简短说明。For a table listing built-in functions and operators, see Section 12.1, “Built-In Function and Operator Reference”有关列出内置函数和运算符的表,请参阅第12.1节,“内置函数和运算符参考”

For general information about loadable functions, see Section 5.7, “MySQL Server Loadable Functions”.有关可加载函数的一般信息,请参阅第5.7节,“MySQL服务器可加载函数”

Table 12.2 Loadable Functions可加载函数

Name名称Description说明Introduced引入版本Deprecated退出版本
asymmetric_decrypt()Decrypt ciphertext using private or public key使用私钥或公钥解密密文
asymmetric_derive()Derive symmetric key from asymmetric keys从非对称密钥派生对称密钥
asymmetric_encrypt()Encrypt cleartext using private or public key使用私钥或公钥加密明文
asymmetric_sign()Generate signature from digest从摘要生成签名
asymmetric_verify()Verify that signature matches digest验证签名是否匹配摘要
asynchronous_connection_failover_add_managed()Add a replication source server in a managed group to the source list将托管组中的复制源服务器添加到源列表8.0.23
asynchronous_connection_failover_add_source()Add a replication source server to the source list将复制源服务器添加到源列表8.0.22
asynchronous_connection_failover_delete_managed()Remove managed group of replication source servers from the source list从源列表中删除复制源服务器的托管组8.0.23
asynchronous_connection_failover_delete_source()Remove a replication source server from the source list从源列表中删除复制源服务器8.0.22
audit_api_message_emit_udf()Add message event to audit log将消息事件添加到审核日志
audit_log_encryption_password_get()Fetch audit log encryption password获取审核日志加密密码
audit_log_encryption_password_set()Set audit log encryption password设置审核日志加密密码
audit_log_filter_flush()Flush audit log filter tables刷新审核日志筛选器表
audit_log_filter_remove_filter()Remove audit log filter删除审核日志筛选器
audit_log_filter_remove_user()Unassign audit log filter from user从用户取消分配审核日志筛选器
audit_log_filter_set_filter()Define audit log filter定义审核日志筛选器
audit_log_filter_set_user()Assign audit log filter to user将审核日志筛选器分配给用户
audit_log_read()Return audit log records返回审核日志记录
audit_log_read_bookmark()Bookmark for most recent audit log event最近审核日志事件的书签
create_asymmetric_priv_key()Create private key创建私钥
create_asymmetric_pub_key()Create public key创建公钥
create_dh_parameters()Generate shared DH secret生成共享DH密钥
create_digest()Generate digest from string从字符串生成摘要
firewall_group_delist()Remove account from firewall group profile从防火墙组配置文件中删除帐户8.0.23
firewall_group_enlist()Add account to firewall group profile将帐户添加到防火墙组配置文件8.0.23
gen_blacklist()Perform dictionary term replacement执行字典术语替换8.0.23
gen_blocklist()Perform dictionary term replacement执行字典术语替换8.0.23
gen_dictionary()Return random term from dictionary从字典返回随机项
gen_dictionary_drop()Remove dictionary from registry从注册表中删除词典
gen_dictionary_load()Load dictionary into registry将字典加载到注册表
gen_range()Generate random number within range生成范围内的随机数
gen_rnd_email()Generate random email address生成随机电子邮件地址
gen_rnd_pan()Generate random payment card Primary Account Number生成随机支付卡主账号
gen_rnd_ssn()Generate random US Social Security number生成随机美国社保号码
gen_rnd_us_phone()Generate random US phone number生成随机美国电话号码
group_replication_get_communication_protocol()Return Group Replication protocol version返回组复制协议版本
group_replication_get_write_concurrency()Return maximum number of consensus instances executable in parallel返回并行执行的最大一致性实例数
group_replication_set_as_primary()Assign group member as new primary将组成员指定为新的主成员
group_replication_set_communication_protocol()Set Group Replication protocol version设置组复制协议版本
group_replication_set_write_concurrency()Set maximum number of consensus instances executable in parallel设置可并行执行的一致性实例的最大数目
group_replication_switch_to_multi_primary_mode()Change group from single-primary to multi-primary mode将组从单主模式更改为多主模式
group_replication_switch_to_single_primary_mode()Change group from multi-primary to single-primary mode将组从多主模式更改为单主模式
keyring_aws_rotate_cmk()Rotate AWS customer master key旋转AWS客户主密钥
keyring_aws_rotate_keys()Rotate keys in keyring_aws storage file在keyring_aws存储文件中旋转键
keyring_hashicorp_update_config()Cause runtime keyring_hashicorp reconfiguration导致运行时keyring_hashicorp重新配置
keyring_key_fetch()Fetch keyring key value获取密钥环密钥值
keyring_key_generate()Generate random keyring key生成随机密钥环密钥
keyring_key_length_fetch()Return keyring key length返回密钥环密钥长度
keyring_key_remove()Remove keyring key取下密钥环密钥
keyring_key_store()Store key in keyring在密钥环中存储密钥
keyring_key_type_fetch()Return keyring key type返回密钥环密钥类型
load_rewrite_rules()Rewriter plugin helper routine重写器插件帮助程序
mask_inner()Mask interior part of string遮罩字符串的内部
mask_outer()Mask left and right parts of string遮罩字符串的左右部分
mask_pan()Mask payment card Primary Account Number part of string屏蔽支付卡主要账号字符串部分
mask_pan_relaxed()Mask payment card Primary Account Number part of string屏蔽支付卡主要账号字符串部分
mask_ssn()Mask US Social Security number美国社会保险号码
mysql_firewall_flush_status()Reset firewall status variables重置防火墙状态变量
mysql_query_attribute_string()Fetch query attribute value获取查询属性值8.0.23
normalize_statement()Normalize SQL statement to digest form将SQL语句规范化为摘要形式
read_firewall_group_allowlist()Update firewall group profile recorded-statement cache更新防火墙组配置文件录制语句缓存8.0.23
read_firewall_groups()Update firewall group profile cache更新防火墙组配置文件缓存8.0.23
read_firewall_users()Update firewall account profile cache更新防火墙帐户配置文件缓存8.0.26
read_firewall_whitelist()Update firewall account profile recorded-statement cache更新防火墙帐户配置文件记录语句缓存8.0.26
service_get_read_locks()Acquire locking service shared locks获取锁定服务共享锁
service_get_write_locks()Acquire locking service exclusive locks获取锁定服务独占锁
service_release_locks()Release locking service locks松开锁定维修锁
set_firewall_group_mode()Establish firewall group profile operational mode建立防火墙组配置文件操作模式8.0.23
set_firewall_mode()Establish firewall account profile operational mode建立防火墙帐户配置文件操作模式8.0.26
version_tokens_delete()Delete tokens from version tokens list从版本标记列表中删除标记
version_tokens_edit()Modify version tokens list修改版本标记列表
version_tokens_lock_exclusive()Acquire exclusive locks on version tokens获取版本令牌上的独占锁
version_tokens_lock_shared()Acquire shared locks on version tokens获取版本令牌上的共享锁
version_tokens_set()Set version tokens list设置版本标记列表
version_tokens_show()Return version tokens list返回版本标记列表
version_tokens_unlock()Release version tokens locks释放版本令牌锁