Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-failover.html
You can repair and rejoin an invalidated primary cluster to the InnoDB ClusterSet topology afterwards, provided that you can fix the issues. The Rome cluster has been marked as invalidated, and its status in the InnoDB ClusterSet deployment has been ...During an emergency failover process, data consistency is not assured, so for safety, the original primary cluster is marked as invalidated during the failover ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/connector-net/en/connector-net-authentication.html
For example, with GSSAPI you can set the ticket-granting ticket (TGT) expiry time, key distribution center (KDC) port, and so on. Pluggable authentication enables the server to determine which plugin applies, based on the user name and host name ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-sles-repo.html
Upgrading MySQL Upgrade MySQL and its components by the following command: $> sudo zypper update mysql-community-server Alternatively, you can update MySQL by telling Zypper to update everything on your system (this might take considerably more ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-mgmd.html
--config-cache Command-Line Format --config-cache[=TRUE|FALSE] Type Boolean Default Value TRUE This option, whose default value is 1 (or TRUE, or ON), can be used to disable the management server's configuration cache, so that it reads its ... The ...All options that can be used with ndb_mgmd are shown in the following ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
Two settings are available to increase the chances of a member remaining in or rejoining a group: group_replication_member_expel_timeout increases the time between the creation of a suspicion (which happens after an initial 5-second detection ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-table.html
For MySQL 9.4.1 and later, if ML_PREDICT_TABLE takes a long time to complete, manually limit input tables to a maximum of 1,000 rows. If on MySQL 9.4.1 and later and ML_PREDICT_TABLE takes a long time to complete, manually limit input tables to a ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
To set the relevant variables at server startup, put these lines in the server my.cnf file: [mysqld] plugin-load-add=connection_control.so connection-control-failed-connections-threshold=4 connection-control-min-connection-delay=2000 To set and ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges at routine execution time, as described later in this section. For NOW(), the binary log includes the timestamp and replicates correctly. By ...