You are correct that the statement will be parsed twice, although the parsing that is done in MySqlClient is quite efficient and as such does not have much impact on the overall performance. It's also true that if a transaction is started in a prepared statement or a stored function the transaction state is not correctly tracked.

So indeed it would be much better to use the information provided by the server. I think it is safe to say we will start using that but at this point I cannot say anything specific about the timeframe.

hi Johan Wikman , I created a pr https://github.com/mariadb-corporation/MaxScale/pull/158, could you review it;