MySQL Server Version Reference  /  Loadable Functions

Chapter 3 Loadable Functions

The following table shows all loadable functions available across MySQL Server 5.6 through 8.0. The table contains these columns:

  • Name: The item name.

  • Introduced: The version or versions in which the item was introduced. This column appears only if it applies to some item.

  • Deprecated: The version or versions in which the item was deprecated. This column appears only if it applies to some item.

  • Removed: The version or versions in which the item was removed. This column appears only if it applies to some item.

  • 5.6, 5.7, and so forth: Whether the item is available in the corresponding MySQL Server series. The indicator links to the item description in the main reference manual if more information is available.

    An item has a row in the table if it ever existed in any series shown in the table. The value displayed for a given series indicates item availability in that series:

    • Yes: The item is available in all production-ready General Availability (GA) versions. For a series that has not reached GA status, Yes indicates that the item is available in the most recently released pre-GA version.

    • Some: The item is available in some GA versions. This is the case if the item was introduced after the first GA version, or removed from some GA version.

    • Blank: The item is not available in any GA version. Either it does not exist in the series, or existed in pre-GA versions but was removed before the series reached GA status.

Table 3.1 Loadable Function Reference

Name Introduced Deprecated 5.6 5.7 8.0
asymmetric_decrypt() 5.6.21, 5.7.9, 8.0.11 Some Yes Yes
asymmetric_derive() 5.6.21, 5.7.9, 8.0.11 Some Yes Yes
asymmetric_encrypt() 5.6.21, 5.7.9, 8.0.11 Some Yes Yes
asymmetric_sign() 5.6.21, 5.7.9, 8.0.11 Some Yes Yes
asymmetric_verify() 5.6.21, 5.7.9, 8.0.11 Some Yes Yes
asynchronous_connection_failover_add_managed() 8.0.23 Some
asynchronous_connection_failover_add_source() 8.0.22 Some
asynchronous_connection_failover_delete_managed() 8.0.23 Some
asynchronous_connection_failover_delete_source() 8.0.22 Some
audit_api_message_emit_udf() Yes
audit_log_encryption_password_get() Yes Yes
audit_log_encryption_password_set() Yes Yes
audit_log_filter_flush() Yes Yes
audit_log_filter_remove_filter() Yes Yes
audit_log_filter_remove_user() Yes Yes
audit_log_filter_set_filter() Yes Yes
audit_log_filter_set_user() Yes Yes
audit_log_read() Yes Yes
audit_log_read_bookmark() Yes Yes
create_asymmetric_priv_key() 5.6.21, 5.7.9, 8.0.11 Some Yes Yes
create_asymmetric_pub_key() 5.6.21, 5.7.9, 8.0.11 Some Yes Yes
create_dh_parameters() 5.6.21, 5.7.9, 8.0.11 Some Yes Yes
create_digest() 5.6.21, 5.7.9, 8.0.11 Some Yes Yes
firewall_group_delist() 8.0.23 Some
firewall_group_enlist() 8.0.23 Some
gen_blacklist() 8.0.23 Yes Yes
gen_blocklist() 8.0.23 Some
gen_dictionary() Yes Yes
gen_dictionary_drop() Yes Yes
gen_dictionary_load() Yes Yes
gen_range() Yes Yes
gen_rnd_email() Yes Yes
gen_rnd_pan() Yes Yes
gen_rnd_ssn() Yes Yes
gen_rnd_us_phone() Yes Yes
group_replication_disable_member_action() Yes
group_replication_enable_member_action() Yes
group_replication_get_communication_protocol() Yes
group_replication_get_write_concurrency() Yes
group_replication_reset_member_actions() Yes
group_replication_set_as_primary() Yes
group_replication_set_communication_protocol() Yes
group_replication_set_write_concurrency() Yes
group_replication_switch_to_multi_primary_mode() Yes
group_replication_switch_to_single_primary_mode() Yes
keyring_aws_rotate_cmk() Yes Yes
keyring_aws_rotate_keys() Yes Yes
keyring_hashicorp_update_config() Yes
keyring_key_fetch() Yes Yes
keyring_key_generate() Yes Yes
keyring_key_length_fetch() Yes Yes
keyring_key_remove() Yes Yes
keyring_key_store() Yes Yes
keyring_key_type_fetch() Yes Yes
load_rewrite_rules() Yes Yes
mask_inner() Yes Yes
mask_outer() Yes Yes
mask_pan() Yes Yes
mask_pan_relaxed() Yes Yes
mask_ssn() Yes Yes
mysql_firewall_flush_status() Yes Yes Yes
mysql_query_attribute_string() 8.0.23 Some
normalize_statement() Yes Yes Yes
read_firewall_group_allowlist() 8.0.23 Some
read_firewall_groups() 8.0.23 Some
read_firewall_users() 8.0.26 Yes Yes Yes
read_firewall_whitelist() 8.0.26 Yes Yes Yes
service_get_read_locks() 5.7.8 Yes Yes
service_get_write_locks() 5.7.8 Yes Yes
service_release_locks() 5.7.8 Yes Yes
set_firewall_group_mode() 8.0.23 Some
set_firewall_mode() 8.0.26 Yes Yes Yes
version_tokens_delete() Yes Yes
version_tokens_edit() Yes Yes
version_tokens_lock_exclusive() Yes Yes
version_tokens_lock_shared() Yes Yes
version_tokens_set() Yes Yes
version_tokens_show() Yes Yes
version_tokens_unlock() Yes Yes