From: Rick James Date: October 4 2012 11:26pm Subject: RE: user last activity and log in List-Archive: http://lists.mysql.com/mysql/228334 Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148CF9236A@SP2-EX07VS01.ds.corp.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 >=20 > Hi, >=20 > 2012/10/4 Reindl Harald >=20 > > > > > > 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. >=20 >=20 > > this makes pretty no sense and is NOT the job of a RDBMS implement it > > in your application / db-abstraction-layer > > >=20 > I can suggest a reading here: > http://www.amazon.com/Implementing-Database-Security-Auditing- > Examples/dp/1555583342 >=20 > Regards > -- > Claudio