Skip to end of metadata
Go to start of metadata

x_cons <database_name> show t_move

Only for load balancing; indicates whether tasks can currently be moved from one user kernel thread to another.

ID   UKT TASK    Current               Max.         Sum Move
         type    state             Runnable    Runnable lock
T1     6 Timer   Sleeping          0.000002    0.000003 LT:1
T2     2 Logwr   No-Work  (255)    0.000010    0.002102 LT:1
T3     1 Tracewr No-Work  (255)    0.000000    0.000000 LT:1
T4     3 Utility Connect wait      0.000000    0.000000 LT:1
T5     7 Idle    Stopped           0.000000    0.000000 LT:1
:
T8     6 Pager   No-Work  (255)    0.000000    0.000000 LT:1
:
T39    6 Pager   No-Work  (255)    0.000000    0.000000 LT:1
T133   7 User    Command wait      0.000001    0.000009 LT:4
T340   4 Server  No-Work  (255)    0.000000    0.000000 LT:1
:
T367   4 Server  No-Work  (255)    0.000000    0.000000 LT:1
T375   5 Event   Stopped           0.000000    0.000000 LT:1
:
T384   5 GarbCol No-Work  (255)    0.002116    0.517215 LT:1
T385   5 GarbCol No-Work  (255)    0.003041    0.487282 LT:1
  • ID: TaskId
  • UKT: UKT ID
  • Task type: Task type
  • Current State: Current task state
  • Max. runnable: Maximum duration spent in runnable state inside the dispatcher in ms
  • Sum runnable: Total duration spent in runnable state inside the dispatcher in ms
  • Move lock: Long term move lock. Load-balancing lock can be either short-term (you'd see a nonzero number) or long-term (as you see: LT:<number>). A task can be moved only when LT value is 0.
    Long-term lock is a bit mask of OR-ed values:
    • 1: task type-dependent lock (certain task types are not allowed to move to different UKT)
    • 2: client disabled load-balancing for the task
    • 4: locked when waiting for communication
    • 8: locked while task inactive (e.g., during startup).

Short-term lock is set for certain operations, like memory allocation via UKT-specific allocator, to prevent moving the task while UKT-specific operation is in progress.