Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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.
- legend:
- ips, tps inserts or transactions per second average
- r/i, r/t: iostat reads per insert or query
- rkb/i, rkb/t: iostat KB read per insert or transaction
- wkb/i, wkb/t: iostat KB written per insert or transaction, not adjusted for TRIM so it can double count
- Mcpu/i, Mcpu/t: vmstat CPU utilization divided by ips or tps and then multiplied by 1M
- size: database size in GB
- wMB/s, rMB/s: iostat MB written/second and read/second
- cpu: vmstat CPU utilization
- r/s: iostat reads/second
- engine: describes my.cnf options and MyRocks build date
- rss: mysqld process RSS in GB
- 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
- - load
- ips r/i rkb/i wkb/i Mcpu/i size rss wMB/s cpu engine
- 55646 0 0 1.25 91 531 0.8 69.5 5.1 rx.nov21.def0.512m.2pc
- 56168 0 0 1.29 86 531 10.3 72.5 4.8 rx.nov21.def0.10g.2pc
- 56163 0 0 1.27 87 531 10.3 71.4 4.9 rx.nov21.def2.10g.2pc
- 55092 0 0 1.26 98 529 10.3 69.3 5.4 rx.nov21.def3.10g.2pc
- 55344 0 0 1.25 90 484 3.0 69.0 5.0 rx.nov21.def4.10g.2pc
- 55988 0 0 1.17 97 486 3.0 65.7 5.5 rx.nov21.def6.10g.2pc
- 56654 0 0 0.92 82 483 3.2 52.3 4.7 rx.nov21.def7.10g.2pc
- 60714 0 0 0.95 84 495 8.6 57.6 5.1 rx.nov21.def8.10g.2pc
- 58732 0 0 0.96 89 488 4.1 56.2 5.2 rx.nov21.def9.10g.2pc
- 60804 0 0 1.24 83 786 3.6 75.6 5.0 rx.nov21.def10.none.10g.2pc
- 61362 0 0 1.25 82 796 10.9 76.5 5.6 rx.nov21.def10.none.4k.10g.2pc
- 61159 0 0 1.25 79 786 6.2 76.2 4.8 rx.nov21.def10.none.8k.10g.2pc
- 61157 0 0 1.50 81 478 3.4 91.9 4.9 rx.nov21.def10.lz4.10g.2pc
- 61274 0 0 1.63 94 429 3.4 99.7 5.8 rx.nov21.def10.zlib-1.10g.2pc
- 61323 0 0 1.57 83 419 3.4 96.5 5.1 rx.nov21.def10.zstd.10g.2pc
- - query @ 24h, mysql
- tps r/t rkb/t wkb/t Mcpu/t size rss un gn ul gl r/s rMB/s wMB/s cpu engine
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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