Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
When in doubt about choosing an encoding type, use variable-length encoding, which is applied by default when tables are loaded into MySQL HeatWave, or use Auto Encoding to obtain encoding recommendations. Tip The Auto Parallel Load utility ... This ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
If you want to use the OCI Generative AI Service Embedding Models when you Ingest Files Using Auto Parallel Load, complete the steps to authenticate OCI Generative AI Service. To ingest multiple files with different unstructured data file formats ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-resource-principal.html
You require the appropriate privileges for Resource Principals to do the following: Load data using Lakehouse Auto Parallel Load and manually with resource principals. Load data using Lakehouse Auto Parallel Load and manually with uniform resource ... Resource principals allow you to authenticate and access Oracle Cloud Infrastructure (OCI) Object Storage ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Enabled automatically upon creation: Specify whether the channel should start automatically after it is successfully created. Replication positioning: Configure the Source GTID settings: Use GTID auto-positioning : Select this option when the system ... Creating a Channel 8.5 Creating a Channel Note:In MySQL replication, a replica is a MySQL server that receives changes from another MySQL server (source) and applies the ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
[WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name DROP HISTOGRAM ON col_name [, col_name] ... The ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/mysql-monitor/8.0/en/mebhealth-advisor-ref.html
Notify when incremental backups are not being used: enables you to generate an event if the monitoring agent detects that incremental backups are not used. The default value is: Warning = 7 days Notify when the last successful incremental backup is ... This section describes the MySQL Enterprise Backup Health Advisor which checks the status of backups, and alerts according to whether they succeeded or ...
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 ...