【JMeter-ClickHouse】使用JMeter对ClickHouse的查询性能进行压测

bmyyyyyy

已于 2024-01-03 15:16:23 修改

阅读量1.7k

点赞数

分类专栏：其他文章标签： jmeter clickhouse sql

于 2023-03-10 16:58:28 首次发布

本文链接：https://blog.csdn.net/weixin_53543905/article/details/129424757

版权

【JMeter-ClickHouse】使用JMeter对ClickHouse的查询性能进行压测

1）生成测试数据
2）读取压测

1）生成测试数据

1.1.下载数据

编译 dbgen

$ git clone git@github.com:vadimtk/ssb-dbgen.git
$ cd ssb-dbgen
$ make

生成数据

$ ./dbgen -s 100 -T c
$ ./dbgen -s 100 -T l
$ ./dbgen -s 100 -T p

1.2.建表（共4张）

customer

CREATE TABLE customer
(
C_CUSTKEY UInt32,
C_NAME String,
C_ADDRESS String,
C_CITY LowCardinality(String),
C_NATION LowCardinality(String),
C_REGION LowCardinality(String),
C_PHONE String,
C_MKTSEGMENT LowCardinality(String)
)
ENGINE = MergeTree ORDER BY (C_CUSTKEY);

lineorder

CREATE TABLE lineorder
(
LO_ORDERKEY UInt32,
LO_LINENUMBER UInt8,
LO_CUSTKEY UInt32,
LO_PARTKEY UInt32,
LO_SUPPKEY UInt32,
LO_ORDERDATE Date,
LO_ORDERPRIORITY LowCardinality(String),
LO_SHIPPRIORITY UInt8,
LO_QUANTITY UInt8,
LO_EXTENDEDPRICE UInt32,
LO_ORDTOTALPRICE UInt32,
LO_DISCOUNT UInt8,
LO_REVENUE UInt32,
LO_SUPPLYCOST UInt32,
LO_TAX UInt8,
LO_COMMITDATE Date,
LO_SHIPMODE LowCardinality(String)
)
ENGINE