Hi
I follow this list for long time. This is first time I have to ask the
question.
I'm developing something like proxy for mysql. Everything works fine
except when mysql client working with mysql over proxy is reciving
bigger amount of data. For example big resultset.
Let me explain situation.
There is mysql backend,mysql client and proxy between them.
The proxy works with proxy client using their own protocol. When proxy
client ask for mysql connection proxy returns crypted username, password
,database name and port number. Then proxy opens socket
(mysql_socket),connects it to mysql and listen for incoming connection.
When it comes the client_socket is created.
Built in mysql client uses this parameters and usually knows nothing
about the proxy :))))
Then proxy using select() function waits for incoming and outgoin data.
With small result set data packets flow like this:
mysql->proxy
proxy>client
client->proxy
proxy->mysql
.
.
.
till end
But with bigger resultset it looks like:
mysql->proxy
proxy->client
client->proxy
proxy->mysql
mysql->proxy
proxy->client
mysql->proxy
mysql->proxy
mysql->proxy
and then mysql client shows Lost connection to MySQL during query.
Well, any help ?
Daniel Las
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
