Search Results
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
This is also true for a semijoin, provided the optimization strategy employed is firstMatch (see Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations). This optimization improves the efficiency of direct comparisons between a ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT privilege governs the creation, modification, and deletion of events. For example, suppose that ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-tablespace-encryption.html
InnoDB data-at-rest encryption is designed to transparently apply encryption within the database without impacting existing applications. Is data decrypted for users who are authorized to see it? A.17.2. What are the encryption algorithms used with ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. You can either create the local table and specify the connection string (containing the server name, login, password) to be used ... To create a FEDERATED table you should follow these steps: Create the table on the remote ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ... (You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
SQL:1999 and later permits such nonaggregates per optional feature T301 if they are functionally dependent on GROUP BY columns: If such a relationship exists between name and custid, the query is legal. SQL-92 and earlier does not permit queries ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
At this point server s2 only needs to be added to the already existing group. At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-fault.html
The donor for distributed recovery is selected randomly from the existing list of suitable online group members in the current view. Because this method of state transfer uses the existing MySQL replication framework, it is possible that some ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-failure-detection.html
Where the network is unstable and members frequently lose and regain connection to each other in different combinations, it is theoretically possible for a group to end up marking all its members for expulsion, after which the group would cease to ... Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the group is not communicating with the others, and is therefore suspected of being out of ...