Search Results
https://dev.mysql.com/doc/refman/9.7/en/group-replication-responses-failure-exit.html
The group_replication_exit_state_action system variable specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to auto-rejoin or does not try. Bear in mind that operator ...Note that in the case of an expelled member, the member does not know that it was expelled until it reconnects to the group, so the specified action is only taken if the member manages to reconnect, or if the member raises a suspicion on itself and expels ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-statistics-estimation.html
Starting a mysql client with the --auto-rehash option enabled, which is the default. The auto-rehash option causes all InnoDB tables to be opened, and the open table operations cause statistics to be recalculated. To improve the start up time of the ...Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or altered with ...
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/9.7/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/9.7/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/9.7/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/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/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/9.7/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 ...