In looking at a couple hundred machine, I see that
Connections / Uptime
has a median of about 0.5 (one connection every 2 seconds)
and a max of about 140.
140 writes to some audit table _might_ have a small impact on the system.
> -----Original Message-----
> From: Claudio Nanni [mailto:claudio.nanni@stripped]
> Sent: Thursday, October 04, 2012 3:51 PM
> To: Reindl Harald
> Cc: mysql@stripped
> Subject: Re: user last activity and log in
>
> Hi,
>
> 2012/10/4 Reindl Harald <h.reindl@stripped>
>
> >
> >
> > Am 04.10.2012 17:28, schrieb Aastha:
> > > I want to find the last time the given list of users logged in.
> > > Is there any mysql table from where i can retrieve the data or any
> > > specific sql
> >
> > no - because this would mean a WRITE QUERY in the mysql-database for
> > every connection - having a web-application with hundrets of calls
> per
> > second would kill the performance
> >
> > No because MySQL does not have this facility. (<5.6)
> Saying that a feature is not present because the hypothetical
> implementation would impact performance doesn't make much sense in my
> opinion.
>
>
> > this makes pretty no sense and is NOT the job of a RDBMS implement it
> > in your application / db-abstraction-layer
> >
>
> I can suggest a reading here:
> http://www.amazon.com/Implementing-Database-Security-Auditing-
> Examples/dp/1555583342
>
> Regards
> --
> Claudio
