Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-metadata.html
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 you run the ML_MODEL_IMPORT routine, the imported table has a model_metadata column that stores the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-explanations.html
Generate Prediction Explanations for a Table After training a model, you can generate a table of prediction explanations on the house_price_testing dataset by using the default Permutation Importance prediction explainer. To generate explanations ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-an-anomaly-detection-model.html
Requirements for Anomaly Detection Training Consider the following based on the type of anomaly detection you are running: Set the task parameter to anomaly_detection for running anomaly detection on table data, or log_anomaly_detection for running ... After preparing the data for an anomaly detection model, you can train the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model-ratings-rankings.html
mysql> CALL sys.ML_MODEL_LOAD('recommendation_use_case', NULL); Make predictions for the test dataset by using the ML_PREDICT_TABLE routine. mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace ... This ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Select either of the following SSL modes: Disabled: Establishes an unencrypted connection between the source and target. Required: (Default) If the server supports encrypted connection, establishes an encrypted connection. The connection attempt ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
MySQL 8.4.6 is a new release of the 8.4 LTS (Long Term Support) series, which focuses on security and bug fixes and are recommended for customers who prefer established behavior. MySQL 8.0.43 is a new release of the 8.0 BugFix series, which focuses ... Release Notes 23 Release Notes Release notes for MySQL HeatWave on AWS 2025-08-26: Data Storage Size Can Now Be Increased For Highly Available DB Systems You can now increase the data storage size of a highly available DB System ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
InnoDB does not keep an internal count of rows in a table because concurrent transactions might “see” different numbers of rows at the same time. SELECT COUNT(*) FROM tbl_name query performance for InnoDB tables is optimized for single-threaded ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ LOCK). After that, the dump becomes lock-free and does not disturb reads and writes on the tables. It was assumed earlier that ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-filter.html
Names of tables and database not containing any special characters need not be quoted. Values used with REPLICATION_WILD_TABLE and REPLICATION_WILD_IGNORE_TABLE are string expressions, possibly containing (special) wildcard characters, and so must ...Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD first (and restarted with START REPLICA SQL_THREAD ...
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
CREATE FUNCTION requires the INSERT privilege for the mysql system schema because it adds a row to the mysql.func system table to register the function. CREATE FUNCTION also adds the function to the Performance Schema user_defined_functions table ...