Last established connection timestamp by a specific user
- Date: Tue, 10 Oct 2017 19:54:00 +0000
- From: "Gone, Sajan" <SGone@xxxxxx>
- Subject: Last established connection timestamp by a specific user
We have a MySQL instance which is currently running on version `5.7.11-enterprise-commercial-advanced-log`. On this instance I am trying to figure out the most recent timestamp at which a specific user has established a connection to this instance (or) performed any DML operations which might have changed the status of the database.
Is there any way I can get such information from the information_schema/performance_schema tables (or) from any of the mysql logs?
Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LB may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.