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

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

it does not matter what kind of users

usually each application has it's own datanase and it's
own user, the application makes the connection and
can at this point log whatever you want

using the "general query log" can only be a bad joke
you will log EVERY query and not only logins

again: it is not the job of a RDBMS to waste I/O and
performance with such things - the application as
example could refresh it only once per user-session

the RDBMS would write blindly for each connection

Am 04.10.2012 18:18, schrieb Aastha:
> Yes, i meant DB users.
>=20
> On Thu, Oct 4, 2012 at 10:57 AM, Johan De Meersman <vegivamp@stripped =
<mailto:vegivamp@stripped>> wrote:
>=20
>=20
>     ----- Original Message -----
>     > From: "Reindl Harald" <h.reindl@stripped <mailto:h.reindl@th=
elounge.net>>
>     >
>     > this makes pretty no sense and is NOT the job of a RDBMS
>     > implement it in your application / db-abstraction-layer
>=20
>     I notice no specification of what kind of users, so I'm assuming DB=
 users. There *is* such a thing: you can
>     find it in the general query log. Turning that on is a considerable=
 performance overhead, though, and so is
>     firmly discouraged on production systems.


--------------enigADDCEE41873221FEDE5F2812
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/

iEYEARECAAYFAlBtuOEACgkQhmBjz394AnkauACdEWe2af9YAyx7AtOMTKAiCsn0
PEIAniGFvDMi9NXozh4lnF1uEMbCb7+o
=CDor
-----END PGP SIGNATURE-----

--------------enigADDCEE41873221FEDE5F2812--