Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-an-anomaly-detection-model.html
If running an unsupervised model, the target_column_name parameter must be set to NULL. If running a semi-supervised model: The target_column_name parameter must specify a column whose only allowed values are 0 (normal), 1 (anomalous), and NULL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain-table.html
If the target column is included in the input table, it is not considered when generating prediction explanations. For tables with over ten columns, we suggest a batch_size value of 10. If the input table has more than ten columns, limit it to ten ... ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-metadata.html
The model_metadata column in the model catalog allows you to view detailed information on trained models. For example, you can view the algorithm used to train the model, the columns in the training table, and values for the model explanation. When ...If you import a model from a table, model_metadata stores the name of the database and ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-ml-model-metadata.html
The model_metadata column in the model catalog allows you to view detailed information on trained models. For example, you can view the algorithm used to train the model, the columns in the training table, and values for the model explanation. When ...If you import a model from a table, model_metadata stores the name of the database and ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-explain-table.html
If the target column is included in the input table, it is not considered when generating prediction explanations. If the input table has more than ten columns, limit it to ten rows. A call to ML_EXPLAIN_TABLE can include columns that were not ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-5-0.html
(WL #16685) MySQL HeatWave MySQL HeatWave now supports bulk loading of tables with generated columns, enhancing its data import capabilities. This update allows for seamless handling of both stored and virtual generated columns, enabling you to ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. If an application stores values from a function such as MD5() or SHA1() that returns a string of hex digits, more efficient storage and comparisons ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
MySQL's mechanism for doing this is the AUTO_INCREMENT column attribute, which enables you to generate sequential numbers automatically. If you try to generate a number that exceeds the maximum allowed by the underlying data type, such as by ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog-table.html
The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing numeric identifier for the model. The model handle is generated or set by the user when the ML_TRAIN ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-unsupported.html
The NDB storage engine does not support indexes on virtual generated columns. As with other storage engines, you can create an index on a stored generated column, but you should bear in mind that NDB uses DataMemory for storage of the generated ...