oqgraph-dev team mailing list archive

Thread
Date

modifying backing table during oqgraph query

To: Antony T Curtis <atcurtis@xxxxxxxxx>
From: Arjen Lentz <arjen@xxxxxxxxxxxxx>
Date: Sat, 2 Mar 2013 11:20:19 +1000 (EST)
Cc: oqgraph-dev@xxxxxxxxxxxxxxxxxxx

Hi Antony, all

I'm seeing some weird crashes when I test stuff by hand though, I'll dig further into that.
Also wondering what happens if you modify a backing table during a graph query?
Perhaps the graph engine needs to, if the backing table is InnoDB, open it within a transaction to get a consistent snapshot. We might even need to insist on InnoDB to make it work that way.
Otherwise a race condition is pretty much unavoidable in the real world - locking is not an option.

Antony, can you clarify how this works?

Cheers
Arjen.
-- 
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Australian peace of mind for your MySQL/MariaDB infrastructure.

Follow us at http://openquery.com/blog/ & http://twitter.com/openquery