Search Results
https://dev.mysql.com/doc/internals/en/sql-bench-directory.html
This directory has the programs and input files which MySQL uses for its comparisons of MySQL, PostgreSQL, mSQL, Solid, etc. Since MySQL publishes the comparative results, it's only right that it should make available all the material necessary to ...There are five subdirectories and sub-subdirectories: \Comments --- Comments about results from tests of Access, Adabas, ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines messages. Message ...
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-csv-json.html
You can use one of the following formats: https://namespace_name.objectstorage.region_name.oci.customer-oci.com/p/PAR_token/n/namespace_name/b/bucket_name/o/object_path ... This topic shows the different ways to export query results as a CSV file ...
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-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-lakehouse-export-query-results-parquet-json.html
end-object ] end-object' dialect_option: { {"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 ...
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.
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. INTO OUTFILE WITH PARAMETERS ...
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 ...