GBase 8a数据库集群,可以通过show engine express status命令来查看当前节点的引擎使用状态。特备是内存。
目录导航
提示
如果要查看某个表的引擎信息,请参考 https://www.gbase8.cn/97
语法
show engine express status
样例
查看引擎状态,样例如下。其中内存信息是最基本的。
gbase> show engine express status;
+-------------+------------------------+--------+
| Type | Name | Status |
+-------------+------------------------+--------+
| memory | memory statistic | ------------------------------------------------
MALLOC: 29633640 ( 28.3 MiB) Bytes in use by application
MALLOC: + 0 ( 0.0 MiB) Bytes in page heap freelist
MALLOC: + 606936 ( 0.6 MiB) Bytes in central cache freelist
MALLOC: + 0 ( 0.0 MiB) Bytes in transfer cache freelist
MALLOC: + 2027712 ( 1.9 MiB) Bytes in thread cache freelists
MALLOC: + 1175712 ( 1.1 MiB) Bytes in malloc metadata
MALLOC: ------------
MALLOC: = 33444000 ( 31.9 MiB) Actual memory used (physical + swap)
MALLOC: + 10723328 ( 10.2 MiB) Bytes released to OS (aka unmapped)
MALLOC: ------------
MALLOC: = 44167328 ( 42.1 MiB) Virtual address space used
MALLOC:
MALLOC: 454 Spans in use
MALLOC: 19 Thread heaps in use
MALLOC: 8192 Tcmalloc page size
------------------------------------------------
Call ReleaseFreeMemory() to release freelist memory to the OS (via madvise()).
Bytes released to the OS take up virtual address space but no physical memory.
------------------------------------------------
Total size of freelists for per-thread caches,
transfer cache, and central cache, by size class
------------------------------------------------
class 1 [ 8 bytes ] : 1943 objs; 0.0 MiB; 0.0 cum MiB
class 2 [ 16 bytes ] : 943 objs; 0.0 MiB; 0.0 cum MiB
class 3 [ 32 bytes ] : 512 objs; 0.0 MiB; 0.0 cum MiB
class 4 [ 48 bytes ] : 104 objs; 0.0 MiB; 0.0 cum MiB
class 5 [ 64 bytes ] : 265 objs; 0.0 MiB; 0.1 cum MiB
class 6 [ 80 bytes ] : 172 objs; 0.0 MiB; 0.1 cum MiB
class 7 [ 96 bytes ] : 46 objs; 0.0 MiB; 0.1 cum MiB
class 8 [ 112 bytes ] : 118 objs; 0.0 MiB; 0.1 cum MiB
class 9 [ 128 bytes ] : 84 objs; 0.0 MiB; 0.1 cum MiB
class 10 [ 144 bytes ] : 105 objs; 0.0 MiB; 0.1 cum MiB
class 11 [ 160 bytes ] : 100 objs; 0.0 MiB; 0.1 cum MiB
class 12 [ 176 bytes ] : 72 objs; 0.0 MiB; 0.1 cum MiB
class 13 [ 192 bytes ] : 62 objs; 0.0 MiB; 0.2 cum MiB
class 14 [ 208 bytes ] : 60 objs; 0.0 MiB; 0.2 cum MiB
class 15 [ 224 bytes ] : 56 objs; 0.0 MiB; 0.2 cum MiB
class 16 [ 240 bytes ] : 64 objs; 0.0 MiB; 0.2 cum MiB
class 17 [ 256 bytes ] : 32 objs; 0.0 MiB; 0.2 cum MiB
class 18 [ 288 bytes ] : 28 objs; 0.0 MiB; 0.2 cum MiB
class 19 [ 320 bytes ] : 77 objs; 0.0 MiB; 0.2 cum MiB
class 20 [ 352 bytes ] : 25 objs; 0.0 MiB; 0.2 cum MiB
class 21 [ 384 bytes ] : 49 objs; 0.0 MiB; 0.3 cum MiB
class 22 [ 416 bytes ] : 18 objs; 0.0 MiB; 0.3 cum MiB
class 23 [ 448 bytes ] : 34 objs; 0.0 MiB; 0.3 cum MiB
class 24 [ 480 bytes ] : 1 objs; 0.0 MiB; 0.3 cum MiB
class 25 [ 512 bytes ] : 27 objs; 0.0 MiB; 0.3 cum MiB
class 26 [ 576 bytes ] : 39 objs; 0.0 MiB; 0.3 cum MiB
class 27 [ 640 bytes ] : 19 objs; 0.0 MiB; 0.3 cum MiB
class 28 [ 704 bytes ] : 10 objs; 0.0 MiB; 0.3 cum MiB
class 29 [ 768 bytes ] : 20 objs; 0.0 MiB; 0.4 cum MiB
class 30 [ 832 bytes ] : 8 objs; 0.0 MiB; 0.4 cum MiB
class 31 [ 896 bytes ] : 9 objs; 0.0 MiB; 0.4 cum MiB
class 32 [ 960 bytes ] : 6 objs; 0.0 MiB; 0.4 cum MiB
class 33 [ 1024 bytes ] : 13 objs; 0.0 MiB; 0.4 cum MiB
class 34 [ 1152 bytes ] : 20 objs; 0.0 MiB; 0.4 cum MiB
class 35 [ 1280 bytes ] : 2 objs; 0.0 MiB; 0.4 cum MiB
class 36 [ 1408 bytes ] : 8 objs; 0.0 MiB; 0.4 cum MiB
class 37 [ 1536 bytes ] : 14 objs; 0.0 MiB; 0.4 cum MiB
class 38 [ 1792 bytes ] : 13 objs; 0.0 MiB; 0.5 cum MiB
class 39 [ 2048 bytes ] : 12 objs; 0.0 MiB; 0.5 cum MiB
class 40 [ 2304 bytes ] : 5 objs; 0.0 MiB; 0.5 cum MiB
class 41 [ 2560 bytes ] : 6 objs; 0.0 MiB; 0.5 cum MiB
class 42 [ 2816 bytes ] : 3 objs; 0.0 MiB; 0.5 cum MiB
class 43 [ 3072 bytes ] : 3 objs; 0.0 MiB; 0.5 cum MiB
class 44 [ 3328 bytes ] : 2 objs; 0.0 MiB; 0.5 cum MiB
class 45 [ 4096 bytes ] : 18 objs; 0.1 MiB; 0.6 cum MiB
class 46 [ 4608 bytes ] : 21 objs; 0.1 MiB; 0.7 cum MiB
class 47 [ 5120 bytes ] : 2 objs; 0.0 MiB; 0.7 cum MiB
class 48 [ 6144 bytes ] : 5 objs; 0.0 MiB; 0.7 cum MiB
class 49 [ 6656 bytes ] : 4 objs; 0.0 MiB; 0.8 cum MiB
class 50 [ 8192 bytes ] : 6 objs; 0.0 MiB; 0.8 cum MiB
class 51 [ 9216 bytes ] : 2 objs; 0.0 MiB; 0.8 cum MiB
class 52 [ 10240 bytes ] : 2 objs; 0.0 MiB; 0.8 cum MiB
class 53 [ 12288 bytes ] : 1 objs; 0.0 MiB; 0.9 cum MiB
class 54 [ 13312 bytes ] : 6 objs; 0.1 MiB; 0.9 cum MiB
class 55 [ 16384 bytes ] : 1 objs; 0.0 MiB; 0.9 cum MiB
class 56 [ 20480 bytes ] : 4 objs; 0.1 MiB; 1.0 cum MiB
class 58 [ 26624 bytes ] : 1 objs; 0.0 MiB; 1.1 cum MiB
class 60 [ 40960 bytes ] : 12 objs; 0.5 MiB; 1.5 cum MiB
class 61 [ 49152 bytes ] : 1 objs; 0.0 MiB; 1.6 cum MiB
class 67 [ 98304 bytes ] : 1 objs; 0.1 MiB; 1.7 cum MiB
class 70 [ 122880 bytes ] : 1 objs; 0.1 MiB; 1.8 cum MiB
class 71 [ 131072 bytes ] : 1 objs; 0.1 MiB; 1.9 cum MiB
class 72 [ 139264 bytes ] : 1 objs; 0.1 MiB; 2.0 cum MiB
class 74 [ 155648 bytes ] : 1 objs; 0.1 MiB; 2.2 cum MiB
class 85 [ 245760 bytes ] : 1 objs; 0.2 MiB; 2.4 cum MiB
------------------------------------------------
PageHeap: 2 sizes; 0.0 MiB free; 10.2 MiB unmapped
------------------------------------------------
1 pages * 6 spans ~ 0.0 MiB; 0.0 MiB cum; unmapped: 0.0 MiB; 0.0 MiB cum
23 pages * 1 spans ~ 0.2 MiB; 0.2 MiB cum; unmapped: 0.2 MiB; 0.2 MiB cum
>255 large * 1 spans ~ 10.0 MiB; 10.2 MiB cum; unmapped: 10.0 MiB; 10.2 MiB cum
|
| DataSession | DataSession Statistics | DataSessionManager
Send buffer size: 0
Initiated Connections: 0
Accepted Connections: 0
Total Sent: 0, Total Recv: 0
|
| sis memory | sis memory statistics | SISRecordDispatcher: peak: 0, current: 0, TmpMatBuf: peak: 0, current: 0, ByteQueue: peak: 0, current: 0 |
| dts info | dts statistics | |
+-------------+------------------------+--+
4 rows in set (Elapsed: 00:00:00.01)