使用 -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