github.com/cockroachdb/pebble@v1.1.2/tool/logs/testdata/compactions-23-1 (about) 1 # Single compaction and flush pair for a single node / store combination. 2 # 3 # Use a combination of [n1,pebble,s1] and [n1,s1,pebble] to mimic the two 4 # formats we see in production. 5 6 7 log 8 I211215 00:00:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,pebble,s1] 1216510 [JOB 1] compacting(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) 9 I211215 00:00:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,s1,pebble] 1216554 [JOB 1] compacted(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) -> L3 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 10 11 I211215 00:01:10.000000 21136 3@vendor/github.com/cockroachdb/pebble/event.go:599 ⋮ [n1,s1,pebble] 24 [JOB 2] flushing 2 memtables to L0 12 I211215 00:01:20.000000 21136 3@vendor/github.com/cockroachdb/pebble/event.go:603 ⋮ [n1,pebble,s1] 26 [JOB 2] flushed 2 memtables to L0 [1535806] (1.3 M), in 0.2s, output rate 5.8 M/s 13 ---- 14 0.log 15 16 summarize 17 ---- 18 node: 1, store: 1 19 from: 211215 00:00 20 to: 211215 00:01 21 r-amp: NaN 22 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 23 compact L2 L3 1 0 0 0 1 13MB 13MB 0B 0B 10s 24 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 25 node: 1, store: 1 26 from: 211215 00:01 27 to: 211215 00:02 28 r-amp: NaN 29 _kind______from______to_____________________________________count___bytes______time 30 flush L0 1 1.3MB 10s 31 total 1 1.3MB 10s 32 33 # Same as the previous case, except that the start and end events are are split 34 # across multiple files (one log line per file). 35 36 reset 37 ---- 38 39 log 40 I211215 00:00:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,bars,s1,foos] 1216510 [JOB 1] compacting(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) 41 ---- 42 0.log 43 44 log 45 I211215 00:00:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,s1,foos] 1216554 [JOB 1] compacted(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) -> L3 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 46 ---- 47 1.log 48 49 log 50 I211215 00:01:10.000000 21136 3@vendor/github.com/cockroachdb/pebble/event.go:599 ⋮ [n1,s1] 24 [JOB 2] flushing 2 memtables to L0 51 ---- 52 2.log 53 54 log 55 I211215 00:01:20.000000 21136 3@vendor/github.com/cockroachdb/pebble/event.go:603 ⋮ [n1,pebble,s1] 26 [JOB 2] flushed 2 memtables to L0 [1535806] (1.3 M), in 0.2s, output rate 5.8 M/s 56 ---- 57 3.log 58 59 summarize 60 ---- 61 node: 1, store: 1 62 from: 211215 00:00 63 to: 211215 00:01 64 r-amp: NaN 65 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 66 compact L2 L3 1 0 0 0 1 13MB 13MB 0B 0B 10s 67 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 68 node: 1, store: 1 69 from: 211215 00:01 70 to: 211215 00:02 71 r-amp: NaN 72 _kind______from______to_____________________________________count___bytes______time 73 flush L0 1 1.3MB 10s 74 total 1 1.3MB 10s 75 76 # Read amplification from the Cockroach log, one within an existing window, 77 # another outside of the existing window. The latter is not included. 78 79 reset 80 ---- 81 82 log 83 I211215 00:00:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,pebble,s1] 1216510 [JOB 1] compacting(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) 84 I211215 00:00:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,pebble,s1] 1216554 [JOB 1] compacted(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) -> L3 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 85 ---- 86 0.log 87 88 log 89 I211215 00:00:15.000000 434 kv/kvserver/store.go:3251 ⋮ [n1,s1] 31356 90 __level_____count____size___score______in__ingest(sz_cnt)____move(sz_cnt)___write(sz_cnt)____read___r-amp___w-amp 91 WAL 1 54 M - 65 G - - - - 70 G - - - 1.1 92 0 0 0 B 0.00 70 G 77 M 133 0 B 0 24 G 19 K 4.2 G 0 0.3 93 1 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 94 2 14 34 M 0.96 18 G 0 B 0 17 M 10 49 G 14 K 55 G 1 2.7 95 3 42 207 M 0.96 12 G 0 B 0 939 M 280 43 G 7.3 K 46 G 1 3.4 96 4 264 1.5 G 0.99 9.1 G 18 M 6 824 M 152 31 G 4.5 K 35 G 1 3.4 97 5 7474 23 G 1.00 2.8 G 116 G 26 K 1.8 G 301 3.2 G 604 3.2 G 1 1.2 98 6 23972 164 G - 98 G 70 G 22 K 1.6 K 1 129 G 3.8 K 135 G 1 1.3 99 total 31766 188 G - 257 G 187 G 48 K 3.6 G 744 536 G 49 K 278 G 5 2.1 100 I211215 00:01:15.000000 434 kv/kvserver/store.go:3251 ⋮ [n1,s1] 31356 101 __level_____count____size___score______in__ingest(sz_cnt)____move(sz_cnt)___write(sz_cnt)____read___r-amp___w-amp 102 WAL 1 35 M - 65 G - - - - 70 G - - - 1.1 103 0 0 0 B 0.00 70 G 77 M 133 0 B 0 24 G 19 K 4.2 G 0 0.3 104 1 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 105 2 14 34 M 0.95 18 G 0 B 0 17 M 10 49 G 14 K 55 G 1 2.7 106 3 42 207 M 0.96 12 G 0 B 0 939 M 280 43 G 7.3 K 46 G 1 3.4 107 4 264 1.5 G 0.99 9.1 G 18 M 6 824 M 152 31 G 4.5 K 35 G 1 3.4 108 5 7474 23 G 1.00 2.8 G 116 G 26 K 1.8 G 301 3.2 G 604 3.2 G 1 1.2 109 6 23972 164 G - 98 G 70 G 22 K 1.6 K 1 129 G 3.8 K 135 G 1 1.3 110 total 31766 188 G - 257 G 187 G 48 K 3.6 G 744 536 G 49 K 278 G 5 2.1 111 ---- 112 1.log 113 114 summarize 115 ---- 116 node: 1, store: 1 117 from: 211215 00:00 118 to: 211215 00:01 119 r-amp: 5.0 120 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 121 compact L2 L3 1 0 0 0 1 13MB 13MB 0B 0B 10s 122 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 123 124 # Long running compaction. 125 126 reset 127 ---- 128 129 log 130 I211215 00:01:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,s1,pebble] 1216510 [JOB 1] compacting(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) 131 I211215 00:03:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,pebble,s1] 1216554 [JOB 1] compacted(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) -> L3 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 132 ---- 133 0.log 134 135 summarize long-running=1m 136 ---- 137 node: 1, store: 1 138 from: 211215 00:01 139 to: 211215 00:02 140 r-amp: NaN 141 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 142 compact L2 L3 1 0 0 0 1 13MB 13MB 0B 0B 2m10s 143 total 1 0 0 0 1 13MB 13MB 0B 0B 2m10s 144 long-running events (descending runtime): 145 _kind________from________to_______job______type_____start_______end____dur(s)_____bytes: 146 compact L2 L3 1 default 00:01:10 00:03:20 130 13MB 147 148 # Single node, multiple stores. 149 150 reset 151 ---- 152 153 log 154 I211215 00:01:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,pebble,s1] 1216510 [JOB 1] compacting(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) 155 I211215 00:01:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,pebble,s1] 1216554 [JOB 1] compacted(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) -> L3 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 156 157 I211215 00:01:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,pebble,s2] 1216510 [JOB 2] compacting(default) L3 [442555] (4.2 M) + L4 [445853] (8.4 M) 158 I211215 00:01:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,pebble,s2] 1216554 [JOB 2] compacted(default) L3 [442555] (4.2 M) + L4 [445853] (8.4 M) -> L4 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 159 ---- 160 0.log 161 162 summarize 163 ---- 164 node: 1, store: 1 165 from: 211215 00:01 166 to: 211215 00:02 167 r-amp: NaN 168 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 169 compact L2 L3 1 0 0 0 1 13MB 13MB 0B 0B 10s 170 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 171 node: 1, store: 2 172 from: 211215 00:01 173 to: 211215 00:02 174 r-amp: NaN 175 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 176 compact L3 L4 1 0 0 0 1 13MB 13MB 0B 0B 10s 177 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 178 179 # Multiple nodes, single stores. Two separate pebble logs. 180 181 reset 182 ---- 183 184 log 185 I211215 00:01:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,pebble,s1] 1216510 [JOB 1] compacting(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) 186 I211215 00:01:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,pebble,s1] 1216554 [JOB 1] compacted(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) -> L3 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 187 ---- 188 0.log 189 190 log 191 I211215 00:01:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n2,pebble,s1] 1216510 [JOB 1] compacting(default) L3 [442555] (4.2 M) + L4 [445853] (8.4 M) 192 I211215 00:01:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n2,pebble,s1] 1216554 [JOB 1] compacted(default) L3 [442555] (4.2 M) + L4 [445853] (8.4 M) -> L4 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 193 ---- 194 1.log 195 196 summarize 197 ---- 198 node: 1, store: 1 199 from: 211215 00:01 200 to: 211215 00:02 201 r-amp: NaN 202 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 203 compact L2 L3 1 0 0 0 1 13MB 13MB 0B 0B 10s 204 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 205 node: 2, store: 1 206 from: 211215 00:01 207 to: 211215 00:02 208 r-amp: NaN 209 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 210 compact L3 L4 1 0 0 0 1 13MB 13MB 0B 0B 10s 211 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 212 213 # Multiple nodes, multiple stores. Two separate pebble logs. Output is sorted by 214 # (time, node, store). 215 216 reset 217 ---- 218 219 log 220 I211215 00:01:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,pebble,s1] 1216510 [JOB 1] compacting(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) 221 I211215 00:01:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,pebble,s1] 1216554 [JOB 1] compacted(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) -> L3 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 222 223 I211215 00:02:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,pebble,s2] 1216510 [JOB 2] compacting(default) L1 [442555] (4.2 M) + L2 [445853] (8.4 M) 224 I211215 00:02:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,pebble,s2] 1216554 [JOB 2] compacted(default) L1 [442555] (4.2 M) + L2 [445853] (8.4 M) -> L2 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 225 ---- 226 0.log 227 228 log 229 I211215 00:00:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n2,pebble,s1] 1216510 [JOB 1] compacting(default) L3 [442555] (4.2 M) + L4 [445853] (8.4 M) 230 I211215 00:00:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n2,pebble,s1] 1216554 [JOB 1] compacted(default) L3 [442555] (4.2 M) + L4 [445853] (8.4 M) -> L4 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 231 232 I211215 00:02:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n2,pebble,s2] 1216510 [JOB 2] compacting(default) L4 [442555] (4.2 M) + L5 [445853] (8.4 M) 233 I211215 00:02:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n2,pebble,s2] 1216554 [JOB 2] compacted(default) L4 [442555] (4.2 M) + L5 [445853] (8.4 M) -> L5 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 234 ---- 235 1.log 236 237 summarize 238 ---- 239 node: 2, store: 1 240 from: 211215 00:00 241 to: 211215 00:01 242 r-amp: NaN 243 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 244 compact L3 L4 1 0 0 0 1 13MB 13MB 0B 0B 10s 245 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 246 node: 1, store: 1 247 from: 211215 00:01 248 to: 211215 00:02 249 r-amp: NaN 250 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 251 compact L2 L3 1 0 0 0 1 13MB 13MB 0B 0B 10s 252 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 253 node: 1, store: 2 254 from: 211215 00:02 255 to: 211215 00:03 256 r-amp: NaN 257 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 258 compact L1 L2 1 0 0 0 1 13MB 13MB 0B 0B 10s 259 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 260 node: 2, store: 2 261 from: 211215 00:02 262 to: 211215 00:03 263 r-amp: NaN 264 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 265 compact L4 L5 1 0 0 0 1 13MB 13MB 0B 0B 10s 266 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 267 268 # Log lines with an absent node / store are aggregated. 269 270 reset 271 ---- 272 273 log 274 I211215 00:01:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n?,pebble,s?] 1216510 [JOB 1] compacting(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) 275 I211215 00:01:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n?,pebble,s?] 1216554 [JOB 1] compacted(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) -> L3 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 276 ---- 277 0.log 278 279 log 280 I211215 00:01:15.000000 434 kv/kvserver/store.go:3251 ⋮ [n?,s?] 31356 281 __level_____count____size___score______in__ingest(sz_cnt)____move(sz_cnt)___write(sz_cnt)____read___r-amp___w-amp 282 WAL 1 54 M - 65 G - - - - 70 G - - - 1.1 283 0 0 0 B 0.00 70 G 77 M 133 0 B 0 24 G 19 K 4.2 G 0 0.3 284 1 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 285 2 14 34 M 0.96 18 G 0 B 0 17 M 10 49 G 14 K 55 G 1 2.7 286 3 42 207 M 0.96 12 G 0 B 0 939 M 280 43 G 7.3 K 46 G 1 3.4 287 4 264 1.5 G 0.99 9.1 G 18 M 6 824 M 152 31 G 4.5 K 35 G 1 3.4 288 5 7474 23 G 1.00 2.8 G 116 G 26 K 1.8 G 301 3.2 G 604 3.2 G 1 1.2 289 6 23972 164 G - 98 G 70 G 22 K 1.6 K 1 129 G 3.8 K 135 G 1 1.3 290 total 31766 188 G - 257 G 187 G 48 K 3.6 G 744 536 G 49 K 278 G 5 2.1 291 ---- 292 1.log 293 294 summarize 295 ---- 296 node: ?, store: ? 297 from: 211215 00:01 298 to: 211215 00:02 299 r-amp: 5.0 300 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 301 compact L2 L3 1 0 0 0 1 13MB 13MB 0B 0B 10s 302 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 303 304 # The same Job ID interleaved for multiple nodes / stores. 305 306 reset 307 ---- 308 309 log 310 I211215 00:01:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,pebble,s1] 1216510 [JOB 1] compacting(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) 311 I211215 00:02:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n2,pebble,s2] 1216510 [JOB 1] compacting(default) L4 [442555] (4.2 M) + L5 [445853] (8.4 M) 312 I211215 00:01:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,pebble,s1] 1216554 [JOB 1] compacted(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) -> L3 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 313 I211215 00:02:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n2,pebble,s2] 1216554 [JOB 1] compacted(default) L4 [442555] (4.2 M) + L5 [445853] (8.4 M) -> L5 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 314 ---- 315 0.log 316 317 summarize 318 ---- 319 node: 1, store: 1 320 from: 211215 00:01 321 to: 211215 00:02 322 r-amp: NaN 323 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 324 compact L2 L3 1 0 0 0 1 13MB 13MB 0B 0B 10s 325 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 326 node: 2, store: 2 327 from: 211215 00:02 328 to: 211215 00:03 329 r-amp: NaN 330 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 331 compact L4 L5 1 0 0 0 1 13MB 13MB 0B 0B 10s 332 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 333 334 # Read amp matching should remain backwards compatible. 335 336 reset 337 ---- 338 339 log 340 I220301 00:00:10.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1845 ⋮ [n1,pebble,s1] 1216510 [JOB 1] compacting(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) 341 I220301 00:00:20.000000 51831533 3@vendor/github.com/cockroachdb/pebble/compaction.go:1886 ⋮ [n1,pebble,s1] 1216554 [JOB 1] compacted(default) L2 [442555] (4.2 M) + L3 [445853] (8.4 M) -> L3 [445883 445887] (13 M), in 0.3s, output rate 42 M/s 342 ---- 343 0.log 344 345 log 346 I220301 00:00:30.000000 200 1@gossip/gossip.go:1500 ⋮ [n1] 74 node has connected to cluster via gossip 347 I220301 00:00:30.000000 200 kv/kvserver/stores.go:269 ⋮ [n1] 75 wrote 0 node addresses to persistent storage 348 I220301 00:00:30.000000 319 2@server/status/runtime.go:569 ⋮ [n1] 76 runtime stats: 154 MiB RSS, 273 goroutines (stacks: 2.5 MiB), 42 MiB/71 MiB Go alloc/total (heap fragmentation: 11 MiB, heap reserved: 3.9 MiB, heap released: 4.2 MiB), 3.2 MiB/5.6 MiB CGO alloc/total (0.0 CGO/sec), 0.0/0.0 %(u/s)time, 0.0 %gc (0x), 425 KiB/500 KiB (r/w)net 349 I220301 00:00:30.000000 319 2@server/status/runtime.go:569 ⋮ [n1] 77 runtime stats: 159 MiB RSS, 266 goroutines (stacks: 3.3 MiB), 42 MiB/78 MiB Go alloc/total (heap fragmentation: 12 MiB, heap reserved: 6.7 MiB, heap released: 64 MiB), 4.4 MiB/6.8 MiB CGO alloc/total (0.4 CGO/sec), 2.9/2.1 %(u/s)time, 0.0 %gc (0x), 335 KiB/323 KiB (r/w)net 350 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 351 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 +__level_____count____size___score______in__ingest(sz_cnt)____move(sz_cnt)___write(sz_cnt)____read___r-amp___w-amp 352 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + WAL 3 779 K - 773 K - - - - 779 K - - - 1.0 353 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + 0 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 354 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + 1 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 355 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + 2 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 356 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + 3 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 357 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + 4 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 358 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + 5 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 359 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + 6 0 0 B - 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 360 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + total 0 0 B - 779 K 0 B 0 0 B 0 779 K 0 0 B 1 1.0 361 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + flush 0 362 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 +compact 0 0 B 0 B (size == estimated-debt, in = in-progress-bytes) 363 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + memtbl 3 1.8 M 364 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 +zmemtbl 0 0 B 365 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + ztbl 0 0 B 366 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + bcache 0 0 B 0.0% (score == hit-rate) 367 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + tcache 0 0 B 0.0% (score == hit-rate) 368 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + titers 0 369 I220301 00:00:30.000000 315 kv/kvserver/store.go:2713 ⋮ [n1,s1] 78 + filter - - 0.0% (score == utility) 370 ---- 371 1.log 372 373 summarize 374 ---- 375 node: 1, store: 1 376 from: 220301 00:00 377 to: 220301 00:01 378 r-amp: 1.0 379 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 380 compact L2 L3 1 0 0 0 1 13MB 13MB 0B 0B 10s 381 total 1 0 0 0 1 13MB 13MB 0B 0B 10s 382 383 reset 384 ---- 385 386 log 387 I220228 14:44:31.497272 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1366 ⋮ [n24,pebble,s24] 33267888 [JOB 10197855] flushing 1 memtable to L0 388 I220228 14:44:31.497485 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267889 [JOB 10197855] flushing: sstable created 21731018 389 I220228 14:44:31.527038 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267892 [JOB 10197855] flushing: sstable created 21731020 390 I220228 14:44:31.542944 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267894 [JOB 10197855] flushing: sstable created 21731021 391 I220228 14:44:31.553581 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267895 [JOB 10197855] flushing: sstable created 21731022 392 I220228 14:44:31.554585 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267896 [JOB 10197855] flushing: sstable created 21731023 393 I220228 14:44:31.569928 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267897 [JOB 10197855] flushing: sstable created 21731024 394 I220228 14:44:31.624309 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267899 [JOB 10197855] flushing: sstable created 21731025 395 I220228 14:44:31.685531 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267901 [JOB 10197855] flushing: sstable created 21731026 396 I220228 14:44:31.686009 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267902 [JOB 10197855] flushing: sstable created 21731027 397 I220228 14:44:31.686415 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267903 [JOB 10197855] flushing: sstable created 21731028 398 I220228 14:44:31.780892 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267906 [JOB 10197855] flushing: sstable created 21731030 399 I220228 14:44:31.790911 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267907 [JOB 10197855] flushing: sstable created 21731031 400 I220228 14:44:31.904614 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267911 [JOB 10197855] flushing: sstable created 21731033 401 I220228 14:44:31.905835 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267912 [JOB 10197855] flushing: sstable created 21731034 402 I220228 14:44:31.906860 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267913 [JOB 10197855] flushing: sstable created 21731035 403 I220228 14:44:31.907602 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267914 [JOB 10197855] flushing: sstable created 21731036 404 I220228 14:44:32.019173 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267920 [JOB 10197855] flushing: sstable created 21731037 405 I220228 14:44:32.019714 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267921 [JOB 10197855] flushing: sstable created 21731038 406 I220228 14:44:32.020161 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267922 [JOB 10197855] flushing: sstable created 21731039 407 I220228 14:44:32.100117 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267925 [JOB 10197855] flushing: sstable created 21731040 408 I220228 14:44:32.100609 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267926 [JOB 10197855] flushing: sstable created 21731041 409 I220228 14:44:32.101065 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267927 [JOB 10197855] flushing: sstable created 21731042 410 I220228 14:44:32.101494 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267928 [JOB 10197855] flushing: sstable created 21731043 411 I220228 14:44:32.102569 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267929 [JOB 10197855] flushing: sstable created 21731044 412 I220228 14:44:32.106284 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1985 ⋮ [n24,pebble,s24] 33267930 [JOB 10197855] flushing: sstable created 21731045 413 I220228 14:44:32.138686 18460916022 3@vendor/github.com/cockroachdb/pebble/compaction.go:1423 ⋮ [n24,pebble,s24] 33267931 [JOB 10197855] flushed 1 memtable to L0 [21731018 21731020 21731021 21731022 21731023 21731024 21731025 21731026 21731027 21731028 21731030 21731031 21731033 21731034 21731035 21731036 21731037 21731038 21731039 21731040 21731041 21731042 21731043 21731044 21731045] (19 M), in 0.6s, output rate 31 M/s 414 ---- 415 0.log 416 417 summarize 418 ---- 419 node: 24, store: 24 420 from: 220228 14:44 421 to: 220228 14:45 422 r-amp: NaN 423 _kind______from______to_____________________________________count___bytes______time 424 flush L0 1 19MB 0s 425 total 1 19MB 0s 426 427 reset 428 ---- 429 430 log 431 I220228 16:01:22.487906 18476248525 3@vendor/github.com/cockroachdb/pebble/ingest.go:637 ⋮ [n24,pebble,s24] 33430782 [JOB 10211226] ingested L0:21818678 (1.8 K), L0:21818683 (1.2 K), L0:21818679 (1.6 K), L0:21818680 (1.1 K), L0:21818681 (1.1 K), L0:21818682 (160 M) 432 45127:I220228 15:58:45.538681 18475981755 3@vendor/github.com/cockroachdb/pebble/ingest.go:637 ⋮ [n24,pebble,s24] 33424719 [JOB 10210743] ingested L0:21814543 (1.4 K), L0:21814548 (1.2 K), L5:21814544 (1.4 K), L5:21814545 (1.1 K), L5:21814546 (1.1 K), L0:21814547 (140 M) 433 ---- 434 0.log 435 436 summarize 437 ---- 438 node: 24, store: 24 439 from: 220228 15:58 440 to: 220228 15:59 441 r-amp: NaN 442 _kind______from______to_____________________________________count___bytes______time 443 ingest L0 3 140MB 444 ingest L5 3 3.6KB 445 total 6 140MB 0s 446 node: 24, store: 24 447 from: 220228 16:01 448 to: 220228 16:02 449 r-amp: NaN 450 _kind______from______to_____________________________________count___bytes______time 451 ingest L0 6 160MB 452 total 6 160MB 0s 453 454 reset 455 ---- 456 457 log 458 I220907 00:27:21.579807 15082709999 3@vendor/github.com/cockroachdb/pebble/event.go:587 ⋮ [n15,pebble,s15] 2736197 [JOB 743692] compacting(delete-only) L6 [18323385] (11 M) 459 I220907 00:27:21.580169 15082709999 3@vendor/github.com/cockroachdb/pebble/event.go:591 ⋮ [n15,pebble,s15] 2736198 [JOB 743692] compacted(delete-only) L6 [18323385] (11 M) -> L6 [] (0 B), in 0.0s, output rate 0 B/s 460 461 I220907 00:27:21.631145 15082710355 3@vendor/github.com/cockroachdb/pebble/event.go:587 ⋮ [n15,pebble,s15] 2736201 [JOB 743694] compacting(default) L5 [18323582] (1.8 K) + L6 [17770912] (128 M) 462 I220907 00:27:22.729839 15082710355 3@vendor/github.com/cockroachdb/pebble/event.go:591 ⋮ [n15,pebble,s15] 2736208 [JOB 743694] compacted(default) L5 [18323582] (1.8 K) + L6 [17770912] (128 M) -> L6 [18323586] (3.6 M), in 1.1s, output rate 3.3 M/s 463 464 I220907 00:27:21.630546 15082710354 3@vendor/github.com/cockroachdb/pebble/event.go:587 ⋮ [n15,pebble,s15] 2736199 [JOB 743693] compacting(move) L5 [18323585] (4.0 M) + L6 [] (0 B) 465 I220907 00:27:21.631002 15082710354 3@vendor/github.com/cockroachdb/pebble/event.go:591 ⋮ [n15,pebble,s15] 2736200 [JOB 743693] compacted(move) L5 [18323585] (4.0 M) + L6 [] (0 B) -> L6 [18323585] (4.0 M), in 0.0s, output rate 50 G/s 466 ---- 467 0.log 468 469 summarize 470 ---- 471 node: 15, store: 15 472 from: 220907 00:27 473 to: 220907 00:28 474 r-amp: NaN 475 _kind______from______to___default____move___elide__delete___count___in(B)__out(B)__mov(B)__del(B)______time 476 compact L5 L6 1 1 0 0 2 128MB 3.6MB 4.0MB 0B 1s 477 compact L6 L6 0 0 0 1 1 0B 0B 0B 11MB 0s 478 total 1 1 0 1 3 128MB 3.6MB 4.0MB 11MB 1s 479 480 reset 481 ---- 482 483 log 484 I230831 04:13:28.824280 3780 3@pebble/event.go:685 ⋮ [n10,s10,pebble] 365 [JOB 226] flushed 6 ingested flushables L0:024334 (1.5 K) + L0:024339 (1.0 K) + L0:024335 (1.9 K) + L0:024336 (1.1 K) + L0:024337 (1.1 K) + L0:024338 (12 K) in 0.0s (0.0s total), output rate 67 M/s 485 486 I230831 04:13:28.689575 3717 3@pebble/event.go:685 ⋮ [n10,s10,pebble] 345 [JOB 219] flushed 6 ingested flushables L0:024323 (1.5 K) + L0:024328 (1.0 K) + L0:024324 (2.0 K) + L2:024325 (1.1 K) + L2:024326 (1.1 K) + L0:024327 (54 K) in 0.0s (0.0s total), output rate 152 M/s 487 ---- 488 0.log 489 490 summarize 491 ---- 492 node: 10, store: 10 493 from: 230831 04:13 494 to: 230831 04:14 495 r-amp: NaN 496 _kind______from______to_____________________________________count___bytes______time 497 ingest L0 10 77KB 498 ingest L2 2 2.2KB 499 total 12 79KB 0s