Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load-partitions.html
As of MySQL 9.1.0, MySQL HeatWave supports partitions for DB System tables. Loading Partitions using Secondary _Load Clause To load partitions into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement with the PARTITION ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-generate-explanation.html
Generate Prediction Explanations for a Table After training a model, you can generate a table of prediction explanations on the testing_data dataset by using the default Permutation Importance prediction explainer. To generate explanations for other ... After training a classification model, you can query the default model explanation or query new model ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-metrics.html
If the input table overlaps with the training table, and remove_seen is true, which is the default setting, then the model will not repeat a recommendation and it ignores the overlap items. The precision_at_k value for the input table is the average ... The ML_TRAIN routine includes the optimization_metric option, and the ML_SCORE routine includes the metric ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model.html
Before You Begin Complete the following tasks: Prepare Data for a Recommendation Model Train a Recommendation Model Options for Generating Predictions The options for ML_PREDICT_ROW and ML_PREDICT_TABLE include the following: threshold: The optional ...To generate predictions, use the sample data from the testing_dataset ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-2-2.html
This default value change will impact the following processes: New vector store tables will be created using multilingual-e5-small by default. Retrieval augmented generation (RAG) will search tables created using the default embedding model, ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-privatelink-details.html
PrivateLink Details 6.3.5.1 PrivateLink Details The PrivateLink Details page has the following tabs: Table 6-3 Tabs on the PrivateLink Details Page Name Description Details Details of the PrivateLink. Table 6-4 PrivateLink Details Field Description ...Endpoints (for Egress PrivateLinks only) Details of the connectivity provided by this Egress ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value when using the insertRow() method. getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is ...
https://dev.mysql.com/doc/refman/9.7/en/access-control.html
For example: SHOW GRANTS FOR 'joe'@'office.example.com'; SHOW GRANTS FOR 'joe'@'home.example.com'; Internally, the server stores privilege information in the grant tables of the mysql system database. The MySQL server reads the contents of these ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-file-removal.html
Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables. With the removal of .frm files: The 64KB table definition size limit imposed by the .frm file structure is removed. The Information Schema ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. A character-based ngram full-text parser that supports Chinese, Japanese, and Korean (CJK), and a word-based MeCab parser plugin that supports Japanese are provided for use with ...