Why does an insert query occasionally take so long to complete?
I have noticed the same phenomenon on my systems. Queries which normally take a millisecond will suddenly take 1-2 seconds. All of my cases are simple, single table INSERT/UPDATE/REPLACE statements — not on any SELECTs. No load, locking, or thread build up is evident. I had suspected that it’s due to clearing out dirty pages, … Read more