Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbeventoperation.html
NdbEventOperation::tableRangeListChanged() Description Use this method to check whether a table range partition list name has changed in connection with a TE_ALTER event. Return value This method returns true if range or list partition name has ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
All partitions are scanned in parallel when all bound index attributes include all attributes in the partitioning key. It is also important to note that, when using NdbIndexScanOperation::BoundEQ (see NdbIndexScanOperation::BoundType) with a ... An ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-heatwave.html
Massively Parallel Architecture The MySQL HeatWave massively parallel architecture uses internode and intranode partitioning of data. Each node within a MySQL HeatWave Cluster, and each CPU core within a node, processes the partitioned data in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data-manually.html
MySQL version 8.2.0 or higher has a guided load feature which allows you to skip the first two steps and load the data from a table or one or partitions of a table directly with a single ALTER TABLE statement. You can manually load data from InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 8.4. Such tables must be prepared prior to upgrade, either by removing the partitioning, or by converting them to InnoDB. See Section 26.6.2, ... If ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
InnoDB does not currently support foreign keys for tables with user-defined partitioning. This restriction does not apply for NDB tables that are partitioned by KEY or LINEAR KEY (the only user partitioning types supported by the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range possible_keys: i key: i key_len: 5 ref: NULL rows: 2 filtered: 100.00 Extra: Using where 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-file-removal.html
InnoDB stopped using partition definition files in MySQL 5.7 with the introduction of native partitioning support for InnoDB tables. In previous MySQL releases, dictionary data was partially stored in metadata files. Issues with file-based metadata ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). The following discussion uses ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The server keeps tablespace metadata in memory for the lifetime of a tablespace. Multiple tables in fewer general tablespaces consume less memory for ...