Search Results
https://dev.mysql.com/doc/refman/8.4/en/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 procedure also attempts to execute ... Traces all Performance Schema instrumentation for a specific statement ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables.
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-save.html
This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. This procedure disables binary logging during its execution by ...To ...
https://dev.mysql.com/doc/x-devapi-userguide/en/using-sql.html
The following example uses a Session to call an SQL Stored Procedure on the specific node. In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string.
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-last-insert-id.html
Within the body of a stored routine (procedure or function) or a trigger, the value of LAST_INSERT_ID() changes the same way as for statements executed outside the body of these kinds of objects (see Section 14.15, “Information Functions”). The ...For stored functions and triggers that change the value, the value is restored when the function or trigger ends, so following statements do not see a changed ...
https://dev.mysql.com/doc/refman/8.4/en/sys-execute-prepared-stmt.html
Thus, this procedure is useful primarily for executing dynamic statements on a one-time basis. If that statement name exists when the procedure is called, its previous content is destroyed. Given an SQL statement as a string, executes it as a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-thread.html
Each result set returned from the procedure should be used for a complete graph. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the ... Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description ...
https://dev.mysql.com/doc/refman/8.4/en/call.html
CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE PROCEDURE. Stored procedures that take no arguments can be invoked without parentheses. When the procedure ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. There are also some restrictions specific to stored functions but not to stored procedures. The restrictions for stored ...SQL ...