Re: Delayed Insert Question

2003-12-09 Thread David Bordas
Tuesday, December 09, 2003 2:51 PM Chris Elsworth wrote: > If you increase delayed_insert_limit then you're effectively giving > the DELAYED thread more preferencee to the table; it will write more > rows (once it can, ie there's a phase of time where there's no locks > on the table) in a batch, w

Re: Delayed Insert Question

2003-12-09 Thread Chris Elsworth
On Tue, Dec 09, 2003 at 02:18:58PM +0100, David Bordas wrote: > > I've read mysql doc sereval times, but i can't find any varaible that > specify when the delayed queue was flushed. Well, I suppose that's because there isn't one. The DELAYED thread handles that by itself. You don't want it too la

Re: Delayed Insert Question

2003-12-09 Thread David Bordas
> > So, i'm using INSERT DELAYED with some good succes. > > > > But I've got a question. > > If i decrease delayed_insert_limit to ten secondes for example, is that mean > > that delayed_queue will be flushed every ten secondes ? > > Is there an other variable that specify the flush time ? > > No -

Re: Delayed Insert Question

2003-12-09 Thread Chris Elsworth
On Tue, Dec 09, 2003 at 12:17:41PM +0100, David Bordas wrote: > So, i'm using INSERT DELAYED with some good succes. > > But I've got a question. > If i decrease delayed_insert_limit to ten secondes for example, is that mean > that delayed_queue will be flushed every ten secondes ? > Is there an o