Last active
September 9, 2019 04:32
-
-
Save inv2004/ac2da251cb23ff0c9cfc8443f2cd2525 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<test> | |
<name>test</name> | |
<type>loop</type> | |
<stop_conditions> | |
<all_of> | |
<total_time_ms>30000</total_time_ms> | |
</all_of> | |
<any_of> | |
<average_speed_not_changing_for_ms>6000</average_speed_not_changing_for_ms> | |
<total_time_ms>60000</total_time_ms> | |
</any_of> | |
</stop_conditions> | |
<main_metric> | |
<queries_per_second /> | |
<min_time /> | |
</main_metric> | |
<create_query>SET allow_experimental_data_skipping_indices = 1</create_query> | |
<create_query> | |
CREATE TABLE perf_test_orig ( | |
c1 LowCardinality(String), | |
c2 UInt8, | |
c3 UInt16, | |
c4 UInt64, | |
timestamp_ns UInt64, | |
timestamp DateTime MATERIALIZED toDateTime(timestamp_ns / 1000000000), | |
c7 Enum8('A' = 0, 'B' = 1), | |
c8 Enum8('AA' = 0, 'BB' = 1), | |
c9 LowCardinality(String), | |
c10 String, | |
INDEX timestamp_idx timestamp TYPE minmax GRANULARITY 1, | |
INDEX c4_idx c4 TYPE minmax GRANULARITY 3 | |
) | |
ENGINE = MergeTree() | |
ORDER BY (c1, c2, timestamp_ns) | |
PARTITION BY toYYYYMM(timestamp); | |
</create_query> | |
<create_query> | |
CREATE TABLE perf_test_new ( | |
c1 LowCardinality(String), | |
c2 UInt8, | |
c3 UInt16, | |
c4 UInt64, | |
timestamp_ns UInt64, | |
timestamp DateTime MATERIALIZED toDateTime(timestamp_ns / 1000000000), | |
c7 Enum8('A' = 0, 'B' = 1), | |
c8 Enum8('AA' = 0, 'BB' = 1), | |
c9 LowCardinality(String), | |
c10 String | |
) | |
ENGINE = MergeTree() | |
ORDER BY (timestamp_ns, c1, c2) | |
PARTITION BY toYYYYMM(timestamp); | |
</create_query> | |
<create_query>SYSTEM STOP MERGES perf_test_orig</create_query> | |
<create_query>SYSTEM STOP MERGES perf_test_new</create_query> | |
<query> | |
SELECT COUNT() FROM (SELECT 'service_name_'||toString(rand() % 10), 0 == rand() % 10, 1, rand() % (100000 / 30), (1546290000 * 10000 + number)*100000+rand()%1000000000 AS timestamp_ns, 'A', 0 == rand() % 2, '12345678901234'||toString(rand() % 10), '{"x":"'||toString(replicate(0, range(rand()%250)))||'"}' | |
FROM system.numbers LIMIT 100000) | |
</query> | |
<query> | |
SELECT COUNT() FROM (SELECT 'service_name_'||toString(rand() % 10), 0 == rand() % 10, 1, rand() % (1000000 / 30), (1546290000 * 10000 + number)*100000+rand()%1000000000 AS timestamp_ns, 'A', 0 == rand() % 2, '12345678901234'||toString(rand() % 10), '{"x":"'||toString(replicate(0, range(rand()%250)))||'"}' | |
FROM system.numbers LIMIT 1000000) | |
</query> | |
<query> | |
INSERT INTO perf_test_orig SELECT '1234567890123'||toString(rand() % 10), 0 == rand() % 10, 1, rand() % (100000 / 30), (1546290000 * 10000 + number)*100000+rand()%1000000000 AS timestamp_ns, 'A', 0 == rand() % 2, '12345678901234'||toString(rand() % 10), '{"x":"'||toString(replicate(0, range(rand()%250)))||'"}' | |
FROM system.numbers LIMIT 100000 | |
</query> | |
<query> | |
INSERT INTO perf_test_orig SELECT '1234567890123'||toString(rand() % 10), 0 == rand() % 10, 1, rand() % (1000000 / 30), (1546290000 * 10000 + number)*100000+rand()%1000000000 AS timestamp_ns, 'A', 0 == rand() % 2, '12345678901234'||toString(rand() % 10), '{"x":"'||toString(replicate(0, range(rand()%250)))||'"}' | |
FROM system.numbers LIMIT 1000000 | |
</query> | |
<query> | |
INSERT INTO perf_test_new SELECT '1234567890123'||toString(rand() % 10), 0 == rand() % 10, 1, rand() % (100000 / 30), (1546290000 * 10000 + number)*100000+rand()%1000000000 AS timestamp_ns, 'A', 0 == rand() % 2, '12345678901234'||toString(rand() % 10), '{"x":"'||toString(replicate(0, range(rand()%250)))||'"}' | |
FROM system.numbers LIMIT 100000 | |
</query> | |
<query> | |
INSERT INTO perf_test_new SELECT '1234567890123'||toString(rand() % 10), 0 == rand() % 10, 1, rand() % (1000000 / 30), (1546290000 * 10000 + number)*100000+rand()%1000000000 AS timestamp_ns, 'A', 0 == rand() % 2, '12345678901234'||toString(rand() % 10), '{"x":"'||toString(replicate(0, range(rand()%250)))||'"}' | |
FROM system.numbers LIMIT 1000000 | |
</query> | |
<drop_query>DROP TABLE IF EXISTS perf_test_new</drop_query> | |
<drop_query>DROP TABLE IF EXISTS perf_test_orig</drop_query> | |
<drop_query>SYSTEM START MERGES perf_test_new</drop_query> | |
<drop_query>SYSTEM START MERGES perf_test_orig</drop_query> | |
</test> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment