Description:
./mysql-proxy -V
mysql-proxy 0.8.3
chassis: mysql-proxy 0.8.3
glib2: 2.22.5
libevent: 1.4.13-stable
LUA: Lua 5.1.4
package.path: /usr/local/mysql-proxy/lib/mysql-proxy/lua/?.lua
package.cpath: /usr/local/mysql-proxy/lib/mysql-proxy/lua/?.so
-- modules
proxy: 0.8.3
-----------------------------------------------------------------------------
[mysql-proxy]
plugins=proxy,admin
admin-username =test
admin-password =123
admin-lua-script = /usr/local/mysql-proxy/share/admin.lua
daemon = true
keepalive = true
#master..
proxy-backend-addresses = 221.231.139.4:3306
#slave ..
proxy-read-only-backend-addresses = 42.121.109.128:3306
proxy-lua-script =/usr/local/mysql-proxy/share/rw-splitting.lua
log-file = /usr/local/mysql-proxy/mysql-proxy.log
log-level = debug
pid-file= /usr/local/mysql-proxy/mysql-proxy.pid
-----------------------------------------------------------------------------
mysqlslap --defaults-file=/etc/my.cnf --concurrency=25,50 --iterations=1 --create-schema=test --query="select * from tb1" --number-of-queries=1000 -uusername -ppassword -h127.0.0.1 -P4040
[connect_server] 127.0.0.1:57893
[1].connected_clients = 0
[1].pool.cur_idle = 26
[1].pool.max_idle = 1
[1].pool.min_idle = 1
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].pool.cur_idle = 50
[2].pool.max_idle = 1
[2].pool.min_idle = 1
[2].type = 2
[2].state = 1
[1] taking master as default
using pooled connection from: 1
mysqlslap: Error when connecting to server: Unknown command
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
mysqlslap: Error when connecting to server: 1047 Unknown command
[disconnect_client] 127.0.0.1:58812
mysqlslap: Error when connecting to server: 1047 Unknown command
mysqlslap: Error when connecting to server: 1047 Unknown command
mysqlslap: Error when connecting to server: 1047 Unknown command
[disconnect_client] 127.0.0.1:58816
mysqlslap: Error when connecting to server: 1047 Unknown command
[disconnect_client] 127.0.0.1:58817
[disconnect_client] 127.0.0.1:58813
[disconnect_client] 127.0.0.1:58818
[disconnect_client] 127.0.0.1:58815
[disconnect_client] 127.0.0.1:58814
mysqlslap: Error when connecting to server: 1047 Unknown command
mysqlslap: Error when connecting to server: 1047 Unknown command
How to repeat:
[network-mysqld.c:1134]: error on a connection (fd: -1 event: 0). closing clien
Suggested fix:
[network-mysqld.c:1134]: error on a connection (fd: -1 event: 0). closing clien
Description: ./mysql-proxy -V mysql-proxy 0.8.3 chassis: mysql-proxy 0.8.3 glib2: 2.22.5 libevent: 1.4.13-stable LUA: Lua 5.1.4 package.path: /usr/local/mysql-proxy/lib/mysql-proxy/lua/?.lua package.cpath: /usr/local/mysql-proxy/lib/mysql-proxy/lua/?.so -- modules proxy: 0.8.3 ----------------------------------------------------------------------------- [mysql-proxy] plugins=proxy,admin admin-username =test admin-password =123 admin-lua-script = /usr/local/mysql-proxy/share/admin.lua daemon = true keepalive = true #master.. proxy-backend-addresses = 221.231.139.4:3306 #slave .. proxy-read-only-backend-addresses = 42.121.109.128:3306 proxy-lua-script =/usr/local/mysql-proxy/share/rw-splitting.lua log-file = /usr/local/mysql-proxy/mysql-proxy.log log-level = debug pid-file= /usr/local/mysql-proxy/mysql-proxy.pid ----------------------------------------------------------------------------- mysqlslap --defaults-file=/etc/my.cnf --concurrency=25,50 --iterations=1 --create-schema=test --query="select * from tb1" --number-of-queries=1000 -uusername -ppassword -h127.0.0.1 -P4040 [connect_server] 127.0.0.1:57893 [1].connected_clients = 0 [1].pool.cur_idle = 26 [1].pool.max_idle = 1 [1].pool.min_idle = 1 [1].type = 1 [1].state = 1 [2].connected_clients = 0 [2].pool.cur_idle = 50 [2].pool.max_idle = 1 [2].pool.min_idle = 1 [2].type = 2 [2].state = 1 [1] taking master as default using pooled connection from: 1 mysqlslap: Error when connecting to server: Unknown command ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- mysqlslap: Error when connecting to server: 1047 Unknown command [disconnect_client] 127.0.0.1:58812 mysqlslap: Error when connecting to server: 1047 Unknown command mysqlslap: Error when connecting to server: 1047 Unknown command mysqlslap: Error when connecting to server: 1047 Unknown command [disconnect_client] 127.0.0.1:58816 mysqlslap: Error when connecting to server: 1047 Unknown command [disconnect_client] 127.0.0.1:58817 [disconnect_client] 127.0.0.1:58813 [disconnect_client] 127.0.0.1:58818 [disconnect_client] 127.0.0.1:58815 [disconnect_client] 127.0.0.1:58814 mysqlslap: Error when connecting to server: 1047 Unknown command mysqlslap: Error when connecting to server: 1047 Unknown command How to repeat: [network-mysqld.c:1134]: error on a connection (fd: -1 event: 0). closing clien Suggested fix: [network-mysqld.c:1134]: error on a connection (fd: -1 event: 0). closing clien