4 - Server Response Packets

Understand server response packets in MariaDB's client/server protocol. This section details the various types of packets sent by the server, including OK, Error, and Result Set packets.

For most commands which the client sends to the server, the server returns the following response packets:

EOF_Packet

Marks the end of a result set and returns status and warnings.

ERR_Packet

Indicates that an error occured.

LOCAL_INFILE_Packet

If the client sends a LOAD DATA LOCAL INFILE statement via com_query, the server responds with LOCAL_INFILE_Packet to tell the client to send a specified file to the server.

OK_Packet

Sent by the server to the client. Indicates a successful completion of a command sent by the client before.

Result Set Packets

The server sends multiple packets as part of a result set.

Result Set Row

Data representing a database result set unit.