Search Results
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/mysql-ai/9.4/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.4/en/mys-ai-aml-ml-model-metadata.html
See Section 7.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.4/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 ...
https://dev.mysql.com/doc/workbench/en/wb-develop-object-management-inspector.html
It allows you to perform maintenance tasks on tables such as ANALYZE, OPTIMIZE, CHECK, and CHECKSUM TABLE. The Schema Inspector and Table Inspector each include the ability to analyze and repair tables, and also view table metrics. Schema Inspector ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-online-backup.html
This section describes how to configure a backup profile that defines what should be backed up, where the backup should be stored, and when (the frequency) it should be backed up. With an active MySQL connection tab open, select MySQL Enterprise ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
Operations include "Analyze Table", "Optimize Table", "Check Table", and "Checksum Table". The Navigator area of the sidebar contains options to manage the active MySQL connection. It also lists the schemas on the server for that connection. To ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor.html
The integrated EXPLAIN plans provide data to help optimize the your queries. The visual SQL editor consists of a set of specialized editors (query, schema, table, and so on) and three panels: sidebar, secondary sidebar, and output area. Each editor ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
To render a secondary index (an index other than the primary key or a unique column) invisible to the optimizer, deselect the Visible option. The Indexes subtab contains all of the index information for your table. The following figure shows an ...