PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-enabling-monitors.html
For example: ===================================== 2014-10-16 18:37:29 0x7fc2a95c1700 INNODB MONITOR OUTPUT ===================================== The header for the standard InnoDB Monitor (INNODB MONITOR OUTPUT) is also used for the Lock Monitor ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
Handler_external_lock The server increments this variable for each call to its external_lock() function, which generally occurs at the beginning and end of access to a table instance. Innodb_buffer_pool_pages_misc The number of pages in the InnoDB ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html
Another set of functions permits version tokens to be locked and unlocked. mysql> SELECT version_tokens_lock_exclusive('lock1', 'lock2', 10); +-----------------------------------------------------+ | version_tokens_lock_exclusive('lock1', 'lock2', ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock Detection”. It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications. Keep ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-scheduling.html
InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks. When multiple transactions are waiting for a lock on the same object, the CATS algorithm determines which transaction ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
--ndb-log-exclusive-reads=[0|1] Command-Line Format --ndb-log-exclusive-reads[={OFF|ON}] System Variable ndb_log_exclusive_reads Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value 0 Starting the server with this ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-obtaining-parent-events.html
Rows of this table have a THREAD_ID column indicating the thread ID of the session that owns the lock, and an EVENT_ID column indicating the Performance Schema event that caused the lock. To find lock information, data_locks is the table containing ...The relation is based on a nested set data model, so the join has several ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
As of MySQL 8.0.13, you can rename tables locked with a LOCK TABLES statement, provided that they are locked with a WRITE lock or are the product of renaming WRITE-locked tables from earlier steps in a multiple-table rename operation. For example, ... RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
Group Replication's certification process for concurrent transactions does not take into account gap locks, as information about gap locks is not available outside of InnoDB. InnoDB does not use gap locks in READ COMMITTED, which aligns the local ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
To do so, stop updating the related tables, commit all transactions, acquire shared locks on the tables, and perform the export operations. FOR EXPORT must remain open while the operation is running; otherwise, the .cfg file is removed as locks are ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table ...