https://dev.mysql.com/sys-ps-trace-statement-digest.html
If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and indicate the polling duration and interval. The result is a report of all ...
https://dev.mysql.com/sys-ps-trace-thread.html
in_interval DECIMAL(20,2): The number of seconds (which can be fractional) to sleep between data collections. Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each ...
https://dev.mysql.com/time-zone-support.html
This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. MySQL Server maintains several time ...Beginning with MySQL 8.0.19, time zone offsets are also supported for inserted datetime values; see Section 11.2.2, “The DATE, DATETIME, and TIMESTAMP Types”, for more ...
https://dev.mysql.com/user-defined-functions-table.html
The value is one of int, decimal, real, char, or row. The user_defined_functions table contains a row for each user-defined function (UDF) registered by a server component or plugin, or by a CREATE FUNCTION statement. user_defined_functions has ...
https://dev.mysql.com/view-check-option.html
The check for v3 also fails: mysql> INSERT INTO v2 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v2' mysql> INSERT INTO v3 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v3' . The WITH CHECK OPTION clause can be given for an ...
https://dev.mysql.com/while.html
Example: CREATE PROCEDURE dowhile() BEGIN DECLARE v1 INT DEFAULT 5; WHILE v1 > 0 DO ... [begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the ...
https://dev.mysql.com/writing-keyring-plugins.html
MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later retrieval. The keyring_descriptor value in the general descriptor points to the type-specific descriptor.
https://dev.mysql.com/xml-functions.html
This also means the user is fully responsible for any typographical errors, since no warnings will be given if (for example) $@myvariable is used where $@myvariable was intended. code injection occurs when malicious code is introduced into the ...
