MySQL Forums
Forum List  »  Router & Proxy

Advanced Search
New Topic

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@10.0.1.174 on db1
76 Query show databases

Simon

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
weird issue with pooled connections losing their user
3297
simon elliston ball
August 24, 2007 09:16AM
Re: weird issue with pooled connections losing their user
2009
simon elliston ball
August 24, 2007 10:23AM
Re: weird issue with pooled connections losing their user
2112
Jan Kneschke
August 26, 2007 09:07AM


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.