PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
A new password-validation system variable permits the configuration and enforcement of a minimum number of characters that users must change when attempting to replace their own MySQL account passwords. For example, if ... This section summarizes ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
row *************************** id: 1 pattern: SELECT ? pattern_database: NULL replacement: SELECT ? + 1 enabled: YES message: NULL pattern_digest: NULL normalized_pattern: NULL The rule specifies a pattern template indicating which SELECT ...These ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer joins. Also, the ...Benefits of BKA include improved join performance due to more efficient table ...
https://dev.mysql.com/doc/refman/8.0/en/index-merge-optimization.html
The Index Merge access method has several algorithms, which are displayed in the Extra field of EXPLAIN output: Using intersect(...) Using union(...) Using sort_union(...) The following sections describe these algorithms in greater detail. The ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
block_encryption_mode Command-Line Format --block-encryption-mode=# System Variable block_encryption_mode Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type String Default Value aes-128-ecb This variable controls the block encryption ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-setup.html
C:\Program Files (x86) Templates The Templates folder has one file for each version of MySQL server. Template files contain keys and formulas to calculate some values dynamically. Choosing a Setup Type Path Conflicts Check Requirements MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html
For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this copy. For ALGORITHM=INPLACE, the NDB Cluster handler tells ... MySQL NDB Cluster 8.0 supports online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html
mysqlx_compression_algorithms Command-Line Format --mysqlx-compression-algorithms=value Introduced 8.0.19 System Variable mysqlx_compression_algorithms Scope Global Dynamic Yes SET_VAR Hint Applies No Type Set Default Value ... To control activation ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
Mysqlx_compression_algorithm: Compression algorithm in use for X Protocol connection for this session. Replica_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
innodb_checksum_algorithm Command-Line Format --innodb-checksum-algorithm=value System Variable innodb_checksum_algorithm Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value crc32 Valid Values ... InnoDB Startup Options ...