- Original Message -
From: "Tadej Guzej" <[EMAIL PROTECTED]>
> How would I log connections to MySQL server?
> I need the time user connects and the time user disconnects.
It's a workaround, but the general MySQL log actually has this information.
Here's a sample:
/usr/sbin/mysqld,
uot;Werner Stuerenburg" <[EMAIL PROTECTED]>
To: "Tadej Guzej" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 9:35 PM
Subject: Re: Logging connections
> You have timestamp fields in your table. When the user connects,
> you inse
You have timestamp fields in your table. When the user connects,
you insert a row. The first timestamp field is set to the entry
time automatically, you just record the user.
When he disconnects, you update the second timestamp with the
disconnect time. You can later compute the difference.
I wo
How would I log connections to MySQL server?
I need the time user connects and the time user disconnects.
Thanks,
Tadej
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
et a recordset displayed.
Am I missing something in the documentation (which I have read!) that treats
the "show processlist" differently?
All I'm really interested in is logging connections. I was trying to avoid
starting mysqld with --log, because I'm not interested in log