Clemens Winter cswinter
cswinter
/ clickhouse-cold-query-hdd-1-thread
Created
August 12, 2018 18:06
This file has been truncated, but you can view the full file.
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
| ➜ ~ uname -a | |
| Linux Archon 4.4.0-66-generic #87-Ubuntu SMP Fri Mar 3 15:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux | |
| ➜ ~ cd nyc-benchmarks/nyc-clickhouse | |
| ➜ nyc-clickhouse sudo lshw -class disk -class storage | |
| [sudo] password for clemens: | |
| *-storage | |
| description: SATA controller | |
| product: ASM1062 Serial ATA Controller | |
| vendor: ASMedia Technology Inc. | |
| physical id: 0 |
cswinter
/ clickhouse-cold-query-ssd
Created
August 12, 2018 18:04
This file has been truncated, but you can view the full file.
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
| ➜ ~ uname -a | |
| Linux Archon 4.4.0-66-generic #87-Ubuntu SMP Fri Mar 3 15:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux | |
| ➜ ~ sudo lshw -class disk -class storage | |
| [sudo] password for clemens: | |
| *-storage | |
| description: SATA controller | |
| product: ASM1062 Serial ATA Controller | |
| vendor: ASMedia Technology Inc. | |
| physical id: 0 | |
| bus info: pci@0000:06:00.0 |
cswinter
/ clickhouse-cold-query-hdd-12-threads
Created
August 12, 2018 17:59
This file has been truncated, but you can view the full file.
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
| ➜ nyc-clickhouse uname -a | |
| Linux Archon 4.4.0-66-generic #87-Ubuntu SMP Fri Mar 3 15:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux | |
| ➜ nyc-clickhouse sudo lshw -class disk -class storage | |
| *-storage | |
| description: SATA controller | |
| product: ASM1062 Serial ATA Controller | |
| vendor: ASMedia Technology Inc. | |
| physical id: 0 | |
| bus info: pci@0000:06:00.0 |
cswinter
/ locustdb-bulk-load-ssd-hdd
Created
August 12, 2018 17:53
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
| ➜ ~ uname -a | |
| Linux Archon 4.4.0-66-generic #87-Ubuntu SMP Fri Mar 3 15:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux | |
| ➜ ~ sudo lshw -class disk -class storage | |
| [sudo] password for clemens: | |
| *-storage | |
| description: SATA controller | |
| product: ASM1062 Serial ATA Controller | |
| vendor: ASMedia Technology Inc. | |
| physical id: 0 | |
| bus info: pci@0000:06:00.0 |
cswinter
/ locustdb-ingestion-ssd
Created
August 12, 2018 17:52
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
| ➜ ~ uname -a | |
| Linux Archon 4.4.0-66-generic #87-Ubuntu SMP Fri Mar 3 15:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux | |
| ➜ ~ sudo lshw -class disk -class storage | |
| [sudo] password for clemens: | |
| *-storage | |
| description: SATA controller | |
| product: ASM1062 Serial ATA Controller | |
| vendor: ASMedia Technology Inc. | |
| physical id: 0 | |
| bus info: pci@0000:06:00.0 |
cswinter
/ locustdb-ingestion-hdd
Created
August 12, 2018 17:49
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
| ➜ ~ uname -a | |
| Linux Archon 4.4.0-66-generic #87-Ubuntu SMP Fri Mar 3 15:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux | |
| ➜ ~ sudo lshw -class disk -class storage | |
| [sudo] password for clemens: | |
| *-storage | |
| description: SATA controller | |
| product: ASM1062 Serial ATA Controller | |
| vendor: ASMedia Technology Inc. | |
| physical id: 0 | |
| bus info: pci@0000:06:00.0 |
cswinter
/ locustdb-cold-query-ssd
Created
August 12, 2018 17:45
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
| ➜ ~ uname -a | |
| Linux Archon 4.4.0-66-generic #87-Ubuntu SMP Fri Mar 3 15:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux | |
| ➜ ~ sudo lshw -class disk -class storage | |
| [sudo] password for clemens: | |
| *-storage | |
| description: SATA controller | |
| product: ASM1062 Serial ATA Controller | |
| vendor: ASMedia Technology Inc. | |
| physical id: 0 | |
| bus info: pci@0000:06:00.0 |
cswinter
/ locustdb-cold-query-hdd
Created
August 12, 2018 17:42
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
| ➜ ~ uname -a | |
| Linux Archon 4.4.0-66-generic #87-Ubuntu SMP Fri Mar 3 15:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux | |
| ➜ ~ sudo lshw -class disk -class storage | |
| [sudo] password for clemens: | |
| *-storage | |
| description: SATA controller | |
| product: ASM1062 Serial ATA Controller | |
| vendor: ASMedia Technology Inc. | |
| physical id: 0 | |
| bus info: pci@0000:06:00.0 |
cswinter
/ locustdb-lz4-vs-nolz4
Created
August 12, 2018 17:35
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
| ➜ ~ uname -a | |
| Linux Archon 4.4.0-66-generic #87-Ubuntu SMP Fri Mar 3 15:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux | |
| ➜ ~ lscpu | |
| Architecture: x86_64 | |
| CPU op-mode(s): 32-bit, 64-bit | |
| Byte Order: Little Endian | |
| CPU(s): 12 | |
| On-line CPU(s) list: 0-11 | |
| Thread(s) per core: 2 | |
| Core(s) per socket: 6 |
cswinter
/ import_mergetree
Created
July 8, 2018 22:46
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
| CREATE TABLE trips_mergetree | |
| ENGINE = MergeTree(pickup_date, pickup_datetime, 8192) | |
| AS SELECT | |
| trip_id, | |
| CAST(vendor_id AS Enum8('1' = 1, '2' = 2, '3' = 3, 'CMT' = 4, 'VTS' = 5, 'DDS' = 6, 'B02512' = 10, 'B02598' = 11, 'B02617' = 12, 'B02682' = 13, 'B02764' = 14)) AS vendor_id, | |
| toDate(pickup_datetime) AS pickup_date, | |
| ifNull(pickup_datetime, toDateTime(0)) AS pickup_datetime, | |
| toDate(dropoff_datetime) AS dropoff_date, | |
| ifNull(dropoff_datetime, toDateTime(0)) AS dropoff_datetime, | |
| assumeNotNull(store_and_fwd_flag) IN ('Y', '1', '2') AS store_and_fwd_flag, |