MySQL Internals Manual  /  X Protocol  /  Comparison to MySQL C/S Protocol

15.9 Comparison to MySQL C/S Protocol

Feature MySQL C/S protocol X Protocol
plaintext auth ✓ via SASL
extentisible auth ✓ (5.6) ✓ via SASL
TLS extension
max message size >= 1Gb
compression extension
resettable sessions COM_RESET_CONNECTION Reset
multiple, sequential sessions COM_CHANGE_USER AuthenticateStart
out-of-band notifications Frame
extensible messages via protobuf
extensible protocol via capability flags CapabilitiesGet
prepared SQL
prepared CRUD
multi-statement ✓ (5.0)
multi-resultset ✓ (5.0) FetchDoneMoreResultsets
OUT-paramset ✓ (5.5) FetchDoneMoreOutParams

Mapping of MySQL C/S COM_ to Mysqlx Messages

Command X Protocol
COM_QUIT Close
COM_INIT_DB
COM_QUERY StmtExecute namespace="sql"
COM_FIELD_LIST ✕, deprecated
COM_CREATE_DB ✕, deprecated
COM_DROP_DB ✕, deprecated
COM_REFRESH ✕, deprecated
COM_SHUTDOWN ✕, use SQL SHUTDOWN
COM_STATISTICS ✕, deprecated
COM_PROCESS_INFO ✕, deprecated
COM_PROCESS_KILL ✕, deprecated
COM_DEBUG ✕, deprecated
COM_PING StmtExecute namespace="xplugin"
COM_CHANGE_USER AuthenticateStart
COM_RESET_CONNECTION Reset
COM_STMT_PREPARE
COM_STMT_SEND_LONG_DATA
COM_STMT_EXECUTE
COM_STMT_CLOSE
COM_STMT_RESET
COM_SET_OPTION
COM_STMT_FETCH

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.