Search Results
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
Assuming that there is an index on (key_part1, key_part2), the following queries may use the index to resolve the ORDER BY part. In the next two queries, key_part1 is compared to a constant. Some types of queries are particularly suited to ... This ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
For InnoDB, the transform is disabled by default, in which case such queries pass without error (but are not transformed). Under these conditions, queries against the performance_schema.replication_group_members table on the former primary (i1) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
Note To run Advisor for both encoding and data placement recommendations, run Auto Encoding first, apply the recommended encodings, rerun the queries, and then run Auto Data Placement. Run the queries that you intend to use or run a representative ...Using the right string column encodings can reduce the amount of memory required on MySQL HeatWave nodes and improve query ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. If the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. The query rows related to the current ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-wordexcel.html
Within Microsoft Excel, you can execute queries on your MySQL server and import the data directly into an Excel Worksheet, presenting the data as a series of rows and columns. You can use Microsoft Word and Microsoft Excel to access information ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-wordexcel.html
Within Microsoft Excel, you can execute queries on your MySQL server and import the data directly into an Excel Worksheet, presenting the data as a series of rows and columns. You can use Microsoft Word and Microsoft Excel to access information ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
The MySQL HeatWave Advisor also provides a Query Insights feature, which provides runtimes for successfully executed queries, and runtime estimates for EXPLAIN queries, queries canceled using Ctrl+C, and queries that fail due to out of memory errors. The revised algorithm prioritizes queries based on estimated cost and wait time in the queue, which enables dynamic, workload-aware query ... Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave Advisor provides ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-mysql-instances-permissions.html
If Server Group is set to Read-Only, or higher, it is impossible to set MySQL Instances to None. That is, if Server Group is set to Read-Only, or higher, MySQL Instances must be set to Read-Only at least. MySQL Instances: grants access to the data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
The following sections in this topic describe how to generate new text-based content using MySQL HeatWave GenAI: Before You Begin Generate Content Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and ...If ...