Gone, Sajan Last established connection timestamp by a specific user
Oct 10, 2017; 19:54
Gone, Sajan
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.
Oct 10
Singer Wang Re: Last established connection timestamp by a specific user
Oct 10, 2017; 16:34
Singer Wang
Re: Last established connection timestamp by a specific user
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!