Search Results
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/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 ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-60.html
For tables, it's also possible to perform maintenance tasks such as ANALYZE, OPTIMIZE, CHECK, and CHECKSUM TABLE. This section summarizes many of the new features added to MySQL Workbench 6.0, in relation to the MySQL Workbench 5.2 release. The ...