Search Results
https://dev.mysql.com/doc/refman/8.4/en/window-function-optimization.html
If it is permissible to sacrifice safety for speed, windowing_use_high_precision can be disabled to permit inverse aggregation. If such differences are permissible, windowing_use_high_precision can be disabled to permit optimized mode. Window ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
The failover support is configured by the following connection properties (their functions are explained in the paragraphs below): failOverReadOnly secondsBeforeRetrySource queriesBeforeRetrySource retriesAllDown autoReconnect autoReconnectForPools ...A failover happens when connection-related errors occur for an underlying, active ...
https://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html
The failover support is configured by the following connection properties (their functions are explained in the paragraphs below): failOverReadOnly secondsBeforeRetrySource queriesBeforeRetrySource retriesAllDown autoReconnect autoReconnectForPools ...A failover happens when connection-related errors occur for an underlying, active ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
Stage 2: Easy safe repair First, try myisamchk -r -q tbl_name (-r -q means “quick recovery mode”). Safe recovery mode uses an old recovery method that handles a few cases that regular recovery mode does not (but is slower). Do so as follows: ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
If innodb_strict_mode is disabled, an invalid KEY_BLOCK_SIZE value results in a warning, and the KEY_BLOCK_SIZE option is ignored. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row ...For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
To prevent use of encryption and override other --ssl-xxx options, invoke the client program with --ssl-mode=DISABLED: mysql --ssl-mode=DISABLED To determine whether the current connection with the server uses encryption, check the session value of ...Instead, a warning is generated and encryption is disabled for new connections on the interface to which the statement ... Several configuration ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
server_ssl_mode Type String Default Value AS_CLIENT Valid Values AS_CLIENT DISABLED PREFERRED REQUIRED SSL connection mode to use when connecting between MySQL Router and server. client_ssl_mode Type String Default Value PREFERRED Valid Values ...If ... When started, MySQL Router reads a list of configuration files that together make up the configuration of the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --sql-mode=mode Command-Line Format --sql-mode=mode Type String Set the SQL mode for the client session. --ssl-fips-mode={OFF|ON|STRICT} ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-changing-group-mode.html
Changing to Single-Primary Mode Use the group_replication_switch_to_single_primary_mode() function to change a group running in multi-primary mode to single-primary mode by issuing: SELECT group_replication_switch_to_single_primary_mode() When you ... This section explains how to change the mode which a group is running in, either single or ...While the action runs, you can check its progress by issuing the following SELECT statement: SELECT event_name, work_completed, work_estimated FROM performance_schema.events_stages_current WHERE event_name LIKE "%stage/group_rpl%"; +----------------------------------------------------------------------+----------------+----------------+ | event_name | work_completed | work_estimated | +----------------------------------------------------------------------+----------------+----------------+ | stage/group_rpl/Multi-primary Switch: applying buffered transactions | 0 | 1 | ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-single-user-mode.html
Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL server (SQL node) or an instance of ndb_restore. When entering single user mode, connections to all other API nodes ...You can also check the status column of the ndbinfo.nodes table (see Section 25.6.15.48, “The ndbinfo nodes Table”, for more ...