Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-refreshing-lakehouse-data.html
If the data has been altered or removed subsequently on Amazon S3, or if you want to add similar data from Amazon S3 that maps to your Lakehouse tables, you can perform a Lakehouse Incremental Load when using MySQL 9.1.0 or later. In a Lakehouse ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
LAST_INSERT_ID(), LAST_INSERT_ID(expr) With no argument, LAST_INSERT_ID() returns a BIGINT UNSIGNED (64-bit) value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most ...You ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/index.html
Abstract This is the user manual for MySQL Enterprise Backup, a commercially licensed backup utility for MySQL databases. It explains the different kinds of backup and restore that can be performed with MySQL Enterprise Backup, and describes the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/trouble.logging.html
You can use the end_lsn value of the latest backup as the starting LSN value for the next incremental backup by specifying it with the --start-lsn option. (An alternative to specifying the start LSN value for an incremental backup is to use the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-replicationsource-category.html
Table 7.28 Replication Source Configuration Metrics NameDescriptionAuto Increment Increment Controls the interval between successive column values within all AUTO_INCREMENT columns within the MySQL server. Auto Increment Offset Determines the ...
https://dev.mysql.com/doc/connector-net/en/connector-net-faq.html
Questions 10.1: Are all commands executed after a transaction begins automatically enlisted in the transaction? 10.2: How do I obtain the value of an auto-incremented column? Questions and Answers10.1: Are all commands executed after a transaction ...When a client begins a transaction in classic MySQL, all subsequent commands (on that connection) are part of that transaction until the client commits or rolls back the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-replication-dashboard-ui-ref.html
Group Auto Increment (Group Replication only) The auto increment defined for the group's members. Important The Max Replication Delay field displays the total amount of replication delay which exists on the monitored topologies. To display a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
The counter auto-increments for each MySQL HeatWave and MySQL HeatWave AutoML query. For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each query. QUERY_TEXT The RAPID engine query or ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog-table.html
The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing numeric identifier for the model. The model_object_catalog table has the following columns: chunk_id A ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
Consider using an auto-increment column if there is not another stable, unique, non-null, numeric column to use. An auto-increment column is also a good choice if there is any doubt whether the value of the primary key column could ever change. If ...Handling Too-Long Or Too-Short Transactions Because MyISAM tables do not support transactions, you might not have paid much attention to the autocommit configuration option and the COMMIT and ROLLBACK ...