About connection id information
Posted by: Jo Hyung Jung
Date: August 04, 2020 02:21AM

Hello, I am curious about mysql's os level information.

Currently, mysql shows client's connection id (in information schema) and os_thread_id ( in performance schema). However os_thread_id doesn't mean client's local thread id, it means mysqld's thread id.

So in order to mapping os level information (pid or thread(lwp) id) to mysql's connection id ( Suppose local connection for DBA or sysadmin ), I have to use tcp/ip connection to use port information as a stepping stone. ( Use netstat -antp | grep port to get pid)

Could you know me the reason why mysql doesn't support os level information? I think this feature is useful when auditing local connection for DBA or sysadmin.

Best wishes,
Jo Hyung Jung

Options: ReplyQuote


Subject
Written By
Posted
About connection id information
August 04, 2020 02:21AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.