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/refman/8.4/en/server-status-variables.html
If this value is high, it is a good indication that your tables are properly indexed for your queries. This value is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to ... The MySQL server maintains many status variables that provide information about its ...
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/refman/8.4/en/select-optimization.html
Queries, in the form of SELECT statements, perform all the lookup operations in the database. Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE ...