Search Results
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
RESIGNAL also can make some procedures shorter if a given handler can handle part of a situation, then pass the condition “up the line” to another handler. RESIGNAL may change some or all information before passing it on. RESIGNAL is related to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
The following function enables you to set a member of a single-primary replication group to take over as the primary. The current primary becomes a read-only secondary, and the specified group member becomes the read-write primary. The function can ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rule-based-filtering.html
This rule set drops information events, and, for other events, removes the source_line field: SET GLOBAL dragnet.log_error_filter_rules = 'IF prio>=INFORMATION THEN drop. For example: SET GLOBAL dragnet.log_error_filter_rules = ' IF ... The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
Dropping Undo Tablespaces Undo tablespaces created using CREATE UNDO TABLESPACE syntax can be dropped at runtime using DROP UNDO TABALESPACE syntax. An undo tablespace must be empty before it can be dropped. See Truncating Undo Tablespaces.) Once ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
It is also possible to drop data files from a tablespace (see example later in this section). This is also true for dropping these objects, subject to the following constraints: A log file group cannot be dropped as long as any tablespaces use it. A ... NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(WL #16205) This release removes support for the ENGINE clause from the following SQL statements: DROP TABLESPACE (all variants) ALTER TABLESPACE ... DROP DATAFILE All other variants of ALTER TABLESPACE, with the two exceptions listed here: ALTER ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-client-commands.html
DROP NODEGROUP nodegroup_id Drops the NDB Cluster node group with the given nodegroup_id. This command can be used to drop a node group from an NDB Cluster. DROP NODEGROUP takes as its sole argument the node group ID of the node group to be dropped.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
Tells the data nodes to drop the original table and then to rename the copy. Operations that add and drop indexes on variable-width columns of NDB tables occur online. ALGORITHM=INPLACE can be used to perform online ADD COLUMN, ADD INDEX (including ... MySQL NDB Cluster supports online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
The ROUTINES table provides information about stored routines (stored procedures and stored functions). If the routine is a stored procedure, this value is empty. If the routine is a stored procedure, this value is NULL. If the routine is a stored ...The ROUTINES table does not include built-in (native) functions or loadable ...