foreign key on delete cascade order?

[George Woodring <george.woodring@xxxxxxxxxx>]

When using FOREIGN KEY ON DELETE CASCADE, is there an order the entries are being deleted?

We are seeing intermittent deadlocks with trying to update a table with the foreign key entry being deleted.

We have 4 levels of tables chained by foreign keys.

machine -> point -> poll -> status

The status is the only one updated constantly and we are trying to figure out how to order the update to avoid the deadlock when the machine is deleted.

Thanks for your help

George

iGLASS Networks
www.iglass.net