MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 121 to 130 of 139 total results

https://dev.mysql.com/doc/refman/8.0/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 ...

10.4.2.3 Optimizing for BLOB Types

https://dev.mysql.com/doc/refman/8.0/en/optimize-blob.html

When storing a large blob containing textual data, consider compressing it first. Do not use this technique when the entire table is compressed by InnoDB or MyISAM. For a table with several columns, to reduce memory requirements for queries that do ...

6.2.2.4 Program Option Modifiers

https://dev.mysql.com/doc/refman/8.0/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 ...

10.2.1.10 Outer Join Simplification

https://dev.mysql.com/doc/refman/8.0/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 ...

14.18 Replication Functions

https://dev.mysql.com/doc/refman/8.0/en/replication-functions.html

The functions described in the following sections are used with MySQL Replication. GTID_SUBTRACT() Return all GTIDs in set that are not in subset. MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified ...

19.1.3.5 Using GTIDs for Failover and Scaleout

https://dev.mysql.com/doc/refman/8.0/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 ...

19.1.3.8 Stored Function Examples to Manipulate GTIDs

https://dev.mysql.com/doc/refman/8.0/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 ...

19.1.3.2 GTID Life Cycle

https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html

If one of the situations described there applies on a server, set binlog_gtid_simple_recovery=FALSE in the server's configuration file before starting it. The life cycle of a GTID consists of the following steps: A transaction is executed and ...

19.1.6.3 Replica Server Options and Variables

https://dev.mysql.com/doc/refman/8.0/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 ...

7.6.4.2 Using the Rewriter Query Rewrite Plugin

https://dev.mysql.com/doc/refman/8.0/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, ...

Displaying 121 to 130 of 139 total results