PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
B-Tree Index Characteristics Hash Index Characteristics B-Tree Index Characteristics A B-tree index can be used for column comparisons in expressions that use the =, >, >=, <, <=, or BETWEEN operators. WHERE index_part1=1 AND index_part2=2 AND ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, described in Section 8.9.3, “Optimizer Hints”. They also work with multi-table DELETE ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-character-sets-table.html
The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. MAXLEN The maximum number of bytes required to store one character. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...
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-connection-control-failed-login-attempts-table.html
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS has these columns: USERHOST The user/host combination indicating an account that has failed connection attempts, in 'user_name'@'host_name' format. This table provides information about the current number of ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-engines-table.html
The ENGINES table has these columns: ENGINE The name of the storage engine. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. SUPPORT The server's level of support for the storage ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table has these columns: USERHOST The account profile name. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-mysql-firewall-whitelist-table.html
The MYSQL_FIREWALL_WHITELIST table has these columns: USERHOST The account profile name. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-plugins-table.html
The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. PLUGIN_STATUS The plugin status, one of ACTIVE, INACTIVE, DISABLED, or DELETED. PLUGIN_TYPE The type of ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-profiling-table.html
The PROFILING table has these columns: QUERY_ID A numeric statement identifier. Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 13.7.5.30, “SHOW PROFILE Statement”). The table is ...