Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:db983ea4c48647a23a2e

Created January 14, 2016 18:34
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 mdcallag/db983ea4c48647a23a2e to your computer and use it in GitHub Desktop.
Save mdcallag/db983ea4c48647a23a2e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Order is:
1) rocksdb.zlib
2) orig5626.zlib
3) orig5710.zlib
4) orig5626.none
5) orig5710.none
tl;dr
* avg & p99 response much time better for RocksDB
* max response usually time better for InnoDB
ADD_NODE
ADD_NODE count = 2793096 p50 = [0.2,0.3]ms p75 = [0.3,0.4]ms p95 = [0.4,0.5]ms p99 = [0.5,0.6]ms max = 14.66ms mean = 0.302ms
ADD_NODE count = 1401815 p50 = [0.2,0.3]ms p75 = [0.3,0.4]ms p95 = [1,2]ms p99 = [2,3]ms max = 265.771ms mean = 0.432ms
ADD_NODE count = 1744719 p50 = [0.2,0.3]ms p75 = [0.2,0.3]ms p95 = [0.3,0.4]ms p99 = [0.7,0.8]ms max = 23.517ms mean = 0.298ms
ADD_NODE count = 1944514 p50 = [0.3,0.4]ms p75 = [0.5,0.6]ms p95 = [1,2]ms p99 = [3,4]ms max = 224.035ms mean = 0.539ms
ADD_NODE count = 1833273 p50 = [0.2,0.3]ms p75 = [0.3,0.4]ms p95 = [0.3,0.4]ms p99 = [0.8,0.9]ms max = 24.224ms mean = 0.313ms
UPDATE_NODE
UPDATE_NODE count = 8008251 p50 = [0.5,0.6]ms p75 = [0.6,0.7]ms p95 = [0.8,0.9]ms p99 = [1,2]ms max = 157.954ms mean = 0.592ms
UPDATE_NODE count = 4015342 p50 = [0.5,0.6]ms p75 = [0.7,0.8]ms p95 = [2,3]ms p99 = [4,5]ms max = 266.076ms mean = 0.818ms
UPDATE_NODE count = 4996497 p50 = [0.5,0.6]ms p75 = [0.7,0.8]ms p95 = [2,3]ms p99 = [4,5]ms max = 238.379ms mean = 0.779ms
UPDATE_NODE count = 5565358 p50 = [0.6,0.7]ms p75 = [1,2]ms p95 = [2,3]ms p99 = [4,5]ms max = 224.135ms mean = 0.986ms
UPDATE_NODE count = 5247623 p50 = [0.5,0.6]ms p75 = [0.9,1]ms p95 = [3,4]ms p99 = [6,7]ms max = 281.515ms mean = 1.07ms
DELETE_NODE
DELETE_NODE count = 1100913 p50 = [0.4,0.5]ms p75 = [0.5,0.6]ms p95 = [0.7,0.8]ms p99 = [1,2]ms max = 158.225ms mean = 0.57ms
DELETE_NODE count = 552210 p50 = [0.4,0.5]ms p75 = [0.6,0.7]ms p95 = [2,3]ms p99 = [4,5]ms max = 23.135ms mean = 0.688ms
DELETE_NODE count = 685872 p50 = [0.4,0.5]ms p75 = [0.6,0.7]ms p95 = [2,3]ms p99 = [3,4]ms max = 86.254ms mean = 0.702ms
DELETE_NODE count = 766010 p50 = [0.5,0.6]ms p75 = [0.8,0.9]ms p95 = [2,3]ms p99 = [4,5]ms max = 72.886ms mean = 0.818ms
DELETE_NODE count = 720653 p50 = [0.5,0.6]ms p75 = [0.8,0.9]ms p95 = [3,4]ms p99 = [6,7]ms max = 41.207ms mean = 0.968ms
GET_NODE
GET_NODE count = 14061517 p50 = [0.4,0.5]ms p75 = [0.4,0.5]ms p95 = [0.6,0.7]ms p99 = [1,2]ms max = 358.147ms mean = 0.465ms
GET_NODE count = 7050095 p50 = [0.3,0.4]ms p75 = [0.4,0.5]ms p95 = [1,2]ms p99 = [2,3]ms max = 266.115ms mean = 0.515ms
GET_NODE count = 8768759 p50 = [0.3,0.4]ms p75 = [0.5,0.6]ms p95 = [2,3]ms p99 = [3,4]ms max = 237.784ms mean = 0.607ms
GET_NODE count = 9776527 p50 = [0.4,0.5]ms p75 = [0.5,0.6]ms p95 = [1,2]ms p99 = [3,4]ms max = 223.999ms mean = 0.588ms
GET_NODE count = 9214367 p50 = [0.4,0.5]ms p75 = [0.7,0.8]ms p95 = [2,3]ms p99 = [5,6]ms max = 280.937ms mean = 0.86ms
ADD_LINK
ADD_LINK count = 9768430 p50 = [0.7,0.8]ms p75 = [0.9,1]ms p95 = [1,2]ms p99 = [1,2]ms max = 358.341ms mean = 0.844ms
ADD_LINK count = 4906059 p50 = [2,3]ms p75 = [4,5]ms p95 = [8,9]ms p99 = [15,16]ms max = 268.053ms mean = 3.366ms
ADD_LINK count = 6093040 p50 = [1,2]ms p75 = [2,3]ms p95 = [5,6]ms p99 = [10,11]ms max = 238.571ms mean = 2.305ms
ADD_LINK count = 6792650 p50 = [1,2]ms p75 = [2,3]ms p95 = [5,6]ms p99 = [8,9]ms max = 230.234ms mean = 2.112ms
ADD_LINK count = 6407731 p50 = [0.9,1]ms p75 = [1,2]ms p95 = [5,6]ms p99 = [10,11]ms max = 142.143ms mean = 1.676ms
DELETE_LINK
DELETE_LINK count = 3248792 p50 = [0.8,0.9]ms p75 = [1,2]ms p95 = [1,2]ms p99 = [1,2]ms max = 158.974ms mean = 0.862ms
DELETE_LINK count = 1631322 p50 = [2,3]ms p75 = [3,4]ms p95 = [7,8]ms p99 = [13,14]ms max = 145.885ms mean = 2.784ms
DELETE_LINK count = 2026718 p50 = [1,2]ms p75 = [2,3]ms p95 = [5,6]ms p99 = [9,10]ms max = 238.605ms mean = 1.985ms
DELETE_LINK count = 2261505 p50 = [1,2]ms p75 = [2,3]ms p95 = [5,6]ms p99 = [8,9]ms max = 223.882ms mean = 1.814ms
DELETE_LINK count = 2134320 p50 = [0.9,1]ms p75 = [1,2]ms p95 = [5,6]ms p99 = [10,11]ms max = 103.039ms mean = 1.529ms
UPDATE_LINK
UPDATE_LINK count = 8702493 p50 = [0.7,0.8]ms p75 = [0.8,0.9]ms p95 = [1,2]ms p99 = [1,2]ms max = 364.141ms mean = 0.828ms
UPDATE_LINK count = 4369694 p50 = [2,3]ms p75 = [4,5]ms p95 = [10,11]ms p99 = [16,17]ms max = 268.56ms mean = 3.901ms
UPDATE_LINK count = 5435506 p50 = [1,2]ms p75 = [3,4]ms p95 = [6,7]ms p99 = [11,12]ms max = 238.065ms mean = 2.59ms
UPDATE_LINK count = 6059520 p50 = [1,2]ms p75 = [2,3]ms p95 = [5,6]ms p99 = [9,10]ms max = 230.279ms mean = 2.298ms
UPDATE_LINK count = 5708822 p50 = [0.9,1]ms p75 = [1,2]ms p95 = [5,6]ms p99 = [10,11]ms max = 282.417ms mean = 1.715ms
COUNT_LINK
COUNT_LINK count = 5312366 p50 = [0.2,0.3]ms p75 = [0.3,0.4]ms p95 = [0.4,0.5]ms p99 = [0.7,0.8]ms max = 161.277ms mean = 0.303ms
COUNT_LINK count = 2661348 p50 = [0.3,0.4]ms p75 = [0.4,0.5]ms p95 = [1,2]ms p99 = [2,3]ms max = 265.828ms mean = 0.456ms
COUNT_LINK count = 3312202 p50 = [0.3,0.4]ms p75 = [0.5,0.6]ms p95 = [1,2]ms p99 = [3,4]ms max = 237.623ms mean = 0.563ms
COUNT_LINK count = 3690466 p50 = [0.3,0.4]ms p75 = [0.4,0.5]ms p95 = [0.8,0.9]ms p99 = [2,3]ms max = 143.073ms mean = 0.423ms
COUNT_LINK count = 3480813 p50 = [0.3,0.4]ms p75 = [0.5,0.6]ms p95 = [2,3]ms p99 = [5,6]ms max = 109.596ms mean = 0.707ms
MULTIGET_LINK
MULTIGET_LINK count = 573385 p50 = [0.6,0.7]ms p75 = [0.7,0.8]ms p95 = [0.9,1]ms p99 = [2,3]ms max = 131.345ms mean = 0.713ms
MULTIGET_LINK count = 287045 p50 = [0.4,0.5]ms p75 = [0.7,0.8]ms p95 = [2,3]ms p99 = [5,6]ms max = 49.001ms mean = 0.835ms
MULTIGET_LINK count = 357192 p50 = [0.5,0.6]ms p75 = [0.7,0.8]ms p95 = [2,3]ms p99 = [4,5]ms max = 46.197ms mean = 0.81ms
MULTIGET_LINK count = 397467 p50 = [0.4,0.5]ms p75 = [0.5,0.6]ms p95 = [1,2]ms p99 = [3,4]ms max = 224.467ms mean = 0.579ms
MULTIGET_LINK count = 374948 p50 = [0.4,0.5]ms p75 = [0.6,0.7]ms p95 = [2,3]ms p99 = [5,6]ms max = 137.969ms mean = 0.779ms
GET_LINKS_LIST
GET_LINKS_LIST count = 55111118 p50 = [0.5,0.6]ms p75 = [0.6,0.7]ms p95 = [0.8,0.9]ms p99 = [1,2]ms max = 411.007ms mean = 0.619ms
GET_LINKS_LIST count = 27656615 p50 = [0.4,0.5]ms p75 = [0.6,0.7]ms p95 = [2,3]ms p99 = [5,6]ms max = 266.386ms mean = 0.785ms
GET_LINKS_LIST count = 34385930 p50 = [0.4,0.5]ms p75 = [0.6,0.7]ms p95 = [1,2]ms p99 = [3,4]ms max = 262.591ms mean = 0.708ms
GET_LINKS_LIST count = 38326452 p50 = [0.4,0.5]ms p75 = [0.5,0.6]ms p95 = [1,2]ms p99 = [3,4]ms max = 224.182ms mean = 0.57ms
GET_LINKS_LIST count = 36133643 p50 = [0.4,0.5]ms p75 = [0.5,0.6]ms p95 = [2,3]ms p99 = [5,6]ms max = 493.038ms mean = 0.758ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment