Skip to content

Instantly share code, notes, and snippets.

@DhruvParanjape

DhruvParanjape/Rocksdb_status

Created February 20, 2017 13:43
Show Gist options
  • Save DhruvParanjape/55dd0eb0b1c022915e6d1b92508aa42f to your computer and use it in GitHub Desktop.
Save DhruvParanjape/55dd0eb0b1c022915e6d1b92508aa42f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Rocksdb_status
mysql> SHOW ENGINE ROCKSDB STATUS\G
*************************** 1. row ***************************
Type: DBSTATS
Name: rocksdb
Status:
** DB Stats **
Uptime(secs): 42.9 total, 42.9 interval
Cumulative writes: 1 writes, 0 keys, 1 commit groups, 0.5 writes per commit group, ingest: 0.00 GB, 0.00 MB/s
Cumulative WAL: 1 writes, 1 syncs, 0.50 writes per sync, written: 0.00 GB, 0.00 MB/s
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
Interval writes: 1 writes, 0 keys, 1 commit groups, 0.5 writes per commit group, ingest: 0.00 MB, 0.00 MB/s
Interval WAL: 1 writes, 1 syncs, 0.50 writes per sync, written: 0.00 MB, 0.00 MB/s
Interval stall: 00:00:0.000 H:M:S, 0.0 percent
** Level 0 read latency histogram (micros):
Count: 5418 Average: 78.3295 StdDev: 32.94
Min: 1 Median: 65.6118 Max: 982
Percentiles: P50: 65.61 P75: 100.91 P99: 139.05 P99.9: 279.10 P99.99: 945.82
------------------------------------------------------
[ 0, 1 ) 1 0.018% 0.018%
[ 1, 2 ) 36 0.664% 0.683%
[ 50, 60 ) 1021 18.845% 19.528% ####
[ 60, 70 ) 2942 54.300% 73.828% ###########
[ 70, 80 ) 6 0.111% 73.939%
[ 80, 90 ) 3 0.055% 73.994%
[ 90, 100 ) 25 0.461% 74.456%
[ 100, 120 ) 646 11.923% 86.379% ##
[ 120, 140 ) 718 13.252% 99.631% ###
[ 140, 160 ) 10 0.185% 99.815%
[ 160, 180 ) 3 0.055% 99.871%
[ 180, 200 ) 1 0.018% 99.889%
[ 250, 300 ) 1 0.018% 99.908%
[ 400, 450 ) 2 0.037% 99.945%
[ 500, 600 ) 2 0.037% 99.982%
[ 900, 1000 ) 1 0.018% 100.000%
** Level 1 read latency histogram (micros):
Count: 5784 Average: 71.4231 StdDev: 26.16
Min: 1 Median: 63.5630 Max: 480
Percentiles: P50: 63.56 P75: 68.59 P99: 138.21 P99.9: 194.77 P99.99: 480.00
------------------------------------------------------
[ 0, 1 ) 8 0.138% 0.138%
[ 1, 2 ) 48 0.830% 0.968%
[ 50, 60 ) 1812 31.328% 32.296% ######
[ 60, 70 ) 2874 49.689% 81.985% ##########
[ 70, 80 ) 69 1.193% 83.178%
[ 80, 90 ) 7 0.121% 83.299%
[ 90, 100 ) 37 0.640% 83.938%
[ 100, 120 ) 456 7.884% 91.822% ##
[ 120, 140 ) 456 7.884% 99.706% ##
[ 140, 160 ) 8 0.138% 99.844%
[ 160, 180 ) 1 0.017% 99.862%
[ 180, 200 ) 3 0.052% 99.914%
[ 250, 300 ) 1 0.017% 99.931%
[ 350, 400 ) 2 0.035% 99.965%
[ 450, 500 ) 2 0.035% 100.000%
*************************** 2. row ***************************
Type: CF_COMPACTION
Name: __system__
Status:
** Compaction Stats [__system__] **
Level Files Size(MB} Score Read(GB} Rn(GB} Rnp1(GB} Write(GB} Wnew(GB} Moved(GB} W-Amp Rd(MB/s} Wr(MB/s} Comp(sec} Comp(cnt} Avg(sec} KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------
L0 2/0 0.00 0.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.000 0 0
L1 1/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.000 0 0
Sum 3/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.000 0 0
Int 0/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.000 0 0
Uptime(secs): 42.9 total, 42.9 interval
Flush(GB): cumulative 0.000, interval 0.000
AddFile(GB): cumulative 0.000, interval 0.000
AddFile(Total Files): cumulative 0, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 0, interval 0
Cumulative compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Interval compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
*************************** 3. row ***************************
Type: CF_COMPACTION
Name: default
Status:
** Compaction Stats [default] **
Level Files Size(MB} Score Read(GB} Rn(GB} Rnp1(GB} Write(GB} Wnew(GB} Moved(GB} W-Amp Rd(MB/s} Wr(MB/s} Comp(sec} Comp(cnt} Avg(sec} KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------
L0 3/0 21.11 0.8 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.000 0 0
L1 3/0 22.48 0.1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.000 0 0
Sum 6/0 43.60 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.000 0 0
Int 0/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.000 0 0
Uptime(secs): 42.9 total, 42.9 interval
Flush(GB): cumulative 0.000, interval 0.000
AddFile(GB): cumulative 0.000, interval 0.000
AddFile(Total Files): cumulative 0, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 0, interval 0
Cumulative compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Interval compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
*************************** 4. row ***************************
Type: Memory_Stats
Name: rocksdb
Status:
MemTable Total: 1584
MemTable Unflushed: 1584
Table Readers Total: 0
Cache Total: 45653752
Default Cache Capacity: 0
4 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment