Re: Last established connection timestamp by a specific user
- Date: Tue, 10 Oct 2017 16:34:44 -0400
- From: Singer Wang <wang@xxxxxxxxxxxxxx>
- Subject: Re: Last established connection timestamp by a specific user
Unfortunately not with the standard configuration.
You're best bet going forward would be to look at
MySQL Enterprise Audit -
On Tue, Oct 10, 2017 at 3:54 PM, Gone, Sajan <SGone@xxxxxx> wrote:
> 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