Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html
MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS series). LTS releases have 8+ years of support and are meant for production use. Performing a minor version upgrade is ...
https://dev.mysql.com/doc/refman/8.4/en/view-algorithms.html
If no ALGORITHM clause is present, the default algorithm is determined by the value of the derived_merge flag of the optimizer_switch system variable. For additional discussion, see Section 10.2.2.4, “Optimizing Derived Tables, View References, ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions.html
For information about optimization and window functions, see Section 10.2.1.21, “Window Function Optimization”. MySQL supports window functions that, for each row from a query, perform a calculation using rows related to that row. The following ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(Bug #36593244) An optimizer hint was ignored, unexpectedly requiring the use of FORCE INDEX, when querying a view that included a UNION. (Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for <NAME>Execute</NAME>. (Bug #36686351) ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
(Bug #37704514) Performance: Redundant conditions in some queries optimized away in MySQL 8.0 were no longer removed in later versions, leading to a significant drop in the performance of such queries. With optimizer_switch set to ... Note These ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-7.html
Audit Log Notes Compilation Notes SQL Function and Operator Notes InnoDB Notes Optimizer Notes Packaging Notes Performance Schema Notes Bugs Fixed Audit Log Notes Fixed an issue related to audit log strategy. (Bug #37003342, Bug #36768046, Bug ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-8.html
Compilation Notes Configuration Notes InnoDB Notes Optimizer Notes Packaging Notes Pluggable Authentication Security Notes Bugs Fixed Compilation Notes The cmake macro MYSQL_CHECK_PROTOBUF did not properly handle multiple calls when using system ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-automl.html
Oracle AutoML automates this workflow, providing you with an optimal model given a time budget. The AutoML ML_TRAIN routine leverages Oracle AutoML technology to automate the process of training a machine learning model. Oracle AutoML replaces the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-ml-model-metadata.html
See Section 8.1.15, “Optimization and Scoring Metrics” to review available metrics. The model_metadata column in the model catalog allows you to view detailed information on trained models. For example, you can view the algorithm used to train ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-quality.html
ML_SCORE scores a model by generating predictions using the feature columns in a labeled dataset as input and comparing the predictions to ground truth values in the target column of the labeled dataset. You cannot score a model with a topic ...