PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
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 traverses the index to locate rows in the base table and returns them to the MySQL server which ...
https://dev.mysql.com/doc/refman/5.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/5.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/5.7/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablestats-table.html
The INNODB_SYS_TABLESTATS table provides a view of low-level status information about InnoDB tables. This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. This information is derived from in-memory ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...