Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
If index type is set to SPATIAL then the created index is the same as it would be created by issuing CREATE INDEX with the SPATIAL keyword, see SPATIAL Index Optimization and Creating Spatial Indexes. To make large collections of documents more ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/devapi-users-working-with-relational-tables-and-documents.html
SQL tables contribute strictly typed value semantics, predictable and optimized storage. After seeing how to work with documents and how to work with relational tables, this section explains how to combine the two and work with both at the same ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/understanding-automatic-document-ids.html
The _id field must be sequential (always incrementing) for optimal InnoDB insertion performance (at least within a single server). This sections describes in detail how document IDs are generated and how to interpret them. X DevAPI relies on ...
https://dev.mysql.com/doc/heatwave/en/heatwave-status-variables.html
Execution occurs if query processing using the secondary engine advances past the preparation and optimization stages. Data is tracked in megabytes and is a cumulative total of data scanned since the MySQL HeatWave Cluster was last started. The ...
https://dev.mysql.com/doc/heatwave/en/index.html
It covers how to load data from the DB System and Object Storage, accelerate query processing, optimize workloads, and use the machine learning and generative AI features of MySQL HeatWave. For information about creating and managing a MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
Auto Parallel Load is a feature of MySQL HeatWave that automates many of the steps for loading data, which include the following: Excluding schemas, tables, and columns that cannot be loaded. Defining RAPID as the secondary engine for tables that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
In the following example, Auto Encoding is run in recommend mode, which analyzes column data, checks the amount of memory on the MySQL node, and provides encoding recommendations intended to reduce the amount of space required on MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
Autopilot Indexing can generate secondary index recommendations that optimize the overall workload performance. Autopilot Indexing obtains workloads from the statement digest history stored in the Performance Schema, evaluates them, and identifies ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
Runtime data can be used for query optimization, troubleshooting, or to estimate the cost of running a particular query or workload on MySQL HeatWave. Auto Query Time Estimation provides: Runtimes for successfully executed queries Runtime estimates ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...