MySQL Forums
Forum List  »  Router & Proxy

Re: weird issue with pooled connections losing their user
Posted by: simon elliston ball
Date: August 24, 2007 10:23AM

Further info:

I have deduced from the query log that the problem lies in the way mysql-proxy handles backends. It would see to be only possible to use a single user and database combination per backend, since the change user happens on one thread (78 in this case) and the query happens on another from the pool. Is it possible to get more information on the threads within the backend so the lua can be adapted to use the same thread as the change user query was run on, and to force the thread used in the lua?

78 Change user user1@ on db1
76 Query show databases


Options: ReplyQuote

Written By
Re: weird issue with pooled connections losing their user
August 24, 2007 10:23AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.