Hi,

Does anyone have a link to an idiots guide to transactions and row locking for innodb tables?

I'm a bit lost with all the options and would like to get an understanding of the concequences of using

MYSQLI_TRANS_START_READ_ONLY
MYSQLI_TRANS_START_READ_WRITE
or even
MYSQLI_TRANS_START_WITH_CONSISTENT_SNAPSHOT.

what errors I should be throwing and how to display them (at least in a dev environment) because without that understanding I'm not really sure that what I am writing will do what I think it should.

Thanks.