Search Results
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
It is removed in this release; including LOW_PRIORITY in LOCK TABLES now causes a syntax error. (Bug #36342792) InnoDB: On Windows, keeping a file open without a shared write lock and attempting to acquire the fil_shard mutex caused a deadlock with ...(Bug #36301441) Audit log filtering by type, using error as the type, did not work ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-process.html
It blocks DDL operations (except for those on user-created temporary tables), but not DML operations (except for those not captured by the binary log, like administrative changes to the database) on InnoDB tables. With this lock applied, mysqlbackup ... The following is a very brief outline of the steps performed by mysqlbackup when it creates a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
Here are the privileges required by mysqlbackup: The minimum privileges for the MySQL user with which mysqlbackup connects to the server include: SELECT on all databases and tables, for table locks that protect the backups against inconsistency ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-switchover.html
Locks the current primary cluster by issuing a FLUSH TABLES WITH READ LOCK statement and setting the super_read_only system variable on all member servers, to prevent further changes during the switchover. A controlled switchover makes a selected ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
The earliest the locks these statements hold can be released (whether they be MyISAM table-level locks or row-level locks in some other storage engine such as InnoDB) is when the statement completes. If the statement is within scope of a ... MySQL ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-0.html
This section provides information about keywords and reserved words in MySQL 8.0. MySQL 8.0 Keywords and Reserved Words MySQL 8.0 New Keywords and Reserved Words MySQL 8.0 Removed Keywords and Reserved Words MySQL 8.0 Keywords and Reserved Words ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-lockmode.html
Lock modes for read operations. SHARED: Set a shared lock on rows EXCLUSIVE: Set an exclusive lock on rows READ_COMMITTED: Set no locks but read the most recent committed values 4.3.1.18.1 Synopsis public final class LockMode extends, ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Node where lock was held crashed, restart scan transaction 251 MySQL error. {296, HA_ERR_LOCK_WAIT_TIMEOUT, TO,{297, HA_ERR_LOCK_WAIT_TIMEOUT, TO,Time-out in NDB, probably caused by deadlock 275 MySQL error. Out of attribute buffers in TC block, ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-changelog-13-2-1-0-0.html
Sys Schema InnoDB Row Lock Waits : based on the innodb_lock_waits view. For more information, see Section 6.32, “Sys Schema InnoDB Row Lock Waits Metrics”. Sys Schema Table Metadata Lock Waits: based on the schema_table_lock_waits sys schema ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-innodbactivity-category.html
Row Lock Time (Delta) The total time spent in acquiring row locks, in milliseconds. Row Lock Waits (Delta) The number of times a row lock had to be waited for. Lists the InnoDB Activity metrics and provides a brief description of each. Table 8.8 ...