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. Requirements and Privileges for Auto Parallel Load To ...
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}]}'; Event-Based ...
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.14.2, “Refresh Data Using Incremental Load”. An empty array is permitted to view the Auto Parallel Load command-line help, see Use ...MySQL 8.4.0 adds support for the following: An input_list JSON array replaces the db_list JSON ...
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/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/heatwave/en/mys-hw-lakehouse-auto-load.html
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 Parallel Load will analyze the data, infer the table structure, and create ...
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-create-table-auto-parallel-load.html
This topics in this section describe how to create external tables using Auto Parallel Load.
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-unload.html
You can use MySQL HeatWave Auto Unload to unload data automatically. This topic contains the following sections: Before You Begin Overview for Unloading Data Automatically Unload Specific Tables Unload All Data Auto Unload Examples What's Next ...