Search Results
https://dev.mysql.com/doc/refman/8.4/en/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. When the optimizer evaluates plans ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. The OBJECT_TYPE column indicates the type of object to which a row applies. TABLE filtering affects table I/O events ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this channel. GTID auto-positioning must be in use for the channel (SOURCE_AUTO_POSITION = ...
https://dev.mysql.com/doc/refman/8.4/en/xa-restrictions.html
XA transaction support is limited to the InnoDB storage engine. For “external XA,” a MySQL server acts as a Resource Manager and client programs act as Transaction Managers. For “Internal XA”, storage engines within a MySQL server act as ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-eventual-consistency.html
MySQL Cluster Manager guarantees eventual consistency among agents, meaning that: Any message communicated among agents is either delivered or not delivered to ALL agents (instead of delivered to some and missed by others). Order of delivery for ...
https://dev.mysql.com/doc/workbench/en/wb-admin.html
MySQL Workbench provides a visual interface to administer your MySQL environment. The available visual tools help configure your MySQL servers, administer users, perform backup and recovery, inspect audit data, and view database health.
https://dev.mysql.com/doc/workbench/en/wb-creating-views.html
You can add views to a database either from the Physical Schemas section of the MySQL Model page or from the EER Diagram.
https://dev.mysql.com/doc/workbench/en/wb-develop.html
A set of visual tools to create, edit, and manage SQL queries, database connections, and objects.
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers.html
Microsoft Windows does not require additional drivers to be installed and configured, but Linux (and macOS) do. The following sections include specific instructions for each type of system.
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-instance-startup-shutdown.html
The Administration - Startup / Shutdown tab enables you to perform the following service-control actions: View the Startup Message Log. With a valid connection established, and the connection tab for it open, you can access the control actions from ...