Skip to content

Instantly share code, notes, and snippets.

@toddlipcon

toddlipcon/gist:c499807a6b4f1e6e0f94f039b5a3b151

Created April 25, 2020 00:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save toddlipcon/c499807a6b4f1e6e0f94f039b5a3b151 to your computer and use it in GitHub Desktop.
Save toddlipcon/c499807a6b4f1e6e0f94f039b5a3b151 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
41.024754216 seconds time elapsed
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
19.625435814 seconds time elapsed
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