Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-ddlstatementactivity-category.html
Table 6.5 DDL Statement Activity Metrics NameDescriptionAlter DB (Delta) The total number of ALTER DATABASE statements executed. Alter Table (Delta) The total number of ALTER TABLE statements executed. Alter Tablespace (Delta) The total number of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
Tables can have a combination of multiple stored and virtual generated columns. Table 4.1 Supported Data Types for Bulk Ingest Data Type Available MySQL version Comments INT All SMALLINT All TINYINT All BIGINT All CHAR All BINARY All VARCHAR All ...
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-limitations.html
Memory Limitations The table used to train a model cannot exceed 10 GB, 100 million rows, or 1017 columns. Routine and Query Limitations ML_EXPLAIN_TABLE and ML_PREDICT_TABLE are compute intensive processes, with ML_EXPLAIN_TABLE being the most ...
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 ...