Hi Peter,
- Original Message -
From: "Peter Thomas"
Sent: Saturday, May 01, 2004 11:24 PM
Subject: Delayed insert record visibility
> I'm trying to understand the delayed insert process to see whether I
can use
> it to reduce the load on mysql, and have the follow
I'm trying to understand the delayed insert process to see whether I can use
it to reduce the load on mysql, and have the following question.
Are 'delayed inserts' which are queued but not yet actually added to the
database by the handler visible to selects on the table?
I'
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
Hi list,
I've got a small MyISAM table which is used for some statistics.
I'm only doing insert into this table.
I need that clients doing INSERT queries can exit as soon as possible.
So, i'm using INSERT DELAYED with some good succes.
But I've got a question.
If i decrease delayed_insert_limit
>Description:
mysqlhotcopy (but possible any other software) can cause delayed
handlers to terminate with "Delayed insert thread couldn't get requested
lock for "
I havent worked out the exact conditions under wich mysqlhotcopy
fails, but it seems that if mysqlhotcopy t
Hello,
I am having some troubles with INSERT DELAYED statement... even when there
are NO pending select, update or delete statements (I can see at the SHOW
PROCESSLIST query) , still it keeps waiting...
This is the info of the delayed process that doesn't want to execute:
db: antrophi
command: