Sharding policy

• 1: Data sharding policy

1 - Data sharding policy

The sharding policy defines if and how extents (data shards) in your cluster are created. You can only query data in an extent once it’s created.

The data sharding policy contains the following properties:

• ShardEngineMaxRowCount:

  • Maximum row count for an extent created by an ingestion or rebuild operation.
  • Defaults to 1,048,576.
  • Not in effect for merge operations.
    • If you must limit the number of rows in extents created by merge operations, adjust the RowCountUpperBoundForMerge property in the entity’s extents merge policy.

• ShardEngineMaxExtentSizeInMb:

  • Maximum allowed compressed data size (in megabytes) for an extent created by a merge or rebuild operation.
  • Defaults to 8,192 (8 GB).

• ShardEngineMaxOriginalSizeInMb:

  • Maximum allowed original data size (in megabytes) for an extent created by a rebuild operation.
  • In effect only for rebuild operations.
  • Defaults to 3,072 (3 GB).

When a database is created, it contains the default data sharding policy. This policy is inherited by all tables created in the database (unless the policy is explicitly overridden at the table level).

Use the sharding policy management commands to manage data sharding policies for databases and tables.

Related content

• .show table policy sharding command

• .show database policy sharding command

• .alter database policy sharding command

• .alter-merge database policy sharding command

• .alter table policy sharding command

• .alter-merge table policy sharding command

• .delete database policy sharding command

• .delete table policy sharding command

• Extents (data shards)

• .show table policy sharding command

• Extents (data shards)