Clickhouse冷热配置

在clickhouse配置目录下config.d创建storage.xml文件

<yandex>
  <storage_configuration>
    <disks>
      <default>
         <keep_free_space_bytes>1024</keep_free_space_bytes>
      </default>
      <vdb>
         <path>/data/vdb/</path>
      </vdb>
      <vdc>
          <path>/data/vdc/</path>
      </vdc>
    </disks>
  <policies>
      <storage>
        <volumes>
          <hot_volume>
            <disk>vdc</disk>
              <max_data_part_size_bytes>29000000</max_data_part_size_bytes>
          </hot_volume>
          <cold_volume>
              <disk>vdb</disk>
          </cold_volume>
        </volumes>
      </storage>
   </policies>
  </storage_configuration>
</yandex>

使用示例

ENGINE = MergeTree
ORDER BY Id
SETTINGS storage_policy = 'storage', index_granularity = 8192