Vladislav,

It’s weird to implement setClientInfo without provide a way to see values (MySql Connector J only put values in a hashtable, I do not know what it is for !)

On Oracle, Sybase, SQLServer and DB2, these values are pushed in processes system view.

https://dev.mysql.com/doc/refman/5.6/en/session-connect-attrs-table.html is actually something like that, and both MySQL and MariaDB drivers support connectionAttributes in the connection URL, so maybe it is something that you can use.

It is weird that these client connection attributes are tied to performance schema, that can be switched off during runtime, or during compilation. I'd rather have it in the information schema, that cannot be switched off. Maybe it is something that we need to fix.

 

As much as possible, we want avoid to use one solution per database vendor or a feature with a performance cost.

 

But I agree, it's boring if it’s implementation can change in future.

 

Thanks.

 

Regards

Jérôme.