Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using-ui.html
Transactional and Locking Statements: filters on statements of type BEGIN, COMMIT, ROLLBACK, SAVEPOINT, RELEASE, LOCK, and UNLOCK. To open the Query Analyzer, select Queries from the navigation menu. Figure 32.1 Default Query Analyzer View Table ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-configuration-views-ref.html
Transactional and Locking Statements: filters on statements of type BEGIN, COMMIT, ROLLBACK, SAVEPOINT, RELEASE, LOCK, and UNLOCK. Configuration views are similar to System and User Filters, see Section 14.3.5, “System and User-defined ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
During the analysis, the table is locked with a read lock for InnoDB and MyISAM. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/en/drop-role.html
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 are presumably user ...DROP ROLE removes one or more roles (named collections of ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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 ...