Advertisement
Guest User

Untitled

a guest
Jan 17th, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.84 KB | None | 0 0
  1. This is linkbench with maxid1=1B. The test server has 48 cores with HT enabled, fast NVMe flash and 50gb of RAM available to MyRocks. The RocksDB block cache was set to 512mb or 10gb and the database is much larger than RAM. The binlog and 2pc were enabled, fsync on commit was disabled for the RocksDB WAL and binlog. The tests use 16 linkbench clients running on the same host as mysqld.
  2.  
  3. legend:
  4. ips, tps inserts or transactions per second average
  5. r/i, r/t: iostat reads per insert or query
  6. rkb/i, rkb/t: iostat KB read per insert or transaction
  7. wkb/i, wkb/t: iostat KB written per insert or transaction, not adjusted for TRIM so it can double count
  8. Mcpu/i, Mcpu/t: vmstat CPU utilization divided by ips or tps and then multiplied by 1M
  9. size: database size in GB
  10. wMB/s, rMB/s: iostat MB written/second and read/second
  11. cpu: vmstat CPU utilization
  12. r/s: iostat reads/second
  13. engine: describes my.cnf options and MyRocks build date
  14. rss: mysqld process RSS in GB
  15. un, gn, ul, gl - p99 response time for most frequent transactions. un is update node, gn is get node, ul is update link, gl is get link
  16.  
  17. - load
  18.  
  19. ips r/i rkb/i wkb/i Mcpu/i size rss wMB/s cpu engine
  20. 55646 0 0 1.25 91 531 0.8 69.5 5.1 rx.nov21.def0.512m.2pc
  21. 56168 0 0 1.29 86 531 10.3 72.5 4.8 rx.nov21.def0.10g.2pc
  22. 56163 0 0 1.27 87 531 10.3 71.4 4.9 rx.nov21.def2.10g.2pc
  23. 55092 0 0 1.26 98 529 10.3 69.3 5.4 rx.nov21.def3.10g.2pc
  24. 55344 0 0 1.25 90 484 3.0 69.0 5.0 rx.nov21.def4.10g.2pc
  25. 55988 0 0 1.17 97 486 3.0 65.7 5.5 rx.nov21.def6.10g.2pc
  26. 56654 0 0 0.92 82 483 3.2 52.3 4.7 rx.nov21.def7.10g.2pc
  27. 60714 0 0 0.95 84 495 8.6 57.6 5.1 rx.nov21.def8.10g.2pc
  28. 58732 0 0 0.96 89 488 4.1 56.2 5.2 rx.nov21.def9.10g.2pc
  29. 60804 0 0 1.24 83 786 3.6 75.6 5.0 rx.nov21.def10.none.10g.2pc
  30. 61362 0 0 1.25 82 796 10.9 76.5 5.6 rx.nov21.def10.none.4k.10g.2pc
  31. 61159 0 0 1.25 79 786 6.2 76.2 4.8 rx.nov21.def10.none.8k.10g.2pc
  32. 61157 0 0 1.50 81 478 3.4 91.9 4.9 rx.nov21.def10.lz4.10g.2pc
  33. 61274 0 0 1.63 94 429 3.4 99.7 5.8 rx.nov21.def10.zlib-1.10g.2pc
  34. 61323 0 0 1.57 83 419 3.4 96.5 5.1 rx.nov21.def10.zstd.10g.2pc
  35.  
  36. - query @ 24h, mysql
  37.  
  38. tps r/t rkb/t wkb/t Mcpu/t size rss un gn ul gl r/s rMB/s wMB/s cpu engine
  39. 3764 0.95 6.35 6.52 8992 450 4.8 4 2 10 9 3562 238.9 24.6 33.8 rx.nov21.def0.512m.2pc
  40. 23557 1.28 8.60 5.89 947 489 14.4 3 2 3 3 30212 202.6 138.8 22.3 rx.nov21.def0.10g.2pc
  41. 23808 1.27 8.59 5.89 940 491 14.1 3 2 3 3 30248 202.0 140.2 22.4 rx.nov21.def2.10g.2pc
  42. 23540 1.30 8.58 5.50 973 490 14.2 3 2 3 3 30511 202.1 130.0 22.9 rx.nov21.def3.10g.2pc
  43. 22930 1.23 14.78 4.78 923 442 11.6 3 2 3 2 28291 339.0 109.7 21.2 rx.nov21.def4.10g.2pc
  44. 23023 1.24 14.89 5.01 950 442 11.6 3 2 3 2 28577 342.7 115.3 21.9 rx.nov21.def6.10g.2pc
  45. 22615 1.27 15.39 4.87 928 446 11.8 3 2 3 2 28720 348.0 110.2 21.0 rx.nov21.def7.10g.2pc
  46. 24455 0.95 12.40 5.58 948 466 13.9 3 2 3 3 23224 303.3 136.5 23.2 rx.nov21.def8.10g.2pc
  47. 24732 1.10 12.89 5.10 871 437 11.9 3 2 3 3 27080 318.7 126.2 21.6 rx.nov21.def9.10g.2pc
  48. 24575 1.06 20.64 7.12 830 738 12.0 3 2 3 2 26026 507.2 175.1 20.4 rx.nov21.def10.none.10g.2pc
  49. 25765 1.24 10.60 7.29 830 750 13.3 3 2 3 2 31901 273.1 187.8 21.4 rx.nov21.def10.none.4k.10g.2pc
  50. 25412 1.14 13.49 7.27 807 743 12.1 3 2 3 2 29008 342.9 185.7 20.5 rx.nov21.def10.none.8k.10g.2pc
  51. 26449 0.97 12.11 6.52 828 421 11.9 3 2 3 2 25697 320.3 172.3 21.9 rx.nov21.def10.lz4.10g.2pc
  52. 24121 0.93 10.36 5.93 1046 366 11.9 3 2 3 2 22525 250.0 143.0 25.2 rx.nov21.def10.zlib-1.10g.2pc
  53. 25450 0.92 10.16 5.98 934 360 11.9 3 2 3 2 23491 258.7 152.3 23.8 rx.nov21.def10.zstd.10g.2pc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement