Re: One slow connection make mysql slow

[Luca Vertua]

Ok, I'm agree with you, someone know how to avoid this?
Why mysql does not retrive data in the buffer before send them on network?
My query is about 400 Kbyte.

Luca

----- Original Message -----
From: "Gelu" <ggelu@stripped>
To: "Luca Vertua" <tech@stripped>; <mysql@stripped>
Sent: Tuesday, May 07, 2002 6:45 PM
Subject: Re: One slow connection make mysql slow


> Hi,
> My opinion:
> For sure is not a bug.
> Perhaps the client lock the table for read/write before access the table
and
> remain locked until retrieve data.
>
> Regards,
> Gelu
> _____________________________________________________
> G.NET SOFTWARE COMPANY
>
> Permanent e-mail address : gg@stripped
>                                           gelugogancea@stripped
> ----- Original Message -----
> From: "Luca Vertua" <tech@stripped>
> To: <mysql@stripped>
> Sent: Tuesday, May 07, 2002 6:34 PM
> Subject: One slow connection make mysql slow
>
>
> > I use mysql to register data in an accounting system, comunications
> > happen in a 200 Mbit network and database is really fast, so lock
> > situation ( ie delete after a long select ... ) is really fast and
> > does not create problems. When I connect from a dialup connection
> > obviously query take the same time but sending results to me may take
> > 30 seconds. The problem is that mysql locks the table up to the end of
> > the data sending process so other local client can't work. Is this a
> > bug? Are there a logical explanation?
> > Thanks for your help
> >
> > Luca
> > mysql, sql
> >
> >
> > ---------------------------------------------------------------------
> > 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 <mysql-thread108226@stripped>
> > To unsubscribe, e-mail
<mysql-unsubscribe-ggelu=arctic.ro@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>