MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 311 to 320 of 797 total results

6.4.6.4 MySQL Enterprise Firewall Reference

https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html

When enabled, the firewall bases operational decisions on the cached data. The firewall database can be the mysql system database or a custom schema (see Installing MySQL Enterprise Firewall). For information about MySQL Enterprise Firewall ...

6.4.4.12 Keyring System Variables

https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html

These variables are unavailable unless the appropriate keyring plugin is installed (see Section 6.4.4.1, “Keyring Plugin Installation”). keyring_aws_cmk_id Command-Line Format --keyring-aws-cmk-id=value System Variable keyring_aws_cmk_id Scope ...

12.4 Operators

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

1.6.3.4 ENUM and SET Constraints

https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html

ENUM and SET columns provide an efficient way to define columns that can contain only a given set of values. See Section 11.3.5, “The ENUM Type”, and Section 11.3.6, “The SET Type”. Unless strict mode is disabled (not recommended, but see ...

6.4.6.3 Using MySQL Enterprise Firewall

https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html

Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 6.4.6.2, “Installing or Uninstalling MySQL Enterprise Firewall”. Also, MySQL Enterprise Firewall does not work together with the query cache; ...

13.4.2.2 CHANGE REPLICATION FILTER Statement

https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html

Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP SLAVE SQL_THREAD ...

13.6.7.2 DECLARE ... HANDLER Statement

https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html

statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...

2.5.7.2 More Topics on Deploying MySQL Server with Docker

https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html

A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Included binaries are limited to: /usr/bin/my_print_defaults /usr/bin/mysql /usr/bin/mysql_config /usr/bin/mysql_install_db ...

16.1.3.7 Stored Function Examples to Manipulate GTIDs

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

This section provides examples of stored functions (see Chapter 23, 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 ...

16.1.2.3 Obtaining the Replication Source's Binary Log Coordinates

https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterstatus.html

To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary log. Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for ...

Displaying 311 to 320 of 797 total results