Skip to content

Instantly share code, notes, and snippets.

@amcintyre99

amcintyre99/gist:661e2c73baa0ad354124c1284614c627

Created June 2, 2017 20:53
Show Gist options
  • Save amcintyre99/661e2c73baa0ad354124c1284614c627 to your computer and use it in GitHub Desktop.
Save amcintyre99/661e2c73baa0ad354124c1284614c627 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
andrew@sherlock:~/dma/odbc_ibm$ perf record node --perf-basic-prof db2-bench-prepare-executeNonQuery.js
100000 queries issued in 45.545 seconds, 2195/sec : Prepare - ExecuteNonQuery
connection closed
[ perf record: Woken up 44 times to write data ]
[ perf record: Captured and wrote 11.859 MB perf.data (306174 samples) ]
andrew@sherlock:~/dma/odbc_ibm$ perf report --stdio
# To display the perf.data header info, please use --header/--header-only options.
#
#
# Total Lost Samples: 0
#
# Samples: 306K of event 'cycles:pp'
# Event count (approx.): 202416094671189
#
# Overhead Command Shared Object Symbol
# ........ ............... .................... ................................................................................................................................................................
#
93.43% node [kernel.kallsyms] [k] _raw_spin_lock_irqsave
6.52% node [kernel.kallsyms] [k] get_futex_key_refs.isra.11
0.01% node nodejs [.] 0x000000000088df3b
0.01% node nodejs [.] v8::internal::Heap::MoveElements
0.00% node nodejs [.] 0x000000000088df2c
0.00% node nodejs [.] 0x000000000088df34
0.00% node nodejs [.] 0x000000000088df20
0.00% node nodejs [.] 0x000000000088df3f
0.00% node libc-2.23.so [.] 0x000000000015f252
0.00% node nodejs [.] 0x000000000088dfd8
0.00% node libc-2.23.so [.] 0x000000000015f23f
0.00% node [kernel.kallsyms] [k] perf_pmu_sched_task
0.00% node nodejs [.] 0x000000000088dfd6
0.00% node libc-2.23.so [.] 0x000000000015f223
0.00% node [kernel.kallsyms] [k] native_write_msr_safe
0.00% node [kernel.kallsyms] [k] enqueue_entity
0.00% node nodejs [.] 0x000000000088df5a
0.00% node nodejs [.] 0x000000000088df6b
0.00% node nodejs [.] 0x000000000088df64
0.00% node nodejs [.] 0x000000000088dfb0
0.00% node nodejs [.] 0x000000000088df89
0.00% node [kernel.kallsyms] [k] _raw_spin_lock
0.00% node nodejs [.] 0x000000000088df98
0.00% node [kernel.kallsyms] [k] dequeue_entity
0.00% node nodejs [.] 0x000000000088df2a
0.00% node nodejs [.] 0x000000000088dfbc
0.00% node nodejs [.] 0x000000000088df44
0.00% node nodejs [.] 0x000000000088df78
0.00% node nodejs [.] 0x000000000088dfa4
0.00% node libc-2.23.so [.] 0x000000000015f279
0.00% node libpthread-2.23.so [.] pthread_mutex_lock
0.00% node nodejs [.] 0x000000000088dfdf
0.00% node libc-2.23.so [.] 0x000000000015f266
0.00% node [kernel.kallsyms] [k] update_cfs_shares
0.00% node [kernel.kallsyms] [k] SYSC_semtimedop
0.00% node libc-2.23.so [.] 0x000000000015f28d
0.00% node libdb2.so.1 [.] clientCommCallback
0.00% node nodejs [.] 0x000000000088dfcb
0.00% node [kernel.kallsyms] [k] update_curr
0.00% node libpthread-2.23.so [.] pthread_getspecific
0.00% node nodejs [.] 0x000000000088dfc2
0.00% node libdb2.so.1 [.] CLI_callbDrdaInput
0.00% node [kernel.kallsyms] [k] __schedule
0.00% node libdb2.so.1 [.] CLI_sqlCompleteCallback
0.00% node [kernel.kallsyms] [k] resched_curr
0.00% node libdb2.so.1 [.] sqljcReadHdrAr
0.00% node nodejs [.] 0x000000000088dfdc
0.00% node libdb2.so.1 [.] sqljrParseOpnQryRm
0.00% node nodejs [.] v8::internal::Execution::Call
0.00% node libdb2.so.1 [.] sqloxltc_app
0.00% node libdb2.so.1 [.] sqlccipcrecv
andrew@sherlock:~/dma/odbc_ibm$ perf record node --perf-basic-prof db2-bench-prepare-executeNonQuery.js
100000 queries issued in 45.408 seconds, 2202/sec : Prepare - ExecuteNonQuery
connection closed
[ perf record: Woken up 41 times to write data ]
[ perf record: Captured and wrote 10.875 MB perf.data (280733 samples) ]
andrew@sherlock:~/dma/odbc_ibm$ perf report --stdio
# To display the perf.data header info, please use --header/--header-only options.
#
#
# Total Lost Samples: 0
#
# Samples: 280K of event 'cycles:pp'
# Event count (approx.): 128737808290136
#
# Overhead Command Shared Object Symbol
# ........ ............... .................... ................................................................................................................................................................
#
44.41% node libdb2.so.1 [.] sqloinca
21.35% node nodejs [.] 0x0000000000f6fb44
16.23% node libdb2.so.1 [.] sqleUCcheckProcessInit
15.37% node libdb2.so.1 [.] sqljcReadHdrAr
2.56% node libdb2.so.1 [.] sqloxltc_app
0.02% node nodejs [.] 0x000000000088df3b
0.01% node nodejs [.] v8::internal::Heap::MoveElements
0.00% node nodejs [.] 0x000000000088df2c
0.00% node nodejs [.] 0x000000000088df34
0.00% node nodejs [.] 0x000000000088df20
0.00% node nodejs [.] 0x000000000088df3f
0.00% node libc-2.23.so [.] 0x000000000015f252
0.00% node nodejs [.] 0x000000000088dfd8
0.00% node libc-2.23.so [.] 0x000000000015f23f
0.00% node [kernel.kallsyms] [k] perf_pmu_sched_task
0.00% node [kernel.kallsyms] [k] native_write_msr_safe
0.00% node nodejs [.] 0x000000000088dfd6
0.00% node nodejs [.] 0x000000000088df2a
0.00% node libc-2.23.so [.] 0x000000000015f223
0.00% node [kernel.kallsyms] [k] enqueue_entity
0.00% node nodejs [.] 0x000000000088df44
0.00% node nodejs [.] 0x000000000088df98
0.00% node nodejs [.] 0x000000000088df5a
0.00% node nodejs [.] 0x000000000088df6b
0.00% node nodejs [.] 0x000000000088df89
0.00% node libpthread-2.23.so [.] pthread_mutex_lock
0.00% node nodejs [.] 0x000000000088df64
0.00% node nodejs [.] 0x000000000088dfb0
0.00% node nodejs [.] 0x000000000088df78
0.00% node nodejs [.] 0x000000000088dfa4
0.00% node nodejs [.] 0x000000000088dfbc
0.00% node nodejs [.] 0x000000000088dfdf
0.00% node libc-2.23.so [.] 0x000000000015f279
0.00% node [kernel.kallsyms] [k] _raw_spin_lock
0.00% node [kernel.kallsyms] [k] dequeue_entity
0.00% node libc-2.23.so [.] 0x000000000015f266
0.00% node libc-2.23.so [.] 0x000000000015f28d
0.00% node [kernel.kallsyms] [k] update_cfs_shares
0.00% node [kernel.kallsyms] [k] SYSC_semtimedop
0.00% node [kernel.kallsyms] [k] _raw_spin_lock_irqsave
0.00% node libdb2.so.1 [.] clientCommCallback
0.00% node nodejs [.] 0x000000000088dfcb
0.00% node [kernel.kallsyms] [k] update_curr
0.00% node libpthread-2.23.so [.] pthread_getspecific
0.00% node nodejs [.] 0x000000000088dfc2
0.00% node [kernel.kallsyms] [k] __schedule
0.00% node libdb2.so.1 [.] SQLFreeStmt2
0.00% node [kernel.kallsyms] [k] resched_curr
0.00% node libpthread-2.23.so [.] pthread_mutex_unlock
0.00% node nodejs [.] v8::internal::Execution::Call
0.00% node libdb2.so.1 [.] CLI_callbDrdaInput
andrew@sherlock:~/dma/odbc_ibm$ perf record node --perf-basic-prof db2-bench-prepare-executeNonQuery.js
100000 queries issued in 45.032 seconds, 2220/sec : Prepare - ExecuteNonQuery
connection closed
[ perf record: Woken up 33 times to write data ]
[ perf record: Captured and wrote 8.526 MB perf.data (221172 samples) ]
andrew@sherlock:~/dma/odbc_ibm$ perf report --stdio
# To display the perf.data header info, please use --header/--header-only options.
#
#
# Total Lost Samples: 0
#
# Samples: 221K of event 'cycles:pp'
# Event count (approx.): 1826632261381051
#
# Overhead Command Shared Object Symbol
# ........ ............... ................... .................................................................................................................................................................
#
34.44% node [kernel.kallsyms] [k] perf_pmu_sched_task
33.71% node [kernel.kallsyms] [k] futex_wait_queue_me
13.24% node libpthread-2.23.so [.] pthread_mutex_unlock
10.84% node [kernel.kallsyms] [k] native_irq_return_iret
2.53% node libdb2.so.1 [.] csmOpenReply
2.53% node libdb2.so.1 [.] csmGetNewCDB
1.14% node [kernel.kallsyms] [k] update_cfs_shares
0.78% node libdb2.so.1 [.] sqleUCApplicationEntry
0.54% V8 WorkerThread libc-2.23.so [.] 0x000000000007dc44
0.18% node libdb2.so.1 [.] SQLExecute
0.06% node nodejs [.] 0x0000000000f6fb18
0.00% node nodejs [.] 0x000000000088df3b
0.00% node nodejs [.] v8::internal::Heap::MoveElements
0.00% node nodejs [.] 0x000000000088df2c
0.00% node nodejs [.] 0x000000000088df34
0.00% node nodejs [.] 0x000000000088df20
0.00% node nodejs [.] 0x000000000088df3f
0.00% node libc-2.23.so [.] 0x000000000015f252
0.00% node nodejs [.] 0x000000000088dfd8
0.00% node libc-2.23.so [.] 0x000000000015f23f
0.00% node nodejs [.] 0x000000000088dfd6
0.00% node libc-2.23.so [.] 0x000000000015f223
0.00% node nodejs [.] 0x000000000088df2a
0.00% node nodejs [.] 0x000000000088df98
0.00% node nodejs [.] 0x000000000088df44
0.00% node nodejs [.] 0x000000000088df78
0.00% node nodejs [.] 0x000000000088df6b
0.00% node nodejs [.] 0x000000000088df5a
0.00% node nodejs [.] 0x000000000088dfa4
0.00% node [kernel.kallsyms] [k] native_write_msr_safe
0.00% node libc-2.23.so [.] 0x000000000015f28d
0.00% node nodejs [.] 0x000000000088dfbc
0.00% node nodejs [.] 0x000000000088dfb0
0.00% node libc-2.23.so [.] 0x000000000015f279
0.00% node nodejs [.] 0x000000000088df64
0.00% node nodejs [.] 0x000000000088dfdf
0.00% node nodejs [.] 0x000000000088df89
0.00% node [kernel.kallsyms] [k] enqueue_entity
0.00% node libc-2.23.so [.] 0x000000000015f266
0.00% node libpthread-2.23.so [.] pthread_mutex_lock
0.00% node [kernel.kallsyms] [k] dequeue_entity
0.00% node [kernel.kallsyms] [k] _raw_spin_lock
0.00% node nodejs [.] 0x000000000088dfcb
0.00% node nodejs [.] 0x000000000088dfc2
0.00% node libpthread-2.23.so [.] pthread_getspecific
0.00% node [kernel.kallsyms] [k] _raw_spin_lock_irqsave
0.00% node [kernel.kallsyms] [k] SYSC_semtimedop
0.00% node libdb2.so.1 [.] clientCommCallback
0.00% node libdb2.so.1 [.] SQLFreeStmt2
0.00% node nodejs [.] v8::internal::Execution::Call
0.00% node nodejs [.] 0x000000000088dfdc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment