PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
--defer-table-indexes Command-Line Format --defer-table-indexes Type Boolean Default Value TRUE In the dump output, defer index creation for each table until after its rows have been loaded. --events Command-Line Format --events Type Boolean Default ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
Returns true (1) if the two document have any key-value pairs or array elements in common. value MEMBER OF(json_array) Returns true (1) if value is an element of json_array, otherwise returns false (0). The functions in this section perform search ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-component.html
If the item is present, its value is true or false, indicating whether the component should read configuration information from the local configuration file. If the value is true, the component ignores the other items in the global configuration ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
If the item is present, its value is true or false, indicating whether the component should read configuration information from the local configuration file. If the value is true, the component ignores the other items in the global configuration ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
EnablePartialLcp: Enable partial LCP (true); if this is disabled (false), all LCPs write full checkpoints. RealtimeScheduler: When true, data node threads are scheduled as real-time threads. WatchDogImmediateKill: When true, threads are immediately ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-privileges.html
The same thing is true with respect to the CREATE USER and DROP USER statements. If these conditions are true, then anyone, anywhere can start a MySQL Server with --ndbcluster --ndb-connectstring=management_host and access this NDB Cluster. This is ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...