Search Results
https://dev.mysql.com/doc/refman/8.4/en/handler.html
If you have a multiple-column index, specify the index column values as a comma-separated list. The handler interface does not have to provide a consistent look of the data (for example, dirty reads are permitted), so the storage engine can use ...
https://dev.mysql.com/doc/refman/8.4/en/host-cache.html
The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-mapping.html
All other national letters from alphabets that have uppercase/lowercase mapping are encoded as shown in the following table. There is a correspondence between database and table identifiers and names in the file system. For the basic structure, ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
At the file system level, copy the .sdi and table content files from the hr schema directory to the secure export directory: The .sdi file is located in the hr schema directory, but might not have exactly the same basename as the table name. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
Do not query this table on a production system unless you are aware of the performance impact and have determined it to be acceptable. The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-table.html
Do not query this table on a production system unless you are aware of the performance impact and have determined it to be acceptable. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also be obtained using InnoDB buffer pool server status variables. The idea of ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-per-index-table.html
The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables have these columns: DATABASE_NAME The schema (database) containing the applicable table. The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in bytes. The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. COMPRESS_OPS The ...