Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-locking.html
X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods for the Collection.find() and Table.select() methods. This section describes how to use the lockShared() and lockExclusive() methods for both the Collection.find() ...This enables you to control row locking to ensure safe, transactional document updates on collections and to avoid concurrency problems, for example when using the modify() ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
This topic contains the following sections: Before You Begin Supported Encoding Types Select the Encoding Type Define String Column Encoding View String Column Encoding What's Next Before You Begin Review the requirements. Select the Encoding Type ... This topic describes how to encode string columns to improve the performance of queries that access ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-json.html
SELECT sum(l_quantity) from lineitem limit 1000 INTO OUTFILE WITH PARAMETERS '{"file":[{ "uri":"oci://bucket_1@tenancy1/data_files_1/"}], "dialect": {"format": "json" } }'; Example for PAR URL The following example uses a specific PAR URL to export ... The option to export query results as an ND-JSON file is available as of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
If you want to change the files in the engine_attribute settings for subsequent loads, see how to Add or Remove Files Using Selecting Load (supported as of MySQL 9.1.2). mysql> USE data_tables; mysql> SELECT COUNT(*) FROM data_table_1; +----------+ ... Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
mysql> CREATE MATERIALIZED VIEW airport_US AS SELECT airport.* FROM airport JOIN airport_geo ON airport.airport_id = airport_geo.airport_id WHERE airport_geo.country = 'UNITED STATES'; The materialized view retrieves information on U.S.-based ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-load-progress.html
mysql> SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME = 'rapid_load_progress'; +----------------+ | VARIABLE_VALUE | +----------------+ | 100.000000 | +----------------+ Note If necessary, you can halt a load ... The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-history.html
To view the MySQL HeatWave query history including query start time, end time, and wait time in the scheduling queue, as discussed in Section 5.4.11, “Auto Scheduling”. CONNECTION_ID The connection ID of the client that issued the query.
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-offload.html
The sys.processlist and sys.x$processlist views in the MySQL sys Schema also include an execution_engine column.
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
Check if you have the SELECT and INSERT privileges for the table that you want to analyze. | | | +--------------+-------------------+---------------------------------------------+ mysql> ALTER TABLE airline_info SECONDARY_LOAD; Query OK, 0 rows ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explanations-ml-explain-row.html
mysql> SELECT sys.ML_EXPLAIN_ROW(input_data, model_handle, [options]); In the following example, include the session variable previously created. The output is similar to the following: mysql> SELECT sys.ML_EXPLAIN_ROW(@row_input, @census_model, ...