MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
The Performance Schema
user_defined_functions
table contains
information about the currently installed user-defined functions
(UDFs):
SELECT * FROM performance_schema.user_defined_functions;
The mysql.func
system table also lists
installed UDFs, but only those installed using
CREATE
FUNCTION
. The
user_defined_functions
table lists
UDFs installed using
CREATE
FUNCTION
as well as UDFs installed automatically by
components or plugins. This difference makes
user_defined_functions
preferable to
mysql.func
for checking which UDFs are
installed. See
Section 27.12.19.12, “The user_defined_functions Table”.