Search Results
https://dev.mysql.com/doc/refman/8.4/en/ipv6-system-support.html
Before MySQL Server can accept IPv6 connections, the operating system on your server host must support IPv6. To produce a description of your system's network interfaces, invoke ifconfig -a and look for IPv6 addresses in the output. If your host ...
https://dev.mysql.com/doc/refman/8.4/en/drop-spatial-reference-system.html
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-db-system.html
To use the additional components of MySQL HeatWave that are included with the MySQL HeatWave Cluster, you must first create a MySQL HeatWave DB System. Create a DB System For MySQL HeatWave on Oracle Cloud Infrastructure (OCI), see Creating a DB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-system-definition.html
You can obtain the value of this parameter by checking the Ndb_system_name status variable. The [system] section is used for parameters applying to the cluster as a whole. The Name system parameter is used with MySQL Enterprise Monitor; ...More ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-maintenance-db-systems.html
Maintenance of a High Availability DB System 12.6 Maintenance of a High Availability DB System Oracle maintains a high availability DB System using a rolling maintenance process that has minimal downtime. The maintenance starts within two hours of ...The rolling maintenance process involves the following steps and does not require any input from you: One of the secondary nodes is removed from the replication ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-server.html
MySQL distributions on Unix and Unix-like system include a script named mysql.server, which starts the MySQL server using mysqld_safe. In the following discussion, adjust the name mysql.server as appropriate for your system. Note For some Linux ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
| @@] system_var_name } SET syntax for variable assignment enables you to assign values to different types of variables that affect the operation of the server or clients: User-defined variables. System variables also can be set at server startup, ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
For additional information about using MySQL server options and system variables, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”. When binary logging is enabled, the log_bin system variable, which ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
This section describes the system and status variables that validate_password provides to enable its operation to be configured and monitored. validate_password.check_user_name Command-Line Format --validate-password.check-user-name[={OFF|ON}] ...
https://dev.mysql.com/doc/refman/8.4/en/show-variables.html
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, “Server System Variables”). The scope for each system variable is listed at Section 7.1.8, “Server ...System variable information is also available from these sources: Performance Schema ...A WHERE clause can be given to select rows using ...