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
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
> > 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 -
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