Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...As of MySQL 8.4, enabling innodb_read_only prevents these operations for all storage ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-functions.html
Example: mysql> SELECT gen_dictionary('mydict'); +--------------------------+ | gen_dictionary('mydict') | +--------------------------+ | My term | +--------------------------+ mysql> SELECT gen_dictionary('no-such-dict'); ... The MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-event-fields.html
Filter components may include or drop error events based on priority, except that system events are mandatory and cannot be dropped. Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
(By default, a recurring event's schedule begins as soon as it is created, and continues indefinitely, until it is disabled or dropped.) If a repeating event does not terminate within its scheduling interval, the result may be multiple instances of ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
To demonstrate ON DELETE and ON UPDATE referential actions, drop the child table and recreate it to include ON UPDATE and ON DELETE subclauses with the CASCADE option. MySQL supports foreign keys, which permit cross-referencing related data across ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-fine-tuning.html
To rebuild FULLTEXT indexes for an InnoDB table, use ALTER TABLE with the DROP INDEX and ADD INDEX options to drop and re-create each index. You can exert more control over full-text searching behavior if you have a MySQL source distribution because ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-methods.html
Wait until all data from the old group is propagated to the new group and then drop the asynchronous replication connection and upgrade any missing members. Wait until all data from the old group is propagated to the new group and then drop the ...
https://dev.mysql.com/doc/refman/8.4/en/host-cache.html
This requires the DROP privilege for the Performance Schema host_cache table or the RELOAD privilege. The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
It is also important to remember that once an extent is used, it cannot be freed again without dropping the data file of which it is a part. For additional information, and examples of creating, dropping, and obtaining information about NDB Cluster ... The FILES table provides information about the files in which MySQL tablespace data is ...