Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ...(Bug #39701) When a statement refers to one or more system ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging ...
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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). Before querying it, set the value of the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-limits.html
The maximum table or tablespace size is impacted by the server's file system, which can impose a maximum file size that is smaller than the internal 64 TiB size limit defined by InnoDB. ERROR 1070 (42000): Too many key parts specified; max 16 parts ... This section describes limits for InnoDB tables, indexes, tablespaces, and other aspects of the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-processes.html
For example, mysql://198.51.100.3/tmp/mysql.sock indicates that the SQL node was started with the skip_networking system variable enabled, and mysql://198.51.100.3:3306/?server-id=1 shows that replication is enabled for this SQL node. If the SQL ...
https://dev.mysql.com/doc/refman/8.4/en/account-management-statements.html
This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional details. When the read_only system variable is enabled, account-management statements require ...