Web lists-archives.com

Last established connection timestamp by a specific user




Hi,

   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?

Thank You,
Sajan Gone
Database Administrator.

________________________________

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.