Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
Runtime data is useful for query optimization, troubleshooting, and estimating the cost of running a particular query or workload. CALL sys.heatwave_advisor (options); For more information about the MySQL HeatWave Advisor, see Optimize Workloads for ... Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave Advisor provides string column encoding and data placement key recommendations based on machine learning models, data analysis, and MySQL HeatWave query ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-3-0.html
In mixed or Lakehouse workloads, where changing data characteristics can degrade performance, this feature helps maintain optimal query execution by keeping statistics up-to-date. For more information, see Optimizer Notes and Optimizing ANY and ALL ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-6-0.html
The VALIDATE ONLY clause can be used to validate a specified number of rows or all rows, and also supports Guided Load options, making it easier to ensure data integrity and optimize loading processes. (WL #16441) MySQL HeatWave now supports auto ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-managing-hw-data.html
The source data is read from an Amazon S3 bucket, transformed into a memory-optimized format, stored in the MySQL HeatWave persistence storage layer, and then loaded to the MySQL HeatWave Cluster memory. Data is loaded into MySQL HeatWave from the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
For information about the performance characteristics of primary keys, especially for InnoDB tables, see Section 10.3.2, “Primary Key Optimization”. ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
MySQL enables extra optimizations for queries on InnoDB tables when the transaction is known to be read-only. Specifying READ ONLY ensures these optimizations are applied in cases where the read-only status cannot be determined automatically. SET ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Several INFORMATION_SCHEMA tables are views on data dictionary tables, which enables the optimizer to use indexes on those underlying tables. Consequently, depending on optimizer choices, the row order of results for INFORMATION_SCHEMA queries might ... Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-format.html
You can use OPTIMIZE TABLE or myisamchk -r to defragment a table. In this case, you may have to run OPTIMIZE TABLE or myisamchk -r from time to time to improve performance. All links may be removed with OPTIMIZE TABLE or myisamchk -r. Dynamic ...
https://dev.mysql.com/doc/refman/8.4/en/execution-plan-information.html
Depending on the details of your tables, columns, indexes, and the conditions in your WHERE clause, the MySQL optimizer considers many techniques to efficiently perform the lookups involved in an SQL query. The set of operations that the optimizer ...A query on a huge table can be performed without reading all the rows; a join involving several tables can be performed without comparing every combination of ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
OPTIMIZE_LOCAL_TABLE Enable use of OPTIMIZE LOCAL TABLE or OPTIMIZE NO_WRITE_TO_BINLOG TABLE. [WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role [, ...