Re: R/W splitting
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.
Subject
Views
Written By
Posted
5846
July 30, 2007 04:54PM
2844
July 31, 2007 02:19PM
3191
July 31, 2007 09:10PM
2883
July 31, 2007 09:26PM
2972
July 31, 2007 10:03PM
2711
July 31, 2007 09:32PM
2676
July 31, 2007 10:11PM
3036
July 31, 2007 10:38PM
Re: R/W splitting
3198
July 31, 2007 11:04PM
2956
August 01, 2007 01:11AM
3190
August 01, 2007 09:05AM
2978
August 01, 2007 09:34AM
2744
August 01, 2007 09:45AM
2975
August 01, 2007 10:06AM
3023
August 01, 2007 10:16AM
2980
August 01, 2007 10:16AM
2894
August 02, 2007 01:05AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.