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/information-schema-innodb-buffer-page-lru-table.html
This allocation could potentially cause an out-of-memory error, especially for systems with multi-gigabyte buffer pools. The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-keywords-table.html
Prior to MySQL 8.0.13, selecting from the KEYWORDS table with no default database selected produced an error. The KEYWORDS table lists the words considered keywords by MySQL and, for each one, indicates whether it is reserved. Reserved keywords may ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
Attempting to run innochecksum on a tablespace that the server already has open results in an Unable to lock file error. This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
Use the following procedure: Perform a slow shutdown of the MySQL server and make sure that it stops without errors. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html
In this case, the transaction returns an error: ER_TABLE_DEF_CHANGED, “Table definition has changed, please retry transaction”. A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory.
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
It uses Electronic Codebook (ECB) block encryption mode for tablespace key encryption and Cipher Block Chaining (CBC) block encryption mode for data encryption. Failing to do so results in errors when starting the server and during InnoDB recovery.
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html
The same error may also occur if the locking thread must look at more than 1,000,000 locks owned by transactions on the wait-for list. When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
If a lock request conflicts with an existing lock and cannot be granted because it would cause deadlock, an error occurs. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
You cannot make a covering index for memcached lookups; InnoDB returns an error if you try to define a composite secondary index over both the key and value columns. InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses ...