Search Results
https://dev.mysql.com/doc/refman/8.4/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/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/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 ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-myisam-fk.html
They are often created for existing databases, to clarify their purpose or document them. MySQL Workbench provides facilities for reverse engineering existing databases, and then creating an EER Diagram automatically. In this case, relationship ...