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
Sign Up Login You must be logged in to post a comment.