Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
You can force NDB to create extra partitions for NDB Cluster tables and thus have more memory available for hash indexes by using the MAX_ROWS option for CREATE TABLE. The only types of user-defined partitioning supported for NDBCLUSTER tables are ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
The cache is comprised of several partitions that store different object types. With the introduction of native partitioning support for InnoDB tables in MySQL 5.7.6, .par files are no longer created for partitioned InnoDB tables. Partitioned MyISAM ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
innodb_adaptive_hash_index_parts Command-Line Format --innodb-adaptive-hash-index-parts=# System Variable innodb_adaptive_hash_index_parts Scope Global Dynamic No SET_VAR Hint Applies No Type Numeric Default Value 8 Minimum Value 1 Maximum Value 512 ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
If a balance cannot be achieved between accurate statistics and ANALYZE TABLE execution time, consider decreasing the number of indexed columns in the table or limiting the number of partitions to reduce ANALYZE TABLE complexity. 17.8.10.1.7 ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-remarks.html
REORGANIZE PARTITION (or the execution of any other DDL statement), it is not possible to restart cluster data nodes. REORGANIZE PARTITION statement has reached the internal commit point: When the cluster is restarted, the data and indexes belonging ... This section provides general information about the behavior of and current limitations in adding NDB Cluster nodes ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
For information about using this statement with partitioned tables and table partitions, see Section 26.3.4, “Maintenance of Partitions”. Other Considerations OPTIMIZE TABLE is performed online for regular and partitioned InnoDB tables. OPTIMIZE ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
If this happens in a table's constraints, default expressions, partitioning expressions, or virtual columns, the table could not be opened. (Bug #32288105) InnoDB: Partition table indexes were not checked when retrieving a record count while that ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-partitionkey.html
Annotation on a class or member to define the partition key. If annotating a class or interface, either a single column or multiple columns can be specified. If annotating a member, neither column nor columns should be specified.
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
The following list enumerates all NDB errors of type AE (Application error). Having a table without primary key uses an autoincremented hidden key, i.e. NDB error code 5002 MySQL error DMEC Error message The process has wrong type. NDB error code ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-3-1.html
(WL #16472) MySQL HeatWave MySQL HeatWave now supports automated partition management, extending the Auto Parallel Load feature of automatically loading and unloading only the necessary partitions in partitioned tables based on usage. This ... Note ...