Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE TABLESPACE. The UNDO keyword must be specified to drop an undo tablespace. Only undo tablespaces created using CREATE UNDO TABLESPACE ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
INSTALL COMPONENT adds the component to the mysql.component table (an InnoDB table), and the components to load at startup are read from this table, which is only accessible after InnoDB is initialized. Note Loading a log component implicitly using ... In MySQL 8.4, error logging uses the MySQL component architecture described at Section 7.5, “MySQL ...