Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly read-only operations ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-server-states.html
Depending on the exit action set by group_replication_exit_state_action, the member is in read-only mode (super_read_only=ON) and could also be in offline mode (offline_mode=ON). Note that a server in offline mode following the OFFLINE_MODE exit ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-understanding-consistency-guarantees.html
Data flow operations apply to both modes of Group Replication: single-primary and multi-primary, however to make this explanation clearer it is restricted to single-primary mode. In terms of distributed consistency guarantees, either in normal or ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
Example usage: innochecksum --version --verbose, -v Command-Line Format --verbose Type Boolean Default Value false Verbose mode; prints a progress indicator to the log file every five seconds. To turn on verbose mode, run: innochecksum --verbose To ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-transactions.html
That blocking lock request is for a row or table lock held by another transaction in an incompatible mode. A lock request always has a mode that is incompatible with the mode of the held lock that blocks the request (read vs. Each transaction in ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
The plugin works with these KMIP-compatible products: Oracle Key Vault Gemalto SafeNet KeySecure Appliance Townsend Alliance Key Manager Entrust KeyControl Each MySQL Server instance must be registered separately as a client for KMIP. The ... Note ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
LOCK IN SHARE MODE causes shared row locks to be used; FOR UPDATE causes exclusive row locks to be used. A number of limitations exist in NDB Cluster with regard to the handling of transactions. The NDBCLUSTER storage engine supports only the READ ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-events.html
SINGLEUSER Events These events are associated with entering and exiting single user mode. Table 25.36 Events relating to single user mode Event Priority Severity Level Description SingleUser 7 INFO Entering or exiting single user mode BACKUP Events ... An event report reported in the event logs has the following format: datetime [string] severity -- message For example: 09:19:30 2005-07-24 [NDB] INFO -- Node 4 Start phase 4 completed This section discusses all reportable events, ordered by category and severity level within each ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-nodes.html
SINGLEUSER is displayed in the status column for all data nodes when the cluster is in single user mode (see Section 25.6.6, “NDB Cluster Single User Mode”). For example, if you put the cluster in single user mode, you can sometimes see data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-download.html
You can either: Start MySQL Shell in SQL mode and import the file by issuing: mysqlsh -u root --sql --file /tmp/world_x-db/world_x.sql Enter password: **** Set MySQL Shell to SQL mode while it is running and source the schema file by issuing: \sql ... As part of this quick-start guide, an example schema is provided which is referred to as the world_x ...