Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...The Transportable Tablespace feature makes it easy to copy the tablespaces from a running MySQL server instance to another running instance, or to perform a restore on the same ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column values. RANGE COLUMNS partitioning differs significantly from RANGE partitioning in the following ways: RANGE ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...(This also includes the table's primary key, since it is by definition a unique ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
There are no rows in nt that lie outside the boundaries of the partition definition for p. Any partition-level MAX_ROWS setting for p must be the same as the table-level MAX_ROWS value set for nt. The setting for any partition-level MIN_ROWS setting ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...You ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. While the examples work as shown for purposes of the present discussion, you ...Ranges should be contiguous but not overlapping, and are defined using the VALUES LESS THAN ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made faster. With non-transactional tables such as MyISAM, locks are placed on entire partitioned table. It ...Therefore its implementation is a part of the MySQL Query ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
This section provides a conceptual overview of partitioning in MySQL 8.4. For information on partitioning restrictions and feature limitations, see Section 26.6, “Restrictions and Limitations on Partitioning”. Partitioning takes this notion a ...The SQL standard does not provide much in the way of guidance regarding the physical aspects of data ...