MySQL Forums
Forum List  »  Router & Proxy

sql-bench test fails
Posted by: Niels de Carpentier
Date: August 24, 2007 05:22AM


I'm doing some testing with mysql proxy to see if we can use it for database loadbalancing.

I'm trying to run sql-bench against mysql-proxy, with 1 master backend en 1 slave backend. (Using the tutorial-keepalive script) Most of the tests seem to fail however:

[root@opteron sql-bench]# ./test-alter-table --host= --user=niels --password=xxxx
Testing server 'MySQL 5.0.22 log/' at 2007-08-24 9:55:15

Testing of ALTER TABLE
Testing with 1000 columns and 1000 rows in 100 steps
Got error: 'Lost connection to MySQL server during query' when connecting to DBI:mysql:database=test;host= with user: 'niels' password: 'xxxx'

From the network dumps I can see 2 possible issues:

- The client might get confused by getting an error on the QUIT command. (I think a quit should just return an OK, even though the connection is kept open between the proxy and the server. As far as the client is concerned, the connection is closed)

- A connect from the client is converted to a change user to the server. Something might be wrong here, as the next query after this fails with error 1047.

Is there any way I can debug this further ?



Options: ReplyQuote

Written By
sql-bench test fails
August 24, 2007 05:22AM
August 26, 2007 09:09AM
August 27, 2007 05:28AM
August 27, 2007 05:36AM

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.