使用 -C 命令显示有关 B-tree 扫描程序子系统和每个 B-tree 扫描程序线程的信息。
图: 带 prof 选项的 onstat -C 命令输出
Btree Cleaner Info
BT scanner profile Information
==============================
Active Threads 1
Global Commands 2000000 Building hot list
Number of partition scans 11003
Main Block 0xc000000003c9dc68
BTC Admin 0xc0000000024bc208
BTS info id Prio Partnum Key Cmd
0xc000000003c9dee8 0 High 0x00000000 0 40 Yield N
Number of leaves pages scanned 77
Number of leaves with deleted items 6
Time spent cleaning (sec) 0
Number of index compresses 0
Number of deleted items 113
Number of index range scans 0
Number of index leaf scans 0
Number of index alice scans 2
图: 带有 hot 选项的 onstat -C 命令输出
Btree Cleaner Info
Index Hot List
==============
Current Item 5 List Created 15:29:47
List Size 4 List expires in 0 sec
Hit Threshold 500 Range Scan Threshold -1
Partnum Key Hits
0x00100191 1 14 *
0x00A00022 1 13 *
0x00100191 2 8 *
0x00100150 2 7 *
图: onstat -C part 命令输出
Btree Cleaner Info
Index Statistics
================
Partnum Key Positions Compress Split
0x00100002 1 146 0 0
0x00100004 1 4 0 0
0x00100004 2 13 0 0
0x00100005 1 1 0 0
0x00100005 2 0 0 0
0x00100006 1 1 0 0
0x00100006 2 0 0 0
0x00100007 2 1 0 0
0x00100008 2 1 0 0
0x0010000a 1 0 0 0
0x0010000e 3 1 0 0
0x00100011 1 1 0 0
0x00100013 2 2 0 0
图: 带有 clean 选项的 onstat -C 命令输出
Btree Cleaner Info
Index Cleaned Statistics
=========================
Partnum Key Dirty Hits Clean Time Pg Examined Items Del Pages/Sec
0x00100013 2 2 0 0 0 0.00
0x0010008b 3 1 0 0 0 0.00
0x001000c7 1 2 0 0 0 0.00
0x00100150 2 7 0 0 0 0.00
0x0010016f 2 2 0 0 0 0.00
0x00100191 1 14 0 0 0 0.00
0x00100191 2 8 0 0 0 0.00
0x00a00011 2 6 0 0 0 0.00
0x00a00013 1 0 0 24 0 24.00
0x00a00019 1 0 0 470 225 470.00
0x00a00022 1 13 0 0 0 0.00
0x00a00022 2 5 0 0 0 0.00
图: onstat -C range
Btree Cleaner Info
Cleaning Range Statistics
=========================
Partnum Key Low High Size Saving
0x001001bc 2 36 69 96 65.6 %
0x001001be 1 16 20 48 91.7 %
0x001001cd 1 8 21 32 59.4 %
0x001001cd 2 24 25 32 96.9 %
图: onstat -C map
Btree Cleaner Info
ALICE Bitmap of Deleted Index Items
===================================
Partnum Key Map
0x00100013 2 0000: 80000000 00000000
0x0010008b 3 0000: 80000000 00000000
0x001000c7 1 0000: 80000000 00000000
0x00100150 2 0000: 80000000 00000000
0x0010016f 2 0000: 80000000 00000000
0x00100191 1 0000: 80000000 00000000
0x00100191 2 0000: 80000000 00000000
0x00a00011 2 0000: 80000000 00000000
0x00a00013 1 0000: 00000000 00000000
0x00a00019 1 0000: 00000000 00000000
0x00a00022 1 0000: 80000000 00000000
0x00a00022 2 0000: 80000000 00000000
图: onstat -C alice
Btree Cleaner Info
ALICE Cleaning Statistics
=========================
System ALICE Info: Mode = 6, Eff = 30 %, Adj = 5
Partnum Mode BM_Sz Used_Pg Examined Dirty_Pg # I/O Found Eff Adj
0x00100013 6 64 97 0 0 0 0 0.0 % 0
0x0010008b 6 64 5 0 0 0 0 0.0 % 0
0x001000c7 6 64 2 0 0 0 0 0.0 % 0
0x00100150 6 64 91 0 0 0 0 0.0 % 0
0x0010016f 6 64 91 0 0 0 0 0.0 % 0
0x00100191 6 64 26 0 0 0 0 0.0 % 0
0x00100191 6 64 26 0 0 0 0 0.0 % 0
0x001001bc 0 0 91 0 0 0 0 0.0 % 0
0x001001cd 0 0 26 0 0 0 0 0.0 % 0
0x001001cd 0 0 26 0 0 0 0 0.0 % 0
0x00a00011 6 64 91 0 0 0 0 0.0 % 0
0x00a00013 6 64 25 24 3 3 1 33.3 % 1
0x00a00019 6 64 470 470 3 3 2 66.7 % 1
0x00a00022 6 64 26 0 0 0 0 0.0 % 0
0x00a00022 6 64 26 0 0 0 0 0.0 % 0