Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-table.html
ML_PREDICT_TABLE generates predictions for an entire table of unlabeled data and saves the results to an output table. ML_PREDICT_TABLE Overview ML_PREDICT_TABLE Syntax Required ML_PREDICT_TABLE Parameters ML_PREDICT_TABLE Options Options for ...
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/audit-log-file-formats.html
Elements following that one represent events such as client connect and disconnect events, executed SQL statements, and so forth. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
To read remote binary logs, the connection parameter options can be given to indicate how to connect to the server. mysqlbinlog's own connection compression does less if transaction payloads are already compressed, but still operates on uncompressed ... The server's binary log consists of files containing “events” that describe modifications to database ...