https://dev.mysql.com/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. Note that the limitations and issues ...
https://dev.mysql.com/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/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/index-hints.html
With statement-based binary logging, having different modes for the master and slaves might lead to replication errors. Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, ...
https://dev.mysql.com/innodb-auto-increment-handling.html
Modifying AUTO_INCREMENT column values in the middle of a sequence of INSERT statements In MySQL 5.7 and earlier, modifying an AUTO_INCREMENT column value in the middle of a sequence of INSERT statements could lead to “Duplicate entry” errors.
https://dev.mysql.com/innodb-index-types.html
Accessing a row through the clustered index is fast because the index search leads directly to the page with all the row data. Every InnoDB table has a special index called the clustered index where the data for the rows is stored. To get the best ...
https://dev.mysql.com/innodb-memcached-porting-mysql.html
Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...
https://dev.mysql.com/innodb-multiple-tablespaces.html
This monolithic approach was targeted at machines dedicated to database processing, with carefully planned data growth, where any disk storage allocated to MySQL would never be needed for other purposes. The file-per-table tablespace feature ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/innodb-page-compression.html
For example, a maximum InnoDB page size of 64KB with a 4KB file system block size may improve compression but may also increase demand on the buffer pool, leading to increased I/O and potential write amplification. InnoDB supports page-level ...
