DELAYED Insert Statements

PHP
1

Hello,

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?

2

The statements will process when the table in question is not used by any other thread - read more details in the official docs http://dev.mysql.com/doc/refman/5.1/en/insert-delayed.html

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