Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
progress_monitor_sql_statements (TEXT): specifies an optional SQL statement to monitor the task progress. The execute_prepared_stmt_from_app_async routine creates an asynchronous task associated with a specific application user. Application-level ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-prepare.html
mysql> CREATE TABLE house_price_training ( id INT PRIMARY KEY, house_size INT, address TEXT, state TEXT, price INT ); Insert the sample data into the table. mysql> CREATE TABLE house_price_testing ( id INT PRIMARY KEY, house_size INT, address TEXT, ... This topic describes how to prepare the data to use for a regression machine learning ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
include_document_uris: limits the documents used for context retrieval by including only the specified document URIs. vector_store_columns: optional parameter which specifies column names for finding relevant vector and embedding tables for context ... 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 ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-3-2.html
(WL #16368) MySQL HeatWave GenAI Content generation using MySQL HeatWave GenAI now supports speculative decoding, which enables faster response token generation and speeds up text generation if the target Large Language Model (LLM) supports ... Note ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-data-import.html
Text files: Names of data files in S3 bucket: Specify the names of data files in the Amazon S3 bucket. Apart from text files, you can specify text files in compressed formats such as gzip (.gz) and zstd (.zst). Fields optionally enclosed: Select the ... Importing Data Using the Data Import Feature 7.2.1.2 Importing Data Using the Data Import Feature Use the data import feature in the MySQL HeatWave Console to import data from an Amazon S3 bucket to a DB System in the same ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-9.html
(WL #10619) In the past, query texts were always passed as strings to QueryInterceptor methods, even if the texts were not actually used by them. Now, only suppliers for the texts are passed, and the texts are only extracted by get() calls on the ...
https://dev.mysql.com/doc/refman/9.7/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). Output is larger than for physical backup, particularly when saved in text ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/9.7/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/9.7/en/information-functions.html
This function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE TABLE statement: CREATE TABLE t (c VARCHAR(288) DEFAULT (CURRENT_USER())); DATABASE() Returns the default (current) database name as a ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...