Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-scanned.html
MySQL HeatWave tracks the amount of base relation data scanned by all queries collectively and by individual queries. To view a cumulative total of data scanned (in MB) by all successfully executed MySQL HeatWave queries from the time the MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin Summarize Text Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and privileges.
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
This offloading reduces execution time, especially for long-running and complex queries. However, it may not be beneficial for SELECT queries that produce large result sets, as the large volume of DML operations on the DB System can limit ... This ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Auto Query Time Estimation provides runtime information for successfully executed queries and runtime estimates for EXPLAIN queries, queries cancelled with Ctrl+C, and queries that fail due to out of memory errors. The recommendations are based upon ... Workload optimization for online analytical processing, OLAP, includes using dictionary encoding for certain string columns and defining data placement keys to optimize for JOIN and GROUP BY query ...
https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the derived table should decrease the number of rows that need to be processed and thus speed ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema specification. This can be done using either of the functions detailed in this section, both of which take two arguments, a JSON schema, and a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-summarize-content.html
The following sections in this topic describe how to summarize exiting content using the GenAI: Before You Begin Summarizing Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and privileges. For Running Batch ...Summarizing Content To summarize text, perform the following steps: To define the text that you want to summarize, set the @text variable: mysql> SET @text="TextToSummarize"; Replace TextToSummarize with the text that you want to ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-model-import.html
Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model catalog. To learn how to use ML_MODEL_IMPORT to share models, see Grant Other Users Access to a Model. ML_MODEL_IMPORT Overview MySQL AI supports the import of AutoML and ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-26.html
Deprecation and Removal Notes Pluggable Authentication Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes The TLSv1 and TLSv1.1 connection protocols now are deprecated and support for them is subject to removal in a future ...