Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training.html
The training dataset used with ML_TRAIN must reside in a table on the MySQL server. AutoML supports tables up to 10 GB in size with a maximum of 100 million rows and or 1017 columns. mysql> CALL sys.ML_TRAIN('table_name', 'target_column_name', ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-explain-row.html
A table can include extra columns, and still use the AutoML model. This allows side by side comparisons of target column labels, ground truth, and explanations in the same table. The column names must match the feature column names in the table used ... The ML_EXPLAIN_ROW routine generates explanations for one or more rows of unlabeled ...
https://dev.mysql.com/doc/relnotes/mysql-ai/en/news-9-5-0.html
This feature collects information on the schemas, tables, and columns that you have access to, and then uses a Large Language Model (LLM) to generate an SQL query for the question pertaining to your data. (Bug #38193173, WL #16315) MySQL AI now lets ... AutoML GenAI AutoML MySQL AI AutoML now supports advanced recommendation capabilities with the introduction of Deep Recommendation models, a deep learning-based approach to building embedding models for personalized ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
To configure keyring_aws, you must obtain a secret access key that provides credentials for communicating with AWS KMS and write it to a configuration file: Create an AWS KMS account. Use AWS KMS to create a secret access key ID and secret access ...
https://dev.mysql.com/doc/workbench/en/wb-intro.html
Data Modeling (Design): Enables you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all aspects of your database using the comprehensive Table Editor. MySQL Workbench ... This chapter provides general information about MySQL Workbench and how it has ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...If ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
Table 5.7 JSON Functions Name Description -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). JSON_ARRAY() Create JSON array JSON_ARRAY_APPEND() Append data to JSON document JSON_ARRAY_INSERT() Insert into JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-limitations.html
The model catalog schema created by the ML_TRAIN procedure incorporates the user name in the schema name (e.g., ML_SCHEMA_joesmith), and a period is not a permitted schema name character. Memory Limitations The table used to train a model cannot ...
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. The following example queries the model ... When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...