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/optimizer-hints.html
Table-Level Optimizer Hints Table-level hints affect use of the Block Nested-Loop (BNL) and Batched Key Access (BKA) join-processing algorithms (see Section 8.2.1.11, “Block Nested-Loop and Batched Key Access Joins”). Consider this statement: ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
Unless a Block Nested-Loop or Batched Key Access algorithm is used, there is no gain from setting the buffer larger than required to hold each matching row, and all joins allocate at least the minimum size, so use caution in setting this variable to ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--loops=# Command-Line Format --loops=# Type Numeric Default Value 0 Minimum Value 0 Maximum Value MAX_INT Repeat commands this number of times (for use in testing). ndb_index_stat provides per-fragment statistical information about indexes on NDB ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-statements.html
MySQL supports the IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT constructs for flow control within stored programs. For example, an IF statement might contain a WHILE loop, which itself contains a CASE statement. Many of these constructs ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
This technique is used for resources that are typically held only for brief periods, where it is more efficient to wait in a “busy loop” than to put the thread to sleep and perform a context switch. If the resource does not become available ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-fine-tuning-the-group-communication-thread.html
The group communication thread (GCT) runs in a loop while the Group Replication plugin is loaded. To force the GCT do an active wait, use the group_replication_poll_spin_loops option, which makes the GCT loop, doing nothing relevant for the ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
The disadvantage of a small innodb_concurrency_tickets value is that large transactions must loop through the queue many times before they can complete, which extends the amount of time required to complete their task. innodb_flushing_avg_loops ...
https://dev.mysql.com/doc/refman/5.7/en/iterate.html
ITERATE label ITERATE can appear only within LOOP, REPEAT, and WHILE statements. ITERATE means “start the loop again.” For an example, see Section 13.6.5.5, “LOOP Statement”.
https://dev.mysql.com/doc/refman/5.7/en/leave.html
LEAVE label This statement is used to exit the flow control construct that has the given label. If the label is for the outermost stored program block, LEAVE exits the program.
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
For more information, see Section 8.2.1.11, “Block Nested-Loop and Batched Key Access Joins”. Block Nested-Loop Flags block_nested_loop (default on) Controls use of BNL join algorithm. For more information, see Section 8.2.1.11, “Block ...Its ...