-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi,
we've enabled /var/log/mysql.log on our server (5.0.24a on Debian testing). However I only want to log commands from certain application, or better say, certain users. When I look at some log output, it looks like this: 060919 9:53:38 15945 Connect [EMAIL PROTECTED] on 15945 Query SET AUTOCOMMIT=0 15945 Init DB somedb 15945 Query SELECT * FROM [...] 15945 Query SELECT * FROM [..] 15945 Query UPDATE [...] 15945 Query COMMIT The way I read this is that once I have a "Connect" command, the ID before uniquely identifies all further SQL commands belonging to this connection -> to this mysql user. Now what I need is something similar to "tail -f" but only for selected connected user. We've so much going on the server that it's impossible to look over all the data without a tool. Before I re-invent the wheel I'ld like to know if there are tools/helper like this available ... ? thanks, - - Markus -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFD6Py1nS0RcInK9ARAloJAJ4s/7ckWeE/s4VO92yVgeUebOrRKwCguCvZ AlJvzmq1VVCCfGj2eIZ3oME= =aqc3 -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
