MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 81 to 90 of 95 total results

https://dev.mysql.com/doc/refman/8.0/en/optimization.html

Depending on your job role (developer, DBA, or a combination of both), you might optimize at the level of individual SQL statements, entire applications, a single database server, or multiple networked database servers. This chapter explains how to ...

10.4 Optimizing Database Structure

https://dev.mysql.com/doc/refman/8.0/en/optimizing-database-structure.html

In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the ...

10.2.1.9 Outer Join Optimization

https://dev.mysql.com/doc/refman/8.0/en/outer-join-optimization.html

The RIGHT JOIN implementation is analogous to that of LEFT JOIN with the table roles reversed. MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to ...

25.4.3.6 Defining NDB Cluster Data Nodes

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html

(NDB 8.0.13) The backup log buffer fulfills a role similar to that played by the backup data buffer, except that it is used for generating a log of all table writes made during execution of the backup. The [ndbd] and [ndbd default] sections are ...

25.4.3.3 NDB Cluster Connection Strings

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-connection-strings.html

This connection string is used in establishing a connection to the management server as well as in performing other tasks depending on the node's role in the cluster. With the exception of the NDB Cluster management server (ndb_mgmd), each node ...

29.12.11.16 The replication_group_members Table

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-members-table.html

MEMBER_ROLE Role of the member in the group, either PRIMARY or SECONDARY. This table shows network and status information for replication group members. The network addresses shown are the addresses used to connect clients to the group, and should ...

20.2.1.3 User Credentials For Distributed Recovery

https://dev.mysql.com/doc/refman/8.0/en/group-replication-user-credentials.html

If group members have been set up to support the use of a remote cloning operation as part of distributed recovery, which is available in MySQL 8.0.17 and later, this replication user is also used as the clone user on the donor, and requires the ...

29.12.2.3 The setup_instruments Table

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html

For more information about the role of the setup_instruments table in event filtering, see Section 29.4.3, “Event Pre-Filtering”. The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT ...

29.12.2.4 The setup_objects Table

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html

For more information about the role of the setup_objects table in event filtering, see Section 29.4.3, “Event Pre-Filtering”. The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum ...

8.4.4.8 Using the keyring_okv KMIP Plugin

https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html

Log in to the Oracle Key Vault management console as a user who has the System Administrator role. Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol ...

Displaying 81 to 90 of 95 total results