Search Results
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/implicit-commit.html
Data definition language (DDL) statements that define or modify database objects. CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. SELECT.) Statements that implicitly use or modify tables in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-sql-format.html
If you want to cause the dump file to force a drop of each database before recreating it, use the --add-drop-database option as well. In this case, mysqldump writes a DROP DATABASE statement preceding each CREATE DATABASE statement. Because the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
There is an exception for CREATE DATABASE, ALTER DATABASE, and DROP DATABASE. The database being created, altered, or dropped is considered to be the default database when determining whether to output the statement. The server's binary log ...To ...
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/analyze-table.html
DROP DATABASE removes histograms for any table in the dropped database because the statement drops all tables in the database. [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
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/mysql-monitor/8.0/en/security-advisors-ref.html
Because the default test database can be accessed by any user and has permissive privileges, it should be dropped immediately as part of the installation process. If a user is configured to use an authentication plug-in, and that plug-in does not ...