系统。磁盘 

包含有关在定义的磁盘信息 服务器配置.

列:

  • name (字符串) — Name of a disk in the server configuration.
  • path (字符串) — Path to the mount point in the file system.
  • free_space (UInt64) — Free space on disk in bytes.
  • total_space (UInt64) — Disk volume in bytes.
  • keep_free_space (UInt64) — Amount of disk space that should stay free on disk in bytes. Defined in the keep_free_space_bytes 磁盘配置参数。

系统。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 所得票数

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