Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache-reduce.html
If you are considering reducing the cache size limit, you can query the Performance Schema table memory_summary_global_by_event_name using the following statement: SELECT * FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME ... The minimum setting for the XCom message cache size in MySQL 8.4 is 128 MB, which enables deployment on a host that has a restricted amount of available ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
Memory usage by hash joins can be controlled using the join_buffer_size system variable; a hash join cannot use more memory than this amount. It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, ...
https://dev.mysql.com/doc/refman/8.4/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
To influence index usage for sorting or grouping rows, use FOR ORDER BY or FOR GROUP BY. Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. 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.4/en/information-schema-innodb-buffer-page-table.html
For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. Do not query this table on a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-pool-stats-table.html
For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cached-indexes-table.html
For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. The INNODB_CACHED_INDEXES table reports the number of index pages cached in the InnoDB buffer pool for each index. Index ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-per-index-table.html
For usage information, see Section 17.9.1.4, “Monitoring InnoDB Table Compression at Runtime” and Section 17.15.1.3, “Using the Compression Information Schema Tables”. The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
For usage information, see Section 17.9.1.4, “Monitoring InnoDB Table Compression at Runtime” and Section 17.15.1.3, “Using the Compression Information Schema Tables”. The INNODB_CMP and INNODB_CMP_RESET tables provide status information on ...