Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
However, if the network drops packets, leading to re-transmissions and higher end-to-end latency, throughput and latency are both negatively affected. What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
This is because foreign key constraints that result in cascading operations executed by a multi-primary mode group can result in undetected conflicts and lead to inconsistent data across the members of the group. Limit on Group Size Limits on ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-multi-primary-mode.html
In multi-primary mode, slower members can also build up an excessive backlog of transactions to certify and apply, leading to a greater risk of conflicts and certification failure. In multi-primary mode (group_replication_single_primary_mode=OFF) ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
Starting two servers or restarting one server with this option set while the group is running may lead to an artificial split brain situation, where two independent groups with the same name are bootstrapped. group_replication_paxos_single_leader ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
If the string is a pattern, any leading directory path and the .sdi file name suffix must be given literally. The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata files.
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
If client A attempts to update a row in Birds at the same time, this will lead to a deadlock: mysql> UPDATE Birds SET value=40 WHERE name='Buzzard'; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction InnoDB rolls ... The following example illustrates how an error can occur when a lock request causes a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-disabling-tablespace-path-validation.html
Manually moved tablespace files will not be detected! Warning Starting the server with tablespace path validation disabled after moving tablespace files can lead to undefined behavior. At startup, InnoDB scans directories defined by the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
With file-per-table tablespaces, each table may have unused space that can only be utilized by rows of the same table, which can lead to wasted space if not properly managed. A file-per-table tablespace contains data and indexes for a single InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-index-types.html
How the Clustered Index Speeds Up Queries Accessing a row through the clustered index is fast because the index search leads directly to the page that contains the row data. Each InnoDB table has a special index called the clustered index that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Reduced locking and waiting for MySQL server resources leads to greater scalability, even for operations that are not involved in the DDL operation. Online DDL improves several aspects of MySQL operation: Applications that access the table are more ...