Dropping into the thread late, but two points:

For all of the standard reasons, different database clients should use
different usernames.  In the limit, you could just make the username contain
the comment.

Beyond that, you can already accomplish 90% of what you'd want by simply
coding your queries as "/* Comment */ SELECT ...", and so on.  For
connections which are not currently running a query, this won't work - but
in my experience, you usually don't care much about connections which aren't
currently running a query.

Later,
scott


-----Original Message-----
From: Alexandre BAUMEISTER
To: [EMAIL PROTECTED]
Sent: 7/4/2001 2:59 PM
Subject: Re: Proposition: Attach a comment to each connection

Bonjour,

I sent this post a few days ago but it didn't get a lot of
contributions.
Wouldn't it be an interresting feature ?

> > >   When  you  have  a  big  web  site  with  a  lot of pages,
programs,
> > >   cronjobs,  applications  ...  connecting  to  Mysql,  it's
sometimes
> > >   difficult  to  find  from where a given query/connection comes
from.
> > >   And it's sometimes urgent to find the origin of a disturbing
query.
> > >
> > >   So,  I  think  it  would  be great to be able to give a comment
when
> > >   connecting  to  Mysql.  "mysqladmin  processlist"  could  show
this
> > >   comment and this may be really helpful in some situations !
> > >
> > >   As this already been discussed ?
> > >

Regards,
Alex.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to