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/mysqlbinlog.html
mysqlbinlog sets the value of pseudo_replica_mode to true before executing any SQL statements. --idempotent Command-Line Format --idempotent Type Boolean Default Value true Tell the MySQL Server to use idempotent mode while processing updates; this ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/9.7/en/server-configuration.html
Its output includes the default option and variable values and looks something like this: activate-all-roles-on-login FALSE admin-address (No default value) admin-port 33062 admin-ssl TRUE admin-ssl-ca (No default value) admin-ssl-capath (No default ... The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its ...
https://dev.mysql.com/doc/refman/9.7/en/any-in-some-subqueries.html
The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The syntax means “there is some b to which a is not equal.” Using <> SOME instead helps ensure that everyone understands the true ...The ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-disabling.html
The audit_log.disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET statement; for example: SET GLOBAL audit_log.disable = true; Setting audit_log.disable to true disables the audit ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-disabling.html
The audit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET statement; for example: SET GLOBAL audit_log_disable = true; Setting audit_log_disable to true disables the audit ...
https://dev.mysql.com/doc/refman/9.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/9.7/en/connecting-using-uri-or-key-value-pairs.html
For example: mysql://user@localhost:3306?get-server-public-key=true This option applies to clients that authenticate with the caching_sha2_password authentication plugin. For example: mysqlx://user@host?connection-attributes ... This section ...
https://dev.mysql.com/doc/refman/9.7/en/derived-table-optimization.html
The optimizer propagates an ORDER BY clause in a derived table or view reference to the outer query block if these conditions are all true: The outer query is not grouped or aggregated. What is true for materialization of derived tables is also true ...The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-plugin.html
For example, if the profile was in PROTECTING mode, that is no longer true after calling sp_reload_firewall_group_rules() and you must set it to PROTECTING again explicitly. For example, if the profile was in PROTECTING mode, that is no longer true ... This section contains information about the MySQL Enterprise Firewall ...
https://dev.mysql.com/doc/refman/9.7/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...