Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-forecaster.html
For possible metric values and their effects, see Optimization and Scoring Metrics. See Optimization and Scoring Metrics, for information about metrics which can be used for MySQL HeatWave AutoML forecasting. Forecaster Constructor ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-recommender.html
For possible metrics and their effects, see Optimization and Scoring Metrics. See Optimization and Scoring Metrics, for information about the metrics compatible with AutoML recommendation. Recommender Constructor Recommender.train() ...
https://dev.mysql.com/doc/refman/9.7/en/subqueries.html
For information about how the optimizer handles subqueries, see Section 10.2.2, “Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions”. All subquery forms and operations that the SQL standard requires are ...
https://dev.mysql.com/doc/refman/9.7/en/trace-general-structure.html
A trace follows the actual execution path very closely; for each join, there is a join preparation object, a join optimization object, and a join execution object. Calls to the range optimizer, cost evaluations, reasons why an access path is chosen ...Query transformations (IN to EXISTS, outer join to inner join, and so on), simplifications (elimination of clauses), and equality propagation are shown in ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/mysql-ai/9.7/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.7/en/mys-ai-aml-ml-model-metadata.html
See Section 8.1.16, “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.7/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 ...