Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
The number of indexed columns in a table The number of partitions. If a table has no partitions, the number of partitions is considered to be 1. Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
(Previously, it was READ_ONLY.) For more information, see Section 20.5.3.2, “Configuring Transaction Consistency Guarantees”, and Section 20.7.7, “Responses to Failure Detection and Network Partitioning”, as well as the descriptions of the ... This section summarizes what has been added to, deprecated in, changed, and removed from MySQL 8.4 since MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-named-windows.html
WINDOW w AS (PARTITION BY country) This construct is not permitted because the OVER clause specifies PARTITION BY for a named window that already has PARTITION BY: OVER (w PARTITION BY year) ... WINDOW w AS (PARTITION BY country) The definition of a ... Windows can be defined and given names by which to refer to them in OVER ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbindexscanoperation.html
An additional version of this method can be used when the application knows that rows in-range will be found only within a particular partition. This is the same as that shown previously, except for the addition of a PartitionSpec. Doing so limits ...NdbIndexScanOperation Class Overview NdbIndexScanOperation::BoundType NdbIndexScanOperation::end_of_bound() NdbIndexScanOperation::getDescending() NdbIndexScanOperation::get_range_no() NdbIndexScanOperation::getSorted() NdbIndexScanOperation::IndexBound NdbIndexScanOperation::readTuples() NdbIndexScanOperation::reset_bounds() NdbIndexScanOperation::setBound() NdbIndexScanOperation Class Overview Parent class NdbScanOperation Child classes None Description The NdbIndexScanOperation class represents a scan operation using an ordered ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbscanoperation.html
NdbScanOperation::getPruned() Description This method is used to determine whether or not a given scan operation has been pruned to a single partition. Return value Returns true, if the scan is pruned to a single table partition. [...] Type: ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-1-0.html
(WL #15491) MySQL HeatWave now supports InnoDB partitions, and INFORMATION_SCHEMA.PARTITIONS includes a SECONDARY_LOAD column that indicates whether a partition has been loaded. When an unload operation successfully unloads the last partition, it ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
CHECK TABLE is supported for partitioned tables, and you can use ALTER TABLE ... CHECK PARTITION to check one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of ...option: ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
In addition, once an extent is allocated to a given partition, it cannot be used to store data from a different partition; an extent cannot store data from more than one partition. This means, for example that a tablespace having a single datafile ...The precise syntax and semantics depend on the storage engine ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
For details of the situation in which you might need to force a new group membership, and a procedure to follow when using this system variable, see Section 20.7.8, “Handling a Network Partition and Loss of Quorum”. This section lists the ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
A table reference (when it refers to a partitioned table) may contain a PARTITION clause, including a list of comma-separated partitions, subpartitions, or both. The effect of this option is that rows are selected only from the listed partitions or ... MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ...