Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
The audit log plugin performs certain actions during initialization and termination based on the effective audit log file name: During initialization, the plugin checks whether a file with the audit log file name already exists and renames it if so.
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
For information about semijoin strategies, see Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations Batched Key Access Joins MySQL implements a method of joining tables called the Batched Key Access (BKA) join algorithm. In ...
https://dev.mysql.com/doc/refman/8.4/en/channels-with-prev-replication.html
Warning Use RESET REPLICA with caution as this statement deletes all existing channels, purges their relay log files, and recreates only the default channel. In this case, error 1964 Multiple channels exist on the replica. When a replica has ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-local.html
An absolute path is required, and the specified directory (“clone_dir”) must not exist, but the specified path must be an existent path. Attempting to clone such tables or tablespaces causes the following error: ERROR 1086 (HY000): File ...The ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
clone_delay_after_data_drop Command-Line Format --clone-delay-after-data-drop System Variable clone_delay_after_data_drop Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value 3600 Unit bytes ...
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... An error occurs if the database exists and you did not specify IF NOT EXISTS. create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name | ENCRYPTION ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... IF ...The event does not run unless the Event Scheduler is ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
An error occurs if you try to add a new row with a key value that matches an existing row. The expression need not reference an existing element in a JSON document inserted into the indexed column, but must itself be syntactically valid. CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
With IGNORE, rows that duplicate an existing row on a unique key value are discarded. SELECT, if IF NOT EXISTS is given and the target table exists, nothing is inserted into the destination table, and the statement is not logged. You can create one ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
Choose whichever of the following procedures applies: If the root account exists with an initial random password that has been expired, connect to the server as root using that password, then choose a new password. Because the password exists, you ... The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema that define MySQL ...