Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
-MAXVALUE represents the greatest lower bound.) For [LINEAR] KEY, RANGE COLUMNS, and LIST COLUMNS partitioning, the partitioning expression consists of a list of one or more columns. For [LINEAR] KEY partitioning, the partitioning function is ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-cloud-options.html
The user credentials are authenticated by the Swift TempAuth identity system when the --cloud-tempauth-url option is used, by the OpenStack Keystone identity service when the --cloud-identity-url option is used, and by HTTP Basic Authentication when ... These options are for using cloud storage for single-file ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-data-placement.html
Data placement keys are used to partition table data among MySQL HeatWave nodes when loading tables. Partitioning table data by JOIN and GROUP BY key columns can improve query performance by avoiding costs associated with redistributing data among ...This topic contains the following sections: Run Auto Data Placement Usage Notes Auto Data Placement Examples What's Next Run Auto Data Placement Note To run Advisor for both encoding and data placement recommendations, run Auto Encoding first, apply the recommended encodings, rerun the queries, and then run Auto Data ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
The most important preconditions for using indexes for GROUP BY are that all GROUP BY columns reference attributes from the same index, and that the index stores its keys in order (as is true, for example, for a BTREE index, but not for a HASH ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Since NDB does not use single-key access for ordered indexes, the counts for tot_key_reads, tot_key_inserts, tot_key_updates, tot_key_writes, and tot_key_deletes are not incremented by ordered index operations. Note When using tot_key_writes, you ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
Note The NDB storage engine uses idempotent execution mode, which suppresses duplicate-key and other errors that otherwise break circular replication of NDB Cluster. In the event of a node failure, errors in replication of NDB tables without primary ... This section discusses known problems or issues when using replication with NDB ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
The following list describes the permissible opt_name flag names, grouped by optimization strategy: Batched Key Access Flags batched_key_access (default off) Controls use of BKA join algorithm. For batched_key_access to have any effect when set to ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
read_key Handler_read_key ASYNC COUNTER The number of requests to read a row based on a key. read_last Handler_read_last ASYNC COUNTER The number of requests to read the last key in an index. read_next Handler_read_next ASYNC COUNTER The number of ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-custom.html
The unedited file in this case is shown here: <?xml version="1.0"?> <data> <value type="object" struct-name="workbench.model.reporting.TemplateInfo" id="{BD6879ED-814C-4CA3-A869-9864F83B88DF}" struct-checksum="0xb46b524d"> <value type="string" ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
ALGORITHM=1 causes the server to use the same key-hashing functions as MySQL 5.1 when computing the placement of rows in partitions; ALGORITHM=2 means that the server employs the key-hashing functions implemented and used by default for new KEY ...