Search Results
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 [, ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
For more information, see Section 17.8.10.1, “Configuring Persistent Optimizer Statistics Parameters”. See Section 17.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters” for additional information. ANALYZE TABLE complexity ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
When you design a database with appropriate primary key columns for each table, operations involving those columns are automatically optimized. Inserts, updates, and deletes are optimized by an automatic mechanism called change buffering. For ...