Search Results
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
It does not take into account whether replication channels have been started or stopped. The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of these functions take string ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists names and operational modes of registered firewall account profiles. It is used in conjunction with the mysql.firewall_users system ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-mysql-firewall-whitelist-table.html
The MYSQL_FIREWALL_WHITELIST table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_whitelist system table that provides persistent storage of firewall data; see MySQL ...