Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-variables.html
time_zone and timestamp variable settings are not passed to MySQL HeatWave when queries are offloaded.
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data-manually.html
Perform the following steps sequentially for each table that you want to load: Exclude table columns with unsupported data types or columns not used in queries Define a secondary engine on the table. You can manually load data from InnoDB tables in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
Concurrent DML operations and queries on the MySQL node are supported while a data load operation is in progress; however, concurrent operations on the MySQL node can affect load performance and vice versa. MySQL HeatWave provides the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-logical-functions.html
Table 5.8 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value ||, OR Logical OR XOR Logical XOR What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-mathematical-functions.html
What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL HeatWave processes . Table 5.9 Mathematical Functions Name Description ABS() Return ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-misc-functions.html
What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL HeatWave processes . Table 5.13 Miscellaneous Functions Name Description ETAG() ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-monitoring.html
This section provides queries that you can use to monitor MySQL HeatWave.
https://dev.mysql.com/doc/heatwave/en/mys-hw-performance-monitoring.html
Use SQL queries to access this data and check the system status and performance. The MySQL Performance Schema collects statistics on the usage of MySQL HeatWave. The Auto Shape Prediction feature in MySQL HeatWave Autopilot uses MySQL statistics ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-quickstart-prereqs.html
You need an operational MySQL HeatWave DB System with the MySQL HeatWave Cluster enabled to do the following: Load and manage data in the MySQL HeatWave Cluster. However, some of these components have some additional requirements that are listed in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd_vector_indexes-table.html
Queries using the same distance metric are accelerated by the index. The rpd_vector_indexes table provides information about vector indexes created for different vector store or embedding tables. SPACE: Vector distance metric, which can be one of: ...