PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.3Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/validate-password.html
This is true even if an account is locked initially because otherwise unlocking the account later would cause it to become accessible without a password that satisfies the policy. The validate_password component serves to improve security by ...
https://dev.mysql.com/doc/refman/8.0/en/checksum-table.html
During the checksum operation, the table is locked with a read lock for InnoDB and MyISAM. [QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that the contents are the same before ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-failure-handling.html
Prior to MySQL 8.0.27, a backup lock on the donor and recipient blocks concurrent DDL operations. From MySQL 8.0.27, concurrent DDL on the donor is blocked only if the clone_block_ddl variable is set to ON (the default setting is OFF). If the ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
FILE_BLOCK_SIZE: This option—which is specific to InnoDB general tablespaces, and is ignored by NDB—defines the block size for the tablespace data file. For example, an 8 kilobyte file block size can be specified as 8192 or 8K. If you do not ...
https://dev.mysql.com/doc/refman/8.0/en/drop-role.html
As of MySQL 8.0.16, users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. Users who have the DROP ROLE privilege can use this statement only to drop accounts that are locked (unlocked accounts ...DROP ROLE removes one or more roles (named collections of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
STOP GROUP_REPLICATION does not complete until either the situation is resolved (for example, by the lock being released), or the component timeout expires and the modules are shut down regardless of their status. Any existing members that are not ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
OPEN does not take a snapshot of the table, and does not lock the table. If a table is flushed with FLUSH TABLES tbl_name WITH READ LOCK was opened with HANDLER, the handler is implicitly flushed and loses its position. HANDLER tbl_name OPEN [ [AS] ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
The former involves the parser, optimizer, table locking, and runtime evaluation N times each. This behavior ensures that each client can retrieve its own ID without concern for the activity of other clients, and without the need for locks or ...It ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
Attempting to run innochecksum on a tablespace that the server already has open results in an Unable to lock file error. innochecksum obtains an exclusive lock when the --write option is used. This tool reads an InnoDB tablespace file, calculates ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-best-practices.html
FOR UPDATE syntax to lock just the rows you intend to update. Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. Use joins wherever data is pulled ...