Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
MySQL HeatWave provides the following methods to load data to MySQL HeatWave: Automatic loading: loads tables and partitions based on usage. MySQL HeatWave partitions data by the table primary key, unless the table definition includes data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-mirror-table.html
QUERIED_PARTITIONS For partitioned tables, lists the InnoDB partitions that have been queried. The rpd_mirror table keeps track of all existing tables in the DB System, whose engine is InnoDB. MYSQL_ACCESS_COUNT Number of times the table has been ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-running-queries.html
Query processing in MySQL HeatWave can access partitions with standard syntax. When MySQL HeatWave is enabled and the data you want to query is loaded, queries that qualify are automatically offloaded from the DB System to MySQL HeatWave for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-window-functions.html
For optimal performance, window functions in MySQL HeatWave utilize a massively parallel, partitioning-based algorithm. MySQL HeatWave window function support includes support for: WINDOW and OVER clauses in conjunction with PARTITION BY, ORDER BY, ...For general information about window functions, see Window Functions, in the MySQL Reference ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to group values into subsets. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-generated-columns.html
For non-partitioned tables, ADD COLUMN and DROP COLUMN are in-place operations for virtual columns. For partitioned tables, ADD COLUMN and DROP COLUMN are not in-place operations for virtual columns. ALTER TABLE operations permitted for generated ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
Values of a generated column are computed from an expression included in the column definition. Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter.html
Within statements considered for rewrite, instances of the following clauses are rewritten and each instance replaced by a single space: ENCRYPTION DATA DIRECTORY (at the table and partition levels) INDEX DIRECTORY (at the table and partition ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
row *************************** id: 1 select_type: SIMPLE table: x partitions: p0,p1 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4 filtered: 100.00 Extra: NULL *************************** 2. row *************************** ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-elements.html
The set of error codes used in error messages is partitioned into distinct ranges; see Error Code Ranges. Error Code Ranges The set of error codes used in error messages is partitioned into distinct ranges, each with its own purpose: 1 to 999: ...