MySQL Forums
Forum List  »  Router & Proxy

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

Hi,

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=172.16.60.153 --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=172.16.60.153 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 ?

Thanks,

Niels

Options: ReplyQuote


Subject
Views
Written By
Posted
sql-bench test fails
4136
August 24, 2007 05:22AM
2357
August 26, 2007 09:09AM
2526
August 27, 2007 05:28AM
2394
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.