Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-show-disabled-instruments.html
Displays all currently disabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_disabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-show-enabled-consumers.html
Example mysql> CALL sys.ps_setup_show_enabled_consumers(); +-----------------------------+ | enabled_consumers | +-----------------------------+ | events_statements_current | | events_statements_history | | events_transactions_current | | ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-show-enabled-instruments.html
Displays all currently enabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_enabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
This index might be silently dropped later if you create another index that can be used to enforce the foreign key constraint. To change the storage engine, you must drop any foreign key constraints first. Dropping Foreign Key Constraints You can ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. The statements listed in this section (and any synonyms for them) ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
The following list summarizes role-management capabilities provided by MySQL: CREATE ROLE and DROP ROLE create and remove roles. Creating Roles and Granting Privileges to Them Defining Mandatory Roles Checking Role Privileges Activating Roles ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
Failure to process the result this way may result in a dropped connection to the server. Multiple-result processing also is required if you execute CALL statements for stored procedures. Results from a stored procedure have these characteristics: ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
Signals can be raised within exception handlers: CREATE PROCEDURE p () BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN SIGNAL SQLSTATE VALUE '99999' SET MESSAGE_TEXT = 'An error occurred'; END; DROP TABLE no_such_table; END; CALL p() reaches the ...Valid simple_value_specification designators can be specified using stored procedure or function parameters, stored program local variables declared with DECLARE, user-defined variables, system variables, or ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
Valid target designators for storing item information can be stored procedure or function parameters, stored program local variables declared with DECLARE, or user-defined variables. Valid condition_number designators can be stored procedure or ...