Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-database.html
The CHARACTER SET and COLLATE clauses make it possible to create databases with different character sets and collations on the same MySQL server. Otherwise (neither CHARACTER SET nor COLLATE is specified), the server character set and server ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin.html
The clone plugin permits cloning data locally or from a remote MySQL server instance. The cloned data comprises a fully functional data directory, which permits using the clone plugin for MySQL server provisioning. Figure 7.1 Local Cloning ...
https://dev.mysql.com/doc/refman/8.4/en/constraints.html
The basic philosophy is that MySQL Server tries to produce an error for anything that it can detect while parsing a statement to be executed, and tries to recover from any errors that occur while executing the statement. This means, for example, ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
The action of these components is affected by other server options and system variables: The output destination is determined by the --log-error option (and, on Windows, --pid-file and --console). Component order is significant because the server ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-priority-based-filtering.html
log_error_verbosity Value Permitted Message Priorities 1 ERROR 2 ERROR, WARNING 3 ERROR, WARNING, INFORMATION If log_error_verbosity is 2 or greater, the server logs messages about statements that are unsafe for statement-based logging. If the value ... The log_filter_internal log filter component implements a simple form of log filtering based on error event priority and error ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rule-based-filtering.html
The following example enables log_filter_dragnet in combination with the built-in log sink: INSTALL COMPONENT 'file://component_log_filter_dragnet'; SET GLOBAL log_error_services = 'log_filter_dragnet; log_sink_internal'; To set log_error_services ... The log_filter_dragnet log filter component enables log filtering based on user-defined ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
The CONNECTION string contains the information required to connect to the remote server containing the table in which the data physically resides. The connection string specifies the server name, login credentials, port number and database/table ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...For example, lookups are case-insensitive if the collation is utf8mb4_0900_ai_ci, whereas lookups are case-sensitive if the collation is utf8mb4_0900_as_cs or ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned issues. Edit the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
REPLICA_SIDE_DISABLED indicates that the creation of the event occurred on another MySQL server acting as a replication source and replicated to the current MySQL server which is acting as a replica, but the event is not presently being executed on ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...