https://dev.mysql.com/osx-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. To enable the launchd service, you can either: ...
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 ...
https://dev.mysql.com/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...
https://dev.mysql.com/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...
https://dev.mysql.com/create-table-check-constraints.html
If the condition evaluates to FALSE, it fails and a constraint violation occurs. CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates to FALSE. IGNORE ... Prior ...
https://dev.mysql.com/mysql-innodb-cluster-working-with-clone.html
Set the disableClone Boolean option to false to disable MySQL Clone for the cluster. It is recommended to use MySQL Clone, by either upgrading the cluster or setting the disableClone option to false. A InnoDB cluster that uses MySQL Clone provides ...
https://dev.mysql.com/connecting-using-uri-or-key-value-pairs.html
For example: mysqlx://user@host?connection-attributes mysqlx://user@host?connection-attributes=true mysqlx://user@host?connection-attributes=false The default behavior is to send the default attribute set. The connection-attributes parameter value ... This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL ...
https://dev.mysql.com/server-configuration.html
Its output includes the default option and variable values and looks something like this: abort-slave-event-count 0 allow-suspicious-udfs FALSE archive ON auto-increment-increment 1 auto-increment-offset 1 autocommit TRUE automatic-sp-privileges ...
https://dev.mysql.com/outer-join-optimization.html
For a LEFT JOIN, if the WHERE condition is always false for the generated NULL row, the LEFT JOIN is changed to an inner join. MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on ...
https://dev.mysql.com/mysql-cluster-programs-ndb-blob-tool.html
--delete-orphans Property Value Command-Line Format --delete-orphans Type Boolean Default Value FALSE Remove orphaned BLOB parts from NDB Cluster tables. --verbose Property Value Command-Line Format --verbose Type Boolean Default Value FALSE Provide ... This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned ...
