Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-schema-error.html
The following list enumerates all NDB errors of type SE (Schema error).
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-data-placement.html
Data placement keys are used to partition table data among MySQL HeatWave nodes when loading tables. Partitioning table data by JOIN and GROUP BY key columns can improve query performance by avoiding costs associated with redistributing data among ...For more information about data placement keys, see Section 5.8.2, “Data Placement ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-schema.html
Data dictionary tables are protected and may only be accessed in debug builds of MySQL. However, MySQL supports access to data stored in data dictionary tables through INFORMATION_SCHEMA tables and SHOW statements. For an overview of the tables ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
The remote table that a FEDERATED table points to must exist before you try to access the table through the FEDERATED table. It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. A FEDERATED table ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. This issue does ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
Preliminary checks: The following issues must not be present: There must be no tables that use obsolete data types or functions. Triggers must not have a missing or empty definer or an invalid creation context (indicated by the character_set_client, ... Before upgrading to the latest MySQL 8.4 release, ensure the upgrade readiness of your current MySQL 8.3 or MySQL 8.4 server instance by performing the preliminary checks described ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbconfiguration-category.html
Table 7.14 InnoDB Configuration Configuration Metrics NameDescriptionAdaptive Flushing Enabled Whether an heuristic to determine when to flush dirty pages in the buffer pool is used. Autoextend Increment The increment size (in MB) for extending the ... Lists the InnoDB Configuration configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-estimate-cluster-size.html
Optionally, log into your DB System and run ANALYZE TABLE on tables you intend to load into the MySQL HeatWave Cluster. Estimates should generally be valid without running ANALYZE TABLE , but running ANALYZE TABLE ensures that estimates are as ...
https://dev.mysql.com/doc/refman/8.4/en/index-page-merge-threshold.html
The MERGE_THRESHOLD for index pages can be defined for a table or for individual indexes. A MERGE_THRESHOLD value defined for an individual index takes priority over a MERGE_THRESHOLD value defined for the table. Setting MERGE_THRESHOLD for a Table ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. While the examples work as shown for purposes of the present discussion, you ...Ranges should be contiguous but not overlapping, and are defined using the VALUES LESS THAN ...