Search Results
https://dev.mysql.com/doc/refman/9.7/en/load-data.html
The server interprets the file name using the character set indicated by the character_set_filesystem system variable. By default, the server interprets the file contents using the character set indicated by the character_set_database system ...For ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-connection-security.html
The choice is made by setting the system variable group_replication_communication_stack to XCOM to use Group Replication's own implementation (this is the default choice), or to MYSQL to use MySQL Server's connection security. Group Replication ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.backup.html
240426 13:01:24 RDR1 INFO: Reading all global variables from the server. 240426 13:01:24 RDR1 INFO: Completed reading of all 623 global variables from the server. 240426 13:01:23 MAIN INFO: MySQL server version is '8.4.0-commercial' 240426 13:01:23 ... In the following illustration, we back up an entire MySQL instance to a single file using the backup-to-image command, which appears at the end of the sample ...
https://dev.mysql.com/doc/refman/9.7/en/connection-compression-control.html
Configuring Connection Compression Configuring Legacy Connection Compression Monitoring Connection Compression Configuring Connection Compression These configuration parameters are available for controlling connection compression: The ...The ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
(See Section 7.1.8, “Server System Variables”.) If you want all your tables to be able to grow above the default limit and are willing to have your tables slightly slower and larger than necessary, you can increase the default pointer size by ...
https://dev.mysql.com/doc/refman/9.7/en/security-against-attack.html
You enable encryption on a MySQL server by setting the binlog_encryption system variable to ON. The SUPER privilege can be used to terminate client connections, change server operation by changing the value of system variables, and control ...(This ... When you connect to a MySQL server, you should use a ...All other information is transferred as text, ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/admin-api-routing-guidelines-syntax.html
The top-level properties of a routing guideline document are: destinations: groupings of MySQL servers using pattern-matching expressions. The following example shows a default destination class for an InnoDB Cluster: "destinations": [ { "match": ...Only online topology members are considered when forming a candidate ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-logs-configuration.html
Server Configuration System Variables Server Configuration Status Variables Server Configuration Command Line Server Configuration System Variables The following are the server telemetry logging system variables: telemetry.log_enabled System ...For ...
https://dev.mysql.com/doc/refman/9.7/en/show-replica-status.html
This is the same as the value for the global gtid_executed system variable on this server, as well as the value for Executed_Gtid_Set in the output of SHOW BINARY LOG STATUS on this server. However, because the file positions are not being regularly ... SHOW REPLICA STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-logging-configuration.html
Naming Conventions for Audit Log Files To configure the audit log file name, set the audit_log.file system variable at server startup. If you want to stop collecting the query statistics, use the audit_log_filter_set_filter() audit log function to ...A flush task configured using the audit_log.flush_interval_seconds system variable has a value of zero by default, which means the task is not scheduled to ... This section describes how to configure audit logging characteristics, such as ...