Online / 6 & 7 February 2021


Passing query attributes through the MySQL protocol

Extension to the wire format to allow data/metadata

I'll explain the newest addition to the MySQL wire format that allows client applications to pass data in the COM_QUERY command that then can be processed by the server and components in various ways. I'll demonstrate how an audit plugin and the SQL query itself can take advantage of the data passed by the client.

COM_QUERY can now take named binary values parameters. And the server can serve the values of these to components and plugins. As well as the SQL query itself. Let's learn how to prepare these values using the C API and how to process them inside the server.


Photo of Joro Kodinov Joro Kodinov