Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
INTO OUTFILE statements and the LOAD_FILE() function, to the specified directory. Post-installation setup involves creating a safe directory for import and export operations, configuring server startup options, initializing the data directory, ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-single-document-operations.html
The CRUD commands described at Section 4.3, “Collection CRUD Function Overview” all act on a group of documents in a collection that match a filter. X DevAPI also provides the following operations, which work on single documents that are ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-single-document-operations.html
The CRUD commands described at Section 4.3, “Collection CRUD Function Overview” all act on a group of documents in a collection that match a filter. X DevAPI also provides the following operations, which work on single documents that are ...
https://dev.mysql.com/doc/heatwave/en/import-data.html
This topic describes how to import data into the DB System. Import Data Use MySQL Shell Shell for importing data into a DB System. Its dump and load utilities are specifically built for this task and support all types of data exports and imports.
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
The second statement SELECT JSON_OBJECT("Task result", "Finished...") into @task_result generates an output that is stored in the reserved session variable @task_result. The execute_prepared_stmt_from_app_async routine creates an asynchronous task ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
The limits.maximumHeatwaveLoadingTasks key specifies the maximum number of VECTOR_STORE_LOAD tasks that can run concurrently for loading unstructured data into the MySQL HeatWave Cluster. For example: mysql> CALL ... As of MySQL 9.3.1, you can run ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
mysql> SELECT JSON_ARRAYAGG(schema_name) FROM performance_schema.rpd_table_id WHERE table_name LIKE 'hw%' INTO @input_list; mysql> CALL sys.heatwave_unload(@input_list, NULL); Unload tables that begin with an “hw” prefix from a schema named db_1. mysql> SELECT JSON_ARRAY(JSON_OBJECT('db_name', 'db_1', 'tables', JSON_ARRAYAGG(table_name))) FROM performance_schema.rpd_table_id WHERE schema_name = 'db_1' AND table_name LIKE 'hw%' INTO @input_list; mysql> CALL sys.heatwave_unload(@input_list, NULL); Unload all user and system ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
The following query example uses INTERVAL() function to calculate and display the time interval into which the departure hour falls, based on the specified thresholds (6, 12, 18, 24). This topic describes how to debug queries that fail to offload ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL HeatWave query processing engine (RAPID) as the secondary engine for the table. With MySQL version 8.2.0 or higher, this step is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
Select the Encoding Type By default, when tables are loaded into MySQL HeatWave, CHAR, VARCHAR, and TEXT type columns are encoded using variable-length encoding. For example, it is permitted for a column description to be specified alongside a ...