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/binary-log-transaction-compression.html
When binary log transaction compression is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a Transaction_payload_event). However, the effort required for data ...Compressed transaction payloads remain in a compressed state while they are sent in the replication stream to replicas, other Group Replication group members, or clients such as ...
https://dev.mysql.com/doc/refman/8.0/en/index-condition-pushdown-optimization.html
ICP can reduce the number of times the storage engine must access the base table and the number of times the MySQL server must access the storage engine. For InnoDB clustered indexes, the complete record is already read into the InnoDB buffer. The ... Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
In the token list for a given server, token names represent database names and token values are read or write depending on whether the database must be used in read-only fashion or whether it can take reads and writes. But suppose that the ...Client ... Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-computer-definition.html
Restart Type Initial System Restart: Requires a complete shutdown of the cluster, wiping and restoring the cluster file system from a backup, and then restarting the cluster. (NDB 8.0.13) This is a unique identifier, used to refer to the host ...Id ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-worker-table.html
For a single-threaded replica, data is shown for the replica's single applier thread. All error codes and messages displayed in the columns relating to errors correspond to error values listed in Server Error Message Reference. LAST_ERROR_NUMBER, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-exit.html
The group_replication_exit_state_action system variable, which is available from MySQL 8.0.12 and MySQL 5.7.24, specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to ...Note that in the case of an expelled member, the member does not know that it was expelled until it reconnects to the group, so the specified action is only taken if the member manages to reconnect, or if the member raises a suspicion on itself and expels ...
https://dev.mysql.com/doc/refman/8.0/en/xa-statements.html
Values generated by one TM must be different from values generated by other TMs. A given TM must be able to recognize its own xid values in a list of values returned by the XA RECOVER statement. Each XA transaction must have a unique xid value, so ... To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and RESUME clauses are recognized but have no ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
This setting has no effect on tables created using any other storage engine than InnoDB. (You are not required to name the column or key my_row_id in such cases.) my_row_id is an invisible column, which means it is not shown in the output of SELECT ... Beginning with MySQL 8.0.30, MySQL supports generated invisible primary keys for any InnoDB table that is created without an explicit primary ...When ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-event-reports.html
By default, the cluster log is saved to a file named ndb_node_id_cluster.log, (where node_id is the node ID of the management server) in the management server's DataDir. Cluster logging information can also be sent to stdout or a syslog facility in ...Each reportable event can be distinguished according to three different criteria: Category: This can be any one of the following values: STARTUP, SHUTDOWN, STATISTICS, CHECKPOINT, NODERESTART, CONNECTION, ERROR, or ...
https://dev.mysql.com/doc/refman/8.0/en/se-csv-repair.html
When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field separators, escaped fields (matching or missing quotation marks), the correct number of fields compared to the table definition and the ...