系统。storage_policies 

包含有关存储策略和卷中定义的信息 服务器配置.

列:

  • policy_name (字符串) — Name of the storage policy.
  • volume_name (字符串) — Volume name defined in the storage policy.
  • volume_priority (UInt64) — Volume order number in the configuration.
  • disks (数组(字符串)) — Disk names, defined in the storage policy.
  • max_data_part_size (UInt64) — Maximum size of a data part that can be stored on volume disks (0 — no limit).
  • move_factor (Float64) — Ratio of free disk space. When the ratio exceeds the value of configuration parameter, ClickHouse start to move data to the next volume in order.

如果存储策略包含多个卷,则每个卷的信息将存储在表的单独行中。

评分: 4 - 1 所得票数

这个内容有帮助??
★★★★☆