Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
Auto Parallel Load is a feature of MySQL HeatWave that automates many of the steps for loading data, which include the following: Excluding schemas, tables, and columns that cannot be loaded. Automatic Loading and Unloading of DB System Tables and ...Defining RAPID as the secondary engine for tables that are to be ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery.html
(The full backup can be made in several ways, such as those listed in Section 9.2, “Database Backup Methods”.) Point-in-time recovery then brings the server up to date incrementally from the time of the full backup to a more recent time.
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.11.2, “Refresh Data Using Incremental Load”. An empty array is permitted to view the Auto Parallel Load command-line help, see Use ...This adds an include list to exactly specify the tables and columns to load for a set of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-load.html
Refer to the Auto Parallel Load Syntax and full descriptions for input_list. The Auto Parallel Load external_tables option is a JSON array that includes one or more db_object items. mysql> SET @db_list = '["tpch"]'; This assumes that Lakehouse Auto ... Note Do not use the external_tables option as of MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
To start a replica using GTID-based replication, you need to enable the SOURCE_AUTO_POSITION option in the CHANGE REPLICATION SOURCE TO statement. Disabling the SOURCE_AUTO_POSITION option again causes the replica to revert to file-based ... GTIDs ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 1671; Symbol: ER_BINLOG_UNSAFE_AUTOINC_COLUMNS; SQLSTATE: HY000 Message: Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Error number: 1722; Symbol: ...It's not allowed ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
The Auto Query Plan Improvement feature collects and stores query plan statistics in a statistics cache when a query is executed in MySQL HeatWave. When a new query shares query execution plan nodes with previously executed queries, the statistics ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load.html
The topics in this section describe how to load structured data from Object Storage using Lakehouse Auto Parallel Load.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
mysql> CREATE EXTERNAL TABLE table_1( col_1 int, col_2 int, col_3 int) ENGINE_ATTRIBUTE='{"dialect": {"format": "csv"}, "file": [{"uri": "oci://mybucket@mynamespace/data_files/data_file_[1-10].csv", "allow_missing_files": true}]}'; mysql> ALTER ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
You can use Auto Parallel Load to load data from Object Storage into MySQL HeatWave Cluster. mysql> SET @input_list = '[{ "db_name": "db_1", "tables": [{ "table_name": "table_1", "engine_attribute": { "file": [{"uri": ...Since no dialect parameters ...