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/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.0/en/version-tokens.html
An application can use token locks to indicate to other cooperating applications that tokens are in use and should not be modified. MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that ...
https://dev.mysql.com/doc/refman/8.0/en/view-algorithms.html
A reason to specify TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it is used to finish processing the statement. This might result in quicker lock release than the MERGE ... The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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 SLAVE] [COMMENT 'string'] DO ...