Re: Setting custom information in processlist

2004-08-11 Thread Naran Hirani
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 t

Re: Setting custom information in processlist

2004-08-10 Thread Justin Swanhart
Oracle has a procedure called DBMS_APPLICATION_INFO.SET_APPLICATION_INFO that allows you to specify up to 64k of addtional information about the current connection. It doesn't have any way to specify this information at connect time though. The data can be accessed in Oracle through the V$SESSION

Re: Setting custom information in processlist

2004-08-10 Thread Jeremy Zawodny
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'