Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/understanding-automatic-document-ids.html
serial is a per-instance automatically incremented integer serial number value, which is hex encoded and has a range of 0 to 264-1. The initial value of serial is set to the auto_increment_offset system variable, and the increment of the value is ...
https://dev.mysql.com/doc/heatwave/en/heatwave-status-variables.html
The following statuses are available: disabled: The event-based incremental load feature is not available. initializing: The event-based incremental load feature is waiting for the server to finish booting and verifying which external tables are set ...Data is tracked in megabytes and is a cumulative total of data scanned since the MySQL HeatWave Cluster was last ...
https://dev.mysql.com/doc/refman/9.7/en/internal-temporary-tables.html
When the limit determined by tmp_table_size is reached, MySQL automatically converts the in-memory internal temporary table to an InnoDB on-disk internal temporary table. When using the MEMORY storage engine for in-memory temporary tables ... In ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-commands-backup.html
Various kinds of backups can be performed by adding different options, like using --compress or --incremental for compressed or incremental backups. The backup operations are the most frequently performed tasks by MySQL Enterprise Backup. In most ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/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.7/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.7/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/9.7/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/9.7/en/replication-options-source.html
Attempting to set the value of auto_increment_increment or auto_increment_offset to a non-integer value produces an error, and the actual value of the variable remains unchanged. When Group Replication is started on a server, the value of ... This ...