Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-installation-windows-path.html
Warning You must exercise great care when editing your system PATH by hand; accidental deletion or modification of any portion of the existing PATH value can leave you with a malfunctioning or even unusable system. To make it easier to invoke MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-optimization.html
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 depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
Specifically, for users who have privileges at the global level, partial_revokes enables privileges for specific schemas to be revoked while leaving the privileges in place for other schemas. It is possible to grant privileges that apply globally ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
changes only the storage engine used by the table, and leaves the table's partitioning scheme intact. There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
The DISCARD OLD PASSWORD clause for ALTER USER discards an account secondary password, leaving only the primary password. MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed periodically.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
When a client disconnects, the Performance Schema decrements by one the CURRENT_CONNECTIONS column in the row and leaves the TOTAL_CONNECTIONS column unchanged. When a client connects to the MySQL server, it does so under a particular user name and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
The PRE_ACQUIRE_NOTIFY and POST_RELEASE_NOTIFY status values are brief and signify that the metadata locking subsubsystem is notifying interested storage engines while entering lock acquisition operations or leaving lock release operations. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
This may leave you wondering why your changes seem to make no difference! To tell the server to reload the grant tables, perform a flush-privileges operation. If the mysqld server is started without the --skip-grant-tables option, it reads all ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
The asynchronous connection failover mechanism additionally changes connection if the currently connected managed source server leaves the managed group, or is no longer in the majority in the managed group. To activate asynchronous connection ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-async-failover.html
For Group Replication source servers that are defined as part of a managed group, the connection is also failed over to another group member if the currently connected source leaves the group or is no longer in the majority. The following functions ...