Skip to content

Instantly share code, notes, and snippets.

@toddlipcon

toddlipcon/gist:0aa04d4eae81c11d99a87925a02d00a8

Created April 25, 2020 00:03
Show Gist options
  • Save toddlipcon/0aa04d4eae81c11d99a87925a02d00a8 to your computer and use it in GitHub Desktop.
Save toddlipcon/0aa04d4eae81c11d99a87925a02d00a8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Before and after comparing the CPU usage of the kudu tserver,
scanning the ~3.4B rows of the l_shipmode column from TPCH lineitem:
Before
=============
Performance counter stats for 'numactl -m 0 -N 0 build/release/bin/kudu-tserver -fs-wal-dir /data/1/todd/tpch-kudu-data/ts-0/wal/ -fs-data-dirs /data/1/todd/tpch-kudu-data/ts-0/data/':
137,685.93 msec task-clock # 3.356 CPUs utilized
106,215 context-switches # 0.771 K/sec
706 cpu-migrations # 0.005 K/sec
80,440 page-faults # 0.584 K/sec
381,320,057,554 cycles # 2.769 GHz
518,791,854,100 instructions # 1.36 insn per cycle
82,484,770,532 branches # 599.079 M/sec
5,603,338,938 branch-misses # 6.79% of all branches
125.574041000 seconds user
15.851152000 seconds sys
After
=============
Performance counter stats for 'numactl -m 0 -N 0 build/thinlto/bin/kudu-tserver.opt -fs-wal-dir /data/1/todd/tpch-kudu-data/ts-0/wal/ -fs-data-dirs /data/1/todd/tpch-kudu-data/ts-0/data/':
50,622.45 msec task-clock # 2.579 CPUs utilized
88,680 context-switches # 0.002 M/sec
525 cpu-migrations # 0.010 K/sec
81,148 page-faults # 0.002 M/sec
140,495,093,925 cycles # 2.775 GHz
266,728,934,861 instructions # 1.90 insn per cycle
31,908,620,331 branches # 630.326 M/sec
470,661,802 branch-misses # 1.48% of all branches
41.104729000 seconds user
12.278663000 seconds sys
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment