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?