Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache.html
Among other functions, the message cache is used for recovery of missed messages by members that reconnect with the group after a period where they were unable to communicate with the other group members. The same cache size limit should be set on ... The group communication engine for Group Replication (XCom, a Paxos variant) includes a cache for messages (and their metadata) exchanged between the group members as a part of the consensus ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks-handling.html
With MySQL table-level locks, the timeout method must be used to resolve deadlocks. This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock Detection”. It explains how to organize database operations to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and final phases of the DDL operation. The failure of an online DDL operation is typically due to one of the following conditions: An ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
A number of limitations exist in NDB Cluster with regard to the handling of transactions. The NDBCLUSTER storage engine supports only the READ COMMITTED transaction isolation level. To ensure that a given transaction reads only before or after ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-autotune.html
realtime: Maximize performance while maximizing sensitivity to timeouts in order to minimize the time needed to detect failed cluster processes. autotune [--dryrun] [--sequential-restart] [--writeload=writeload] template cluster_name writeload: ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-predict-table.html
ML_PREDICT_TABLE generates predictions for an entire table of unlabeled data. ML_PREDICT_TABLE Overview ML_PREDICT_TABLE Syntax Required ML_PREDICT_TABLE Parameters ML_PREDICT_TABLE Options Options for Recommendation Models Requirements and Options ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
For information about the implications of this change for server operation and compatibility of the server with clients and connectors, see caching_sha2_password as the Preferred Authentication Plugin. Important To connect to the server using an ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
The preceding filter enables logging of events in the connection class. The preceding definition can be written like this: { "filter": { "class": [ { "name": [ "connection", "general", "table_access" ] } ] } } Logging Specific Event Subclasses To ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. The server then authenticates the client, determining from ...Pluggable authentication makes it easy for DBAs to choose and change the authentication method used for individual MySQL ...