Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-overview.html
mysql> CREATE DATABASE classification_data; mysql> USE classification_data; Create the table to insert the sample data into. This topic describes how to prepare the data to use for a classification machine learning model. The classification ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-predictions-ml-predict-row.html
The column names must match the feature column names in the trained table. Generating Predictions on One or More Rows of Data Another way to generate predictions is to create a JSON_OBJECT with specified columns and labels, and then generate ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-data-overview.html
Labeled Data Example A table of data for bank customers can be a labeled dataset. The feature columns in the table have data related to job, marital status, education, and city of residence. You can use some of the data in this table to train a ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-preparing-a-recommendation-model.html
mysql> CREATE DATABASE recommendation_data; mysql> USE recommendation_data; Create the table to insert the sample data into. mysql> CREATE TABLE training_dataset ( user_id VARCHAR(3), item_id VARCHAR(3), rating DECIMAL(3, 1), PRIMARY KEY (user_id, ... This topic describes how to prepare the data to use for a recommendation machine learning model using explicit ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-prepare.html
mysql> CREATE DATABASE regression_data; mysql> USE regression_data; Create the table to insert the sample data into. mysql> CREATE TABLE house_price_training ( id INT PRIMARY KEY, house_size INT, address TEXT, state TEXT, price INT ); Insert the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-vector-store-overview.html
About Accelerated Processing of Queries on Vector-Based Tables GenAI lets you run queries on tables that contain vector embeddings at an accelerated pace by offloading them to the MySQL AI Engine (AI engine). However, for query offload to be ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-user-configurable-system-variables.html
Note:Click on the name of a system varuable in Table 19-7 to see its description in the MySQL Reference Manual. skip_name_resolve OFF sort_buffer_size 262144 sql_mode ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ... User-Configurable System Variables 19.5 User-Configurable System Variables Configure the following global system variables with the MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
This example changes the SQL statement executed by myevent to one that deletes all records from mytable; it also changes the schedule for the event such that it executes once, one day after this ALTER EVENT statement is run. ALTER EVENT myevent ON ...The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API calls. If the redo log files occupy less space than the specified value, dirty pages are flushed from the buffer pool to ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
Locking Service Monitoring The locking service is implemented using the MySQL Server metadata locks framework, so you monitor locking service locks acquired or waited for by examining the Performance Schema metadata_locks table. MySQL distributions ...