Hi,
I think it's better to lock the table before to "delete".If you offer more
details.... maybe we can help.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : gg@stripped
gelugogancea@stripped
----- Original Message -----
From: "Luca Vertua" <tech@stripped>
To: "Gelu" <ggelu@stripped>; <mysql@stripped>
Sent: Tuesday, May 07, 2002 7:52 PM
Subject: Re: One slow connection make mysql slow
> 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
> > >
> > >
> >
>
>
