Thank you very much for your reply, Jeremy. I have been searching high and low for some sort of solution in MySQL, now I can stop.
In answer to your question other systems simply allow certain attributes to
be set at connection time, e.g. application_name, host_name, etc. So I normally
post_fix to the application_name a short date-time value which allows me
to distinguish connections in the list of processes on the server.
Cheers, Naran
Naran Hirani (Database/Software Specialist) MRC Rosalind Franklin Centre for Genomics Research Wellcome Trust Genome Campus, Hinxton, Cambridge, CB10 1SB, UK ______________________________________________________________ Tel: +44 (0)1223 494536 Fax: +44 (0)1223 494512 Web: www.rfcgr.mrc.ac.uk E-mail: [EMAIL PROTECTED]
Jeremy Zawodny wrote:
On Thu, Aug 05, 2004 at 12:36:55PM +0100, Naran Hirani wrote:
Hi,
I'm using a single shared user-login for a web-based application to
my mysql database - is there a way of including some information at
connect time or during processing that would show up when issuing
`show processlist'?
Only if you prefixed each query with a comment:
/* foo #3 */ SELECTL * FROM world ORDER BY...
But not at connect time.
Basically, I need to able to distinguish potentially multiple
connections with the same login and process information some how.
This sort of thing is possible in other SQL engines so probably
should be in MySQL too.
Interesting. How do other systems handle this?
Jeremy
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]