Hi
Right now I'm happy.
Sorry for spam. I had an error in mys socket coke.
By
P.S. Proxy works well and gives many possibilities.
Daniel Łaś wrote:
>
> 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
---------------------------------------------------------------------
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