Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-threadpool-category.html
Table 7.36 Thread Pool Configuration Metrics NameDescriptionAlgorithm This variable controls which algorithm the thread pool plugin uses. A value of 0 (the default) uses a conservative low-concurrency algorithm which is most well tested and is known ... Lists the Thread Pool configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection-model-types.html
Unsupervised Anomaly Detection When running an unsupervised anomaly detection model, the machine learning algorithm requires no labeled data. This type of machine learning algorithm uses a specific set of labeled data along with unlabeled data to ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
The files are named, booking.tsv1, booking.tsv2, ..., booking.tsv25:LOAD DATA FROM S3 's3-us-east-1://mysql-heatwave-data-us-east-1/airportdb/booking.tsv.' COUNT 25 IN PRIMARY KEY ORDER INTO TABLE booking COLUMNS TERMINATED BY '\t' LINES TERMINATED ... Importing Data Using the Bulk Ingest Feature 7.2.2.2 Importing Data Using the Bulk Ingest Feature Connect to a DB System and bulk ingest data from an Amazon S3 bucket to a DB System in the same ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
Replica_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, table, or hash scan). Options and Variables Introduced in MySQL 8.4 Options and Variables Deprecated in ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
MySQL supports binary log transaction compression; when this is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a Transaction_payload_event). You can also ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
(Bug #89511, Bug #27484882) InnoDB performs cascading operations using a depth-first search algorithm on the records of the index that corresponds to the foreign key constraint. MySQL supports foreign keys, which permit cross-referencing related ...
https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table tbl_name. ALGORITHM and LOCK clauses may be given to influence the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-message-compression.html
Group Replication uses the LZ4 compression algorithm to compress messages sent in the group. Note that the maximum supported input size for the LZ4 compression algorithm is 2113929216 bytes. With the LZ4 compression algorithm, do not set a value ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
20.1.3.1.1 Primary Election Algorithm The automatic primary member election process involves each member looking at the new view of the group, ordering the potential new primary members, and choosing the member that qualifies as the most suitable.
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-flushing.html
Adaptive Flushing InnoDB uses an adaptive flushing algorithm to dynamically adjust the rate of flushing based on the speed of redo log generation and the current rate of flushing. The adaptive flushing algorithm helps avoid such scenarios by ...