Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-supported-models.html
This topic contains the following sections: Before You Begin View Available Models MySQL HeatWave In-Database LLMs OCI Generative AI Service LLMs MySQL HeatWave In-Database Embedding Models OCI Generative AI Service Embedding Models Languages What's ... This topic provides the list of languages that MySQL HeatWave GenAI supports and the embedding models as well as large language models (LLMs) that are available in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
For example, the following statement generates one Query event, two TableRead events, and a TableInsert events: INSERT INTO t3 SELECT t1.* FROM t1 JOIN t2; Each TableXXX event contains <TABLE> and <DB> elements to identify the table to which the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
To generate AutoML queries, NL2ML leverages the databases, tables, and table columns in the DB System. mysql> CALL sys.NL2ML (query, response); Replace query with your question in natural language, and response with the name of the session variable ... Available as of MySQL 9.4.0, the NL2ML routine enables you to learn about MySQL HeatWave AutoML by leveraging Oracle Cloud Infrastructure Generative AI (OCI) and asking questions in natural ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-summarize-content.html
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 summarize. This ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
If you do not specify a model handle name, a model handle is automatically generated that is based on the database name, input table name, the user name training the table, and a unique numerical identifier. mysql> SET @variable = 'model_handle'; ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
unique_subquery This type replaces eq_ref for some IN subqueries of the following form: value IN (SELECT primary_key FROM single_table WHERE some_expr) unique_subquery is just an index lookup function that replaces the subquery completely for better ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-key-cache.html
To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems. Otherwise, the server chooses a cache block buffer containing a different table index block (or blocks) and replaces the data ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-handles.html
If you do not specify a model handle name, a model handle is automatically generated that is based on the database name, input table name, the user name training the table, and a unique numerical identifier. mysql> SET @variable = 'model_handle'; ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
You can pass the text string in the routine manually or use data from tables in your database. Generate a Vector Embedding for Specified Text To generate a vector embedding using MySQL HeatWave GenAI, perform the following steps: To define the text ... This section describes how to generate vector embeddings using the ML_EMBED_ROW MySQL HeatWave GenAI ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, UPDATE, and TABLE statements. MySQL 8.4 supports a FOR SCHEMA clause, which ...