Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-tomcat.html
The possible workarounds, if viable, are as follows: use "antiResourceLocking=true" as a Tomcat Context attribute, or remove the META-INF/ directory. The following instructions are based on the instructions for Tomcat-5.x, available at ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
innodb_api_enable_mdl: Locks table used by InnoDB memcached plugin, so that it cannot be dropped or altered by DDL through SQL interface. Options and Variables Introduced in MySQL 8.4 Options and Variables Deprecated in MySQL 8.4 Options and ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-problems.html
If you use ALTER TABLE on a transactional table or if you are using Windows, ALTER TABLE unlocks the table if you had done a LOCK TABLE on it. If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
When performing foreign key checks, InnoDB sets shared row-level locks on child or parent records that it must examine. For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
SELECT is applied as an atomic operation, a metadata lock is held on the table while data is inserted, which prevents concurrent access to the table for the duration of the operation. An atomic DDL statement combines the data dictionary updates, ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
Binary logging is done immediately after a statement or transaction completes but before any locks are released or any commit is done. The binary log contains “events” that describe database changes such as table creation operations or changes ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
When running CHECK TABLE on large InnoDB tables, other threads may be blocked during CHECK TABLE execution. If a lock request extends beyond the semaphore wait threshold, InnoDB aborts the process. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
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 cloning operation is unable to obtain a DDL lock within the time limit specified by the clone_ddl_timeout variable, an ...
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
CREATE DATABASE is not permitted within a session that has an active LOCK TABLES statement. CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
For example, you could use the GET_LOCK() function, or row or table locking. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT ...