Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
The exact point at which a transaction is committed depends on the transaction consistency level that is set for the group (see Section 20.5.3, “Transaction Consistency Guarantees”). Group Replication is designed to ensure that the database ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-use-cases.html
Alternative to asynchronous Source-Replica replication - In certain situations, using a single source server makes it a single point of contention. Group Replication enables you to create fault-tolerant systems with redundancy by replicating the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication.html
There is a built-in group membership service that keeps the view of the group consistent and available for all servers at any given point in time. This chapter explains Group Replication in MySQL 8.4, and how to install, configure and monitor ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
For manual ROLLBACK, the value of LAST_INSERT_ID() is not restored to that before the transaction; it remains as it was at the point of the ROLLBACK. It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-pool-stats-table.html
Pages made “young” take longer to age out of the buffer pool, while pages made “not young” are moved much closer to the point of eviction. The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-metrics-table.html
Each monitor represents a point within the InnoDB source code that is instrumented to gather counter information. The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-st-geometry-columns-table.html
Permitted values are: geometry, point, linestring, polygon, multipoint, multilinestring, multipolygon, geometrycollection. The ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. This table is based on the ...
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-auto-increment-handling.html
The current maximum auto-increment counter value is written to the redo log each time it changes and saved to the data dictionary on each checkpoint; this makes the current maximum auto-increment counter value persistent across server restarts. On a ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup-recovery.html
For information about point-in-time recovery, recovery from disk failure or corruption, and how InnoDB performs crash recovery, see Section 17.18.2, “InnoDB Recovery”. This section covers topics related to InnoDB backup and recovery. For ...