Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-history.html
To view the MySQL HeatWave query history including query start time, end time, and wait time in the scheduling queue, as discussed in Section 5.4.11, “Auto Scheduling”. CONNECTION_ID The connection ID of the client that issued the query.
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd_vector_indexes-table.html
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: DOT, EUCLIDEAN, and COSINE. Queries using the same distance metric ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
mysql> SET @variable = (SELECT model_handle FROM ML_SCHEMA_user1.MODEL_CATALOG ORDER BY build_timestamp DESC LIMIT 1); The following example sets the latest_model variable. mysql> SET @latest_model = (SELECT model_handle FROM ... When ML_TRAIN ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-25.html
For example, the following query can now be offloaded to MySQL HeatWave for execution: SELECT DISTINCT a FROM t1 ORDER BY c DESC; (Bug #32583856) Query plan statistics are now collected and stored in a statistics cache when a query is executed in ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
MySQL HeatWave then uses the zone maps for range and point queries to only scan data chunks that are relevant for the query, and accelerates these queries by an order of magnitude. (WL #14713) A new MySQL optimizer is introduced for MySQL HeatWave ... MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML queries are now monitored and recorded in the Performance Schema tables rpd_query_stats and ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-cloudwatch-metrics.html
dbSystemId Detailed mysql.stats.handler.read_next Count The number of requests to read the next row in key order. dbSystemId Detailed mysql.stats.handler.read_prev Count The number of requests to read the previous row in key order. CloudWatch ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-queries.html
Running MySQL HeatWave Queries 10.1 Running MySQL HeatWave Queries When a MySQL HeatWave Cluster is enabled and the data you want to query is loaded in MySQL HeatWave, queries that qualify are automatically offloaded from the MySQL DB System to the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-client-side-failover-xdevapi.html
For connections with the priority property NOT set for each host in the connection URL, hosts are attempted one after another in a random order. When using the X Protocol, Connector/J supports a client-side failover feature for establishing a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-charsets.html
Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-known-issues-limitations.html
In order to avoid such errors, we recommend setting a connection time zone that uses a monotonic clock by, for example, setting connectionTimeZone=UTC, and configuring other date-time connection properties according to your needs; see Section 6.6, ... The following are some known issues and limitations for MySQL Connector/J: When Connector/J retrieves timestamps for a daylight saving time (DST) switch day using the getTimeStamp() method on the result set, some of the returned values might be ...