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 HeatWave Advisor, see Workload Optimization for ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
2023-04-27: New Features Now Availability HeatWave Scale-out Data Management on AWS S3 MySQL HeatWave on AWS now provides an optimized storage layer built on AWS S3 to store the HeatWave in-memory hybrid columnar representation of the data. MySQL ...
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 HeatWave persistence storage layer, and then loaded to the HeatWave cluster memory. If you have not loaded data into the DB System, see ...
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 [, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
For information about using EXPLAIN output to tune INFORMATION_SCHEMA queries, see Section 10.2.3, “Optimizing INFORMATION_SCHEMA Queries”. INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the ...