Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-multi-primary-mode.html
20.1.3.2.2 Data Definition Statements In a Group Replication topology in multi-primary mode, care needs to be taken when executing data definition statements, also commonly known as data definition language (DDL). MySQL 8.4 supports atomic Data ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Evaluation of ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
The LOAD DATA statement loads a data file into a table. The statement can load a file located on the server host, or, if the LOCAL keyword is specified, on the client host. In theory, a patched server could tell the client program to transfer a ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
An INSERT statement also accesses only one partition per inserted row; this is true even for a table that is partitioned by HASH or KEY although this is not currently shown in the output of EXPLAIN. Important Invalid DATE and DATETIME values ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-filtering.html
Global and Thread Consumers Wait Event Consumers Stage Event Consumers Statement Event Consumers Transaction Event Consumers Statement Digest Consumer Global and Thread Consumers global_instrumentation is the highest level consumer. Statement Event ...To enable or disable a consumer, set its ENABLED value to YES or ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
Use the CREATE USER statement to associate an account with an authentication plugin, or ALTER USER to change its plugin. The server checks statements executed during the client session by employee_ext against the privileges granted to employee. For ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
Attribute promotion can be used with both statement-based and row-based replication, and is not dependent on the storage engine used by either the source or the replica. Important Whether you use statement-based or row-based replication, the ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
This statement reconfigures the active TLS context from the current values of the TLS context-related system variables. Instead, a warning is generated and encryption is disabled for new connections on the interface to which the statement applies.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-interface-usage.html
Setting the flag to 1 cause the client to attempt reconnecting to the server before giving up if a statement cannot be performed because of a lost connection. While a connection is active, the client may send SQL statements to the server using ...