[Info-ingres] select * from remotecmdl

[Paul White]

It is an uncommitted transaction.  lockstat shows a physical table level
lock.  On Linux, the rmcmd process consumes CPU. Under windows I havent
seen CPU counter impacted. I usually disable it for security and
performance. (also mgmtsvr)

lockstat
id: 04DC000B Tran_id: 00005CAD650340A3 R_llb: 04DD0004 R_cnt: 0 S_llb:
00000000 S_cnt: 0 Wait: 00000000 Locks: (1,0/2000)
    PID:7605 SID:00007F63D0F806C0 Stash: (R:7, L:0)  Status:

    Id: 00023217 Rsb: 000173FC Gr: X   Req: X   State: GR PHYS(1) Attr:
PHYSICAL,IS_RSBS  KEY(TABLE,DB=5cad7464,TABLE=[265,0])

 ps -fu ingres
  7391 ingres    20   0  131612   1660    808 S   0.0  0.0   1:43.61 iigcn
  7566 ingres    20   0  594072  31188  16416 S   0.0  0.3   8:01.86 iidbms
  7589 ingres    20   0  265412   2960   2516 S   0.0  0.0   1:56.01 dmfacp
  7605 ingres    20   0 3408028   1.8g  20796 S   0.0 15.9   2422:39 iidbms
  7640 ingres    20   0  138372   7780    956 S   0.0  0.1 112:25.52 iigcc
  7659 ingres    20   0  144104   8572   1372 S   0.0  0.1  32:40.78 iigcd
  7675 ingres    20   0  153456    952    704 S   0.0  0.0  18:31.59 rmcmd
  7708 ingres    20   0 6587944  19284    260 S   0.0  0.2  32:08.93 mgmtsvr



Paul
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20191119/cc747a0d/attachment.html>