Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
This was the behavior of Group Replication before the group_replication_consistency variable was added. In this scenario, the system changes access permissions and it wants to be sure that all clients see the correct permission. Scenario 7: On the ... 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/internals/en/x-protocol-expect-expectations.html
Adding another expect-block handles it: Mysqlx.Expect::Open([+no_error]) Mysqlx.Crud::PrepareFind(stmt_id=1, ...) // may fail Mysqlx.Expect::Open([+no_error]) Mysqlx.PreparedStmt::Execute(stmt_id=1, ...) // expectation(no_error) failed ...Assume the ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/global-error-reference.html
This document lists “global” error messages that are shared in the sense that they can be produced by the MySQL server or by MySQL client programs. If the server writes a message to the error log that has a global error code, it pads the error ...These errors have error codes in the range from 1 to ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
This is also true for TIMESTAMP if the explicit_defaults_for_timestamp system variable is enabled (see Section 7.1.8, “Server System Variables”). Subqueries, parameters, variables, stored functions, and loadable functions are not permitted. When ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
That is, if the replica_parallel_workers system variable is greater than 0, this table is populated when START REPLICA is executed, and the number of rows shows the number of workers. Alternatively, the set of executed GTIDs can be obtained from the ...Query results can be saved in tables for further analysis, or assigned to variables and thus used in stored ...This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has ...
https://dev.mysql.com/doc/ndbapi/en/ndb-table.html
It is possible using the NDB API to create tables independently of the MySQL server. However, it is usually not advisable to do so, since tables created in this fashion cannot be seen by the MySQL server. Variable size attributes have a size of 12 ... This section provides information about the Table class, which models a database table in the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
The block_nested_loop flag of the optimizer_switch system variable controls hash joins. The block_nested_loop flag of the optimizer_switch system variable controls hash joins. For BKA to be used, the batched_key_access flag of the optimizer_switch ...A package of keys for a portion of rows from the join buffer, together with their associations, is sent by a MySQL Server (SQL node) to MySQL Cluster data ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
The ndb_data_node_neighbour system variable is also used for fully replicated tables, to ensure that when a fully replicated table is accessed, we access the data node which is local to this MySQL Server. It is also possible to use the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-message-compression.html
Whether a specific message is compressed depends on the threshold that you configure using the group_replication_compression_threshold system variable. This limit is lower than the maximum possible value for the ...This is especially important ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-message-fragmentation.html
The system variable group_replication_communication_max_message_size specifies a maximum message size for Group Replication communications, above which messages are fragmented. The greatest permitted value is the same as the maximum value of the ...