From: Reindl Harald
Date: October 4 2012 11:57pm
Subject: Re: user last activity and log in
List-Archive: http://lists.mysql.com/mysql/228335
Message-Id: <506E2275.5040006@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig9564BFFA50F2F1E71AA002FE"

--------------enig9564BFFA50F2F1E71AA002FE
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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.
>=20
> 140 writes to some audit table _might_ have a small impact on the syste=
m.
>=20
>> -----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


--------------enig9564BFFA50F2F1E71AA002FE
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlBuInUACgkQhmBjz394AnlulACglMx4G4CaFjoiR5QsQjbwkjte
IMMAn2+PL6RXwdwgQePJJOVE/jHgdnSO
=jJ36
-----END PGP SIGNATURE-----

--------------enig9564BFFA50F2F1E71AA002FE--