help wantedtype/feature-request
Description
how to record the client's ip and the db'username
Describe the feature you'd like: In tidb,it is hard to get the userstat,We can only fetch the ProcessList periodically。When we migrate tidb , we have to know where the user is coming from and which DB is going to access.
Teachability, Documentation, Adoption, Migration Strategy: like the feature in mariadb : https://mariadb.com/kb/en/user-statistics/
Maybe the table and record as below:
mysql [test]> select * from userstats;
+----------+--------------+-----------------+-------------+---------------------+
| username | client | instance | schema_name | last_accesstime |
+----------+--------------+-----------------+-------------+---------------------+
| appuser2 | 172.168.12.6 | 10.19.12.6:4000 | schema_1 | 2021-04-08 19:32:00 |
| appuser1 | 179.168.9.10 | 11.19.12.9:4000 | schema_1 | 2021-04-08 19:31:00 |
+----------+--------------+-----------------+-------------+---------------------+
2 rows in set (0.00 sec)
mysql [test]>