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-limitations-transactions.html
This can be done by using the IGNORE INDEX index hint as part of the SELECT statement reading the table (see Section 10.9.4, “Index Hints”). A number of limitations exist in NDB Cluster with regard to the handling of transactions. The ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-variables.html
The MySQL Enterprise Data Masking and De-Identification components support the following system variables. Variables are unavailable unless the appropriate MySQL Enterprise Data Masking and De-Identification components are installed (see Section ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system variable. It is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb_data_node_neighbour: Specifies cluster data node "closest" to this MySQL Server, for transaction hinting and fully replicated tables. Ndb_trans_hint_count_session: Number of transactions using hints that have been started in this session. The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
If there is a concern that optimizer-hint comments may be stored in object definitions so that dump files when reloaded with mysql would result in execution of such commands, either invoke mysql with the --binary-mode option or use a reload client ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
Note The mysql client always passes optimizer hints to the server, regardless of whether this option is given. --default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint about which client-side authentication plugin to use.
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
Block Nested-Loop Flags block_nested_loop (default on) Controls use of hash joins, as do the BNL and NO_BNL optimizer hints. Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
The KEY_BLOCK_SIZE value is treated as a hint; a different size could be used by InnoDB if necessary. Compressed tables can be created in file-per-table tablespaces or in general tablespaces. The system tablespace (space 0, the .ibdata files) can ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
Check the notes and hints at the end of this section for Solaris specific notes that you may need before or after installation. Note MySQL 8.4 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. For ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
The amount of space that is reserved may not be exactly as configured, as the innodb_fill_factor value is interpreted as a hint rather than a hard limit. InnoDB performs a bulk load instead of inserting one index record at a time when creating or ...