MySQL Forums
Forum List  »  MyISAM

Problem: INSERT DELAYED works like normal INSERT
Posted by: Benland Benland
Date: March 27, 2012 06:15AM

Hello,

when I do request like "INSERT DELAYED INTO table VALUES (...)", my server doesn't create thread: it works like normal INSERT.

I have notice that with command "SHOW STATUS LIKE '%delayed%'", it always display:
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Not_flushed_delayed_rows 0

I checked my tables, and they are in MyISAM...
I specify that my server is in replication, and it's the master.

Have you an idea to resolve this problem , please ?

Benoit



Edited 2 time(s). Last edit at 03/29/2012 07:46AM by Benland Benland.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem: INSERT DELAYED works like normal INSERT
3032
March 27, 2012 06:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.