Skip navigation links

MySQL Forums :: Proxy :: R/W splitting


Advanced Search

Re: R/W splitting
Posted by: Jan Kneschke ()
Date: July 31, 2007 11:04PM

Yep, you only see a connection being in use when it is executing a query. Otherwise we move the connection back in to the connection pool as soon as we can.

connected_clients is perhaps a wrong name. It is the number of connections which are in use right now.
connected_clients + idling_connections is the number of open connections to the backends.

In my blog I have take the keep-alive tutorial apart and explained all the little steps about how and why it works. Check out http://jan.kneschke.de/2007/8/1/mysql-proxy-learns-r-w-splitting

--
Jan Kneschke, MySQL Enterprise Tools



Edited 1 time(s). Last edit at 07/31/2007 11:05PM by Jan Kneschke.

Options: ReplyQuote


Subject Views Written By Posted
R/W splitting 4430 Jan Kneschke 07/30/2007 04:54PM
Re: R/W splitting 2164 Gerry Reno 07/31/2007 02:19PM
Re: R/W splitting 2349 Gerry Reno 07/31/2007 09:10PM
Re: R/W splitting 2193 Gerry Reno 07/31/2007 09:26PM
Re: R/W splitting 2326 Jan Kneschke 07/31/2007 10:03PM
Re: R/W splitting 2021 Gerry Reno 07/31/2007 09:32PM
Re: R/W splitting 1974 Gerry Reno 07/31/2007 10:11PM
Re: R/W splitting 2344 Gerry Reno 07/31/2007 10:38PM
Re: R/W splitting 2438 Jan Kneschke 07/31/2007 11:04PM
Re: R/W splitting 2321 Georgi Georgiev 08/01/2007 01:11AM
Re: R/W splitting 2448 Christopher Hubrich 08/01/2007 09:05AM
Re: R/W splitting 2312 Jan Kneschke 08/01/2007 09:34AM
Re: R/W splitting 2099 Christopher Hubrich 08/01/2007 09:45AM
Re: R/W splitting 2145 Christopher Hubrich 08/01/2007 10:06AM
Re: R/W splitting 2320 Jan Kneschke 08/01/2007 10:16AM
Re: R/W splitting 2357 Jan Kneschke 08/01/2007 10:16AM
Re: R/W splitting 2234 Christopher Hubrich 08/02/2007 01:05AM


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.