Problem: INSERT DELAYED works like normal INSERT
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.
Subject
Views
Written By
Posted
Problem: INSERT DELAYED works like normal INSERT
3276
March 27, 2012 06:15AM
1475
March 29, 2012 09:49PM
1540
March 30, 2012 10:08AM
1916
March 31, 2012 12:59PM
1840
April 01, 2012 07:31AM
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.