clickhouse存储记录(一)

源数据库存放位置：

/data/clickhouse/data/metadata/

源数据库表存放位置

ubuntu@collector:/$ ls /data/clickhouse/data/metadata/
default      ethereum                  ethereum_backup_20250928.sql  information_schema.sql  system      test_ethereum      test_web3      web3
default.sql  ethereum_backup_20250928  ethereum.sql                  INFORMATION_SCHEMA.sql  system.sql  test_ethereum.sql  test_web3.sql  web3.sql

源数据库表存放位置：

在数据库目录下面：

ubuntu@collector:/data/clickhouse/data/metadata/test_ethereum$ ls
accounts.sql  blocks.sql  block_tasks.sql  logs.sql  transactions.sql

源数据库表数据：

/data/clickhouse/data/metadata/test_ethereum/block_tasks.sql

 format_version.txt   mutation_5189.txt  mutation_5210.txt  mutation_5229.txt  mutation_5253.txt  mutation_5272.txt
ATTACH TABLE _ UUID '961d82dc-51ce-4e11-b9e9-783fe384131d'
(
    `created_at` DateTime64(3) COMMENT '创建时间',
    `updated_at` DateTime64(3) COMMENT '更新时间',
    `deleted_at` Nullable(DateTime64(3)) COMMENT '删除时间',
    `start_block` UInt64 COMMENT '开始区块号',
    `end_block` UInt64 COMMENT '结束区块号',
    `status` String COMMENT '任务状态',
    `owner` String COMMENT '任务所有者',
    `assigned_at` DateTime64(3) COMMENT '分配时间',
    `completed_at` DateTime64(3) COMMENT '完成时间',
    `data_hash` String COMMENT '数据哈希',
    `blocks_finished` UInt8 DEFAULT false COMMENT '区块数据是否完成',
    `transactions_finished` UInt8 DEFAULT false COMMENT '交易数据是否完成',
    `logs_finished` UInt8 DEFAULT false COMMENT '日志数据是否完成',
    `account_finished` UInt8 DEFAULT false COMMENT '地址数据是否完成',
    `reset_times` UInt64 DEFAULT 0 COMMENT '重置次数',
    INDEX idx_block_tasks_status status TYPE minmax GRANULARITY 3,
    INDEX idx_block_tasks_blocks_finished blocks_finished TYPE minmax GRANULARITY 3,
    INDEX idx_block_tasks_transactions_finished transactions_finished TYPE minmax GRANULARITY 3,
    INDEX idx_block_tasks_logs_finished logs_finished TYPE minmax GRANULARITY 3,
    INDEX idx_block_tasks_account_finished account_finished TYPE minmax GRANULARITY 3
)
ENGINE = MergeTree
PARTITION BY intDiv(start_block, 500000)
PRIMARY KEY (start_block, end_block)
ORDER BY (start_block, end_block)
SETTINGS enable_block_number_column = 1, enable_block_offset_column = 1, index_granularity = 8192

包含最关键的数据uuid：UUID '961d82dc-51ce-4e11-b9e9-783fe384131d'

源数据表数据存储目录

/data/clickhouse/data/store/961/961d82dc-51ce-4e11-b9e9-783fe384131d

 ubuntu@collector:/data/clickhouse/data/store/961/961d82dc-51ce-4e11-b9e9-783fe384131d$ ls
44_89_144_9_5282     mutation_5181.txt  mutation_5199.txt  mutation_5215.txt  mutation_5231.txt  mutation_5252.txt  mutation_5268.txt
45_38_90_10_5282     mutation_5182.txt  mutation_5200.txt  mutation_5216.txt  mutation_5232.txt  mutation_5253.txt  mutation_5269.txt
46_1_5102_192_5277   mutation_5183.txt  mutation_5201.txt  mutation_5217.txt  mutation_5233.txt  mutation_5254.txt  mutation_5270.txt
46_5116_5116_0_5277  mutation_5184.txt  mutation_5202.txt  mutation_5218.txt  mutation_5234.txt  mutation_5255.txt  mutation_5271.txt
detached             mutation_5185.txt  mutation_5203.txt  mutation_5219.txt  mutation_5235.txt  mutation_5256.txt  mutation_5272.txt
format_version.txt   mutation_5186.txt  mutation_5204.txt  mutation_5220.txt  mutation_5236.txt  mutation_5257.txt  mutation_5273.txt
mutation_5171.txt    mutation_5187.txt  mutation_5205.txt  mutation_5221.txt  mutation_5237.txt  mutation_5258.txt  mutation_5274.txt
mutation_5172.txt    mutation_5188.txt  mutation_5206.txt  mutation_5222.txt  mutation_5238.txt  mutation_5259.txt  mutation_5275.txt
mutation_5173.txt    mutation_5189.txt  mutation_5207.txt  mutation_5223.txt  mutation_5239.txt  mutation_5260.txt  mutation_5276.txt
mutation_5174.txt    mutation_5192.txt  mutation_5208.txt  mutation_5224.txt  mutation_5240.txt  mutation_5261.txt  mutation_5277.txt
mutation_5175.txt    mutation_5193.txt  mutation_5209.txt  mutation_5225.txt  mutation_5241.txt  mutation_5262.txt  mutation_5281.txt
mutation_5176.txt    mutation_5194.txt  mutation_5210.txt  mutation_5226.txt  mutation_5242.txt  mutation_5263.txt  mutation_5282.txt
mutation_5177.txt    mutation_5195.txt  mutation_5211.txt  mutation_5227.txt  mutation_5248.txt  mutation_5264.txt  patch-8cef4cfbba2ac6dea7080b73ed457d55-46_5280_5280_0_5279
mutation_5178.txt    mutation_5196.txt  mutation_5212.txt  mutation_5228.txt  mutation_5249.txt  mutation_5265.txt  tmp_mut_46_1_5102_192_5282
mutation_5179.txt    mutation_5197.txt  mutation_5213.txt  mutation_5229.txt  mutation_5250.txt  mutation_5266.txt  tmp_mut_46_5116_5116_0_5282
mutation_5180.txt    mutation_5198.txt  mutation_5214.txt  mutation_5230.txt  mutation_5251.txt  mutation_5267.txt

这里存放了mutation相关操作记录