Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
Auto Query Time Estimation can provide runtime data for up to 1000 queries, which is the MySQL HeatWave query history limit. Auto Query Time Estimation data is also available in JSON format or SQL table format with queries to the ... Auto Query Time ...This topic contains the following sections: Run Auto Query Time Estimation Auto Query Time Estimation Data Auto Query Time Estimation Examples What's Next Run Auto Query Time Estimation For Auto Query Time Estimation to provide runtime data, a query history must be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
This topic describes how to debug queries that fail to offload to MySQL HeatWave for execution. Setting Secondary Engine Definition By default, SELECT queries are offloaded to MySQL HeatWave for execution and fall back to the DB System if that is ...To force a query to execute on MySQL HeatWave or fail if that is not possible, set the use_secondary_engine variable to ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. The slow query log can be used to find queries that take a long time to execute ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-json.html
end-object dialect_option_key_value: { "format": "csv" | "field_delimiter": "," | "record_delimiter": "\\n" | "encoding": "utf8mb4" | "escape_character": "\\" | "quotation_marks": "\"" | "null_value": "\\N" | "has_header": {true | false} } Parameter ... This topic shows the different ways to export query results as a CSV file with JSON ...
https://dev.mysql.com/doc/internals/en/optimizer-union-queries.html
Therefore, for this query: SELECT * FROM Table1 WHERE column1 = 'x' UNION ALL SELECT * FROM TABLE1 WHERE column2 = 'y' if both column1 and column2 are indexed, then each SELECT is done using an indexed search, and the result sets are merged. Notice ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-parquet-json.html
end-object dialect_option_key_value: { "format": "parquet" | "compression": {"uncompressed"|"snappy"|"gzip"|"brotli"|"zstd"|"lz4"} } Parameter Descriptions for URI Supported as of MySQL 9.3.1. You can use one of the following formats: ... This topic ...
https://dev.mysql.com/doc/internals/en/traceable-queries.html
They are: SELECT; INSERT or REPLACE (with VALUES or SELECT); UPDATE/DELETE and their multi-table variants; all the previous ones prefixed by EXPLAIN; SET (unless it manipulates the optimizer_trace system variable); DO; DECLARE/CASE/IF/RETURN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Verify if the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-json.html
The option to export query results as an ND-JSON file is available as of MySQL 9.3.1. You can use one of the following formats: ...This topic shows the different ways to export query results as an ND-JSON file. end-object dialect_option_key_value: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-non-json.html
Syntax: https://objectstorage.region_name.oraclecloud.com/n/namespace_name/b/bucket_name/o/prefixes Example: https://objectstorage.region1.oraclecloud.com/n/tenancy1/b/usr-bucket/o/summary/2024/Mar/ AWS S3 URL: Available for MySQL HeatWave on AWS.