Session
Control the current and open sessions: show the session id, the user, the Java PID and the open sessions, change the mode, show the help and close the session.

WS Session

@chat@cmdid@count sessions@sessions@sid

DB Session

byecmdidcount sessionsexithelpquitsessionssid@pidwho

@chat


Description

    To change the mode to CHAT.

admin
@chat
mentdb
CHAT mode activated (do not use directly with the editor, only in your application with the web socket driver).

@cmdid


Description

    To show the number of web socket commands executed by the current user

admin
@cmdid
mentdb
5
Used in use cases (4 recipes)

    MQL developer › Request context in session and secrets
    Execution modes › Context of a run: user, session, pid, traces
    Configuration & connections › Stamp an action with the user, session and process
    System administrator & DevOps › Sessions and errors of the day
Often used with

    count sessions  ·  who  ·  sessions  ·  sid  ·  pid  ·  and  ·  concat_var  ·  date sysdate

@count sessions


Description

    To count all open web socket sessions

admin
@count sessions
mentdb
1
Used in use cases (6 recipes)

    MQL developer › Request context in session and secrets
    Backend & web service developer › Health check endpoint for the load balancer
    Execution modes › Context of a run: user, session, pid, traces
    Configuration & connections › Stamp an action with the user, session and process
    Debugging & error handling › A health snapshot of the server as JSON
    System administrator & DevOps › Sessions and errors of the day
Often used with

    cmdid  ·  who  ·  sessions  ·  sid  ·  execute  ·  json doc  ·  json iobject  ·  metric current available mem

@sessions


Description

    To show open web socket sessions

admin
@sessions
mentdb
[ { "maxUsable": 600, "nbExecution": 5, "id": 2, "used": 0, "user": "admin", "life": "0/600s" } ]
Used in use cases (4 recipes)

    Execution modes › Context of a run: user, session, pid, traces
    Configuration & connections › Stamp an action with the user, session and process
    System administrator & DevOps › Sessions and errors of the day
    System administrator & DevOps › Maintenance window: lock, change the config, reopen
Often used with

    cmdid  ·  count sessions  ·  sid  ·  who  ·  and  ·  log trace  ·  pid  ·  config reload

@sid


Description

    To show the current web socket session id

admin
@sid
mentdb
3
Used in use cases (5 recipes)

    MQL developer › Request context in session and secrets
    Execution modes › Context of a run: user, session, pid, traces
    Configuration & connections › Make sure a batch never runs twice at the same time
    System administrator & DevOps › Maintenance window: lock, change the config, reopen
    Configuration & connections › Stamp an action with the user, session and process
Often used with

    who  ·  cmdid  ·  count sessions  ·  sessions  ·  and  ·  log trace  ·  not  ·  string regexp_extract

bye


Description

    To close the session (or exit or quit)

admin
bye
mentdb
Session close with successful.

cmdid


Description

    To show the number of commands executed by the current user

admin
cmdid
mentdb
25
Used in use cases (4 recipes)

    MQL developer › Request context in session and secrets
    Execution modes › Context of a run: user, session, pid, traces
    Configuration & connections › Stamp an action with the user, session and process
    System administrator & DevOps › Sessions and errors of the day
Often used with

    count sessions  ·  who  ·  sessions  ·  sid  ·  pid  ·  and  ·  concat_var  ·  date sysdate

count sessions


Description

    To count all open sessions

admin
count sessions
mentdb
3
Used in use cases (6 recipes)

    MQL developer › Request context in session and secrets
    Backend & web service developer › Health check endpoint for the load balancer
    Execution modes › Context of a run: user, session, pid, traces
    Configuration & connections › Stamp an action with the user, session and process
    Debugging & error handling › A health snapshot of the server as JSON
    System administrator & DevOps › Sessions and errors of the day
Often used with

    cmdid  ·  who  ·  sessions  ·  sid  ·  execute  ·  json doc  ·  json iobject  ·  metric current available mem

exit


Description

    To close the session (or bye or quit)

admin
exit
mentdb
Session close with successful.

help


Description

    To show this help menu

quit


Description

    To close the session (or exit or quit)

admin
quit
mentdb
Session close with successful.

sessions


Description

    To show all open sessions

admin
sessions
mentdb
[ { "maxUsable": 600, "nbExecution": 2, "used": 0, "id": 4, "user": "admin", "life": "0/600s" } ]
Used in use cases (4 recipes)

    Execution modes › Context of a run: user, session, pid, traces
    Configuration & connections › Stamp an action with the user, session and process
    System administrator & DevOps › Sessions and errors of the day
    System administrator & DevOps › Maintenance window: lock, change the config, reopen
Often used with

    cmdid  ·  count sessions  ·  sid  ·  who  ·  and  ·  log trace  ·  pid  ·  config reload

sid


Description

    To show the current session id

admin
sid
mentdb
5
Used in use cases (5 recipes)

    MQL developer › Request context in session and secrets
    Execution modes › Context of a run: user, session, pid, traces
    Configuration & connections › Make sure a batch never runs twice at the same time
    System administrator & DevOps › Maintenance window: lock, change the config, reopen
    Configuration & connections › Stamp an action with the user, session and process
Often used with

    who  ·  cmdid  ·  count sessions  ·  sessions  ·  and  ·  log trace  ·  not  ·  string regexp_extract

@pid


Description

    To show the current Java PID

admin
pid
mentdb
5423
Used in use cases (2 recipes)

    Configuration & connections › Stamp an action with the user, session and process
    System administrator & DevOps › Sessions and errors of the day
Often used with

    cmdid  ·  count sessions  ·  sessions  ·  who  ·  date sysdate  ·  exceeded sessions  ·  json parse_array  ·  log archive path

who


Description

    To show the current user

admin
who
mentdb
admin
Used in use cases (5 recipes)

    MQL developer › Request context in session and secrets
    Execution modes › Context of a run: user, session, pid, traces
    Configuration & connections › Make sure a batch never runs twice at the same time
    System administrator & DevOps › Sessions and errors of the day
    Configuration & connections › Stamp an action with the user, session and process
Often used with

    cmdid  ·  count sessions  ·  sid  ·  sessions  ·  pid  ·  string regexp_extract  ·  and  ·  concat_var