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.na...@gmail.com] > Sent: Thursday, October 04, 2012 3:51 PM > To: Reindl Harald > Cc: mysql@lists.mysql.com > Subject: Re: user last activity and log in > > Hi, > > 2012/10/4 Reindl Harald <h.rei...@thelounge.net> > > > > > > > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
