Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
In other words, 1048576 - 1044440 = 4136 bytes per partition is currently being used to store the data from this table's disk-based columns. For fully replicated tables, ndb_desc shows only the nodes holding primary partition fragment replicas; ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
row *************************** id: 1 select_type: PRIMARY table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4 filtered: 33.33 Extra: Using where *************************** 2. row ...Its value is a set ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
row *************************** id: 1 select_type: SIMPLE table: flightschedule partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 9828 filtered: 100 Extra: NULL 1 row in set, 1 warning (0.2389 sec) Execute the ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...| TABLE table_name} value: {expr | DEFAULT} value_list: value [, value] ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-unload-tables.html
Unload Partitions As of MySQL 9.1.0, MySQL HeatWave supports partitions for DB System tables. INFORMATION_SCHEMA.PARTITIONS includes a SECONDARY_LOAD column that indicates whether a partition is loaded. See the following to learn more: Load ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-system-tablespace.html
Additional information about the system tablespace is provided under the following topics in the section: Resizing the System Tablespace Using Raw Disk Partitions for the System Tablespace Resizing the System Tablespace This section describes how to ... The system tablespace is the storage area for the change ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... When inserting into a partitioned table, ...| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
For example, 09 is DB_TYPE_MYISAM, but 14 if MyISAM with partitioning. The .frm file for a partitioned table contains partition information, in clear text, in addition to the usual table definition details. PARTITION clause and not just the MYISAM ... Regardless of the storage engine you choose, every MySQL table you create is represented on disk by a .frm file that describes the table's format (that is, the table ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-object-cache.html
The dictionary object cache comprises cache partitions that store different object types. Some cache partition size limits are configurable, whereas others are hardcoded. The table definition cache partition exists in parallel with the table ... The ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-missing.html
REORGANIZE PARTITION statement in the mysql client for each NDB table in the cluster. It is possible using MySQL Cluster Manager to perform a partial restore of a MySQL NDB Cluster—that is, to restore from a backup in which backup images from one ...