OK_Packet

You are viewing an old version of this article. View the current version here.

OK_Packet

OK_Packet is sent by the server to the client and indicates a successful completion of a command sent by the client before.

Direction

Server to client.

Fields


Status flag

SERVER_STATUS_IN_TRANS1
SERVER_STATUS_AUTOCOMMIT2
SERVER_MORE_RESULTS_EXISTS8
SERVER_QUERY_NO_GOOD_INDEX_USED16
SERVER_QUERY_NO_INDEX_USED32
SERVER_STATUS_CURSOR_EXISTS64
SERVER_STATUS_LAST_ROW_SENT128
SERVER_STATUS_DB_DROPPED1 << 8
SERVER_STATUS_NO_BACKSLASH_ESCAPES1 << 9
SERVER_STATUS_METADATA_CHANGED1 << 10
SERVER_QUERY_WAS_SLOW1 << 11
SERVER_PS_OUT_PARAMs1 << 12
SERVER_STATUS_IN_TRANS_READONLY1 << 13
SERVER_SESSION_STATE_CHANGED1 << 14


Session state info


Session change type

0SESSION_TRACK_SYSTEM_VARIABLES
1SESSION_TRACK_SCHEMA
2SESSION_TRACK_STATE_CHANGE
3SESSION_TRACK_GTIDS
4SESSION_TRACK_TRANSACTION_CHARACTERISTICS
5SESSION_TRACK_TRANSACTION_STATE


Notes

  • Session tracking is supported from MariaDB 10.2. To determine if session tracking is enabled, check if the CLIENT_SESSION_TRACK flag is set in server_capabilities.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.