DELAYED Insert Statements


I have used DELAYED insert statements to enhance the speed of my script, cutting off at least half the processing time. My question is, how long of a break does the MySQL server need to process the statements?

Based on my SHOW STATUS, I have 930 statements in the delayed_writes field. And this normal could get as large as thousands.

Im running a cron every minute adding more statements to this queue, so im wondering if I need to do something like take the entire site offline every night for an hour or two to process are the queued statements.

Does this sound right?

The statements will process when the table in question is not used by any other thread - read more details in the official docs

It sounds like the table is constantly being used. In this case, INSERT DELAYED might not be a good choice for you