Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-model-sharing.html
Share Your Models To share a model you created, you can use the ML_MODEL_EXPORT and ML_MODEL_IMPORT routines. The other user can then run AutoML commands on the imported model. As the admin user, train and load the model to export. If you need to ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-predictions-ml-predict-row.html
mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); For more information about training and loading models, see Train a Model and Load a Model. After training and loading the model, you can generate predictions on one or more rows of data. Inputting ... ML_PREDICT_ROW generates predictions for one or more rows of data specified in JSON ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-a-recommendation-model-similar-items.html
For known items, the output includes a list of predicted items that have similar ratings and are appreciated by similar users. The predictions are expressed in cosine similarity, and range from 0, very dissimilar, to 1, very similar. Before You ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-a-recommendation-model-similar-users.html
For known users, the output includes a list of predicted users that have similar behavior and taste. The predictions are expressed in cosine similarity, and range from 0, very dissimilar, to 1, very similar. Before You Begin Review and complete the ... This topic describes how to generate recommendations for similar ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
For example: mysql> SELECT CONVERT_TZ(O_ORDERDATE, 'UTC','EST') FROM tpch.orders; Rewrite as: mysql> SELECT CONVERT_TZ(O_ORDERDATE, '+00:00','-05:00') FROM tpch.orders; Only UNIX_TIMESTAMP() and FROM_UNIXTIME() functions support a timezone value ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
If the operation does not resume within the allotted time, it aborts and returns an error, and the donor drops the snapshot. This section describes failure handing at different stages of a cloning operation. If the cloning operation is unable to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-flushing.html
For table data stored on SSD, seek time is not a significant factor and you can disable this setting to spread out write operations. Side effects of limiting page flushing during idle periods may include a longer shutdown time following a lengthy ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-per-index-table.html
Compressed InnoDB pages are uncompressed whenever compression fails, or the first time a compressed page is accessed in the buffer pool and the uncompressed page does not exist. For usage information, see Section 17.9.1.4, “Monitoring InnoDB Table ... The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you evaluate the performance and usefulness of compression for specific ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
For more information see, Section 19.4.4, “Using Replication with Different Source and Replica Storage Engines”. For information about setting up a replica, see Section 19.1.2.6, “Setting Up Replicas”, and Section 19.1.2.5, “Choosing a ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-data-split.html
The following data types for this column are supported: DATETIME TIMESTAMP DATE TIME YEAR semisupervised: If running an anomaly detection task, set this to true for semi-supervised learning, or false for unsupervised learning. As of MySQL 9.4.1, ...