Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
For partitioned tables, ENGINE shows the name of the storage engine used by all partitions. (This is also true if the InnoDB table is partitioned.) AVG_ROW_LENGTH The average row length. (In-memory data resource usage is reported by the DATA_LENGTH ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.4/en/insert-select.html
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { SELECT ... You can explicitly select which partitions or subpartitions (or both) of the source or ...
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
For partitioned tables, Engine shows the name of the storage engine used by all partitions. (This is also true if the InnoDB table is partitioned.) Avg_row_length The average row length. (In-memory data resource usage is reported by the Data_length ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Table fragment fixed data reference has reached maximum possible value (specify MAXROWS or increase no of partitions) 1604 MySQL error. User specified partition id not allowed for scan takeover operation 4511 MySQL error. Explicit partitioning info ... This section lists all NDB errors, ordered by NDB error ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Error number: 1164; Symbol: HW_ER_PARTITION_NOT_LOADED Message: Accessed partition has not been loaded - %s. Description: The execution of query by HeatWave needs the partition to be loaded. Error number: 1165; Symbol: HW_ER_UNSUPPORTED_LOAD_POOL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
The INFORMATION_SCHEMA.PARTITIONS view includes a SECONDARY_LOAD column that indicates whether a partition has been loaded. If an operation loads or unloads the whole table, and does not specify individual partitions, then it updates all the ... To ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
partitions (JSON name: partitions) The partitions from which records would be matched by the query. No matching rows after partition pruning (JSON property: message) For DELETE or UPDATE, the optimizer found nothing to delete or update after ... The ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
When this clause is used, if any rows from the file cannot be inserted into any of the partitions or subpartitions named in the list, the statement fails with the error Found a row not matching the given partition set. The file can be read from the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
Joins referencing tables explicitly partitioned by [LINEAR] HASH, LIST, or RANGE currently cannot be pushed down. That is, the data node housing the cluster partition accessed by the first statement of a given transaction is used as the transaction ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
For partitioned tables, both the single-single and multiple-table forms of this statement support the use of a PARTITION clause as part of a table reference. This option takes a list of one or more partitions or subpartitions (or both). Only the ...