PDF (US Ltr)
- 40.2Mb
PDF (A4)
- 40.3Mb
Man Pages (TGZ)
- 262.0Kb
Man Pages (Zip)
- 367.6Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
Search Results
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
Optimizer hints may also be applied; see Optimizer Hints for Block Nested-Loop and Batched Key Access Algorithms. Optimizer hints may also be applied; see Optimizer Hints for Block Nested-Loop and Batched Key Access Algorithms. Optimizer Hints for ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
binlog_gtid_simple_recovery Command-Line Format --binlog-gtid-simple-recovery[={OFF|ON}] System Variable binlog_gtid_simple_recovery Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value ON This variable controls how binary log ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
The following means are available to influence whether the optimizer attempts to merge derived tables, view references, and common table expressions into the outer query block: The MERGE and NO_MERGE optimizer hints can be used. The MERGE and ...The ...
https://dev.mysql.com/doc/refman/8.4/en/comments.html
Another variant of C-style comment syntax is used to specify optimizer hints. Hint comments include a + character following the /* comment opening sequence. If there is a concern that optimizer-hint comments may be stored in object definitions so ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
The value is treated as a hint; a different size could be used if necessary. The value is treated as a hint; a different size could be used if necessary. The KEY_BLOCK_SIZE value is treated as a hint; a different size could be used by InnoDB if ...| ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ... Index hints can be specified to affect how the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
In such a case, you might need to use index hints to pass along advice about which lookup method is more efficient for a particular query. See Also column, composite index, index, index hint, persistent statistics, random dive, selectivity, unique ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
mysql_firewall_database Command-Line Format --mysql-firewall-database[=value] System Variable mysql_firewall_database Scope Global Dynamic No SET_VAR Hint Applies No Type String Default Value mysql Specifies the database from which MySQL Enterprise ...When enabled, the firewall bases operational decisions on the cached ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. Group attributes enable control over ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
This section summarizes what has been added to, deprecated in, changed, and removed from MySQL 8.4 since MySQL 8.0. A companion section lists MySQL server options and variables that have been added, deprecated, or removed in MySQL 8.4; see Section ...