Search Results
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 ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
Warning Changing privileges and permissions improperly on MySQL can potentially cause your server installation to have non-optimal security properties. This section explains the symptoms and resolutions for the most commonly encountered issues with ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core.html
optionsBuilder.UseMySQL("server=localhost;database=library;user=user;password=password"); } Limitations The Connector/NET implementation of EF Core has the following limitations: Memory-Optimized Tables is not supported. MySQL Connector/NET ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework60.html
DbSet.AddRange/RemoveRange provides an optimized way to add or remove multiple entities from a set. MySQL Connector/NET integrates support for Entity Framework 6 (EF6), which now includes support for cross-platform application deployment with the ...