Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-expel.html
You can use the group_replication_member_expel_timeout system variable to allow additional time between the creation of a suspicion and the expulsion of the suspect member. A suspicion is created when one server does not receive messages from ...A ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
If this happens, you should be aware that the join may not succeed if a hash join cannot fit into memory and it creates more files than set for open_files_limit. It is possible to control whether hash joins are employed using one of the BNL and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
PARTITION_EXPRESSION The expression for the partitioning function used in the CREATE TABLE or ALTER TABLE statement that created the table's current partitioning scheme. For each such row: The SUBPARTITION_NAME, SUBPARTITION_ORDINAL_POSITION, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the source. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica.
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting-datadict.html
The procedure assumes that you only have .ibd file backups, you are recovering to the same version of MySQL that initially created the orphan .ibd files, and that .ibd file backups are clean. See Section 17.6.1.4, “Moving or Copying InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to indexes other than primary keys (either explicit or implicit). ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER ...
https://dev.mysql.com/doc/refman/8.4/en/log-file-maintenance.html
As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking place. As mentioned previously, flushing the binary log creates a new binary log file, whereas ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-start.html
myisam_max_sort_file_size The maximum size of the temporary file that MySQL is permitted to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA). If the file size would be larger than this value, the index is created ... The following options to mysqld can be used to change the behavior of MyISAM ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-exclusive-to-cluster.html
The following are limitations specific to the NDB storage engine: Machine architecture. All machines used in the cluster must have the same architecture. That is, all machines hosting nodes must be either big-endian or little-endian, and you cannot ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
Execute one or more CREATE NODEGROUP commands in the NDB Cluster management client to create the new node group or node groups to which the new data nodes belong. Exception: For tables created using the MAX_ROWS option, this statement does not work; ... In this section, we list the basic steps required to add new data nodes to an NDB ...