I'm observing that when I have many processes doing some work on my
system that the transactions run along almost in lockstep. It appears
from messages posted here that the foreign keys are acquiring and
holding locks during the transactions, which seems like it would cause
this behavior.
I'd like to experiment with deferred foreign key checks so that the
lock is only held during the commit when the checks are done.
My questions are:
1) can I, and if so, how do I convert my existing FK's to deferrable
without drop/create of the keys. Some of the keys take a long time
to create and I'd like to avoid the hit.
2) do I increase the liklihood of deadlocks when the FK locks are
being acquired or is it just as likeley as with the current
non-deferred checking?
I'm running 7.4 (soon to be 7.4.1)
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/