List:General Discussion« Previous MessageNext Message »
From:Luca Vertua Date:May 7 2002 4:52pm
Subject:Re: One slow connection make mysql slow
View as plain text  
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
> >
> >
>

Thread
One slow connection make mysql slowLuca Vertua7 May
  • Re: One slow connection make mysql slowGelu7 May
  • Re: One slow connection make mysql slowLuca Vertua7 May
  • Re: One slow connection make mysql slowGelu7 May