MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 211 to 220 of 226 total results

29.20 Restrictions on Performance Schema

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-restrictions.html

For example, if you select events from a performance_schema table into a temporary table, intending to join that table with the original table later, there might be no matches. The Performance Schema avoids using mutexes to collect or produce data, ...

10.3.2 Primary Key Optimization

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

These unique IDs can serve as pointers to corresponding rows in other tables when you join tables using foreign keys. The primary key for a table represents the column or set of columns that you use in your most vital queries. Query performance ...

8.2.2 Privileges Provided by MySQL

https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html

NDB_STORED_USER Enables the user or role and its privileges to be shared and synchronized between all NDB-enabled MySQL servers as soon as they join a given NDB Cluster. The privileges granted to a MySQL account determine which operations the ...

14.18.3 Asynchronous Replication Channel Failover Functions

https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html

If the replication channel is on a Group Replication primary for a group where failover between replicas is active, the source list is broadcast to all the group members when they join or when it is updated by any method. The following functions, ...

19.1.3.2 GTID Life Cycle

https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html

For example, you might need to do this after carrying out test queries to verify a replication setup on new GTID-enabled servers, or when you want to join a new server to a replication group but it contains some unwanted local transactions that are ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...

19.1.6.4 Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html

The dependency information in those logs is used to assist the process of state transfer from a donor's binary log for distributed recovery, which takes place whenever a member joins or rejoins the group. Startup Options Used with Binary Logging ...

19.1.6.3 Replica Server Options and Variables

https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html

Group Replication—MySQL 9.2.0 and later: When a group primary is receiving and applying transactions from an external source through an asynchronous channel and a new member joins the group, replica_preserve_commit_order=ON is not guaranteed to ...

19.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication

https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html

As of MySQL 8.0.22, DML operations that read data from MySQL grant tables (through a join list or subquery) but do not modify them are performed as non-locking reads on the MySQL grant tables and are therefore not safe for statement-based ...For ...

8.1.7 Client Programming Security Guidelines

https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html

It would be nearly impossible, for example, to debug a common 10-way join SELECT statement without providing information regarding which databases, tables, and other objects are involved with problems. Client applications that access MySQL should ...

15.7.7.22 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/8.0/en/show-index.html

The higher the cardinality, the greater the chance that MySQL uses the index when doing joins. SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This ...

Displaying 211 to 220 of 226 total results