https://dev.mysql.com/mysql-nutshell.html
JSON_SCHEMA_VALID() returns TRUE (1) if the document validates against the schema and FALSE (0) if it does not. If they contain any key-value pairs or array elements in common, the function returns TRUE (1); otherwise it returns FALSE (0). MEMBER ...
https://dev.mysql.com/nested-join-optimization.html
The following discussion refers to the join syntax described in Section 13.2.10.2, “JOIN Syntax”. The syntax of table_factor is extended in comparison with the SQL Standard. The latter accepts only table_reference, not a list of them inside a ...
https://dev.mysql.com/replication-options-gtids.html
If an incorrect GTID set is computed in either situation, it will remain incorrect even if the server is later restarted with binlog_gtid_simple_recovery=FALSE. If either of these situations apply or might apply on the server, set ... Startup ...
https://dev.mysql.com/explain-output.html
Impossible HAVING (JSON property: message) The HAVING clause is always false and cannot select any rows. Impossible WHERE (JSON property: message) The WHERE clause is always false and cannot select any rows. Impossible WHERE noticed after reading ...
https://dev.mysql.com/json-validation-functions.html
JSON_SCHEMA_VALID() returns true if the document is validates against the schema, and false if it is not; JSON_SCHEMA_VALIDATION_REPORT() provides a report in JSON format on the validation. Provided that these conditions are met: If the document ...
https://dev.mysql.com/mysql-cluster-api-definition.html
AutoReconnect Table 22.199 This table provides type and value information for the AutoReconnect API node configuration parameter Property Value Version (or later) NDB 8.0.13 Type or units boolean Default false Range true, false Restart Type N This ... The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster ...
https://dev.mysql.com/mysql-cluster-programs-ndbd.html
--foreground Property Value Command-Line Format --foreground Type Boolean Default Value FALSE Causes ndbd or ndbmtd to execute as a foreground process, primarily for debugging purposes. --initial Property Value Command-Line Format --initial Type ...
https://dev.mysql.com/mysql-cluster-shm-definition.html
Communications between NDB cluster nodes are normally handled using TCP/IP. The shared memory (SHM) transporter is distinguished by the fact that signals are transmitted by writing in memory rather than on a socket. The shared-memory transporter ...
https://dev.mysql.com/server-system-variables.html
Boolean variables can be set at startup to the values ON, TRUE, OFF, and FALSE (not case sensitive), as well as 1 and 0. If false, XA transactions remain attached to the handling session as long as that session is alive, during which time no other ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
