Measuring cpimport Performance Baseline with ioping
Baseline Performance Reference Metrics
Infrastructure Layout
Ingestion Runtime
Observed Storage Latency (ioping)
Manual Benchmarking Procedure
CREATE TABLE cptest ( group_name CHAR(2), number1 DECIMAL(12, 2), -- [Truncated for brevity; insert columns up to col250] col250 varchar(250) ) ENGINE=COLUMNSTORE;INSERT INTO cptest SELECT CAST(ROUND(RAND() * 10, 0) AS CHAR), ROUND(RAND() * 10000, 2), -- [Truncated for brevity; complete selections to match your column layout] substring(MD5(RAND()),1,2) FROM seq_1_to_10000;SELECT * FROM cptest INTO OUTFILE '/tmp/cptest.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';cpimport -E '"' -s "," test cptest /tmp/cptest.csvsudo yum install ioping cd /var/lib/columnstore/dataX/ ioping -c 30 .
Evaluating ioping Output Summary
ioping Output SummaryAutomated Scripted Performance Testing
Script Implementation
Last updated
Was this helpful?

