Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
# For InnoDB
> perf stat -a sleep 10
480786.505638 task-clock (msec) # 48.074 CPUs utilized [100.00%]
406,045 context-switches # 0.845 K/sec [100.00%]
258,676 cpu-migrations # 0.538 K/sec [100.00%]
10,685,383 page-faults # 0.022 M/sec
1,066,925,976,990 cycles # 2.219 GHz [83.34%]
0 stalled-cycles-frontend # 0.00% frontend cycles idle
0 stalled-cycles-backend # 0.00% backend cycles idle
1,187,695,891,275 instructions # 1.11 insns per cycle [83.34%]
178,653,927,527 branches # 371.587 M/sec [83.34%]
2,080,994,715 branch-misses # 1.16% of all branches [83.33%]
# For MyRocks
> perf stat -a sleep 10
480793.976758 task-clock (msec) # 48.075 CPUs utilized [100.00%]
1,083,130 context-switches # 0.002 M/sec [100.00%]
344,212 cpu-migrations # 0.716 K/sec [100.00%]
2,366,968 page-faults # 0.005 M/sec
1,045,590,594,448 cycles # 2.175 GHz [83.34%]
0 stalled-cycles-frontend # 0.00% frontend cycles idle
0 stalled-cycles-backend # 0.00% backend cycles idle
589,791,039,853 instructions # 0.56 insns per cycle [83.34%]
100,791,607,387 branches # 209.636 M/sec [83.34%]
1,006,840,542 branch-misses # 1.00% of all branches [83.33%]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment