Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-prep-gather.html
Use the technique explained in Creating Incremental Backups Using Only the Redo Log. Only needed if you perform incremental backups using the --incremental-with-redo-log-only option rather than the --incremental option. The size of the InnoDB redo ... Before backing up a particular database server for the first time, gather some information and use it to make some planning decisions, as outlined in the following ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/monitoring-innodb-cluster.html
Tip InnoDB Cluster manages the Group Replication Protocol version being used automatically, see InnoDB Cluster and Group Replication Protocol for more information. Information is shown for instances recovering using either MySQL Clone, or ... This ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/setting-up-innodb-cluster-and-mysql-router.html
The Shell is unable to decide whether incremental state recovery can correctly provision it. The safest and most convenient way to provision a new instance is through automatic clone provisioning, which will completely overwrite the state of ... In ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-1.html
(WL #16545) MySQL HeatWave Lakehouse MySQL HeatWave Lakehouse now supports event-based automatic incremental load on OCI, allowing for seamless and automated data refresh of tables loaded from object storage. With this update, customers can ...MySQL ... These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
The current maximum auto-increment counter value is written to the redo log each time the value changes, which makes it crash-safe. For more information about how InnoDB handles auto-increment values, see Section 17.6.1.6, “AUTO_INCREMENT Handling ...InnoDB automatically checks the logs and performs a roll-forward of the database to the ...To achieve point-in-time recovery after ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
Attempting to set the value of auto_increment_increment or auto_increment_offset to a noninteger value produces an error, and the actual value of the variable remains unchanged. When Group Replication is started on a server, the value of ...However, ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #37271715) InnoDB: It was possible for an ALTER TABLE operation using the INPLACE algorithm on a table containing both a spatial index and an auto-increment column to cause corruption or, in debug builds, to trigger a debug assert. This was due ...This change means the row version is no longer incremented for these simple ... Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management ...
https://dev.mysql.com/doc/ndbapi/en/ndb-table.html
Table::getNoOfAutoIncrementColumns() Description This method is used to obtain the number of auto-incrment columns in a table. Return value An integer representing the number of auto-increment columns in the table. validate() is called automatically ... This section provides information about the Table class, which models a database table in the NDB ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-0-1-u1.html
MySQL HeatWave AutoML MySQL HeatWave GenAI MySQL HeatWave Lakehouse MySQL HeatWave MySQL HeatWave AutoML MySQL HeatWave AutoML now supports semi-supervised learning for anomaly detection. This is an unsupervised machine learning technique that is ...This type of machine learning algorithm uses a specific set of labeled data along with unlabeled data to detect ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
InnoDB sets an exclusive lock on the end of the index associated with the AUTO_INCREMENT column while initializing a previously specified AUTO_INCREMENT column on a table. With innodb_autoinc_lock_mode=0, InnoDB uses a special AUTO-INC table lock ...