Search Results
https://dev.mysql.com/doc/refman/9.7/en/hash-joins.html
If this happens, you should be aware that the join may not succeed if a hash join cannot fit into memory and it creates more files than set for open_files_limit. It is possible to control whether hash joins are employed using one of the BNL and ...
https://dev.mysql.com/doc/refman/9.7/en/implicit-commit.html
ANALYZE TABLE, CACHE INDEX, CHECK TABLE, FLUSH, LOAD INDEX INTO CACHE, OPTIMIZE TABLE, REPAIR TABLE, RESET (but not RESET PERSIST). The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the ...
https://dev.mysql.com/doc/refman/9.7/en/index-condition-pushdown-optimization.html
For InnoDB clustered indexes, the complete record is already read into the InnoDB buffer. Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine ...
https://dev.mysql.com/doc/refman/9.7/en/index-merge-optimization.html
The Index Merge access method retrieves rows with multiple range scans and merges their results into one. This access method merges index scans from a single table only, not scans across multiple tables. The merge can produce unions, intersections, ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-collations-table.html
The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which the collation is associated. IS_DEFAULT Whether the collation is the default for its character set.
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-buffer-pool-stats-table.html
PAGES_MADE_YOUNG_RATE The number of pages made young per second (pages made young since the last printout / time elapsed). PAGES_MADE_NOT_YOUNG_RATE The number of pages not made per second (pages not made young since the last printout / time ... The ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-tablespaces-table.html
SERVER_VERSION The MySQL version that created the tablespace, or the MySQL version into which the tablespace was imported, or the version of the last major MySQL version upgrade. The INNODB_TABLESPACES table provides metadata about InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table provides a view into the in-memory data cache for the MySQL Enterprise Firewall plugin. It lists names and operational modes of registered firewall account profiles. It is used in conjunction with the ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-mysql-firewall-whitelist-table.html
The MYSQL_FIREWALL_WHITELIST table provides a view into the in-memory data cache for the MySQL Enterprise Firewall plugin. It is used in conjunction with the mysql.firewall_whitelist system table that provides persistent storage of firewall data; ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-partitions-table.html
The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into account any indexing changes. Each row in this table corresponds to an individual partition or ...