Search Results
https://dev.mysql.com/doc/refman/8.4/en/network-namespace-support.html
Suppose that both processes run on a host with IP address 203.0.113.10 but use different namespaces. To address this issue, MySQL enables specifying the network namespace to use for TCP/IP connections, so that both endpoints of connections use an ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
It is possible to grant privileges that apply globally if the partial_revokes system variable is enabled. Specifically, for users who have privileges at the global level, partial_revokes enables privileges for specific schemas to be revoked while ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
For InnoDB tables, both tables must use the same row format. In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE e; Query OK, 0 rows affected (1.31 sec) mysql> ALTER TABLE es3 REMOVE PARTITIONING; Query OK, 0 rows ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
For table-related events, the Performance Schema combines the contents of setup_objects with setup_instruments to determine whether to enable instruments and whether to time enabled instruments: For tables that match a row in setup_objects, table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-tables.html
Bounded progress instrumentation The WORK_COMPLETED and WORK_ESTIMATED columns are both meaningful. The table-copy task has a defined termination (all rows copied), and the stage/sql/copy to tmp table stage is instrumented to provided bounded ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
Both statements yield the same normalized form and thus are considered “the same”: SELECT * FROM orders WHERE customer_id = ? AND quantity > ? The normalized statement contains less information but is still representative of the original ... The ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
In the case that an account uses an authentication method that is the default for both the server and the client program, the server need not communicate to the client which client-side plugin to use, and a round trip in client/server negotiation ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
If both operands of a binary arithmetic operator are parameters, the type of the parameters is decided by the context of the operator. (In this case, an implicit CAST(? AS derived_type) is performed.) The derived type and actual type of the ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
The SYSTEM_USER privilege has an effect on the accounts to which a given user can apply its other privileges, as well as whether the user is protected from other accounts: A system user can modify both system and regular accounts. A regular account ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
To use REPLACE, you must have both the INSERT and DELETE privileges for the table. REPLACE supports explicit partition selection using the PARTITION clause with a list of comma-separated names of partitions, subpartitions, or both. REPLACE ...