Search Results
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system variable. row ...
https://dev.mysql.com/doc/refman/8.4/en/hexadecimal-literals.html
Due to the difference in result types, the displayed values differ: High-order 0 digits are not displayed for the numeric result. Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
For multi-file tablespaces, specify each file: ibd2sdi ibdata1 ibdata2 The files of a multi-file tablespace must be specified in order of the ascending page number. ibd2sdi is a utility for extracting serialized dictionary information (SDI) from ...
https://dev.mysql.com/doc/refman/8.4/en/index-preloading.html
Although the blocks stay in the cache, because there are enough buffers for all of them, they are fetched from disk in random order, and not sequentially. If there are enough blocks in a key cache to hold blocks of an entire index, or at least the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
CLUST_INDEX_SIZE The number of pages on disk that store the clustered index, which holds the InnoDB table data in primary key order. The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables. This data is used ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
It is very fast to reference the primary key columns in WHERE clauses, ORDER BY clauses, GROUP BY clauses, and join operations. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, ...