Re: mysql transaction theory

Brian May <brian@microcomaustralia.com.au> wrote:

The only thing I can find about transactions is that they are atomic, but nothing about transactions causing other processes to block.

Is this the same for other non-mysql databases?

I don't know much about database systems, so this might not help, but the PostGRESQL documentation appears relevant: http://www.postgresql.org/docs/9.3/static/mvcc-intro.html (be sure to read the sections that follow the introduction for details).