PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html
row *************************** Table: accounts Non_unique: 0 Key_name: ACCOUNT Seq_in_index: 1 Column_name: USER Collation: NULL Cardinality: NULL Sub_part: NULL Packed: NULL Null: YES Index_type: HASH Comment: Index_comment: Visible: YES ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 3. InnoDB stores user data in clustered indexes ... Storage engines are MySQL components that handle the SQL operations for different table ...
https://dev.mysql.com/doc/refman/8.0/en/audit-api-message-emit.html
audit_api_message_emit_udf(component, producer, message[, key, value] ...) Adds a message event to the audit log. Message events include component, producer, and message strings of the caller's choosing, and optionally a set of key-value pairs. key, ... As of MySQL 8.0.14, the audit_api_message_emit component enables applications to add their own message events to the audit log, using the audit_api_message_emit_udf() ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
A candidate object is contained in a target object if and only if for each key in the candidate there is a key with the same name in the target and the value associated with the candidate key is contained in the value associated with the target key.
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Foreign key referential actions (ON UPDATE, ON DELETE) are prohibited on columns used in CHECK constraints. Likewise, CHECK constraints are prohibited on columns used in foreign key referential actions. Prior to MySQL 8.0.16, CREATE TABLE permits ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the online log. This is ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
One additional repository, the applier worker metadata repository, is created primarily for internal use, and holds status information about worker threads on a multithreaded replica. A replica server creates two replication metadata repositories, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-redo-log-reader.html
ndb_redo_log_reader is intended for use primarily by NDB Cluster developers and Support personnel in debugging and diagnosing problems. --file-key, -K Command-Line Format --file-key=key Introduced 8.0.31-ndb-8.0.31 Supply file decryption key using ... Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption.html
To use encryption, a keyring component or plugin must be installed and configured to supply MySQL Server's keyring service. For instructions to do this, see Section 8.4.4, “The MySQL Keyring”. Any supported keyring component or plugin can be ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to converting between the ucs2 character set and character sets such as utf16 or utf32. For example, the differences in maximum index key ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...