PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysqldm-options.html
--enable-cleartext-plugin Command-Line Format --enable-cleartext-plugin Type Boolean Default Value FALSE Enable the mysql_clear_password cleartext authentication plugin. mysqldm accepts MySQL standard connection options and several mysqldm-specific ...
https://dev.mysql.com/doc/refman/9.7/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an ...
https://dev.mysql.com/doc/refman/9.7/en/optimize-blob.html
(Use the CRC32(expr) function to produce the hash value.) Since hash functions can produce duplicate results for different inputs, you still include a clause AND blob_column = long_string_value in the query to guard against false matches; the ...
https://dev.mysql.com/doc/refman/9.7/en/option-modifiers.html
The “enabled” form of the option may be specified in any of these ways: --column-names --enable-column-names --column-names=1 The values ON, TRUE, OFF, and FALSE are also recognized for boolean options (not case-sensitive). Some options are ...
https://dev.mysql.com/doc/refman/9.7/en/outer-join-simplification.html
(That is, it converts the outer join to an inner join.) A condition is said to be null-rejected for an outer join operation if it evaluates to FALSE or UNKNOWN for any NULL-complemented row generated for the operation. Table expressions in the FROM ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-metadata-table.html
The variables_metadata table shows, for each server system variable, its name, scope, type, range of values (where applicable), and description. VARIABLE_SCOPE The variable's scope; this is one of the values listed here: GLOBAL The variable is ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-failover.html
There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new replica which can then be used for scaleout, being promoted to source as necessary for failover. Each identifier ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html
This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or ...
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-usage.html
This is subject to false positives, but serves as a quick rejection test. To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled when you install it (see Section 7.6.4.1, ...