Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
The AUDIT_ABORT_EXEMPT privilege is available to permit a user account’s queries to always be executed even if an abort item would block them. Table 8.40 audit_log_policy_value Values Value Corresponding audit_log_policy Value 0 or "::none" NONE 1 ...For information about using JSON data in MySQL, see Section 13.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
The HEATWAVE_CHAT routine automatically calls the ML_RAG routine which loads an LLM and runs a semantic search on the available vector stores by default. If the routine cannot find a vector store, then it calls the ML_GENERATE routine and uses ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag.html
The ML_RAG routine performs retrieval-augmented generation (RAG) by: Taking a natural-language query. This routine aims to provide detailed, accurate, and contextually relevant answers by augmenting a generative model with information retrieved ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
You can use this routine for generating and running SQL queries only for databases and tables that you have access to. schemas: specifies the databases to consider for generating and running SQL queries. tables: specifies the tables to consider for ...The routine also runs the generated SQL statement and displays the result ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
This data is available in the slow query log for qualifying queries, and in the context of the audit log it similarly helps to detect outliers for activity analysis. This section describes how to configure audit logging characteristics, such as the ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. A collection is a set of one or more columns included in a FULLTEXT index. For each row in the ...
https://dev.mysql.com/doc/refman/8.4/en/gone-away.html
If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 64MB. This section also covers the related Lost ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
WITH ROLLUP queries, to test whether NULL values in the result represent super-aggregate values, the GROUPING() function is available for use in the select list, HAVING clause, and ORDER BY clause. The GROUP BY clause permits a WITH ROLLUP modifier ...