MySQL 5.7 Release Notes
The following table lists each function that is loadable at 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”
For general information about loadable functions, see Section 5.6, “MySQL Server Loadable Functions”.
Table 12.2 Loadable Functions
| Name | Description |
|---|---|
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 |
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 |
create_digest() |
Generate digest from string |
flush_rewrite_rules() |
Load rewrite_rules table into Rewriter cache |
gen_blacklist() |
Perform dictionary term replacement |
gen_dictionary_drop() |
Remove dictionary from registry |
gen_dictionary_load() |
Load dictionary into registry |
gen_dictionary() |
Return random term from dictionary |
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 |
keyring_aws_rotate_cmk() |
Rotate AWS customer master key |
keyring_aws_rotate_keys() |
Rotate keys in keyring_aws storage file |
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 |
normalize_statement() |
Normalize SQL statement to digest form |
read_firewall_users() |
Update firewall account profile cache |
read_firewall_whitelist() |
Update firewall account profile recorded-statement cache |
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_mode() |
Establish firewall account profile operational mode |
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 |