maria-developers team mailing list archive

[jerome brauge <j.brauge@xxxxxxxxxxx>]

Hello,
Apparently, no one is interested by this request.
I think it is still interesting for project "MDEV-10137 Providing compatibility to other databases".

Major databases allow to see these informations:
- master..sysprocesses on Sybase and SQLserver 
- v$session or gv$session on Oracle
- SYSIBMADM.SNAPAPPL_INFO on DB2 LUW
- pg_stat_activity on postgresql

I can make a patch to add ApplicationName, ClientUser and ClientHostname to Information_schema.processlist.
Must I open a feature request on jira and wait your agreement ?

Best regards,
Jérôme.

-----Message d'origine-----
De : Maria-developers [mailto:maria-developers-bounces+j.brauge=qualiac.com@xxxxxxxxxxxxxxxxxxx] De la part de jerome brauge
Envoyé : mardi 7 mars 2017 15:49
À : MariaDB Developers (maria-developers@xxxxxxxxxxxxxxxxxxx)
Objet : [Maria-developers] Adding information de Information_schema.processlist

Hello,

Connector/J support the method setClientInfo and standard information : ApplicationName, ClientUser and ClientHostname.
(https://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#setClientInfo(java.lang.String,%20java.lang.String)

It's seem that there is no way to see these information by a select because session variables are used to store these values.
 
Can we add these information as columns in Information_schema.processlist  ?

Regards,
Jérôme.


_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp