GBase 8a数据库集群查看引擎状态 show engine express status

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)