beside the fact that msql CAN NOT do this at all the median is not really releavt in the median you see also night hours with zero load
on a typical webserver with load you have much more * a cms system * many page requests per second * no you can not use persistent connections if you have let's say 100 databases and 100 domains with 500 prefork pcroesses because these would mean in the worst case 50000 connections * enable query log on machines with some hundret queriers per second would be a self DOS and fill your disks Am 05.10.2012 01:26, schrieb Rick James: > 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
signature.asc
Description: OpenPGP digital signature