Search Results
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
Session extends AutoCloseable so it can be used in the try-with-resources pattern. This pattern allows the application to create a session in the try declaration and regardless of the outcome of the try/catch/finally block, clusterj will clean up ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
This topic contains the following sections: Before You Begin Generate a Vector Embedding for Specified Text Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and privileges. To Run Batch Queries, add the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-progress-tracking.html
You can monitor the progress of MySQL HeatWave AutoML routines through Performance Schema queries made from a second MySQL Client session. mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', JSON_OBJECT('task', 'classification'), ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-25.html
When a new query shares query execution plan nodes with previously executed queries, the actual statistics collected from previously executed queries are used instead of estimated statistics, which improves query execution plans, cost estimations, ...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 MySQL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-27-u2.html
For MySQL HeatWave queries that join large and small relations, bloom filters reduce the amount of data processed by early filtering and the amount of memory used during query processing. (WL #14752) The rpd_query_stats table, which stores MySQL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-0-0.html
(WL #15931) MySQL HeatWave Autopilot MySQL HeatWave Autopilot includes improvements to cardinality estimation for queries that run in MySQL HeatWave and MySQL HeatWave Lakehouse. (WL #15817) MySQL HeatWave MySQL HeatWave includes improvements to ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-1.html
(WL #16905) MySQL HeatWave AutoML and MySQL HeatWave GenAI now support enhanced concurrency, enabling the processing of multiple queries simultaneously across different sessions, which significantly improves overall performance and efficiency. (WL ... These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-workload-perf-data.html
Recent Queries Displays recently executed queries with the Query Text, the query Start Time, and the Duration (ms) of the query. You are provided with options to Search by Query Text for specific queries and to Aggregate Executions to view ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
An implication of this behavior is that EXPLAIN for full-text queries is typically slower than for non-full-text queries for which no expression evaluation occurs during the optimization phase. Optimizations are applied to certain kinds of FULLTEXT ... The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...