PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-adaptive-hash.html
The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient memory for the buffer pool without sacrificing transactional features or reliability. The adaptive ...Based on the observed pattern of searches, a hash index is built using a prefix of the index ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
Running SHOW TABLE STATUS, SHOW INDEX, or querying the Information Schema TABLES or STATISTICS tables with the innodb_stats_on_metadata option enabled. Optimizer statistics are persisted to disk by default, enabled by the innodb_stats_persistent ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-lru-table.html
For more information about how the InnoDB manages buffer pool data, see Section 17.5.1, “Buffer Pool”. The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the ...For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool ...It has LRU_POSITION ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications. Deadlocks are a classic problem in transactional databases, but they are not dangerous unless they are so frequent that ... This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-table.html
For more information about how the InnoDB manages buffer pool data, see Section 17.5.1, “Buffer Pool”. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. The INNODB_BUFFER_PAGE table has these columns: ...For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-datafiles-table.html
The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces. Note The INFORMATION_SCHEMA FILES table reports metadata for InnoDB tablespace types including file-per-table tablespaces, general ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-optimize-tablespace-page-allocation.html
Attempting to disable innodb_extend_and_initialize on those systems returns the following error: Changing innodb_extend_and_initialize not supported on this platform. As of MySQL 8.0.22, you can optimize how InnoDB allocates space to file-per-table ...As of MySQL 8.0.22, you can disable innodb_extend_and_initialize on Linux systems to avoid physically writing NULLs to newly allocated tablespace ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-truncate-table-reclaim-space.html
To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. This is in contrast ...When a table is truncated, it is dropped and re-created in a new .ibd file, and the freed space is returned to the operating ...Additionally, there ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-brief-table.html
INNODB_TABLESPACES provides the same metadata but loads more slowly because other metadata provided by the table, such as FS_BLOCK_SIZE, FILE_SIZE, and ALLOCATED_SIZE, must be loaded dynamically. The INNODB_TABLESPACES_BRIEF table provides space ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. FOR SHARE, or from reading the data in certain transaction isolation levels. These clauses are ...