why can not it send to the second slave ?

[zhou changliang]

mysql version is :
Server version: 5.0.45-community-nt-log MySQL Community Edition (GPL)

mysql proxy is :
0.6.0

master mysql 192.168.0.77:3305
the first slave 192.168.0.77:3307
the first slave 192.168.0.77:3308
they are on windows xp

mysql proxy on redhat 4 192.168.1.123:4040

i only config the rw-splite.lua

if not proxy.global.config.rwsplit then
proxy.global.config.rwsplit = {
min_idle_connections = 2,
max_idle_connections = 4,

is_debug = true
}
end



I start the proxy with the commend

[root@rhel sbin]# mysql-proxy --proxy-read-only-backend-addresses=192.168.0.77:3307 --proxy-read-only-backend-addresses=192.168.0.77:3308 --proxy-backend-addresses=192.168.0.77:3305 --proxy-lua-script=rwzcl.lua >/mnt/log.txt



and I connect the proxy

D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"
D:\mysql\mysql5.0.45\bin\mysql -h192.168.1.123 -P4040 -uroot -pbecom test -e "select count(*) from t"



the log.txt show the result that it always send to the first slave 3307, while 3308 never be sent.


[connect_server] 192.168.0.77:52235
[1].connected_clients = 0
[1].pool.cur_idle = 0
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 0
[1] idle-conns below min-idle
[read_query] 192.168.0.77:52235
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3305
is_slave : false
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:52235
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3305
is_slave : false
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:52235
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:52235

[connect_server] 192.168.0.77:14604
[1].connected_clients = 0
[1].pool.cur_idle = 0
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[1] idle-conns below min-idle
[read_query] 192.168.0.77:14604
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3305
is_slave : false
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:14604
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3305
is_slave : false
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:14604
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:14604

[connect_server] 192.168.0.77:41228
[1].connected_clients = 0
[1].pool.cur_idle = 0
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[1] idle-conns below min-idle
[read_query] 192.168.0.77:41228
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3305
is_slave : false
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:41228
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3305
is_slave : false
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:41228
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:41228

[connect_server] 192.168.0.77:2573
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 0
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 0
[2] idle-conns below min-idle
[read_query] 192.168.0.77:2573
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:2573
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:2573
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:2573

[connect_server] 192.168.0.77:30221
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 0
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[2] idle-conns below min-idle
[read_query] 192.168.0.77:30221
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:30221
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:30221
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:30221

[connect_server] 192.168.0.77:55565
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 0
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[2] idle-conns below min-idle
[read_query] 192.168.0.77:55565
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:55565
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:55565
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:55565

[connect_server] 192.168.0.77:17422
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 0
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 0
[3] idle-conns below min-idle
[read_query] 192.168.0.77:17422
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:17422
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:17422
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:17422

[connect_server] 192.168.0.77:44046
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 0
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[3] idle-conns below min-idle
[read_query] 192.168.0.77:44046
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:44046
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:44046
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:44046

[connect_server] 192.168.0.77:4879
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 0
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[3] idle-conns below min-idle
[read_query] 192.168.0.77:4879
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:4879
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:4879
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:4879

[connect_server] 192.168.0.77:30735
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:30735
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:30735
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:30735
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:30735

[connect_server] 192.168.0.77:31503
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:31503
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:31503
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:31503
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:31503

[connect_server] 192.168.0.77:31759
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:31759
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:31759
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:31759
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:31759

[connect_server] 192.168.0.77:32527
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:32527
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:32527
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:32527
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:32527

[connect_server] 192.168.0.77:32783
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:32783
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:32783
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:32783
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:32783

[connect_server] 192.168.0.77:33039
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:33039
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:33039
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:33039
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:33039

[connect_server] 192.168.0.77:33807
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:33807
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:33807
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:33807
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:33807

[connect_server] 192.168.0.77:34063
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:34063
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:34063
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:34063
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:34063

[connect_server] 192.168.0.77:34575
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:34575
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:34575
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:34575
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:34575

[connect_server] 192.168.0.77:35087
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:35087
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:35087
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:35087
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:35087

[connect_server] 192.168.0.77:35343
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:35343
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:35343
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:35343
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:35343

[connect_server] 192.168.0.77:36111
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:36111
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:36111
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:36111
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:36111

[connect_server] 192.168.0.77:36367
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:36367
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:36367
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:36367
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:36367

[connect_server] 192.168.0.77:36879
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:36879
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:36879
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:36879
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:36879

[connect_server] 192.168.0.77:37647
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:37647
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:37647
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:37647
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:37647

[connect_server] 192.168.0.77:37903
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:37903
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:37903
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:37903
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:37903

[connect_server] 192.168.0.77:38415
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:38415
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:38415
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:38415
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:38415

[connect_server] 192.168.0.77:38927
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:38927
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:38927
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:38927
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:38927

[connect_server] 192.168.0.77:39439
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:39439
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:39439
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:39439
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:39439

[connect_server] 192.168.0.77:39695
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:39695
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:39695
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:39695
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:39695

[connect_server] 192.168.0.77:40463
[1].connected_clients = 0
[1].pool.cur_idle = 3
[1].pool.max_idle = 4
[1].pool.min_idle = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 3
[2].pool.max_idle = 4
[2].pool.min_idle = 2
[2].type = 2
[2].state = 1
[3].connected_clients = 0
[3].pool.cur_idle = 3
[3].pool.max_idle = 4
[3].pool.min_idle = 2
[3].type = 2
[3].state = 1
[1] taking master as default
using pooled connection from: 1
[read_query] 192.168.0.77:40463
current backend = 0
client default db = test
client username = root
query = select @@version_comment limit 1
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:40463
current backend = 0
client default db = test
client username = root
query = select count(*) from t
sending to backend : 192.168.0.77:3307
is_slave : true
server default db: test
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true
[read_query] 192.168.0.77:40463
current backend = 0
client default db = test
client username = root
(QUIT) current backend = 0
[disconnect_client] 192.168.0.77:40463


Can anyone help me ?



Edited 1 time(s). Last edit at 12/22/2007 08:28AM by zhou changliang.