Skip to content

Instantly share code, notes, and snippets.

View mdcallag's full-sized avatar
🎯
Focusing

Mark Callaghan mdcallag

🎯
Focusing
View GitHub Profile
@mdcallag
mdcallag / o.summ.my
Created December 1, 2021 01:04
r.10mrows.300s.1u.prep1 - o.summ.my
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000284 0 0.072 1.226 81967 x.my5649.y8.pk1
0.000284 0 0.069 0.872 82644 x.my5735.y8.pk1
0.000449 0 0 0.863 64935 x.my8020.y8.pk1
0.000370 0 0 0.865 61728 x.my8022.y8.pk1
0.000366 0 0 0.869 63291 x.my8023.y8.pk1
0.000359 0 0 0.86 65789 x.my8026.y8.pk1
0.000396 0 0.017 0.871 67567 x.my8027.y8.pk1
@mdcallag
mdcallag / gist:f9e974afda0d98ce6afd1ee813fb04e6
Created December 1, 2021 01:03
r.10mrows.300s.1u.prep0 - o.summ.my
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000283 0 0.072 1.224 82644 x.my5649.y8.pk1
0.000273 0 0.07 0.854 88495 x.my5735.y8.pk1
0.000438 0 0 0.858 67114 x.my8020.y8.pk1
0.000363 0 0 0.862 63694 x.my8022.y8.pk1
0.000369 0 0 0.862 62893 x.my8023.y8.pk1
0.000352 0 0 0.862 67114 x.my8026.y8.pk1
0.000399 0 0.017 0.888 67114 x.my8027.y8.pk1
@mdcallag
mdcallag / gist:a46d2df7924eed14438ae9a26cc5e279
Created December 1, 2021 00:55
r.400mrows.300s.1u.prep0 - o.sumr.r1.pg
db_1 = x.pg124.x5.pk1
db_2 = x.pg134.x5.pk1
db_3 = x.pg140.x5.pk1
db_1 db_2 db_3
1.00 1.12 1.13 point-query.warm.range100.pk1
1.00 0.89 0.88 point-query.pre.range100.pk1
1.00 1.02 1.01 random-points.pre.range10.pk1
1.00 1.02 1.02 random-points.pre.range100.pk1
1.00 1.20 1.20 random-points.pre.range1000.pk1
@mdcallag
mdcallag / gist:ad81f3869eef8e4ac0e3628a59b08553
Created December 1, 2021 00:55
r.10mrows.300s.1u.prep1 - o.sumr.r1.pg
db_1 = x.pg124.x5.pk1
db_2 = x.pg134.x5.pk1
db_3 = x.pg140.x5.pk1
db_1 db_2 db_3
1.00 1.06 1.05 point-query.warm.range100.pk1
1.00 1.00 1.00 point-query.pre.range100.pk1
1.00 0.98 0.99 random-points.pre.range10.pk1
1.00 0.95 0.97 random-points.pre.range100.pk1
1.00 0.95 0.97 random-points.pre.range1000.pk1
@mdcallag
mdcallag / gist:96c4db58348478d502ed2b6a4105f678
Created December 1, 2021 00:54
r.10mrows.300s.1u.prep0 - o.sumr.r1.pg
db_1 = x.pg124.x5.pk1
db_2 = x.pg134.x5.pk1
db_3 = x.pg140.x5.pk1
db_1 db_2 db_3
1.00 1.06 1.05 point-query.warm.range100.pk1
1.00 1.00 0.95 point-query.pre.range100.pk1
1.00 0.98 0.98 random-points.pre.range10.pk1
1.00 0.99 0.99 random-points.pre.range100.pk1
1.00 0.99 1.00 random-points.pre.range1000.pk1
@mdcallag
mdcallag / gist:981f65259e5661692efa0dd07bab120b
Created December 1, 2021 00:52
r.400mrows.300s.1u.prep0 - o.sumr.r1.my
db_1 = x.my5649.y8.pk1
db_2 = x.my5735.y8.pk1
db_3 = x.my8020.y8.pk1
db_4 = x.my8022.y8.pk1
db_5 = x.my8023.y8.pk1
db_6 = x.my8026.y8.pk1
db_7 = x.my8027.y8.pk1
db_1 db_2 db_3 db_4 db_5 db_6 db_7
1.00 1.04 0.86 0.81 0.80 0.85 0.88 point-query.warm.range100.pk1
@mdcallag
mdcallag / gist:0b1b6d45bcb19dd89a9a8122352f1166
Created December 1, 2021 00:52
r.10mrows.300s.1u.prep1 - o.sumr.r1.my
db_1 = x.my5649.y8.pk1
db_2 = x.my5735.y8.pk1
db_3 = x.my8020.y8.pk1
db_4 = x.my8022.y8.pk1
db_5 = x.my8023.y8.pk1
db_6 = x.my8026.y8.pk1
db_7 = x.my8027.y8.pk1
db_1 db_2 db_3 db_4 db_5 db_6 db_7
1.00 1.01 0.79 0.75 0.77 0.80 0.82 point-query.warm.range100.pk1
@mdcallag
mdcallag / gist:b09e642d7ca71fc3655a7404603fd9db
Created December 1, 2021 00:52
r.10mrows.300s.1u.prep0 - o.sumr.r1.my
db_1 = x.my5649.y8.pk1
db_2 = x.my5735.y8.pk1
db_3 = x.my8020.y8.pk1
db_4 = x.my8022.y8.pk1
db_5 = x.my8023.y8.pk1
db_6 = x.my8026.y8.pk1
db_7 = x.my8027.y8.pk1
db_1 db_2 db_3 db_4 db_5 db_6 db_7
1.00 1.07 0.81 0.77 0.76 0.81 0.81 point-query.warm.range100.pk1
ops_sec mb_sec size_gb c_wgb w_amp c_mbps c_secs usec_op p50 p99 p99.9 p99.99 pmax uptime stall% Nstall u_cpu s_cpu test date version job_id
557865 223.4 0.0 41.87 1.0 126.10 538.7 1.8 1.2 5 19 99 9310 340 0.3 6 0.7 0.1 fillseq.wal_disabled.v400 2021-11-22T12:07:30 6.0
523826 209.8 0.0 43.68 1.0 117.67 608.2 1.9 1.3 6 19 122 88700 380 2.6 113 0.8 0.1 fillseq.wal_disabled.v400 2021-11-22T15:19:46 6.1
543829 217.8 0.0 42.97 1.0 122.20 527.2 1.8 1.3 5 18 89 8570 360 0.0 0 0.7 0.1 fillseq.wal_disabled.v400 2021-11-22T18:36:15 6.2
489522 196.1 0.0 42.80 1.0 109.56 628.8 2.0 1.4 7 19 127 156652 400 2.1 130 0.8 0.1 fillseq.wal_disabled.v400 2021-11-22T21:54:11 6.3
539178 216.0 0.0 42.54 1
./db/version_edit.h:86:8: error: implicitly-declared ‘constexpr rocksdb::FileDescriptor::FileDescriptor(const rocksdb::FileDescriptor&)’ is deprecated [-Werror=deprecated-copy]
86 | struct FileMetaData {
| ^~~~~~~~~~~~
./db/version_edit.h:55:19: note: because ‘rocksdb::FileDescriptor’ has user-provided ‘rocksdb::FileDescriptor& rocksdb::FileDescriptor::operator=(const rocksdb::FileDescriptor&)’
55 | FileDescriptor& operator=(const FileDescriptor& fd) {
| ^~~~~~~~