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/mysql-cluster-programs-ndb-import.html
--no-hint Command-Line Format --no-hint Do not use distribution key hinting to select a data node. ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB API. ndb_import requires a ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-optimization.html
To provide a hint about the table join order, use optimizer hints; see Section 10.9.3, “Optimizer Hints”. MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends.
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
In addition to using the optimizer_switch system variable to control optimizer use of Skip Scan session-wide, MySQL supports optimizer hints to influence the optimizer on a per-statement basis. The range access method uses a single index to ...
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
Ways to accomplish this include join-order optimizer hints (see Section 10.9.3, “Optimizer Hints”), STRAIGHT_JOIN immediately following the SELECT, and the STRAIGHT_JOIN join operator. Disable condition filtering for the session: SET ... In join ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-variables.html
connection_control_max_connection_delay Command-Line Format --connection-control-max-connection-delay=# System Variable connection_control_max_connection_delay Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 2147483647 ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
rewriter_enabled System Variable rewriter_enabled Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON Valid Values OFF Whether the Rewriter query rewrite plugin is enabled. Users communicate with the plugin by modifying ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
tbl_name [[AS] alias] [index_hint] The use of index hints provides the optimizer with information about how to choose indexes during query processing. For a description of the syntax for specifying these hints, see Section 10.9.4, “Index Hints”.
https://dev.mysql.com/doc/refman/8.4/en/replication-options.html
Command-Line Format --server-id=# System Variable server_id Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 1 Minimum Value 0 Maximum Value 4294967295 This variable specifies the server ID. System Variable server_uuid ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
This includes statements that include a nonzero MAX_EXECUTION_TIME optimizer hint, and statements that include no such hint but execute while the timeout indicated by the max_execution_time system variable is nonzero. The MySQL server maintains ...
https://dev.mysql.com/doc/refman/8.4/en/set-resource-group.html
An alternative to SET RESOURCE GROUP is the RESOURCE_GROUP optimizer hint, which assigns individual statements to a resource group. SET RESOURCE GROUP group_name [FOR thread_id [, thread_id] ...] SET RESOURCE GROUP is used for resource group ...