Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-activity-category.html
InnoDB Buffer Cache Sub-Optimal Hit (Rate) Logical I/O is many times faster than physical I/O, and therefore a DBA should strive to keep physical I/O to a minimum. InnoDB Buffer Pool Writes Bottleneck (Rate) For optimal performance, InnoDB should ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-thresholds.html
For example, the expression for the performance advisor, “Thread Cache Size May Not Be Optimal”, is: 100-((%Threads_created% / %Connections%) * 100) < THRESHOLD The THRESHOLD is set at 95% for an Info level alert, 85% for a Warning alert, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analytics.html
The Auto Parallel Load utility facilitates the process of loading data by automating required steps and optimizing the number of parallel load threads. After running a number of queries, use the HeatWave Autopilot Advisor to optimize the workload.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
It analyzes the characteristics of the data and creates an optimized machine learning model that can be used to generate predictions and explanations. HeatWave AutoML is optimized for HeatWave shapes and scaling, and all processing is performed on ... This section describes how to view a chat session ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-rag.html
It involves using algorithms and techniques to automatically identify the best model for a given dataset and optimize its hyperparameters without requiring manual intervention from data analysts or ML practitioners. You provide the data, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
Usage notes: JOIN and GROUP BY query optimizations are only applied if at least one of the JOIN or GROUP BY relations has a key that matches the defined data placement key. If a JOIN operation can be executed with or without the JOIN and GROUP BY ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-troubleshooting.html
To avoid offloading inexpensive queries to HeatWave, the optimizer uses a query cost estimate threshold value. The query cost threshold unit value is the same unit value used by the MySQL optimizer for query cost estimates. Solution A: Your query ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection.html
It can identify common anomaly types, such as local, global, and clustered anomalies, and can achieve an AUC score that is similar to, or better than, when identifying the following: Global anomalies compared to KNN, with an optimal k hyperparameter ... HeatWave AutoML includes anomaly detection, which is also known as outlier ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-progress-tracking.html
Use a second MySQL Client window to track progress with calls to the Performance Schema. Progress tracking does not support ML_MODEL_IMPORT for models in HeatWave AutoML format. For each of these routines, progress tracking tracks each individual ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-advanced-options.html
mysql> CALL sys.ML_TRAIN('heatwaveml_bench.census_train', 'revenue', JSON_OBJECT('task','classification', 'exclude_model_list', JSON_ARRAY('LogisticRegression', 'GaussianNB')), @census_model); The optimization_metric option specifies a scoring ...