Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. For this reason, EXTRACT() is not permitted as a partitioning function when it specifies the unit as WEEK. Each of these ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-partitioning.html
Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure, except where an exception is specifically allowed (see Section 19.5.1.9, “Replication with Differing Table ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-partitions.html
Before MySQL 9.1.0, MySQL HeatWave does not support explicit partition selection. As of MySQL 9.1.0, MySQL HeatWave supports InnoDB partitions with the following limitations: MySQL HeatWave cannot load partitions with Auto Parallel Load. MySQL ...
https://dev.mysql.com/doc/internals/en/optimizer-partitioning-related.html
See Partitioning for general information about the partitioning implementation in MySQL 5.1 and later.
https://dev.mysql.com/doc/ndbapi/en/overview-application-level-partitioning.html
There is no restriction against instantiating multiple Ndb_cluster_connection objects representing connections to different management servers in a single application, nor against using these for creating multiple instances of the Ndb class. Such ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 1591; Symbol: ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENT; SQLSTATE: HY000 Message: Table has no partition for some existing values Error number: 1592; Symbol: ER_BINLOG_UNSAFE_STATEMENT; SQLSTATE: HY000 Message: Unsafe statement written to ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-subpartitions.html
Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned table. Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-nodes-groups.html
An ndbd or ndbmtd process, which stores one or more fragment replicas—that is, copies of the partitions (discussed later in this section) assigned to the node group of which the node is a member. A node group consists of one or more nodes, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
When data is loaded into MySQL HeatWave, it is partitioned by the table primary key and sliced horizontally for distribution among MySQL HeatWave nodes by default. This topic includes the following sections: Before You Begin Define a Data Placement ...To use this feature, define data placement keys on the most frequently used JOIN keys and the keys of the longest running ...