MySQL Forums
Forum List  »  MyISAM

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


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 ?


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

Options: ReplyQuote

Written By
Problem: INSERT DELAYED works like normal INSERT
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.